Skip to main content
DocumentationLibraryReference
App
Slide deck
Paid media
Leadership

Marketing Channel Performance and Forecast

The Monday paid media review for the CMO, as slides that download as a PowerPoint file.

Slide 1: the title, for the latest complete Monday-to-Sunday week.

Slide 1: the title, for the latest complete Monday-to-Sunday week.

Data it reads
Ad spend, conversions and attributed revenue by platform and campaign (Ad Reporting), and GA4 visits by channel.
Workspaces
channel_performance_weekly (6 queries) and site_visits_weekly (1 query)
Period
The latest complete Monday-to-Sunday week, with 13-week trends
Parameter
Spend change for the scenario, default +15%, from −20% to +50%
Exports
PowerPoint, PDF, Markdown, Excel
Template
kater-template="powerpoint": 1280 × 720 slides with speaker notes

Rebuild prompt

Prompt
Make a Monday-morning slide deck for our CMO called Marketing Channel Performance and Forecast, for the latest complete Monday-to-Sunday week. Slides: a title with the week; last week’s spend, attributed revenue, ROAS and cost per conversion against the week before, with ROAS by platform for the week and the last 13 weeks; weekly ROAS by platform over 13 weeks; each platform’s share of spend against its share of revenue, with a table of spend, revenue and ROAS; a 13-week budget scenario at +15% spend with expected, low and high revenue; the eight campaigns that spent the most, with ROAS this week and last; GA4 visits and new visitors by channel against the week before; and a decisions slide. Put talking points and sources in the speaker notes, use a navy corporate theme, and make it downloadable as PowerPoint.

Variations to try

  • “Add a slide on cost per conversion by campaign type.”
  • “Run the scenario at +25% and show the difference from +15%.”
  • “Make a monthly version for the board with the last 12 complete months.”

Assumptions to adjust

  • ROAS is attributed revenue divided by ad spend, using each platform’s own attribution.
  • The scenario assumes efficiency stays within the last 13 weeks’ range.
  • A week runs Monday to Sunday.