This process uses the data dictionary, the flat file, and the weekly report template.
What you’ll end up with
- A week’s worth of new rows added to the flat file, checked and trustworthy.
- A one-page report, filed in the weekly report archive, comparing performance against target and flagging anything outside its normal range.
Before you start
- Your data dictionary Part 1 is filled in: north star, KPI tiers, attribution model, and sources of truth are settled.
- Your flat file exists and has at least a few weeks of history to compare against.
The process at a glance
1
Confirm the week's rows
The daily fill already wrote them; confirm the week is complete and restate estimates. Loading by hand, pull each metric from its source of truth.
2
Check them
Run the flat file checks before trusting a single number in the report.
3
Check the change log
Read the data dictionary’s change log for anything that happened this week.
4
Write the report
Fill in the weekly report template: pacing, exceptions, and anything needing a decision.
5
Quality check and deliver
Confirm the numbers and send, with a short message giving the headline.
6
File it
Log the report in the weekly report archive.
1. Confirm the week’s rows
If an agent fills the flat file daily, the week’s rows already exist. Confirm every day of the week is present, and restate any row still markedis_estimate against the settled platform figures.
If you load weekly by hand, pull each metric from the system named as its source of truth in the data dictionary and add the week’s rows. Load raw inputs only, spend, clicks, purchases, revenue; never a calculated ratio. Wait at least two days after the week ends before a hand load: conversion data settles over a couple of days, and a week loaded too early will need correcting later.
2. Check them
Run through the flat file’s checks before using the new rows for anything. At minimum: spend matches the ad platforms, revenue matches the source of truth, and nothing looks unclassified or missing that wasn’t missing last week. If a check fails, fix it before writing the report. An error caught here costs a few minutes; the same error found after the report has already shaped a decision costs a great deal more.3. Check the change log
Read the data dictionary’s change log for anything logged during the week: a promotion, a price change, a tracking change, a site issue. This is what prevents the “why did revenue spike on Wednesday” conversation from becoming its own investigation when the answer was already on record.4. Write the report
Fill in the weekly report template. Compare against target and normal range, not against last week; week-over-week movement on weekly data is mostly noise. Only include a metric in the exceptions section if it’s genuinely outside its normal range, and give each exception a real cause or an honest “unknown, investigating.”5. Quality check and deliver
Before sending, run three checks, each a testable assertion: every number in the summary appears in the pacing table; each pace value equals actual divided by expected for the period; last week’s “needs a decision” items appear, marked resolved or carried forward. When an AI drafts the report, the report owner is the reviewer: they read, edit, and approve before it goes out, unless this cadence is flagged auto-send in reporting cadence. Send on the day the schedule records, with a two- or three-line message giving the headline and the ask. A report attached with no summary in the message body tends to get opened later, which in practice often means never.6. File it
Log the report in the weekly report archive. Weekly reports are logged by folder location rather than one row per report; see the archive page for the retention period.Related resources
- Data dictionary Metric definitions and normal ranges this report compares against. Targets and floors live in KPI definitions.
- Flat file template The source every number in the report comes from.
- Weekly report template The fill-in template this process produces.
- Weekly report archive Where the finished report gets filed.
- Monthly reporting process How four or five of these weeks become the next report up.
MCP wiring
MCP wiring
Type: process
Domains: reporting
Provides:
Uses:
Hands off to:
Domains: reporting
Provides:
process:weekly-reportingUses:
data-dictionary, flat-file, kpi-definitions, library:change-log, library:report, report-template:weekly, reporting-cadenceHands off to:
process:monthly-reportingTriggers: “Write the weekly report” · “How did we do this week?” · “Weekly numbers” · “Draft this week’s update”Asks, in order:- Which week? (defaults to last complete week) Options: your answer. Skip when: cadence-triggered.
- Anything not in the change log I should know about? Options: your answer. Skip when: auto-send cadence.
Get the complete Marketing OS
Subscribe to Snow Doughnut, our free weekly newsletter, and get the Notion workspace where you do the work: tasks, a marketing calendar, name generators, briefs, and more.
Have us run it for you
We implement this system, use it to help you grow and scale, then hand it all off to you when you’re ready.