Google Analytics Exclude Filter

I'm working with a very large data set where most of the data is not tied to a GA Campaign. In order to reduce the amount of data I'm working with, I'd like to filter out all rows that do not have the value "(not set)".
My current formula:
"
{
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:campaign",
"operator": "EXACT",
"expressions": [
"(not set)"
]
}
]
}
]
}
"
I've tried replacing "EXACT" with everything that I can think of to exclude it including: "EXCLUDE", "NOTEQUAL", "NOT_EQUAL", "DOES_NOT_EQUAL", "NOT_EQUAL_TO", "!=", "DOES NOT MATCH", "DOES_NOT_MATCH", "DOES_NOT_CONTAIN", "DOES NOT CONTAIN".
None of these seem to work. Each time I get the same error:
"Domo is ready, but Domo received an error requesting the data. (Bad/Malformed Request). Invalid value at 'report_requests[0].dimension_filter_clauses[0].filters[0].operator' (type.googleapis.com/google.analytics.reporting.v4.DimensionFilter.Operator), "EXCLUDE""
Best Answer
-
Thankfully, one of my developers was able to help me out. Here's the solution:
""not": "true"," has to go exactly before "operator":
{
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:campaign", "not": "true",
"operator": "EXACT",
"expressions": [
"(not set)"
]
}
]
}
]
}
0
Answers
-
Thankfully, one of my developers was able to help me out. Here's the solution:
""not": "true"," has to go exactly before "operator":
{
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:campaign", "not": "true",
"operator": "EXACT",
"expressions": [
"(not set)"
]
}
]
}
]
}
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive