Overview
This week at a glance
· BigQuery, client_name = 'Lyma'
Gap panel - asset pool health by ad set
Every active ad set. Gap = funnel-stage target pool - (current live ads - this week's pauses). Click a column header to sort.
Main RAG view
One row per active ad. Click a column header to sort. Hover a truncated name to see the full text.
Ads that are switched on but not delivering
ACTIVE status at Meta but zero impressions in the last 7 days. Check learning status, rejections, or budgets in Ads Manager.
Themes in this selection
Craig's eight audit themes, rolled up from the creative tags. Brief a whole theme, or use the Theme filter to see only its winners.
Winners panel - iterate on this theme
Green ads only, with the reason they're winning.
Past creative
What the board looked like on an earlier date. Every number here, including the cards above, is as of the date you pick rather than today. Each ad shows whether it is still running now.
Account health over time
Every archived snapshot. Each point is the board as it stood that day, judged by the rules in force then.
No trend data yet — it builds as snapshots are archived.
Ads by status
Creative assets needed to refill target pools
Median cost per acquisition
Across every live ad that converted in the window.Theme mix over time
Spend sitting in ads flagged for pause
30-day spend on RED ads — the money the pause list is about.What is driving performance
Every live ad grouped by one creative dimension, for the current period. Theme mix over time is charted above.
Pause board
Every ad the rules flag RED this run. Pausing here changes the live Meta account — the API re-checks each ad is still RED before it acts.
Actioned
Everything this tool has done, newest first. Only ads paused here can be switched back on here.