latestOpenAPI 3.0.02026-08-137192110.1 KB

75294f591cc2

Custom Reports

Create custom reports

Create one or more custom reports (GAQL for Google Ads, ShopifyQL for Shopify) and attach them to the given ELT Syncs. Batchable: pass multiple items to create the same or different reports across many ELT Syncs in a single call. Each item is processed independently, so one failing item does not affect the others.

post/custom_reports

Request body

add_as_source_streamboolean

Whether to also register each created report as an active source stream on its ELT Sync so it starts syncing on the next run. Defaults to true.

Example request

{
  "reports": [
    {
      "elt_sync_id": "X4ughggABSd3UY",
      "name": "Weekly Spend by Campaign",
      "query": "SELECT campaign.id, campaign.name, metrics.cost_micros FROM campaign"
    }
  ]
}

Response

The result of each requested custom report creation, in the same order as the request.