get_campaign_performance_report
Query live campaign performance from BigQuery to get spend, impressions, clicks, and side-by-side ROAS comparisons including platform ROAS, MTA attributed ROAS, margin ROI, attributed CPA, and pipeline value per campaign.
Instructions
Query live campaign performance from BigQuery. Returns spend, impressions, clicks, platform ROAS, MTA attributed ROAS, margin ROI, attributed CPA, and pipeline value per campaign. All three ROAS numbers are returned side-by-side so you can see the gap between what platforms claim vs what multi-touch attribution shows. Requires BigQuery mode.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| status | No | ||
| date_to | No | ||
| team_id | No | ||
| platform | No | ||
| date_from | No | ||
| funnel_stage | No |