How do I apply regex filters in the Google Analytics connector?
Best Answer
-
Important to note, if the above article is displaying emoji in the filters of Google Analytics, you just need to turn them off to properly view the article.
This is found in My Settings > Preferences > Display.
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"2
Answers
-
A useful feature built into the Google Analytics connector is the ability to filter the data you import using Google’s own Filter API. Filters are short statements that you can apply within a Google Analytics Data Source that give you added flexibility to let you refine the data that’s imported.
For example, let’s say you are interested in building a Current Visitors Count Data Source that displays the number of visitors currently on the contact page on your website. By default the Data Source will pull through the total number of visitors across the whole of the website you’re tracking with Google Analytics. However, applying the filter ga:pageTitle==Contact would allow you to refine this and import only the visitors currently on your page titled ‘Contact’ on your Data Source.
BUILDING A FILTER STATEMENT: DIMENSIONS & METRICS
A filter statement consists of several elements that tell the Data Source exactly what data needs to be imported. At the heart of this statement are the dimensions or metrics that the Data Source is supposed to filter, such as the source of traffic or the URL of a specific page.
Popular dimensions and metrics include:
campaign medium keyword year language day source pageTitle transactions pagePath country bounceRate A full range of metrics and dimensions can be found at https://developers.google.com/ analytics/devguides/reporting/core/dimsmets. Almost all of these can be added and even combined within a filter statement to create a very specific set of data within a Data Source.
BUILDING A FILTER STATEMENT: OPERATORS
Operators work with metrics to allow you to specify how your data should be manipulated. For example, if you’ve selected ‘city’ as the metric you’re interested in, do you want to include only data from a specific city, exclude data from a specific city, include only data from a specific list of cities, or display data from cities that contain a specific word? Operators let you take the basic ‘city’ data and do much more with it than simply showing it.
OPERATOR DESCRIPTION EXAMPLE == Equals, exact match Show data for visitors who have visited your website exactly 8 times.ga:sessionCount==8 != Does not equal, does not match Show visitor data for all sources apart from Google. ga:source!=google > Greater than Show data for visitors who have visited your website over 9 times.ga:sessionCount>9 < Less than Show data for visitors who have visited your website fewer than 2 times.ga:sessionCount<2 >= Greater than or equal to Show data for visitors who have visited your website 9 times or more.ga:sessionCount>=9 Contains Show data for any page whose URL contains the word ‘learn’.ga:pagePath=@learn Does not contain ga:pagePath!@404 =~ Contains a match for a regular expression Show data for visitors from countries starting with ‘united’.ga:country=~united !~ Does not start with, using regular expression Exclude data for visitors from countries starting with ‘united’.ga:country!~united Source: https://developers.google.com/analytics/devguides/reporting/core/v3/reference#filterOperators
BUILDING A FILTER STATEMENT: STRINGS & VALUES
The final part of a filter statement to be aware of is the string or value. Set at the end, it lets you define a specific value for the metric you’re basing your filter on, for example an individual city, date, page title or traffic source. The string or value should match those available for the metric you’ve defined in the first part of the statement, i.e if your metric is ‘city’ you much choose the name of a city to filter or else you will trigger an error.
COMBINING FILTERS
Filters can also be combined using AND as well as OR logic to create a powerful tool for monitoring very specific elements of your business.
The OR operator is defined using a comma (,). It takes precedence over the AND operator and may NOT be used to combine dimensions and metrics in the same expression.
Example: Visitors using either Windows OR Macintosh operating systems: ga:operatingSystem== Windows,ga:operatingSystem==Macintosh
The AND operator is defined using a semi-colon (;). It is preceded by the OR operator and CAN be used to combine dimensions and metrics in the same expression.
Example: Country is United Kingdom AND the source is Facebook: ga:country==United%20 Kingdom;ga:browser==Facebook
Source: https://developers.google.com/analytics/devguides/reporting/core/v3/reference#combiningFilters
EXAMPLE FILTERS
Here are some example filters to get you started:

FILTER SYNTAX ga:source==twitter.com Traffic source is Twitter ga:keyword==google Referring keyword is ‘google’ ga:pageTitle==Contact Title of page is ‘Contact’ (exact match) ga:pagePath=~contact URL of page contains ‘contact’ anywhere ga:country==United Kingdom Visitor country is United Kingdom ga:country==United Kingdom;ga:city!=London Country is United Kingdom and City is not London ga:eventCategory==DownloadReport,ga:eventCategory==DownloadCaseStudy Show all events with the category DownloadReport or DownloadCaseStudy ga:eventCategory==DownloadReport,ga:eventLabel!=ShareCaseStudy Show all events with the category Download but not Label ShareCaseStudy There are a number of useful resources that have been provided by Google to help explain the many other ways to get the most out of Google Analytics. Please see the links below for additional information.
- Google Analytics Concepts https://developers.google.com/analytics/resources/concepts/
- Google Analytics Academy https://analyticsacademy.withgoogle.com/
- Google Analytics API filters: Dimensions & Metrics https://developers.google.com/analytics/devguides/reporting/core/dimsmets
- Getting the most out of Google Analytics http://blog.kissmetrics.com/50-resources-for-getting-the-most-out-of-google-analytics
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"4 -
Important to note, if the above article is displaying emoji in the filters of Google Analytics, you just need to turn them off to properly view the article.
This is found in My Settings > Preferences > Display.
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive