filter in custom connector google analytics
Are there any documentation in the google analytics custom connector at the filter level
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 filterga: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 contain a match for a regular expression Exclude data for visitors from countries starting with ‘united’.ga:country!~united
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.
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
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.
I am no longer with Domo, please reach out to another Domo lead for assistance. Thank you!2
- 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
In the help center there is an entire page dedicated to the google analytics connector
This does not have any specifics on the filter options but refers to the google api documentation. The best page I found on this is
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 479 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 43 Visualize
- 199 Beast Mode
- 2K Charting
- 8 Variables
- 20 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 29 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部