Thursday
Oct152009

Yahoo Web Analytics data inflated by Bing and how to fix it

This article is thanks to Rudi Shumpert from Code by Numbers who picked up this issue earlier this month where the bot from Bing was artificially inflating Omniture Site Catalyst data.

Today I discovered that Yahoo! Web Analytics (YWA) is also being impacted by this bug, thankfully it was easy to discover this using the “Last Visitors” report. Interestingly this is a report I would rarely (if ever) use but after seeing increased traffic to my site over the last couple of weeks decided to drill into the strange traffic using this very granular report.

Fortunately being a reader of Rudi’s blog I immediately recognised a strange set of visitors from Washington, using IE6 with a low screen resolution from msn.com using an IP address beginning 65.55.*.*

When Rudi discovered this in Site Catalyst it was a relatively complex process to filter out the data using a coldfusion tag to prevent the JavaScript loading. I’m neither a developer, nor do I have access to server level code for Squarespace, but with YWA it’s easy to filter data using an IP Address filter:

Step 1: Go to settings, select “exclude your browser and edit report defaults”:

Step 2: Click “edit” in general settings:

Step 3: Go to Statistics Settings, enter an IP address range of 65.55.*.* then click update

As YWA is a real time analytics tool, the erroneous Bing bots will be excluded from forward looking reports. One more little issue dealt with.

Cheers, James.

PrintView Printer Friendly Version

EmailEmail Article to Friend

References (1)

References allow you to track sources for this article, as well as articles that were written in response to this article.
  • Source
    The past couple of months we noticed a very odd trend the the geo-location / city data that was being saved in Omniture. The great metropolis of Redmond, Washington was now the number 1 city of origin of our web visitors. And this was not a small lead, they were the number 1 city by more than double the traffic from the number 2 spot.

Reader Comments (4)

James,

Thanks for the comments. That is very cool that YWA lets you set an exclude filter like that.

-Rudi

October 15, 2009 | Unregistered CommenterRudi Shumpert

well, isn't this still in beta, or even with this issue it has been open to the public?

October 21, 2009 | Unregistered Commenteranalytics

Hi Rudi - thanks for discovering the problem in the first place! There are a lot of very nice features in YWA, am currently in the process of documenting

Hi 'analytics',

Yahoo Web Analytics is not in beta, but the tool is currently only open to Yahoo! advertisers (via account management team or through Yahoo Analytics Authorised Consultants (see YWACN site here).

Cheers, James.

October 23, 2009 | Registered CommenterJames Dutton

ColdFusion offers a Simplified database access, which really helps me with workflow.

November 1, 2009 | Unregistered CommenterColdFusion Consulting

InfoYour post has been submitted.

Your post will be visible on this site after it has been approved by an editor.
« "Secret" new Google Analytics features (GA Intelligence) to be released soon? | Main | Web Analytics Association comes to Singapore and South East Asia »