Categories: Online Marketing

How To Use Google Analytics View Filters To Exclude Multiple IPs

Setting up Google Analytics is easy. You simply have to install the Google Analytics tracking code on the site and BOOM! Data starts flowing through your dashboard.

Right? WRONG!

One of the biggest mistakes most people make while setting up Google Analytics is they DON’T exclude internal IPs, and you may be one of them.

How many times in a day do you check your own (or your client’s) website? Once? Twice? More than ten times? If it’s more than that, you have skewed data.

The solution is to use the view filters to exclude yours and your client’s IPs from getting tracked in Google analytics.

Let’s take a look at how you can exclude:

  1. Subnet Of IPs
  2. IP Ranges (Sequential)
  3. Random IPs

How to Exclude Specific IP’s from Google Analytics for better reporting:

#1 Exclude Subnet of IPs

Let’s say you want to exclude all the subnets of IPs starting with 192.168.0.x, where x is any number.

You can create a view filter with type as ‘predefined’, then select ‘exclude traffic from IP address that begins with‘ and paste the starting part of an IP  ‘192.168.0’

Doing so will filter out all the IPs starting with 192.168.0

For Eg: 192.168.0.1, 192.168.0.2, 192.168.0.3 and so on…

Save the filter and you’re good to go.

#2 Exclude IP Range (Sequential)

IP Range can be any range of sequential IPs, for eg:

  • 192.168.0.0 – 192.168.0.9
  • 192.168.0.10 – 192.168.0.19
  • & so on…

I have seen a lot of people creating ten different filters for each IP, a very time-consuming job. The best way is to use REGEX to exclude the group of IPs in a single filter.

Here’s how you can do it.

  1. Go to view filters and create a new one.
  2. Choose Filter Type as ‘Custom’ and Filter Field as ‘IP Address’
  3. Add ‘^192\.168\.0\.[0-9]$’ in the filter pattern

The above example will exclude IP range from 192.168.0.0 to 192.168.0.9 (10 IPs).

I won’t go into much details about regex, but remember these basics:

  • ^ – denotes the start of the string
  • $ – denotes the end of the string
  • | – denotes the ‘OR’
  • \ – denotes the escape character.
  • [0-9] – denotes any number from 0 to 9

Lastly, save the filter.

#3 Exclude Random IPs

Well, most of the times you need to exclude the IPs of your home, office, mobile, and clients.

These IPs are neither sequential nor a part of the same IP subnet; they are random.

In that case, you can simply use the ‘OR’ in Regex which is denoted as ” | “. So if you have random IPs, say 193.168.0.34 & 127.101.1.1.

You can use ^193.168.0.34$|^127.101.1.1$

Check the image below.

As we discussed earlier ‘^’ denotes ‘starts with’, ‘$’ denotes ‘ends with’ & ‘|’ denotes ‘OR’ condition.

So, if you have five random IPs, you can simply put it in this format:

^IP1$|^IP2$|^IP3$|^IP4$|^IP5$

Click Save.

Tip #1: Use Regex Tool To Verify The Syntax

Sadly, Google Analytics does not provide the ‘preview‘ for IP address filters.

No worries.

You can use any Regex testing tool available online. One of them, which I use a lot, is Regextester.

You can input your Regex pattern in the above row and paste all the IPs you want to exclude in the ‘Test String’ box.

I have included four IPs in the Regex pattern and pasted the same in the Test String box (along with one extra IP).

If the IPs turn blue, those are matched.

If everything goes well, you can copy the same expressions and add ^ & $ at the start/end of each IP and use it in Google Analytics.

Tip #2: Use Tag Assistant To Test Different IPs

Tag assistant is a chrome add-on which allows you to debug and test whether or not your Google tags are firing correctly.

One of the features is to change the IP address.

You can test the IP addresses which you have excluded via Regex filters one by one and click ‘update’.

Tag assistant will re-analyze the reports and show you if the hits are well filtered. You can learn more about it here.

Final Thoughts

Google Analytics filters are non-retroactive. i.e., the filters will only alter the data moving forward.

So make sure you exclude internal IPs at the initial stages of setting up the Google Analytics.

This is a guest post by Ritwik. If you would like to submit something original for ShoutMeLoud then read our submission guidelines here.

Also, here are a few hand-picked guide for you to read next:

Subscribe on Youtube

Share

Recent Posts

5 Best Ecommerce Tools Every Merchant Needs to Know!

The world is going online. With the new infrastructural developments taking place globally, more and more businesses are opting to… Read More

November 21, 2018 8:48 pm

Google Ads Brings Merchant Promotions to Shopping Actions by @MattGSouthern

Google Ads is bringing its Merchant Promotions program to Shopping Actions for retailers. This integration allows online retailers to add… Read More

November 21, 2018 4:48 pm

Popular AMP for WordPress Plugin Patches Critical Security Flaw by @MattGSouthern

The top AMP plugin for WordPress, AMP for WP, has released a released a patch for a critical security vulnerability.… Read More

November 21, 2018 12:39 pm

How SEO & PPC Keyword Research Can Work Together by @TaylorDanRW

A well-orchestrated PPC campaign can benefit a good SEO campaign, as Sergey Grybniak explores in How to Combine SEO &… Read More

November 21, 2018 8:38 am

3 Social Media Tools to Jumpstart Your Influencer Marketing

Social Media Marketing Industry Report In our 10th annual social media study (44 pages, 70+ charts) of 5700+ marketers, you'll… Read More

November 21, 2018 6:28 am

Digital Extortion: Don’t Let Your Data Be Held Hostage by @tonynwright

Recently, our firm took over the digital marketing efforts for a small company. Their previous digital marketing efforts were led… Read More

November 20, 2018 8:18 pm