In short

A weekly marketing report means exporting figures from several platforms, pasting them into a spreadsheet and writing a few lines about what changed. The improved process pulls the same figures from your exports each week, lays them out the same way, drafts the commentary and flags any spend that has gone over the limits you set.

Figures come only from your own data, with every number traceable to its export. The marketing manager approves the report before it is shared, and the system never changes campaigns or budgets.

  • Sector Small and medium-sized businesses
  • Role Marketing manager
  • Job Weekly marketing performance report

The job today

Every Monday the marketing manager downloads exports from the advertising platforms, the website analytics and the email tool, pastes them into last week's spreadsheet and fixes the formulas that broke. The commentary is written in a hurry. If a campaign overspent on Friday, it is often noticed the following week.

Where it breaks

  • Most of the time goes on copying figures, not on understanding them.
  • Each platform measures things differently, and the definitions are not written down.
  • Overspends are noticed late.
  • The report changes shape each week, so trends are hard to see.

The improved process, step by step

  1. Agree the measuresWrite down once which figures the report uses, where each comes from and what it means, along with the spend limits for each channel.
  2. Collect the exportsEach week the system collects the agreed exports from your platforms, read-only.
  3. Build the reportIt lays the figures out in the same format every week, with week-on-week changes and a link from every number to its source.
  4. Flag spend and anomaliesAny channel over its spend limit, and any figure that moves sharply, is flagged at the top of the report.
  5. Draft the commentary AI preparesAn assistant drafts short commentary on what changed, using only the figures in the report. It marks anything it cannot explain as a question for the manager.
  6. A person approves before sharing A person approvesThe marketing manager checks the figures and commentary, edits and approves the report before it goes to the team or the board.
The weekly marketing report at a small business: process diagramSteps: 1. Agree the measures; 2. Collect the exports; 3. Build the report; 4. Flag spend and anomalies; 5. Draft the commentary (AI prepares); 6. A person approves before sharing (a person approves) 01 Agree the measures 02 Collect the exports 03 RULES CHECK Build the report 04 RULES CHECK Flag spend and anomalies 05 AI PREPARES Draft the commentary 06 A PERSON APPROVES A person approves before sharing
The process at a glance. Teal steps are prepared with AI help; the amber step is where a person approves.

Where a person must approve

A person approves

The report is approved by the marketing manager before it is shared. Anything that sends, changes or cannot be undone waits for that approval.

The system never pauses campaigns, changes budgets or edits ads. Those decisions stay with people.

The data boundary

  • The system has read-only access to the agreed exports. It cannot change campaigns, bids or budgets.
  • Reports use aggregate figures. Individual customer data is not needed.
  • Every figure links to the export it came from.
  • Every report, edit and approval is logged.

Checklist before you start

  • We know which platforms our marketing figures come from.
  • We can export the figures we need, or read them directly.
  • We have agreed definitions for the measures that matter.
  • We have agreed spend limits for each channel.
  • We know who reads the report and what they need from it.
  • One person owns approving the report, with cover.

This is an illustrative walkthrough of a common pattern. It is not a client case study, and the details will differ in your organisation.