Regex Filters in Google Analytics?

etszyingho
etszyingho 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:

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

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

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

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

      

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

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

      

Categories