Many weekly performance marketing reports are long, screenshot-heavy and hard to act on. They list impressions, clicks, click-through rates and platform ROAS for every campaign, and leave the reader to work out whether things are going well. A good weekly report does the opposite: it states in a few lines whether marketing is on track against the business goal, explains what changed and why, and lists the decisions for the coming week. This article sets out what belongs in a weekly report, what to leave out, how to write the commentary and a template you can adapt for D2C or lead-generation businesses.
Who the weekly report is for
Write for the person who decides on budget, usually the founder, CEO or head of marketing, not for the specialists running campaigns. They need to know whether spend is producing the outcomes the business needs, whether anything has gone wrong, and what is being done about it. Campaign managers need more detail, but that belongs in the ad platforms and a separate working dashboard, not in the weekly report. Keeping these separate is the single most effective way to make the report shorter and more useful.
Start with business outcomes
Open with the outcomes that matter to the business, compared with the plan and the previous period. For D2C: revenue, new customers, orders and contribution margin after returns. For lead generation: qualified leads, opportunities and, where the sales cycle allows, revenue. Then show total marketing spend against plan and the key efficiency measures: MER and new customer acquisition cost for D2C, cost per qualified lead and cost per opportunity for lead generation. These figures should come from your store or CRM, not from summed platform reports, so that they reflect actual results rather than attributed ones.
Then the channel view
Below the business outcomes, show a compact table by channel: spend, platform-reported results, cost per result and, where available, CRM- or store-based results. Note where platform-reported results and actual results diverge, because the gap often explains why the business numbers moved differently from what the platforms show. Keep this to the main channels, such as Meta, Google, LinkedIn, marketplaces and quick-commerce, and group small ones.
The one-page template
Adapt the rows to your business model. Keep the whole report to one page or one screen.
| Section | Contents | Source |
|---|---|---|
| Headline | One or two sentences: on track or not, and the main reason | Analyst summary |
| Business outcomes | Revenue or qualified pipeline, new customers, against plan and last week | Store or CRM |
| Spend and efficiency | Total spend vs plan; MER and new customer CAC, or cost per qualified lead and opportunity | Finance, store, CRM |
| Channel table | Spend, results, cost per result by channel; platform vs actual where different | Ad platforms and CRM |
| What changed | Tests launched, budget moves, creative changes, tracking issues, external factors | Change log |
| Learnings | What the week taught, with evidence | Test log |
| Decisions for next week | Specific actions with owners | Team agreement |
What to leave out
Leave out metrics that do not change decisions at the leadership level: impressions, reach, clicks and click-through rates for every campaign, platform relevance scores and screenshots of dashboards. Include one of these only when it explains a change in outcomes, for example a drop in click-through rate on the main campaign explaining a rise in cost per lead. Also leave out summed platform-reported revenue as a headline, because platforms double-count and it usually exceeds actual revenue.
Writing the commentary
The commentary is the most valuable part of the report and the most often skipped. For each significant movement, answer three questions: what changed, why, and what are we doing about it. Use specific evidence: cost per lead rose on the main search campaign because a competitor began bidding on our brand terms; we have raised the brand campaign's budget and will review on Thursday. Avoid vague explanations such as algorithm fluctuations unless there is evidence. If the cause is unknown, say so and state how you will find out.
Weekly versus monthly
The weekly report tracks direction and catches problems early. Weekly numbers are noisy, especially in lead generation with small volumes and long sales cycles, so avoid large decisions based on one week. The monthly report adds context: trends over several months, cohort performance, incrementality test results, creative learnings and budget plans for the next month. Keeping the weekly report short makes room for a fuller monthly review.
Making it routine
Automate the data collection so the report takes minutes to assemble, using a dashboard tool connected to the ad platforms, store and CRM. Keep a running change log through the week so the what-changed section writes itself. Send the report on the same day each week, and use it as the agenda for a short weekly review. Over time, the decisions section becomes a record of how the account was managed and why, which is invaluable when people or agencies change.
Adapting the report for agencies
If an agency runs your paid media, ask for the weekly report in this format rather than the agency's standard template. Agencies often report on what their own platforms show, so specify that business outcomes come from your store or CRM and that the agency must explain gaps between platform-reported and actual results. Give the agency read access to the CRM or a shared dashboard so it can see qualified leads and revenue by campaign. Agree in advance which decisions the agency can make without approval, such as moving budget between ad sets within a channel, and which need sign-off, such as shifting budget between channels. A shared, consistent format also makes it much easier to compare agencies or hand over between them, because the history is in a structure you own rather than in a series of differently designed decks.
Example commentary
Commentary is easier to write with examples in mind. A D2C example: revenue was below plan this week because Meta prospecting delivered fewer new customers after two winning ads fatigued; we launched three new concepts on Tuesday and will read results next Tuesday; MER held at plan because repeat orders from the email campaign were strong. A lead generation example: qualified leads were on plan but cost per qualified lead rose because a broad match test in Google pulled in job seekers; we added negatives and will end the test if cost per qualified lead has not returned to target by Friday; the LinkedIn webinar campaign produced two opportunities from target accounts. Each example names the movement, the cause with evidence, the action and when it will be checked. That is the standard to aim for, and it fits in a few lines.
A checklist before sending
Before the report goes out each week, check a few things. Do the business outcome figures come from the store or CRM rather than ad platforms? Has total spend been reconciled with the platforms' billing for the period? Is every significant movement explained with a cause, an action and a date? Are the decisions specific, with owners? Are any tracking problems or data gaps stated openly? Is the report still one page? A two-minute check against this list keeps the quality consistent from week to week, especially when different people prepare it.
FAQ
A headline, business outcomes against plan, total spend and efficiency measures, a compact channel table, what changed, learnings and decisions for next week.
Not as the headline. Use revenue or pipeline from your store or CRM, and show platform figures in the channel table, noting where they differ.
Impressions, reach, clicks and click-through rates for every campaign, unless one explains a change in outcomes. They belong in working dashboards, not the leadership report.
One page or one screen. Detailed campaign data belongs in a separate working dashboard for the specialists.
It adds trends, cohort performance, incrementality results, creative learnings and next month's budget plan, while the weekly report tracks direction and catches problems.
The person or agency closest to the campaigns drafts it, and the marketing lead checks that the commentary explains movements in business outcomes, not just platform metrics.
Only briefly, for example naming the ads that drove a change. Detailed creative analysis belongs in the monthly review and the creative learning log.
Say so in the report, show both figures and explain the likely reason, such as attribution windows or returns. Do not quietly pick the more flattering number.