Skip to content

    • Connectors

    Connectors

    Regex Filters in Google Analytics?

    Member
    in Connectors

    Hello! I saw another post on this but I don't think that's what I was looking for.

    I'm trying to build a regex filter for the Google Analytics connector and I'm wondering how I can exclude a certain regex statement. This is what I have so far but I'm actually not sure what the operator should be. This filter is supposed to exclude a certain page from being counted towards the report, and I have metrics like pageviews, sessions etc.

    {

      "dimensionFilterClauses": [

        {

          "filters": [

            {

              "dimensionName": "ga:pagePath",

              "operator": "",

              "expressions": [

                "/grammar-and-plagiarism/"

              ]

            }

          ]

        }

      ]

    }

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      Hi @etszyingho

      As part of your filter you can negate the filter by passing in 

      1. "not": "True",


      It would look something like:

      1. {
      2.  
      3.   "dimensionFilterClauses": [
      4.  
      5.   {
      6.  
      7.   "filters": [
      8.  
      9.   {
      10.   "not": "True",
      11.  
      12.   "dimensionName": "ga:pagePath",
      13.  
      14.   "operator": "",
      15.  
      16.   "expressions": [
      17.  
      18.   "/grammar-and-plagiarism/"
      19.  
      20.   ]
      21.  
      22.   }
      23.  
      24.   ]
      25.  
      26.   }
      27.  
      28.   ]
      29.  
      30. }
      31.  
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      Hi @etszyingho

      As part of your filter you can negate the filter by passing in 

      1. "not": "True",


      It would look something like:

      1. {
      2.  
      3.   "dimensionFilterClauses": [
      4.  
      5.   {
      6.  
      7.   "filters": [
      8.  
      9.   {
      10.   "not": "True",
      11.  
      12.   "dimensionName": "ga:pagePath",
      13.  
      14.   "operator": "",
      15.  
      16.   "expressions": [
      17.  
      18.   "/grammar-and-plagiarism/"
      19.  
      20.   ]
      21.  
      22.   }
      23.  
      24.   ]
      25.  
      26.   }
      27.  
      28.   ]
      29.  
      30. }
      31.  
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thanks Grant! I appreciate your help. I updated the filters and it worked :-)

    • Coach

      Glad to hear it worked for you @etszyingho . If you could accept the answer above so it's easier for others to find the solution I'd appreciate it, thanks!

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Hi @GrantSmith - can I ask you another question about REGEX filters? How can I best specify exclusion of multiple regex values within a filter? I am using the following but I don't think that Domo is giving me the right data points. I'm getting discrepancies between GA UI and also Domo, and double checked the views.

      I've tried using something like IN_LIST as well as PARTIAL but that also did not work. The issue is that Domo is not filtering the correct data when I add in multiple filters.

      FYI this is a correction post for the correct filter expressions

      1. {"dimensionFilterClauses": [
      2.     {
      3.       "filters": [
      4.         {
      5.           "not" : "True",
      6.           "dimensionName": "ga:pagePath",
      7.           "operator": "REGEX",
      8.           "expressions": [
      9.             "popular-problems"
      10.           ]
      11.         },
      12.         {
      13.           "not" : "True",
      14.           "dimensionName": "ga:pagePath",
      15.           "operator": "REGEX",
      16.           "expressions": [
      17.             "problemwidget"
      18.           ]
      19.         }
      20.       ]
      21.     }
      22.   ]
      23. }

        

    • Member

      Hi @GrantSmith - can I ask you another question about REGEX filters? How can I best specify exclusion of multiple regex values within a filter? I am using the following but I don't think that Domo is giving me the right data points. I'm getting discrepancies between GA UI and also Domo, and double checked the views.

      I've tried using something like IN_LIST as well as PARTIAL but that also did not work. The issue is that it is not correctly filtering when I add in multiple filter clauses.

      1. {"dimensionFilterClauses": [
      2.     {
      3.       "filters": [
      4.         {
      5.           "not" : "True",
      6.           "dimensionName": "ga:pagePath",
      7.           "operator": "REGEX",
      8.           "expressions": [
      9.             "popular-problems"
      10.           ]
      11.         },
      12.         {
      13.           "not" : "True",
      14.           "dimensionName": "ga:pagePath",
      15.           "operator": "REGEX",
      16.           "expressions": [
      17.             "popular-problems"
      18.           ]
      19.         }
      20.       ]
      21.     }
      22.   ]
      23. }

        

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories