February 2010

22 Feb 2010 02:19 am

many splendorCompetitive intelligence, the "what else", is one of the core tenets of Web Analytics 2.0.

The reason is simple: The ecosystem within which you function on the web contains mind blowing data you can use to become better.

Your traffic grew by 6% last year, what was your competitor's growth rate? 15%. Feel better? : ) When should you start doing paid search advertising for tours to Italy for 2011? In May 2010 (!). What is your "share of search" in the netbook segment compared to your biggest competitor? 9 points higher, now you deserve a bonus! How many visitors to your site go visit your competitor's site right after coming to yours? 39%, good god! Where to do display advertisements to ensure you get in front of men considering proposing to their girlfriends (or boyfriends)? Go beyond targeting men between the age of 28 and 34, use search behavior and be really smart.

I am just scratching the surface of what's possible.

It is simply magnificent what you can do with freely available data on the web about your direct competitors, your industry segment and indeed how people behave on search engines and other websites.

The secret to making optimal use of CI data lies in one single realization: You must ensure you understand how the data you are analyzing is collected.

Not all sources of CI data are created equal. It is key that before you use the data that comScore or Nielsen or Google or HitWise or Compete or your brother-in-law shove into your face that you understand where the data comes from.

Once you understand that you choose: 1. The best source possible that is 2. The right answer for the question you are asking (which implies you have to be flexible!).

Here are the sources of competitive intelligence data.

#1: Toolbar Data.

Toolbars are add-on's that provide additional functionality to web browsers, such as easier access to news, search features, and security protections. They are available from all the major search engines such as Google, MSN, Yahoo! as well as from thousands of other sources.

yahoo toolbar

These toolbars also collect limited information about the browsing behavior of the customers who use them, including the pages visited, the search terms used, perhaps even time spent on each page, and so forth. Typically, data collected is anonymous and not personally identifiable information (PII).

After the toolbars collect the data, your CI tool then scrubs and massages the data before presenting it to you for analysis. For example, with Alexa, you can report on traffic statistics (such as rank and page views), upstream (where your traffic comes from) and downstream (where people go after visiting your site) statistics, and key-words driving traffic to a site.

Millions of people use widely deployed toolbars, mostly from the search engines, which makes these toolbars one of the largest sources of CI data available. That very large sample size makes toolbar data a very effective source of CI data, especially for macro website traffic analysis such as number of visits, average duration, and referrers.

Search engine toolbars are a ton more popular which is the key reason that other toolbars data sources, such as Alexa, are not useful any more (the data is simply not good enough).

Toolbar Data Bottom-line: Toolbar data is typically not available by itself. It is usually a key component in tools that use a mix of sources to provide insights.

#2: Panel Data.

Panel data is another well-established method of collecting data. to gather panel data, a company may recruit participants to be in a panel, and each panel member installs a piece of monitoring software. The software collects all the panel’s browsing behavior and reports it to the company running the panel. Additionally the person is also required to self report demographic, salary, household members, hobbies, education level and other such detailed information.

panel data

Varying degrees of data are collected from a panel. At one end of the spectrum, the data collected is simply the websites visited, and at the other end, the monitoring software records the credit cards, names, addresses, and any other personal information typed into the browser.

Panel data is also collected when people unknowingly opt into sending their
data. Common examples are a small utility you install on your computer to get the weather or an add-on for your browser to help you auto complete forms. in the unreadable terms of service you accept, you agree to allow your browsing behavior to be recorded and reported.

Panels can have a few thousand members or several hundred thousand.

You need to be cautious about three areas when you use data or analysis based on panel data:

Sample bias: Almost all businesses, universities, and other institutions ban monitoring software because of security and privacy concerns. Therefore, most monitored behavior tends to come from home users. Since usage during business hours forms a huge amount of web consumption, it is important to know that panel data is blind to this information.

Sampling bias: People are enticed to install monitoring software in exchange for sweep-stakes entries, downloadable screensavers and games, or a very small sum of money (such as $3 per month). This inclination causes a bias in the data because of the type of people who participate in the panel. This is not itself a deal breaker, but consider whose behavior you want to analyze vs. who might be in the sample.

Web 2.0 challenge: Monitoring software (overt or covert) was built when the Web was static and page-based. The advent of rich experiences such as video, Ajax, and Flash means no page views, which makes it difficult for monitoring software to capture data accurately. Some monitoring software companies have tried to adapt by asking companies to embed special beacons in their website experiences, but as you can imagine, this is easier said than done (select few want to do it, then do they do it well and how do you compare companies that did or did not beaconify?).

