Your CEO asks a simple question in the monthly review: did our advertising budget support the products and categories we said mattered?
The marketing report has plenty of numbers. Spend, revenue, conversions, ROAS and campaign trends are all there, and they describe how the account performed. What they rarely show is what the investment supported across the product range.
I have sat on both sides of that question: building ecommerce marketing reports as a marketing director, and now reading them as a CEO. What was missing, in both chairs, was the connection between the spend and the commercial plan the company had agreed a month earlier.
A campaign can hit its ROAS target while most of the budget flows to established bestsellers. The new collection gets little exposure. A strategic category loses share of spend. Products with weak stock or thin margins keep absorbing investment. None of that looks unhealthy in the campaign report.
That is the gap product-level ad spend reporting closes. It connects what each product received in advertising investment with the commercial role the business gave it, then aggregates upward into a view leadership can act on.
Campaign Reporting and Leadership Reporting Answer Different Questions
Paid marketing teams need detailed campaign metrics to run the account: bidding, creative, audiences, search terms, feed quality and campaign structure. Removing that detail would make the account harder to manage, and nothing here replaces it.
Leadership starts from different questions:
- Did the launch get enough visibility during its commercial window?
- How much budget reached the categories we want to grow?
- Did advertising support products with healthy stock and margin?
- How much spend still went to products we had already deprioritized?
- What changed after the latest commercial decision?
Campaigns are poor proxies for those questions. One Performance Max campaign can contain a new launch, core bestsellers, overstock and products the business no longer wants to push, all sharing one budget and one target. A healthy average can sit on top of a weak allocation.
The raw material for a better answer already exists. Google Ads' Products reporting shows impressions, product clicks, cost, conversions and conversion value for Merchant Center products across the campaign types that show them. Its totals cover the share of performance attributed to ads that served products, so they will not reconcile with the campaign report to the euro. What the report cannot supply is the retailer's own context: why each product mattered, and what role the plan gave it.
Start with the Decision the Business Made
A useful leadership report begins before the period does, with a short record of the decision being evaluated. Without it, the report can only describe performance after the fact, and the meeting drifts into interpreting numbers nobody agreed to judge against.
Suppose the commercial plan for September is to launch an autumn collection of 500 products, keep year-round bestsellers funded, and stop pushing summer products that are down to broken size ranges. Those are three different product roles in a catalog of 20,000. They should exist in the report as named cohorts, not get reconstructed from campaign names at the end of the month.
A simple High, Standard and Low priority model gives everyone the same vocabulary:
- High: products the business has chosen to support now
- Standard: products that remain available to normal campaign optimization
- Low: products where more advertising pressure is currently less useful
The rules behind those groups can reflect category, stock, margin, returns, seasonality, launches or any connected business field available to the rule. What matters for reporting is that the decision exists, in writing, before the results arrive.
This changes the character of the review. Instead of asking whether a good ROAS means the strategy worked, the team compares the intended priorities with the allocation that followed.
Connect Product Performance to Commercial Context
A product-level report brings four layers of information together.
| Reporting layer | What it shows | Leadership question |
|---|---|---|
| Allocation | Ad spend and share of spend by product, priority, category or brand | Where did the money go? |
| Visibility | Impressions, product clicks and the share of products receiving exposure | Did the intended products get a real opportunity? |
| Outcome | Revenue, conversions and value against spend | What happened after they got it? |
| Commercial context | Priority, stock, margin, returns, season or launch role | Did the result support the plan? |
The first three layers come from Google Ads and GA4. The fourth comes from the retailer, and it is the difference between a product list and a management report. Ad platforms never see margins, stock cover or return rates, so the business has to attach that context itself.
This is also why the first question in any launch review should concern visibility rather than sales. A product that received a fair test and failed produced useful evidence. A product that never got impressions did not answer anything.
At Expanly, this is the shape of the current Reports view: revenue, clicks, impressions and ad spend over time, for the whole catalog or filtered to the High, Standard and Low segments, with breakdowns for top brands and categories. Underneath, each product carries one priority per day, so spend is attributed to the priority the product held at the time. The deeper cuts described in this article, by market, collection or launch cohort, come from those same product rows; today we build them together with customers rather than in the self-service view. Detailed margin, stock, return and rule logic stays in Expanly. Google receives only the approved priority label used by the campaign structure.
Build the Report from Product Rows Upward
Start with one row per product per day, then aggregate consecutive days with the same priority. Each row carries the product identifier, spend, visibility and outcome metrics, the priority valid on those dates and the business dimensions the decision needs. A report built on today's labels quietly assigns last month's spend to this month's decision.
For the September plan, the rows might look like this:
| Date(s) | Product ID | Priority | Commercial role | Ad spend | Impressions | Product clicks | Revenue | Next action |
|---|---|---|---|---|---|---|---|---|
| Sep 1–30 | JKT-2101 | High | Autumn launch | €420 | 38,000 | 610 | €1,900 | Keep the current launch setup |
| Sep 1–30 | FLC-0043 | Standard | Year-round bestseller | €1,150 | 96,000 | 1,720 | €7,400 | No change |
| Sep 1–30 | SWM-1188 | Low | Summer, broken sizes | €310 | 22,000 | 300 | €900 | Tighten the availability rule |
| Sep 1–30 | UNK-0912 | Unclassified | No category match | €260 | 18,000 | 240 | €0 | Fix the data before judging |
The exact columns matter less than the shape: one product-priority period per row, advertising numbers next to commercial context, and a decision at the end.
Campaign totals lose this distribution. Two categories can deliver the same revenue while one receives broad support and the other depends on three products. Leadership may make a different inventory or launch decision once that difference is visible.
Keep unmatched products in their own group. A missing category, priority or business-data match is a data-quality problem, and the spend attached to it shows whether the report is ready for a strategic decision.
State which attribution the revenue follows because Google Ads and analytics count conversions differently. Once the rows are complete, roll the same data up by priority, category, brand, market or collection.
The Three Views a CEO Report Needs
The report does not need to reproduce the advertising dashboard. Three views usually carry the whole discussion, and together they show where the money actually went, seen against the priorities the business set.
1. Allocation by priority
Show total spend and share of spend across High, Standard and Low products, with revenue or conversion value alongside for context. Keep allocation visible as a result in its own right.
This answers whether the account gave more opportunity to the products the business chose. It also exposes spend still reaching Low-priority products. Treat that as a prompt to inspect the campaign structure, labels and priority logic rather than as automatic waste.
This view is also where a real reallocation shows first. At Scandinavian Outdoor, the Low-priority share of spend fell from 51% to 24% and the High-priority share grew from 18% to 29% after product priorities went live. (Full case study)
2. The largest gaps between plan and execution
Break the allocation down by the dimensions leadership already uses: category, brand, market, collection or launch cohort. Then report the few exceptions that would change a decision, not every variance.
In the September example, the report might show that the autumn collection received far less than its planned share of spend because its products shared a campaign and a target with established bestsellers. Or that a strategic brand kept its visibility but lost sellable variants halfway through the month. Both findings point to a specific next action.
3. Observed change after the decision
Compare the period before and after the priority change, against the most honest baseline available: a similar previous launch, a matched product group or the rest of the catalog. Report what changed in allocation and business performance without turning a before-and-after chart into causal proof.
The language matters here. "Revenue increased after the rule went live" is an observation. "The rule caused the increase" requires a stronger test. Leadership gets more value from an honest comparison than from false precision.
Build a One-Page Report People Can Act On
Everything above fits on one page, with the supporting detail in an appendix. A practical structure:
- Decision: what the business chose to support during the period
- Allocation: how spend divided across the agreed priorities
- Exceptions: which categories, brands or products diverged most from the plan
- Observed result: what changed in visibility, spend and business performance
- Next action: what the team will keep, change or test next
For the September plan, the one-pager would show the launch cohort's share of catalog, impressions, clicks and spend, how many of the 500 new products received meaningful exposure, whether spend kept leaking to the broken-size summer range, and how those figures compare with the launch objective. The campaign tables move to the appendix.
The next action might be a listing-group change, a protected budget for a smaller launch cohort, lower priority for weak-stock products, or no change at all because the test worked as intended. Reporting earns its place when it changes the next decision.
Five Ways Ad Spend Reports Mislead Leadership
Campaign totals can look strong while supporting the wrong part of the range. Keep the campaign view for specialists and add the product view for the business.
ROAS measures revenue efficiency, not whether revenue came from the categories, margins or stock positions the company wanted to support. This is why ROAS alone fails retailers as a strategy metric.
Averages hide distribution. Total impressions and spend can rise while most products stay invisible. Show how allocation spreads across products and priorities.
A before-and-after chart shows sequence, not cause. Promotions, pricing, demand, weather and competitors move at the same time, so present the comparison and its limits together.
Charts that cannot change a decision belong in the appendix.
Make the Commercial Plan Visible Before the Month Ends
Most leadership teams do not need another weekly campaign report. They need the connection between the commercial plan and the investment meant to support it, visible while there is still time to react.
That connection is built product by product. Attach the priority, category, stock and margin context that shaped the decision, aggregate it into the three views, and put the one-pager in front of the people who made the plan.
The starting point is the same question we ask in our product-level budget analysis: can you explain where the money went in the language of the business?
When the CEO asks whether advertising supported the strategy, the answer should not depend on a campaign name or a healthy average. It should be visible in the allocation.
