Pulls GA4 + Brevo automatically, keeps Power BI & qualitative fields manual, outputs a copy-ready block for the Monday form.
Pick the Sunday that starts the week you're reporting on (BRV reports run Sunday–Saturday). Last year's comparison week is calculated automatically (364 days back, same weekday).
Pulled server-side by the Apps Script (GA4 attribution + Email revenue/bookings, and Brevo sends/open/click rate) — this reads that week's row.
| This year | Last year | |
|---|---|---|
| Direct % | ||
| Organic % | ||
| Paid % | ||
| Email Revenue ($) | ||
| Email Bookings | ||
| Sends | ||
| Open rate % | % | % |
| Click rate % | % | % |
This reads whatever the weekly trigger already pulled for the Sunday you select above. Run manualPullForWeek() in the Apps Script editor first if you need to backfill a week on demand.
Pacing figures — Power BI Desktop has no API access yet, so these stay manual entry for now.