The panel methodology is based on the traditional television data capture model. In a world that is massively fragmented, panels face a huge challenge in collecting accurate and complete (or even representative) data. A rule of thumb I have developed is if a site gets more than 5 million unique visitors a month, then there is a sufficient signal from panel-based data.

Panel Data Bottom-line: For companies such as comScore and Nielsen panel data has been a primary source for competitive reporting they provide their clients. But because of the methodology's inherent limitations, recently panel data is augmented by other sources of data before it is provided for analysis (including for a subset of data you'll get from comScore and Nielsen – please check & clarify before you use the data).

#3: ISP (Network) Data.

We all get our internet access from Internet Service Providers (ISP's), and as we surf the Web, our requests go through the servers of these ISP's to be stored in server log files.

network cables

The data collected by the ISP consists of elements that get passed around in URLs, such as sites, page names, keywords searched, and so on. The ISP servers can also capture information such as browser types and operating systems.

The size of these isps translates into a huge sample size.

For example, Hitwise which chiefly relies on isp data, has a sample size of 10 million people in the United states and 25 million worldwide. Such a large sample size reduces sample bias (surprise!). There are also geographically focused competitive intelligence solutions, like Netsuus in Spain, that provide analysis from excellent locally sourced data.

The other benefit of ISP data is that the sampling bias is also reduced; since you and I don’t have to agree to be monitored, our ISP simply collects this anonymous data and then sells it to third-party sources for analysis.

ISP's typically don’t publicize that they sell the data, and companies that purchase that data don’t share this information either. So, there is a chance of some bias. Ask for the sample size when you choose your ISP-based CI tool, and go for the biggest you can find.

ISP Data Bottom-line: The largest samples of CI data currently available comes from ISP data (in tools like Hitwise and Compete). Though both tools (and other smart ones like them) increasingly use a small sample of panel data and even some small amount of purchased toolbar data.

#4: Search Engine Data.

Our queries to search engines, such as Bing, Google, Yahoo!, and Baidu, are logged by those search engines, along with basic connectivity information such as IP address and browser version. In the past, analysts had to rely on external companies to provide search behavior data, but increasingly search engines are providing tools to directly mine their data.

search engine

You can use search engine data with a greater degree of confidence, because it comes directly from the search engine (doh!). Remember, though, that the data is specific to that search engine—and because each search engine has distinct user base, it is not wise to apply lessons from one to another.

With that mild warning here are some amazing tools. . . .

In Google AdWords, you can use Keyword Tool, the Search-based Keyword Tool and Insights for Search.

Similar tools are available from Microsoft: Entity Association, Keyword Group Detection, Keyword Forecast, and Search Funnels (all at Microsoft adCenter Labs).

Search Engine Data Bottom-line:Search engine data tends to be the primary, and typically the best source you can find, for search data analysis. If you are analyzing data for your SEO or PPC campaigns and you find the search engine providing the data then you should instantly embrace it and immediately propose marriage!

#5: Benchmarks from Web Analytics Vendors.

Web analytics vendors have lots of customers, which means they have lots of data. Many vendors now aggregate this real customer data and present it in the form of benchmarks that you can use to index your own performance.

Benchmarking data is currently available from Fireclick, Coremetrics, and Google Analytics. Often, as is the case with Google Analytics, customers have to explicitly opt in their data into this benchmarking service. But this is not always true for all vendors, please check with yours.

web analytics benchmarking report

Both Fireclick and Coremetrics provide benchmarks related to conversion rates, cart abandonment, time on site, and so forth. Google Analytics provides benchmarks for visits, bounce rates, page views, time on site, and % new visits.

In all three cases, you can compare your performance to specific vertical markets (for example, retail, apparel, software, and so on), which is much more meaningful.

The cool benefit of this method is that websites directly report very accurate data, even if the web analytics vendor makes that data anonymous. The downside is that your competitors might not all use the same tool as you; therefore, you are comparing your actual performance against the actual performance of a subset of your competitors.

With data from vendors, you must be careful about sample size, that is, how
many customers the web analytics vendor has. If your web analytics vendor has just 1,000 customers and it is producing benchmarks in 15 industry categories, it might be a hit or a miss in terms of how valuable / representative the benchmarks are.

WA Vendor Data Bottom-line: Data from web analytics vendors comes from their clients, so it is real data. The client data is anonymous, so you can’t do a direct comparison between you and your arch enemy; rather, you’ll compare yourself to your industry segment (which is perfectly ok).

#6: Self-reported Data.

It is common knowledge that some methods of data collection, such as panel-
based, do not collect data with the necessary degree of accuracy. A site’s own analytics tool may report 10 million visits, and the panel data may report 6 million. To overcome this issue, some vendors, such as Quantcast and Google’s Ad Planner, allow websites to report their own data through their tools.

self reported competitive data

For sites that rely on advertising, the data used by advertisers must be as
accurate as possible; hence, the sites have an incentive to share data directly. If your competitors publish their own data through vendors such as Google’s Ad planner or Quantcast, then that is probably the cleanest and best source of data for you.

One thing to be cautious about when you work with self-reported data. Check the definitions of various metrics. For example, if you see a metric called Cookies, find out exactly what that metric means before you use the data.

Self-Reported Data Bottom-line: Because of its inherent nature, self-reported data tends to augment other sources of data provided by tools such as Ad Planner or Quantcast. It also tends to be the cleanest source of data available.

#7: Hybrid Data (/All Your Base Are Belong To Us).

Competitive intelligence vendors are observing you from the outside. Any single source, toolbar or panels or isp or tags or spyware etc, will have its own bias / limitation.

Some, smart, vendors now use multiple sources of data to augment the data set they started their life with.

all your base are belong to us

The first method is to append the data. This is what's happening in the case of Quantcast and Google Ad Planner, in both cases they have their own source of data to which your self reported data is added. The resulting reports are "awesomely good".

The second method is to put many different sources (say toolbar, panel, isp) into a blender, churn at high speed, throw in a pinch of math and a dash or correction algorithms, and – boom! – you have one "awesomely good" number. A good example of this is Compete or the DoubleClick Ad Planner.

Google's Trends for Websites is another example of a tool that uses hybrid data for its reporting (see answer #2 here).

The benefit of using hybrid methodology is that the vendor can plug in any gaps
that might exist between different sources.

The challenge is that it is much harder to peel back the onion and understand some of the nuances and biases in the data (sometimes mildly frustrating to analysis ninja's such as myself!).

Hence, the best-practice recommendation is to forget about the absolute numbers and focus on comparing trends; the longer the time period, the better.

Hybrid Data Bottom-line: As the name implies, hybrid data contains data from many different sources and is increasingly the most commonly used methodology. It will probably be the category that will grow the most because frankly in context others look rather sub optimal.

[Update:] #8: External Voice of Customer Data.

This is one often overlooked source of competitive intelligence (/benchmarking) data. There are several ways to use Voice of Customer data.

For starters various companies such as iPerceptions (like CoreMetrics, Google Analytics, Fireclick above for clickstream) publish Customer Satisfaction & Task Completion Rate (my most beloved metric!) numbers for various industries.

If I am in the internet retail game I can use these benchmarks to compare my performance:

iperceptions retail ecommerce task completion report

Or I can dig deeper and compare my performance by the Primary Purpose segments:

iperceptions customer satisfaction by purpose of visit

Both of the above are from the iPerceptions Q4 2009 Ecommerce Benchmark report. You'll find other reports in the Resource Center.

With other sources like the ACSI (American Customer Satisfaction Index) you can get a big deeper. Just choose an industry from their site, I choose Internet Travel, and bam!

american customer satisfaction index internet travel

If I am Travelocity I am wondering what in the name of Jebus did the other guys do last year to have all those gains in Satisfaction where I got a zero.

And really what are those guys at Priceline eating! 5.6 points improvement just last year, 15 points over the last 9! Sure they started with a smaller number but still.

What can I, sad Travelocity, learn from them? From others?

In both cases above the intelligence came from a third party doing the research and giving you data for free.

But you can also commission studies, from the two companies above or one of thousands like them on the web.

Or you can do it yourself.

loop11 usability process

I just met a Top Web Company the other day and I spent $300 on 20 remote usability participants to go to the website of Top Web Company and their main competitor. I gave the usability participants the exact same tasks to do on both sites.

The scores were most illuminating (and embarrassing for Top Web Company). It allowed me to (without working at either company) collect competitive intelligence about how each were delivering against: 1. Task Completion Rate and 2. Customer Satisfaction.

You could collect your own competitive intel using UserTesting.Com, User Zoom, Loop11, or one of many other tools.

Or for even "cheaper" (and a bit less impactful) insights you can use something delightful like www.fivesecondtest.com. Upload how your pages, upload those of your competitors (or complete strangers not in your industry) and learn from real users which designs they prefer and what works best.

Hybrid Data Bottom-line: I love customers, I love Task Completion Rate as a powerful metric, I love VOC. Above are three simple ways in which you can collect competitive intelligence using Voice of Customer data and drive action perhaps even faster than the first seven methods!

[PS: Nothing, absolutely nothing, works better to win against HiPPOs than using competitors and customers!]

The Optimal Competitive Analysis Process.

A lot of data is available about your industry or your competitors that you can
use to your benefit.

Here is the process I recommend for CI data analysis:

1. Ensure that you understand exactly how the data is collected.

2. Understand both the sample size and sampling bias of the data reported to you. Really spend time on this.

3. If steps 1 and 2 pass the sniff test, use the data.

Don’t skip the steps, and glory will surely be yours.

See the additional posts linked to below for types of analysis you can do once you choose the right tool [OR you can also start on page 221 of my new book Web Analytics 2.0!].

Ok now your turn.

Do you use a source of competitive intelligence data not covered in this blog post? Which of the above 7 is your favorite? Was there something surprising you learned in this post? What is one thing you would add to the critical analysis above?

Please share your tips, best practices, critique in comments.


Couple other related posts you might find interesting:

01 Feb 2010 03:01 am

bloomHere is a key difference between Reporting Squirrels and Analysis Ninjas: The latter almost exclusively leverage custom reports (powered by advanced segmentation) and the former flirt with one standard report and then another and then other and in the best case scenario pull only half of their hair out.

There is nothing particularly wrong with the standard 19,000 reports in your web analytics tool. But they do represent the Vendor's best guess about what you should look at. Sometimes they even get it right.

Most of the time though your business is absolutely unique (even as it exists amongst hundreds of competitors) and it is absolutely important that you take your web analytics tool and mold it around you. The power that is given to you even in free tools like Yahoo! Web Analytics and Google Analytics can create a view of data that will help you find faster insights.

This post is inspired by a suggestion from Horia Neagu in reply to my tweet asking for blog post ideas. My thanks to Horia.

Horia's question was: How about a post entitled "10 Google Analytics Custom the Reports You Absolutely Must Set Up"?

I am not going to write about that, simply because the very idea that a report is custom means that there are probably no "ten standard custom reports" to set up.

I am going to share one recommendation and two ideas for making your own custom reports better.

This is a "teach a person to fish" type post. Sorry. :)

[UPDATE: If you want to download three advanced custom reports to do Page Efficiency Analysis, Visitor Acquisition Efficiency Analysis & Paid Search Performance Analysis please check out: 3 Awesome, Downloadable, Custom Web Analytics Reports]

many different directions

No Goals, No Glory.

Here's a cliché: If you don't know where you are going, any road will take you there.

Nowhere is this more applicable than when it comes to trying to find insights from your data you can action.

You report your poor heart away, no one seems to be able to take anything you give and take action.

Often it is the case that you and I have not bothered to sit down with he HiPPO / the boss's boss and tried to understand what in the name of all that is holy and pure is our website trying to do!

What are the goals?

No custom report (or advanced segment, the life giving oxygen) was ever created without an answer to that question.

So ask that question. Get an answer before you go about your customization ways.

If your leaders / clients truly want wisdom from you they will answer the question. But it does happen sometimes that begging or throwing yourself at her/him does not elicit anything of value.

question 1In those rarest of rare cases (after you have already submitted your resume to other companies that will cherish you for the golden child you are) try to figure these one or more of these three things out:

1. Where it the company currently spending money? Email marketing? Affiliate? Paid Search? Online PR?

And what's the biggest bucket?

Now go create your custom reports because if you can help the HiPPO's figure out how to reduce cost of acquisition they will love you more than you can imagine.

2. If possible, without violating HR policies, figure out what your boss's salary bonus is tied to.

Start doing analysis that will help your boss get a raise. A great goal to have, love and promotions likely.

3. Go visit your website, yes yes the one you have not used for a while. : ) Find out the single worst thing about it (should take you less than half hour of clicking around).

