The 30-second read
Spend, clicks, orders and revenue at a glance — then the detail lives in each section.
Daily spend & link clicks
last 30 daysOnline revenue vs the weekly target
Target: $20,000/week (set Jul 2026).
The briefing
AI-written · numbers from the data onlyNightly machine notes + the weekly analyst briefing. Commentary, not gospel — the charts stay the source of truth.
Meta Ads
Every level rolls up from ad × day rows — pick a range, the math happens here in the browser.
Performance by campaign
Campaign → ad set → ad. Halo ROAS = all revenue from the ad's clicks ÷ spend. Direct ROAS (advertised-SKU only) activates at v2 with the Shopify join.
Revenue
Online store revenue by week against the $20,000 target. In-store joins when a POS export exists.
Weekly online revenue
Shopify · refunds excludedWeek table
Online sessions & revenue by channel
GA4 · last 28 daysWhere online activity and tracked online revenue come from. In-store impact is not in these numbers.
Competitor Watch
What they're running right now — snapshotted daily, archived forever. The Ad Library forgets; we don't.
The ad wall
active adsSite Health
Microsoft Clarity friction metrics — rage clicks, dead clicks, quick-backs, JS errors. Heatmaps live in Clarity itself.
Sessions by country
3-day windowBrowsers
Devices & sources
Worst offenders — pages losing visitors
act on thesePages ranked by friction. Quick-backs = arrived and bounced straight out (ad promise ↔ page mismatch). Dead clicks = clicked something that did nothing. Heatmaps & recordings live in Clarity — link out per page.
Executive
The monthly board read: MER, blended CAC, the three-bucket ROI story. YoY first. No platform ROAS here, by design.
Activates at v2
needs total-revenue feed
The Executive section switches on when the revenue pipe lands (Shopify token → weekly totals → MER).
Spec is locked: TL;DR narrative box · money scorecard (revenue, spend, MER, blended CAC — each vs YoY)
· ROPO health check (online vs in-store split) · three-bucket waterfall (UTM-matched floor, unattributed halo, in-store lift)
· platform plug-and-play table — every new ads platform gets its row in the same change that integrates it. Delivery: live page, print-PDF one-pager, email share.
System
Pipeline states, data coverage, and what unlocks next. If something is red here, the runbook has the fix.