Regex Filters in Google Analytics?

etszyingho

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/"

          ]

        }

      ]

    }

  ]

}

GrantSmith

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/"

  ]

  }

  ]

  }

  ]

}

GrantSmith

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/"

  ]

  }

  ]

  }

  ]

}

etszyingho

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

GrantSmith

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!

etszyingho

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

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"
          ]
        }
      ]
    }
  ]
}