Skip to main content
Use this to produce a report, or to set reporting up for the first time. Every step here can be done by a person or by an AI agent connected to the same tools, with one division that never moves: the report owner is a person, and the owner stands behind every report that goes out. An agent can fill the flat file, run the checks, and draft every cadence; the owner reviews and approves, unless a cadence is flagged auto-send in reporting cadence.
Every report reads from the flat file, not from the ad platforms. If two reports pull from two places, they will eventually disagree and nobody will know which is right.

Setting it up (once)

1

1. Read the framework

Reporting framework concepts covers the north star, counter-metrics, and how the layers relate. Data quality and rollup concepts covers what breaks when daily rows don’t add up to the weekly and monthly ones.
2

2. Define every metric once

Fill in the marketing reporting data dictionary: one definition, one owner, one grain per metric. Then agree the headline set in KPI definitions.If a starter pack fits, begin there: ecommerce or sales-led.
3

3. Build the flat file

Set up the flat file. Its metric names come from the data dictionary, and its campaign, ad_group, ad, and product columns join on your naming conventions and UTM values. Decide which grains you store: channel alone cannot answer a per-product or per-campaign question. Record the file’s location, and how each source of truth is accessed, in the data dictionary’s where everything lives section, so any actor, person or agent, can open both.
4

4. Set the schedule

Fill in the reporting cadence register: when each report runs, who or what drafts it, who approves it, whether it auto-sends, and where it lands. This is where “the scheduled day” on every process page resolves.
5

5. Set the dashboards

Decide how the numbers are presented on demand in dashboard standards.

Producing a report

Each period rolls up into the next. A monthly report is not written from scratch; it’s assembled from weeks that already reconciled.
1

1. Load and check the rows

Add the period’s rows to the flat file and check them against the rules in data quality and rollup concepts. When an agent fills the file daily, this step is confirming the period is complete and restating estimates, not loading. Catch the gaps before writing, not after someone questions a number.
2

2. Check the change log

Anything that changed mid-period (a budget shift, a tracking fix, a naming correction) explains a movement that otherwise looks like performance.
3

3. Write it

Use the template for the period. Report writing concepts covers how to say what happened without overclaiming a cause.
4

4. File it

Save to the archive for that period. The archive is what makes a quarterly report possible without re-deriving three months of numbers.
Type: process
Domains: reporting, setup
Provides: task:report-on-results
Uses: dashboard-standards, data-dictionary, flat-file, kpi-definitions, library:report, naming-convention, report-template, reporting-cadence, utm-rules
Hands off to: process:daily-brief, process:weekly-reporting, process:monthly-reporting, process:quarterly-reporting, process:yearly-reporting
Triggers: “How did we do?” · “Make me a report” · “Set up reporting” · “Write the monthly” · “Build our KPI definitions”Asks, in order:
  1. Producing a report, or setting reporting up? Options: Produce / Set up. Skip when: flat file and dictionary exist -> produce.
  2. Which cadence? Options: report-period. Skip when: named.
  3. (Setup) Ecommerce or sales-led starter pack? Options: starter-pack. Skip when: producing.
Output: Routes to the cadence process, or setup: data dictionary, KPI definitions, flat file, cadence register, dashboard standards.

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.
Last modified on November 2, 2026