Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Marketing Analytics and Reporting › Beginner

Checkpoint: Monthly Marketing Reporting

Scenario questions on the second module: choosing between a report, a dashboard and joined data, writing commentary that explains rather than repeats, keeping outcome metrics apart from activity, and running the monthly pack so it arrives on time and can be trusted. Each answer is explained and points back to the page that teaches it.
CheckpointBeginner levelModule 2: Reports people read4 minUpdated

What this checkpoint covers

The questions draw on the comparison of reporting and business intelligence, the monthly marketing report template and the monthly reporting pack procedure. Each describes a situation at work and asks what you would do or what has gone wrong.

Task

  • Write a short answer to every question before opening the explanations.
  • Mark each answer right, partly right or wrong against its explanation.
  • For any miss, reread the linked section and write down what you would now say.

Questions

  1. A paid search manager wants to know each morning whether spend is pacing ahead of budget. Does she need the monthly report, a dashboard, or a warehouse?
  2. A finance director asks which acquisition channel brings customers who are still buying a year later. The team has a Looker Studio page connected to each ad platform. Can it answer?
  3. A report's commentary reads "Sessions rose this month and conversion rate fell." What is missing?
  4. A results table lists impressions, followers, email open rate and revenue in that order. What would you change?
  5. Halfway through producing the pack, the analyst notices a filter would make last month's lead figure look cleaner and applies it. What is wrong?
  6. Analytics shows far more purchases than the shop platform this month, a much wider gap than usual. The pack is due tomorrow. What do you do?
  7. The head of marketing wants to report return on investment (ROI) for each channel from the platforms' own attributed revenue. What should the report say alongside the figures?
  8. A reader emails asking for three new metrics to be added to this month's pack before it goes out. How do you respond?

Answers explained

Question one

A dashboard reading the platform directly. The question is operational, needs near real-time data and is fully answered by the platform's own numbers. A monthly report is too late and a warehouse adds delay for no benefit. The reporting versus BI comparison describes exactly this case as what reporting does well.

Question two

No. Several platform connectors side by side are still reporting: each shows its own platform's view, and none holds the customer's later purchases. The question needs spend joined to customers and orders over time, kept in data the team owns. That is business intelligence, and the comparison of reporting and BI warns against calling a blended page BI.

Question three

The reason and the consequence. Commentary that restates the chart wastes the reader's time; it should say why the numbers moved, using the launch, pause and annotation logs as evidence, separate fact from inference, and say what the team will do. The commentary step of the reporting pack procedure sets this out.

Question four

Lead with the outcome and its drivers, and move metrics with no target out of the table. Revenue goes first, then the drivers that explain it. Impressions, followers and open rate belong in the channel lines or on a dashboard unless the plan set a target for them. The results table in the report template puts outcome KPIs first for this reason.

Question five

Definitions must not change during production. Changing a filter breaks the comparison with last month and makes this month's number look better for reasons that have nothing to do with performance. Changes go through the head of marketing and are made between packs, with a note. The reporting pack procedure lists this among its common mistakes.

Question six

Run the data checks before anything else: duplicate purchase events, a tracking change, test orders. Use the shop platform's figures for the outcome, flag the analytics figures with a note, raise an issue with the analytics owner and send the pack on time with the issue stated. The reconciliation step of the pack procedure shows the same case.

Question seven

That each platform's revenue reflects its own Attribution window and model, so the channel figures overlap and will add up to more than the business's real revenue. Say which source each figure comes from, show the blended return from the business's own revenue alongside, and point to where the definitions live, as the report template's definitions section requires.

Question eight

Log the request and consider it at the next change to the pack, through the head of marketing. Adding metrics during production delays the pack and introduces numbers nobody has checked. The hand-offs section of the procedure treats new metric requests this way.

Where to go next

If you missed questions one, two or four, rework the dental group report exercise. If you missed the questions on the routine, reread the reporting pack procedure from the top. When you are ready, the next module on the beginner marketing analytics level moves into Looker Studio.

Pages this lesson applies

Terms used on this page

Also related

Related