ad_performance
Analyze ad performance across a date range, flagging dead or underperforming ads based on clicks and CTR. Returns impressions, clicks, spend, CTR, CPC, CPM, and conversions to inform optimization.
Instructions
Per-ad performance over an inclusive YYYY-MM-DD window, flagging weak ads.
Returns impressions/clicks/spend with derived CTR/CPC/CPM and joined conversions &
cost-per-conversion. Each row's flag is dead (enough impressions, ~no
clicks), underperforming (very low CTR), or ok. Rows are sorted worst-first.
Same-day data is partial; today is handled but may be incomplete.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| since | Yes | ||
| until | Yes | ||
| campaign_id | No | ||
| min_impressions | No | ||
| dead_max_clicks | No | ||
| underperf_max_ctr | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| since | Yes | ||
| until | Yes | ||
| currency | No | ||
| rows | No | ||
| dead_count | No | ||
| underperforming_count | No | ||
| totals | No |