1. Building a Collector

In This Chapter:

Planning an Approach

Planning the Workbook Structure

The VBA Code

The Analysis Sheets

The word analytics connotes, among other notions, the idea that the raw data that gets analyzed includes quantitative measures of online browsing behavior. Data collection instruments such as Omniture and Google Analytics are useful in part because they track a variety of behavior—hits, views, downloads, buys, and so on—along with information about the source of the visit. However, there are times that you want to measure product performance but can’t access the traffic data.

Suppose you supply a product that another company or companies resell on their own websites. Although those companies might share their web traffic ...

Get Predictive Analytics: Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.