Now go look for data that will help you prove that the worst thing is the worst thing. Not a bad goal to have to fix what's completely broken, and people will listen.

Three good proxies if you have no goals to start with. Ideally you'll know what your Macro Conversion is so you'll start your analysis with a bang. Super ideal would be that you know both your macro and micro conversions!

Remember: No goals, no glory. Not for you. Not for your boss. Not for your company.

Custom Reporting Tip #1: Always, Always, Always Focus On The End To End.

One problem with standard web analytics reports is that the data you need is scattered all over the place, making it harder for you to find insights.

For example I am trying to figure out which pages stink and need fixing. In Yahoo! Web Analytics the standard report only shows Page Views and Average Time on Page. How much good will that do?

Or I want to figure out which sources of traffic I should make love to or divorce? The standard Google Analytics report spreads the data I need over four tabs.

Custom reports are good at solving this problem. Drag the dimension you need (traffic sources, landing pages etc) and analyze the data by choosing the metrics that tell the end to end story.

End to end has three pieces: Input. Onsite Activity. Outcome.

Here is my favorite, custom, traffic sources report:

google analytics custom traffic sources report sm

[Click on the image for a higher resolution version.]

By inputs I mean metrics that help you understand (in line with your goals) how well the "top of the funnel" (usually acquisition) is working.

