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:

Additional resources

Check out this tool to preview your custom reports: https://ga-dev-tools.google/ga4/query-explorer/