Google Analytics 4 (Airbyte) FAQs
Custom reports
How can I create custom reports?
In the GA4 (Airbyte) integration, custom reports can be generated by providing a JSON that defines the dimensions and metrics that should be included in the table
Example:
[
{
"name":"revenue_source_report",
"dimensions":[
"date",
"country",
"sessionSourceMedium",
"sessionCampaignName"
],
"metrics":[
"activeUsers",
"sessions",
"purchaseRevenue",
]
}
]
To include more than one report just add another object to the array just like this:
[
{
"name":"revenue_source_report",
"dimensions":[
"date",
"country",
"sessionSourceMedium",
"sessionCampaignName"
],
"metrics":[
"activeUsers",
"sessions",
"purchaseRevenue",
]
}
,
{
"name":"custom_revents_report",
"dimensions":[
"date",
"sessionDefaultChannelGroup",
"eventName",
"isConversionEvent",
"sessionSourceMedium"
],
"metrics":[
"sessions",
"eventCount"
]
}
]
Please check out these docs to find out which dimensions & metrics are available:
- https://developers.google.com/analytics/devguides/reporting/data/v1/rest/v1beta/properties/runReport#body.request_body.FIELDS.dimensions
- https://developers.google.com/analytics/devguides/reporting/data/v1/rest/v1beta/properties/runReport#body.request_body.FIELDS.metrics
- https://docs.airbyte.com/integrations/sources/google-analytics-data-api/#connector-specific-features
Additional resources
Check out this tool to preview your custom reports: https://ga-dev-tools.google/ga4/query-explorer/
Updated about 1 year ago