📆 Monthly Overview — Vendor (NRR and Ads)

Dashboard link: https://app.emax-digital.com/monthly-overview-for-vendors-nrr-all-ads

Overview

The Monthly Overview (Vendor) dashboard gives Amazon Vendor Central brands a structured, period-by-period view of how the business performed across the selected year — combining the retail P&L (Net Received Revenue, Shipped COGS, Shipped Revenue, Net PPM) with the full advertising picture (Sponsored Ads + DSP spend, sales, and traffic funnel) in one place. Every metric is shown alongside its prior-year equivalent and a year-over-year growth rate, so the question "is this period better or worse than the same period last year?" is answered at a glance.

It is built for vendor managers and finance/controlling teams who need a clean monthly (or weekly / quarterly) reporting view that ties retail performance and advertising performance together — particularly useful for monthly business reviews, budget tracking, and reconciling sell-in vs. sell-out vs. ad-driven sales.

What You Can See on This Dashboard

The dashboard is structured in three blocks: Retail Performance (Net Received Revenue, Shipped COGS, Shipped Revenue, Net PPM), Advertising Performance vs. Ordered Revenue (spend, sales, ACoS, TACoS, ROAS), and Advertising Traffic Funnel (impressions, clicks, CTR, CPC, CPM). Each block has a trend chart followed by a detailed period-level table.

Section 1 — Net Received Revenue, Shipped COGS & Growth Rate (Trend)

The opening view of retail performance: how sell-in (Net Received Revenue) and cost of goods shipped have developed across the year compared to the prior year.

Key metrics:

• Net Received Revenue (NRR) — Revenue from inventory received and invoiced by Amazon in the period.

• Net Received Revenue Previous Year — The same metric for the equivalent period one year ago.

• Shipped COGS — Cost of goods shipped from Amazon to customers in the period.

• Shipped COGS Previous Year — Equivalent prior-year value.

• Net Received Revenue Growth — Year-over-year % change in NRR.

• Shipped COGS Growth — Year-over-year % change in Shipped COGS.

Visualizations: A combined bar chart per period (week/month/quarter, depending on the Reporting Range filter) showing NRR and Shipped COGS for the current and prior year side-by-side, with the YoY growth rates overlaid.

Section 2 — Vendor Revenue Detail Table (NRR / Shipped COGS / Shipped Revenue / Net PPM)

The detailed periodic breakdown — one row per period — covering the full retail P&L line-by-line.

Key metrics:

• Net Received Revenue — Current period and prior-year value, YoY growth %, and the Diff. Man.–Sour. column showing the gap between Manufacturing and Sourcing distributor views.

• Shipped COGS — Current period, prior year, YoY growth %, and Diff. Man.–Sour.

• Shipped Revenue — Sell-out revenue (goods shipped to customers), current period, prior year, YoY growth %, and Diff. Man.–Sour.

• Net PPM (Net Pure Product Margin) — Weighted average margin across shipped units, current period, prior year, and YoY growth %.

The Diff. Man.–Sour. columns highlight the difference between the Manufacturing and Sourcing perspectives for each cost metric — useful to surface discrepancies between the two distributor models.

Visualizations: A wide period-level table with all retail KPIs grouped per metric (current value · diff · prior year · growth).

Section 3 — Ad Spend vs. Ad Sales (Trend)

The advertising headline view: how ad investment and ad-attributed revenue have moved through the year, with the two key efficiency ratios.

Key metrics:

• Ad Spend — Total amount spent on Amazon advertising (Sponsored Ads + DSP) in the period.

• Ad Sales — Revenue attributed to advertising (14-day attribution).

• ACoS (Advertising Cost of Sales) — Ad Spend ÷ Ad Sales. Measures advertising efficiency in isolation.

• TACoS (Total Advertising Cost of Sales) — Ad Spend ÷ total Ordered Revenue. Reflects the true advertising cost burden across the whole vendor business, not just ad-attributed sales.

Visualizations: Combined bar/line chart with Ad Spend and Ad Sales as bars, and ACoS and TACoS as lines, plotted across the year.

Section 4 — Advertising Performance vs. Ordered Revenue (Detail Table)

A comprehensive periodic table tying advertising performance back to total Ordered Revenue, broken out by Sponsored Ads vs. DSP.

Key metrics:

• Total Ad Spend — Combined Sponsored Ads + DSP spend per period.

• % Sponsored Ads Spend of Total Ad Spend — Share of total ad spend going to Sponsored Ads.

• % DSP Spend of Total Ad Spend — Share of total ad spend going to DSP.

• Paid Sales (SA + DSP) — Total attributed ad sales across both channels.

• Paid Sales (Sponsored Ads) / Paid Sales (DSP) — Channel-level breakout of ad-attributed sales.

• % Ad Sales of Ordered Revenue — Share of total Ordered Revenue that is ad-attributed.

• Ordered Revenue — Total Ordered Revenue for the period (the denominator for TACoS).

• Organic Sales — Ordered Revenue minus total attributed ad sales — an estimate of non-ad-driven sales.

• ACoS / ROAS / TACoS — The three core efficiency metrics. ROAS = Ad Sales ÷ Ad Spend (the inverse of ACoS).

Visualizations: A wide period-level table covering channel mix, paid-vs-organic split, and the three efficiency ratios.

Section 5 — Impressions vs. Clicks by Campaign Type (Trend)

The top of the advertising funnel, broken out by ad format, so you can see which campaign types are driving reach across the year.

Key metrics:

• Impressions by Ad Type — Per-period impressions for Sponsored Products, Sponsored Brands, Sponsored Brands Video, Sponsored Display, and DSP.

• CTR (Click-Through Rate) — Total clicks ÷ total impressions, across all ad types combined.

Visualizations: Stacked bar chart of impressions per period (one stack segment per ad type), with the overall CTR plotted as a line.

Section 6 — Impressions, Clicks, CTR, CPC & CPM (Detail Table)

The detailed advertising funnel table — total reach and engagement across all ad types per period.

Key metrics:

• Impressions — Total ad impressions across all ad types.

• Clicks — Total ad clicks across all ad types.

• CTR — Click-through rate (Clicks ÷ Impressions).

• CPC (Cost per Click) — Average cost per ad click.

• CPM (Cost per 1,000 Impressions) — Cost efficiency of reach.

Visualizations: Period-level table covering the full traffic-and-cost funnel.

Available Filters

Filter interaction notes

• Subcategory depends on Category. Selecting categories narrows the available sub-categories. If no Category is selected, all sub-categories are available.

• Distributor View changes the cost perspective for NRR, Shipped COGS, and Shipped Revenue. The Diff. Man.–Sour. columns in the detail table always show the gap between both views regardless of which one is currently selected.

• Tag / Category / Subcategory filters apply to advertising too. When any of these is active, advertising metrics (Ad Spend, Ad Sales, Impressions, Clicks, etc.) are recalculated at ASIN level using only the matching products. This means ad totals will be lower than the unfiltered (account-wide) view.

• Year and Reporting Range work together. Switching the Reporting Range reshapes every chart and table on the page to the new granularity.

Use Cases

1 — Monthly business review preparation

You need to walk leadership through last month's performance against the same month last year.

• Set Year = current year, Reporting Range = Monthly, Distributor View = Manufacturing.

• Read the Net Received Revenue / Shipped COGS trend chart for the headline retail story, then drop to the Vendor Revenue Detail table for line-by-line numbers (NRR, Shipped COGS, Shipped Revenue, Net PPM — each with YoY growth %).

• Move to the Ad Spend vs. Ad Sales chart for the advertising headline and the Advertising Performance vs. Ordered Revenue table for the paid-vs-organic split and TACoS trend.

2 — Budget vs. actuals check across the year

You want to see whether the year is tracking to plan and where the deltas are concentrated.

• Set Reporting Range = Monthly and look at the YoY Growth % columns across all four retail KPIs in the detail table.

• Identify months where Shipped Revenue Growth significantly outpaces or trails NRR Growth — this signals timing differences between sell-in and sell-out worth investigating.

• Cross-check the Net PPM Growth column to confirm whether growth is profitable.

3 — Manufacturing vs. Sourcing reconciliation

You need to understand the gap between the Manufacturing and Sourcing distributor views.

• Open the Vendor Revenue Detail table and focus on the Diff. Man.–Sour. columns for NRR, Shipped COGS, and Shipped Revenue.

• Periods with unusually large differences may indicate sourcing entity timing differences, transfer pricing changes, or data reconciliation issues worth raising with your Amazon vendor manager.

4 — Tracking TACoS across the year

You want to know whether the business is becoming more or less reliant on advertising over time.

• Read the Ad Spend vs. Ad Sales chart, focusing on the TACoS line.

• In the Advertising Performance detail table, watch the % Ad Sales of Ordered Revenue column — if this share is rising while overall Ordered Revenue is flat, organic demand is weakening and ads are filling the gap.

• Use the Organic Sales column to confirm whether non-ad-driven revenue is growing in absolute terms.

5 — Channel mix review (Sponsored Ads vs. DSP)

You want to see how spend and sales are split between Sponsored Ads and DSP, and whether the mix is shifting.

• In the Advertising Performance vs. Ordered Revenue table, read the % Sponsored Ads Spend and % DSP Spend columns period over period.

• Compare against Paid Sales (Sponsored Ads) and Paid Sales (DSP) to see whether each channel's share of sales matches its share of spend — a sign of channel efficiency.

6 — Ad funnel efficiency check

You suspect ad costs are creeping up. You want to know whether it is a CPC, CPM, or CTR problem.

• Open the Impressions, Clicks, CTR, CPC & CPM detail table.

• Trace CPC and CPM month-over-month — rising CPM with stable CTR points to auction inflation; falling CTR with stable CPM points to creative or targeting fatigue.

• Use the Impressions by Campaign Type chart to see whether one ad format is driving the cost shift.

Limitations & Notes

• Vendor Central only. This dashboard covers Vendor (1P) data. Seller Central (3P) sales and advertising are not included.

• Manufacturing vs. Sourcing. Only one distributor view is shown at a time for the main KPI values; use the Diff. Man.–Sour. columns in the detail table to see the gap between both. A simultaneous combined view across both models is not available.

• Ad attribution window: 14 days. Ad Sales / Paid Sales figures are based on Amazon's 14-day attribution window. Very recent periods may still see small upward revisions as attributed orders complete.

• Filter scope on advertising. When Tag, Category, or Subcategory filters are active, advertising metrics are recomputed at ASIN level using only matching products. Unfiltered (account-wide) ad totals will therefore be larger than filtered views — this is expected, not an error.

• Ignored ASINs. Only non-ignored ASINs contribute to the sell-out and ad-funnel metrics. ASINs flagged as ignored in the Catalog are excluded throughout.

• Net PPM availability. Net PPM is only populated where Amazon reports it; for very new ASINs or some marketplaces the figure may be blank or partial for the most recent periods.

• Organic Sales is a derived estimate. Organic Sales = Ordered Revenue − attributed Ad Sales (SA + DSP). Because attribution is click-based and 14-day-bound, this should be read as an approximation of non-ad-driven demand, not a precise figure.

• Year filter scope. All trend charts and tables show the selected year vs. the prior year. To compare against earlier years, change the Year filter and re-run.

Data Refresh

Data updates every 8 hours (approximately three times per day).