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
- 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?
- 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?
- A report's commentary reads "Sessions rose this month and conversion rate fell." What is missing?
- A results table lists impressions, followers, email open rate and revenue in that order. What would you change?
- 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?
- 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?
- The head of marketing wants to report return on investment (ROIProfit relative to cost.) for each channel from the platforms' own attributed revenue. What should the report say alongside the figures?
- 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 AttributionAssigning conversion credit to touchpoints. 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.
