Describe the issue/error/question
Hello community,
I’m having a problem with the google analytics node. I want to automate one GA custom report in n8n. As far as I understand the only way to do this is to generate the same custom report by selecting all the fields in n8n node. I managed to add date range, one dimension and one metric but I can’t use the filter dimention functionality for some reason.
Any idea why this might be?
Here is the report I’m trying to creare
What is the error message (if any)?
ERROR: Bad request - please check your parameters
Unknown dimension(s): submitFreebie|RAF For details see https://developers.google.com/analytics/devguides/reporting/core/dimsmets.
Details
Google Analytics
Execute node
Parameters
Credential for Google Analytics OAuth2 API
Resource
Operation
View Name or ID
Fixed
Expression
Return All
Fixed
Expression
Simplify
Fixed
Expression
Additional Fields
Date Ranges
Start Date
Fixed
Expression
End Date
Fixed
Expression
Dimensions
Name or ID
Fixed
Expression
Name or ID
Fixed
Expression
Name or ID
Fixed
Expression
Add Dimension
Dimension Filters
Dimension Name or ID
Fixed
Expression
Operator
Fixed
Expression
Value
Fixed
Expression
Add Dimension Filter
Metrics
Alias
Fixed
Expression
Expression
Fixed
Expression
Formatting Type
Fixed
Expression
Add Metrics
I wish this node would…
Problem in node ‘Google Analytics‘
Bad request - please check your parameters
Please share the workflow
(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)
{
“meta”: {
“instanceId”: “bd3424651820da96219b3bf8bf1cdfabcd2b0cc2dbde58159a106ccfa63cca09”
},
“nodes”: [
{
“parameters”: {},
“id”: “49e62e75-b5f6-4a6d-ada6-10bb0513c74e”,
“name”: “When clicking "Execute Workflow"”,
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
1140,
580
]
},
{
“parameters”: {
“viewId”: “54789410”,
“returnAll”: true,
“additionalFields”: {
“dateRangesUi”: {
“dateRanges”: {
“startDate”: “2023-01-21T23:00:00.000Z”,
“endDate”: “2023-01-27T23:00:00.000Z”
}
},
“dimensionUi”: {
“dimensionValues”: [
{
“name”: “ga:sourceMedium”
},
{
“name”: “ga:campaign”
},
{
“name”: “ga:eventAction”
}
]
},
“dimensionFiltersUi”: {
“filterValues”: [
{
“dimensionName”: “submitFreebie|RAF”,
“operator”: “REGEXP”,
“expressions”: “ga:eventAction”
}
]
},
“metricsUi”: {
“metricValues”: [
{
“alias”: “Total Events”,
“expression”: “ga:totalEvents”
}
]
}
}
},
“id”: “3be3c3ee-6447-4159-a636-b41e35a6ce6c”,
“name”: “Google Analytics”,
“type”: “n8n-nodes-base.googleAnalytics”,
“typeVersion”: 1,
“position”: [
1340,
580
],
“credentials”: {
“googleAnalyticsOAuth2”: {
“id”: “46”,
“name”: “Google Analytics account”
}
}
}
],
“connections”: {
“When clicking "Execute Workflow"”: {
“main”: [
[
{
“node”: “Google Analytics”,
“type”: “main”,
“index”: 0
}
]
]
}
}
}
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database you’re using (default: SQLite):
- Running n8n with the execution process [own(default), main]:
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: