Filtering IP Ranges From SmarterStats Reports

 Analytics  Comments Off on Filtering IP Ranges From SmarterStats Reports
Dec 162016
 

Recently while looking through my site’s traffic report from the past few months I noticed an unusual spike.  I use SmarterStats by SmarterTools which is a web based enterprise analytics tool and is free for one domain. After looking through a few other reports I came to realize that the spike I was seeing was caused by my site monitoring tool UptimeRobot. I didn’t want that activity to skew my stats so I decided to remove their IP address from the reports.

image

 

Using Logparser to find IP addresses by userAgent

UptimeRobot’s monitoring services use a range of IP addresses so I decided to use Log Parser to double check my logs to see which IPs of theirs where showing up. Here’s the query I used.

Add a Log Processing Rule

Log Parser quickly identified the IPs I wanted to exclude. Fortunately SmarterStats makes it easy to exclude a variety of data from your reports. After logging into your Stats report click on Settings and then Log Processing Rules.

 

image

Click Add from the menu and select Log Processing Rule. The Import Filter window will open and you can configure what you need to exclude or include.

image

 

To exclude the UptimeRobot IP addresses I enter the ranges 69.162.124.226 – 69.162.124.237 and 63.143.42.242 – 63.143.42.253. Their service uses a variety of IP addresses depending on where you are in the world. You can read more about that here.

image

 

Reprocessing Logs

After you have added the metrics that you want to filter from your logs you should clikc the Reprocess button. Depending on how many months or years of data you have in your logs it will take anywhere from a few minutes to a few hours. You will be able to monitor the import process from your report dashboard.

image

 

In Summary

SmarterStats by SmarterTools is a comprehensive web analytics tool. Periodically you may need to exclude data from your stats reports such activity from site monitoring services like UptimeRobot. Thanks for reading!

Peter Viola

Creative, customer focused, results oriented, Senior Web Systems Engineer who enjoys providing the highest level of customer service supporting complex Windows hosting solutions. MCITP, MCSA, MCTS

More Posts - Website