{"id":4191,"date":"2020-05-14T11:11:48","date_gmt":"2020-05-14T11:11:48","guid":{"rendered":"https:\/\/trackingchef.com\/?p=4191"},"modified":"2020-12-14T15:12:45","modified_gmt":"2020-12-14T12:12:45","slug":"creating-filters-in-google-analytics","status":"publish","type":"post","link":"https:\/\/trackingchef.com\/google-analytics\/creating-filters-in-google-analytics\/","title":{"rendered":"Creating filters in Google Analytics"},"content":{"rendered":"\n<p>A Google Analytics (GA) Property can be split into multiple Views, to simplify your analysis and limit the data visible to different stakeholders in the organization.<\/p>\n\n\n\n<p>Using filters, the GA account admin can limit each View to a specific subset of data collected by the Property.<\/p>\n\n\n\n<p>In this post I will explain how to create filters with examples of common filters I use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Important notes on filter<\/h2>\n\n\n\n<ul><li>Filters can only be created by users with Edit permissions to the Google Analytics account. Other users can only add or remove an existing filter to a View.<\/li><li>Filters are managed on the Account level and can be shared across Properties and Views.<\/li><li>Filters do not apply retroactively so that they will only effect data from the point they were set and onwards. If you have damaged data in your View, it will not fix that (you can probably use a Segment to fix most of it).<\/li><li>Multiple filters can be applied to a single view, but they will act in the order in which they are set. <ul><li>A good example is filtering out internal traffic and then only traffic to the blog, which will return a &#8220;clean&#8221; view of non-employee blog traffic.<\/li><li>A bad example is filtering in only traffic from the UK and then only traffic from Argentina. This will result in no data, as no user can answer both criteria simultaneously.<\/li><\/ul><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a Filter<\/h2>\n\n\n\n<ol><li>To create a filter, navigate to your account&#8217;s Admin page.<\/li><li>Select the relevant Account, Property and View<\/li><li>Under the View column, click on &#8220;Filters&#8221;<\/li><li>You will see a list of the existing set for this View and their order<br>(you can set the filter&#8217;s order by clicking &#8220;Assign Filter Order&#8221;)<\/li><li>Click &#8220;+Add Filter&#8221;<\/li><li>You can then choose to create a new filter or apply an existing one from your account<\/li><li>When creating a new filter you also need to set its name. I recommend using descriptive names, e.g. &#8220;Exclude internal traffic&#8221; or &#8220;Include only blog traffic&#8221;<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Creating a Predefined Filter<\/h3>\n\n\n\n<p>Google Analytics offers four standard filters as predefined, making them simple to create. <\/p>\n\n\n\n<ol><li>Select the Filter Type &#8220;Predefined&#8221;<\/li><li>Select the filter type, Exclude or Include.<ol><li>Exclude will filter <strong>OUT <\/strong>sessions that match the criteria<\/li><li>Include will filter <strong>IN <\/strong>only sessions that match the criteria<\/li><\/ol><\/li><li>Select the filter criteria &#8211; What do you want to filter by?<ol><li>ISP Domain &#8211; This filter is obsolete as this data point has been depracated in 2020<\/li><li>IP Addresses &#8211; This filter can be applied to filter out internal traffic (or filter in only Dev traffic)<br>Your IP address can be easily found by Googling &#8220;What is my IP address&#8221;. This filter can also be applied to an IP C-Class to exclude multiple IPs.<\/li><li>Subdirectories &#8211; This filter can be applied to include only traffic to a specific subfolder on you site, e.g. a blog that sits under \/blog<\/li><li>Hostname &#8211;  This filter can be applied to include\/exclude only traffic to a specific domain or subdomain, e.g. a blog that sits on blog.example.com<\/li><\/ol><\/li><li>Select the criteria expression &#8211; How do you want to match the criteria?<ol><li>That are equal to<\/li><li>That begin with<\/li><li>That end with<\/li><li>That contain<\/li><\/ol><\/li><li>You can then add the criteria to match in the field shown<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"617\" height=\"250\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-17.png\" alt=\"\" class=\"wp-image-4195\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-17.png 617w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-17-300x122.png 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><figcaption>Predefined filter in Google Analytics<\/figcaption><\/figure>\n\n\n\n<p>After the filter is set up, you can test the filter before saving by clicking &#8220;Verify this filter&#8221;. This will test the filter against traffic from the past 7 days to see how the data would have been impacted. If this is a new account without previous data, this test is irrelevant.<\/p>\n\n\n\n<p>In the case of IP related filters, this test isn&#8217;t supported as Google Analytics doesn&#8217;t store IP data for future reporting (it is only used in the initial data processing of a session).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating a Custom Filter<\/h3>\n\n\n\n<p>For more complex uses, Google Analytics offers the option for Custom Filter. Aside from include\/exclude filters, these filters can also be used to manipulate the data collected by GA.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Exclude and Include<\/h3>\n\n\n\n<p>Similarly to the Predefined filter, you can Include\/Exclude sessions based on almost any data point available in GA. Unlike the Predefined filters, these use <a rel=\"noreferrer noopener\" href=\"https:\/\/en.wikipedia.org\/wiki\/Regular_expression\" target=\"_blank\">Regex (Regular expressions)<\/a> for matching the string. If you&#8217;re only using numbers and characters, in most cases this won&#8217;t make any difference.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"467\" height=\"571\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-18.png\" alt=\"\" class=\"wp-image-4196\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-18.png 467w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-18-245x300.png 245w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><figcaption>Custom filters in Google Analytics<\/figcaption><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Pro tip:<\/strong><br>You can &#8220;dry run&#8221; these filter in advance in almost any report by creating an advanced filter with Regex matching<\/p><\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">Lowercase\/Uppercase<\/h3>\n\n\n\n<p>For example, campaign data in GA is case sensitive, so the reporting for Summer-Love-2020 and summer-love-2020 will be split into two separate campaigns. With the Lowercase\/Uppercase filter, you can enforce a unified naming convention.<\/p>\n\n\n\n<p>I personally always default to lowercase.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Search and Replace<\/h3>\n\n\n\n<p>This filter is useful for fixing errors that are out of our control or removing sensitive data from GA.<\/p>\n\n\n\n<p>For example, if a partner of yours is linking to your website with the wrong UTM parameters, you can easily capture these and update to the right ones.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"444\" height=\"302\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-19.png\" alt=\"\" class=\"wp-image-4197\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-19.png 444w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-19-300x204.png 300w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><figcaption>Replace a string with string<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Advanced<\/h3>\n\n\n\n<p>This filter can be used to remove sensitive data, such as personally identifiable information (PII) from the URL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Filters I use<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exclude internal traffic<\/h3>\n\n\n\n<p>Useful for maintaining  your GA data clean from employee traffic.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"391\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-20.png\" alt=\"\" class=\"wp-image-4199\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-20.png 654w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-20-300x179.png 300w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<p>Your IP address can be found by Googling &#8220;what is my IP address&#8221;. In an office setting, I recommend asking your IT team.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Include traffic to my domain<\/h3>\n\n\n\n<p>This filter is useful for blocking spam traffic on your GA account (it&#8217;s a thing, really). It will only include sessions that have landed on your domain.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"381\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-21.png\" alt=\"\" class=\"wp-image-4200\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-21.png 647w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-21-300x177.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Include traffic to a subdomain<\/h3>\n\n\n\n<p>This filter will include only traffic to a certain subdomain, e.g. blog.trackingchef.com<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"643\" height=\"384\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-22.png\" alt=\"\" class=\"wp-image-4201\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-22.png 643w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-22-300x179.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Include traffic to a subfolder<\/h3>\n\n\n\n<p>This filter will include only traffic to a certain folder, e.g. trackingchef.com\/blog<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"381\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-23.png\" alt=\"\" class=\"wp-image-4202\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-23.png 659w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-23-300x173.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/figure>\n\n\n\n<p>If this is the top most folder, I recommend using the expression &#8220;that begin with&#8221;.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Include traffic from a specific country<\/h3>\n\n\n\n<p>This filter is a Custom one.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"518\" height=\"497\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-24.png\" alt=\"\" class=\"wp-image-4203\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-24.png 518w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-24-300x288.png 300w\" sizes=\"(max-width: 518px) 100vw, 518px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Pro tip:<\/strong><br>You can concatenate several countries in a single filter with a | (pipeline) between them, e.g. United Kingdom|Argentina|Pakistan<\/p><\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">Include traffic from a specific source<\/h3>\n\n\n\n<p>This filter is useful when I want to analyze only a specific traffic source or when working with a vendor in charge of a specific source, e.g. your SEO agency. This example will filter in only traffic from Organic channels (Search Engines).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"484\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-25.png\" alt=\"\" class=\"wp-image-4204\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-25.png 512w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-25-300x284.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Add hostname to path<\/h3>\n\n\n\n<p>When working with multiple domains or subdomains under a single Property, the View level reporting will not show the hostname by default, causing much confusion in analysis. To resolve this, you can add the Advanced filter to  prepend the hostname to the URL.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"550\" height=\"550\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-26.png\" alt=\"\" class=\"wp-image-4205\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-26.png 550w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-26-300x300.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2020\/05\/image-26-150x150.png 150w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/figure>\n\n\n\n<p>Advanced <strong>Field A -&gt; Extract A<\/strong>:<\/p>\n\n\n\n<ul><li>Select field: Hostname<\/li><li>Paste (.*)<\/li><\/ul>\n\n\n\n<p><strong>Field B -&gt; Extract B<\/strong>:<\/p>\n\n\n\n<ul><li>Select field: Request URI<\/li><li>Paste (.*)<\/li><\/ul>\n\n\n\n<p><strong>Output To -&gt; Constructor<\/strong>:<\/p>\n\n\n\n<ul><li>Select field: Request URI<\/li><li>Paste $A1$B1<\/li><\/ul>\n\n\n\n<p>Keep &#8220;Field A Required&#8221; and &#8220;Override Output Field&#8221; selected<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post I will explain how to create filters with examples of common filters I use.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4191"}],"collection":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/comments?post=4191"}],"version-history":[{"count":7,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4191\/revisions"}],"predecessor-version":[{"id":4822,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4191\/revisions\/4822"}],"wp:attachment":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/media?parent=4191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/categories?post=4191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/tags?post=4191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}