wafle_ads_breakdown_by_creative
Break down ad performance by creative to spot winning creatives and wasteful spend. Shows spend, impressions, clicks, conversions, ROAS, and CPA per creative using server-side CAPI data.
Instructions
Per-creative performance breakdown for a campaign (or whole account if campaign_id omitted). Returns spend, impressions, clicks, conversions, ROAS and CPA for every creative_id active in the window. Cross-tabbed against wafle CAPI orders, so ROAS reflects server-side truth, not Meta's pixel.
Use when you need to find the one creative carrying a campaign vs the ones bleeding spend. Sort defaults to spend desc; a winner flag tags creatives whose ROAS is in the top quartile AND spend is above the per-creative significance floor (default 5,000 cents).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| slug | Yes | Wafle store slug, e.g. 'gamerland' or 'lensitive'. | |
| sort | No | spend_desc | |
| range | No | Lookback shortcut. Aligned with the merchant's tz, ending today. | 7d |
| campaign_id | No | Optional Meta campaign id; omit for account-wide. | |
| min_spend_cents | No | Hide creatives with cumulative spend below this — avoids LLM noise on pre-launch creatives. |