visits new visitsIn my case that is measuring Visits (to know who is sending how much) and % of New Visits (to know who is sending how much that is of value to me – new visitors are very valuable in this case).

At a glance I have the information to start making some preliminary superficial judgments about performance.

By onsite activity I mean choosing metrics that help you understand the behavior of your visitors on your website (thus absolving your Acquisition team of any blame, perhaps!).

bounce rate average time on siteIn my case that is measuring Bounce Rate (not so fast Acquisition team, don't get me bad traffic! :)) and Average Time on Site (as a proxy of measuring if the landing pages are engaging visitors and as a proxy of how much each traffic bucket engages with the site).

Depending on my goals I would choose different onsite activity metrics for my custom report.

By outcomes I mean, well you don't need to know do you? You read this blog! I am all about outcomes, every day!!

goal conversions average valueIn my case the outcome metrics are Goal 1 (my macro conversion) and Average Value created for my website.

I could also have used $ Index or Per Visit Goal Value metrics if I were analyzing a non-ecommerce / content only website.

Remember Without a crisp articulation of outcomes every battle you fight will be lost, every day and you will live a very very unhappy life.

With these end to end metrics my custom report tells me stories that would otherwise take too long to piece together (or stories I might have missed completely).

One of the stunning realizations was just valuing Twitter traffic for example. (Click on the above report for a higher resolution report).

My twitter (social media) campaigns were doing exceptionally well. Lots of traffic (#3) overall, the second highest conversion rate (0.78%) and a Average Value that was not the best but rather sweet ($136 – which looks ever better when you compare the cost which is negligible).

Yet non focused traffic from twitter is not doing that well. 0.33% conversion and $39 average value. Pathetic.

I can now jump, like a na'vi, from row to row understand performance quickly and efficiently.

The power for a custom report that shows the end to end story.

It is so easy too.

For example here is the exact same custom report created in Yahoo! Web Analytics, just 30 seconds of drag and drop:

yahoo web analytics custom report sm

[Click on the image for a higher resolution version.]

Always go e2e. If you don't, you better have a good excuse!

Custom Reporting Tip #2: Create "Micro Eco-Systems".

I think I can honestly say that I have get to meet a single decision maker or a department or a company that has yet to tell me: "You know what the problem is Avinash? I don't get enough reports."


We love spewing out data and pretty soon your company has 200 reports and I'll bet you $50 that not a single decision is actually based on data.

So fix it.

Create micro eco-systems.

What I mean are custom reports that do three things:

1. Reduce the number of reports (kill! kill! kill!) and yet coalesce information into one place.

2. Match metrics up with the audience that needs it. Personalize, personalize, personalize!

3. Force you, yes dear darling you, to talk to people and truly understand what motivates them (and then you create a report!).

Let's understand how to do this by looking at a real life example.

My goal is to create a "search ecosystem" report that collects different important pieces of data, for three different stakeholders, all into one place.

I do that by first understanding who all the stake holders are who'll need to use the data (let's hope!) and doing a simple stake holder interview to understand what their business goals are.

Now rather than spamming everyone with a report (that no one will find, I'll have a hard time version controlling, and other such pain), I'll just put it all together in one place (at least in Google Analytics due to a simple yet exceptional feature – tabs!!).

Here is a pictorial view of the process that I'll go through:

google analtyics custom micro ecosystem report sm

[Click on the image for a higher resolution version.]

My first "client" is the Acquisition team, they are responsible for spending the company's money wisely. They are measured on bringing new Visitors (potential customers) to the site.

I create a tab for them that shows Visits, New Visits, Bounce Rate and Average Time on Page (not site). I add the latter two because I want them to see their end to end view and I want them to realize they hold some level of responsibility for people not just coming, but also staying.

We have just one report, each day (God willing) they'll log in and see their own personalized sweet view of the data:

search traffic acquisition report sm

[Click on the image for a higher resolution version.]

But I am not done yet.

Next up is my HiPPO. Let's call him Paul.

Paul only cares about Revenue and all things connected to revenue. He does not care about any other metric. Nothing wrong with that.

Rather than creating another report for Paul I click on *Add Tab* simply do this:

add tab to a custom report

Create a person view for Paul. I throw in Visits (I have to give him some context and some Input metric) and Goal Conversion Rate (so he knows efficiency), Goal Value, Revenue, Shipping (because Paul is having us charge lots for shipping because he thinks of it as a profit center (!!), not great but remember I am personalizing).

Here's the resulting output:

search traffic hippo report sm

[Click on the image for a higher resolution version.]

You know what the result is?

Paul actually looks at the data every other day (and a bit deeper each Friday) because it does not contain crap. It contains just what he needs to do his job (find people to reward and find people to fire).

That is what you are going for. Taking people from data apathy to data usage.

[Oh yes, yes, I noticed Revenue and Shipping are zero in the above screenshot. I wish I could show you someone's real data! Not today. But you get what the report is trying to do.]

Finally there's Amy. Another key stake holder, but a tougher nut to crack. You see her bonus is tied only to Visits, a low bar if there ever was one.

So what do you do?

You can't over smart Amy, she is too smart for you (and probably a level or two higher).

You are going to lose her if you give her too much data.

You need to entice her to start using data, and restrain your smarts – you know you want to create a impressive 8 column report!

In this case I simply add a tab. It says Amy Chang (so she knows it is her very own personal report). It has Visits and Average Time on Site. I added Time on Site as a Outcome metric, just to keep up with my outcomes obsession.

search traffic amy report sm

[Click on the image for a higher resolution version.]

It is simple. It is effective.

It will get her to see just the data she wants (plus one more thing :)).

And here's the sweet part…. since this his an eco-system report perhaps she (and Paul as well) might see other pieces of data in other tabs and might be intrigued enough to ask you to add more metrics.

Then and only then and only at that time and only when you are asked (am I repeating myself?) add those metrics. It is vastly more likely that she (and Paul) will use the data.

There you go… one report that has all the data each stake holder needs personalized and customized.

No one is going to come to you and say: "hey want folder is my search report" or "I don't understand what all this data is saying" – it is personalized. And when you have to make changes, it is all in one place.


happy birthday

Such simple little things: tabs (or cup cakes :)).

Makes it so much easier for you to create a data democracy. And a bit sad that you can't do this with most paid web analytics tools today – yes you can create a custom report but the above report would be a one huge 13 column report that:

1. You would be able to read on your computer screen and

2. No one will understand because of spurious data unrelated to what they want and

3. Drive you into the arms of a multi tab excel spreadsheet (which will bring its own bucket of pain for you).

I hope all paid web analytics vendors will incorporate this feature, for the sake for our data democracy!

That's the story. Goals. End to End. Micro self contained eco-systems.

I was hoping to teach you how to fish, rather than just tell you which 10 reports to create. Regardless of the specifics of the reports and metrics above I hope you have learned a bit more as to how to think about approaching the issue and the important things to focus on.

Custom reports are a powerful way to take what looks overwhelming in web analtyics – REPORTS and DATA – and make it didapper. It is also a wonderful way to start the journey of your company, big or small, to start using data.

Ok now your turn.

Do you have custom reporting tips to share with us? What small or big thing you have done that really really worked for you? Have you tried end to end reports? How about micro eco-systems? What strategy completely failed? Got a custom report you think everyone in the world should be using?

Please share your stories / tips / bruises / successes.

I'll send the best one a copy of my new book Web Analytics 2.0.

UPDATE: It was hard to pick just one winner so a copy of the book goes out to SteveK (for advocating common sense!) and to Ali Shah (for emphasizing sharing of context). A bonus prize also goes to MGSeeley (for bringing a smile with his adorable analytics haiku!).