In this post we’re going to discuss how to block these bots from your GA reports so that you can have clean data from which to make smart business decisions and make more money!
First let’s understand that “well behaved” bots usually have one of two fingerprints:
What kind of tracks does your bot traffic leave? Well it’s best to start with an Advanced Segment that begins to whittle away this bot traffic from the real traffic. Apply this segment to your Google Analytics data and you’ll be viewing only direct traffic that bounces.
Do you see any patterns in the browser version reports? (Audience>>Technology>>Browser & OS)
In the screen shot above we’ve selected “Mozilla Compatible Agent” and version 5.0 with no Java Support looks like a likely bot suspect.
What about identifying bots by ISP? (Audience>>Technology>>Network)
So from the data above we can see some interesting sources of bouncing traffic. Next I created another segment to view each of these ISP’s (1. microsoft corp , 6. yahoo! inc. and 16. Inktomi Corporation).
As you can see from the data above, all of the traffic from these ISP’s bounced.
Your next action is to decide if you want to go a step further and actually filter out this traffic from your analysis profiles.
If you decide to block traffic based on browser profile, then you’ll need to construct a series of filters to do this.
The first two combine browser data together with Java Support (yes or no) to allow you to then filter only the offending browser profile (Third filter listed in the image above) that is utilized by the bots.
If you decide that the ISP route is the way to go, then you’ll have a much easier path:
Where the pattern is equal to yahoo|microsoft corp$|inktomi
Either way, you should remember to:
In summary, it really does not matter why the bot is on your site, what’s important is that they are triggering nuisance pageviews that can skew your numbers and conversion rates. Are they affecting your GA data? Apply the segments above and find out for yourself!
Google Analytics API has multiple reporting tools, one of them being Excellent Analytics. Marketers did you know about the Excel plugin that pulls your data from Google Analytics into Excel sheets?
To start this integration you can use this free tool called Excellent Analytics. Excellent Analytics is easy to install by clicking the download button at the top of the page.
Use Excellent Analytics to automate reporting and spend more time exploring in Google Analytics.
Measurements within Excellent Analytics include:
Once you have customized measurements for your report, choose the profile(s) the report will be run for. If there is more than one profile, Excellent Analytics will display a report for each profile side by side on the same spreadsheet. The Execute button will trigger these reports to start collecting data and your automated reporting will begin. The data will be collected and exported into Excel. Excellent Analytics is convenient, because the range with headers can be used for pivot tables and other marketing charts.