Prebuilt Reports Private Preview

We include the following prebuilt report by default.

You can enable or disable the prebuilt report table on the Schema tab to avoid syncing data you don't need.

`AD_REPORT_DAILY` report

Daily ad-level performance, aggregated from the OpenAI Ads Insights API.

Column	Description
`ad_id`	The ID of the ad. Primary key.
`date`	The date of the report row, in `YYYY-MM-DD` format. Primary key.
`ad_account_id`	The ID of the ad account that owns the ad.
`ad_group_id`	The ID of the ad's ad group.
`campaign_id`	The ID of the ad's campaign.
`start_time`	The start of the reporting window, as a Unix timestamp.
`end_time`	The end of the reporting window, as a Unix timestamp.
`ad_impressions`	The number of times the ad was shown.
`ad_clicks`	The number of clicks the ad received.
`ad_ctr`	The click-through rate (clicks divided by impressions).
`ad_cpc`	The average cost per click.
`ad_cpm`	The average cost per 1,000 impressions.
`ad_spend`	The total amount spent on the ad.

If you need a different aggregation level, time granularity, segment, or set of fields, add a custom report instead.