Regex Filters in Google Analytics?

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:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @etszyingho

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

    "not": "True",
    


    It would look something like:

    {
    
      "dimensionFilterClauses": [
    
      {
    
      "filters": [
    
      {
      "not": "True",
    
      "dimensionName": "ga:pagePath",
    
      "operator": "",
    
      "expressions": [
    
      "/grammar-and-plagiarism/"
    
      ]
    
      }
    
      ]
    
      }
    
      ]
    
    }
    
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @etszyingho

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

    "not": "True",
    


    It would look something like:

    {
    
      "dimensionFilterClauses": [
    
      {
    
      "filters": [
    
      {
      "not": "True",
    
      "dimensionName": "ga:pagePath",
    
      "operator": "",
    
      "expressions": [
    
      "/grammar-and-plagiarism/"
    
      ]
    
      }
    
      ]
    
      }
    
      ]
    
    }
    
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Thanks Grant! I appreciate your help. I updated the filters and it worked :-)

  • 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!**
  • 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

    {"dimensionFilterClauses": [
        {
          "filters": [
            {
              "not" : "True",
              "dimensionName": "ga:pagePath",
              "operator": "REGEX",
              "expressions": [
                "popular-problems"
              ]
            },
            {
              "not" : "True",
              "dimensionName": "ga:pagePath",
              "operator": "REGEX",
              "expressions": [
                "problemwidget"
              ]
            }
          ]
        }
      ]
    }
    

      

  • 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.

    {"dimensionFilterClauses": [
        {
          "filters": [
            {
              "not" : "True",
              "dimensionName": "ga:pagePath",
              "operator": "REGEX",
              "expressions": [
                "popular-problems"
              ]
            },
            {
              "not" : "True",
              "dimensionName": "ga:pagePath",
              "operator": "REGEX",
              "expressions": [
                "popular-problems"
              ]
            }
          ]
        }
      ]
    }