ip python filter
Estimated Read Time: 3 minute(s)
Common Topics: google, analytics, ip, python, filter

Not every Python script needs to be complex, long, and work of art. Sometimes it can help with quick mundane tasks. One such opportunity presented itself a couple of weeks ago where a client asked for 50+ IPs to be filtered from a Google Analytics view.

We could have taken 20 minutes and manually added them, but we instead took 5 minutes to write a very small Python script to do it for us and now we have a script to use next time a client wants to bulk exclude filter IPs too! Let’s get started!

Requirements and Assumptions

  • Python 3 is installed and basic Python syntax understood
  • Access to a Linux installation (I recommend Ubuntu) or Google Colab.
  • IP list in a CSV under column name “ip”

Import and Install Modules

  • pandas: for importing the IPs

Let’s get that one lonely module imported.

import pandas as pd

Next, we import the CSV containing our IPs into a dataframe.

Import and Convert

df = pd.read_csv("ipp-ips.csv")

Now we convert the IP column into a list object.

ip_list = df["ip"].tolist()

Escape and Join

With a couple of simple list comprehensions, we escape the period (.) in each IP, which is RegEx signifies a wild card and we add in the start and end anchor (^ and $) to match the IPs exactly.  The start and end anchors express how a string should begin and end exactly.

ip_list = [x.replace('.','\.') for x in ip_list ]
ip_list = ['^' + x + '$' for x in ip_list ]

Once we have our IPs formatted we need to add in the RegEx alternation pipe between each of them which signifies “OR”.

seperator = "|"

Add to Google Analytics Filter

Run the script and you could get an output like (depending on how many IPs you have, yes I know these are all the same IP):


Head over to your Google Analytics view and paste into the filter creation. Note there is a 255 character limit per filter. If you have many IPs, you’ll need to split them up into multiple filters. I would love to learn a nice way of doing this automatically with Python while not cutting the IPs up in bad spots.

filter ip google analytics


In seconds you avoid the manual grind of adding IPs to a Google Analytics filter. Remember to try and make my code even more efficient.  Now get out there and try it out! Follow me on Twitter and let me know your applications and ideas!

IP Filter for Google Analytics Using Python FAQ

How can Python and RegEx be employed for a bulk IP filter in Google Analytics?

Python scripts can be developed to implement a bulk IP filter using regular expressions (RegEx) to exclude specific IP addresses from Google Analytics data.

Which Python libraries are commonly used for implementing a bulk IP filter with RegEx for Google Analytics?

Python libraries like re for regular expressions, googleanalytics for interacting with Google Analytics, and pandas for data manipulation are commonly used for this task.

What specific steps are involved in using Python and RegEx for a bulk IP filter in Google Analytics?

The process includes fetching Google Analytics data, defining a list of IP addresses to filter, applying RegEx patterns to match and exclude those IPs, and updating the Google Analytics configuration.

Are there any considerations or limitations when using Python and RegEx for a bulk IP filter?

Consider the accuracy of RegEx patterns, potential variations in IP formats, and the need for periodic updates to the filter list. Ensure compliance with Google Analytics terms and conditions.

Where can I find examples and documentation for a bulk IP filter in Google Analytics using Python and RegEx?

Explore online tutorials, documentation for relevant Python libraries, and resources specific to Google Analytics API integration for practical examples and detailed guides on implementing bulk IP filters with Python and RegEx.

Greg Bernhardt
Follow me

Leave a Reply