Revenue Overview (IBA Vendor)

Dashboard link: https://app.emax-digital.com/international-business-analysis-vendor-main-page/intern-business-analysis-vendor-revenue-overview

Overview

The Revenue Overview sub-dashboard of the International Business Analysis (Vendor) suite gives Amazon Vendor Central brands a single cross-marketplace view of their full commercial funnel — from sell-in (Net Received Revenue) through sell-out (Ordered or Shipped Revenue), Shipped COGS, and product-level profitability (Net PPM). Every figure is shown for the selected year alongside the prior-year equivalent, with year-to-date (YTD) scorecards, a comprehensive marketplace P&L table, rolling trend charts, marketplace-level YoY development, and a period-by-period detail table that also includes advertising metrics.

It is designed for international vendor managers and brand leads who need to answer: "How is the global business performing this year versus last year, which marketplaces are driving the change, and where is profitability moving in the right direction?"

This dashboard covers Amazon Vendor Central (1P) data only. Seller Central (3P) revenue is tracked separately.

What You Can See on This Dashboard

The dashboard is organised top-to-bottom into four blocks: YTD Scorecards & Marketplace Snapshot, Marketplace P&L Summary, Rolling Trends vs. Prior Year, and Marketplace-Level Trends + Monthly Detail.

Section 1 — YTD Scorecards

A column of four KPI scorecards on the left of the dashboard gives an instant year-to-date pulse check across all marketplaces combined, each compared to the same YTD window last year.

Key metrics:

• Net Received Revenue YTD — Total sell-in at cost price for the selected year, summed across all marketplaces, compared to the same YTD window in the prior year. Cost basis follows the Distributor View (Manufacturing or Sourcing).

• Shipped Revenue YTD (Sell-Out) — Year-to-date sell-out revenue across all marketplaces vs. prior year. The revenue type shown — Ordered Revenue or Shipped Revenue — follows the Sales View filter. In Sourcing view, only Shipped Revenue is available.

• Shipped COGS YTD — Year-to-date Shipped Cost of Goods Sold across all marketplaces vs. prior year.

• Net PPM YTD — Year-to-date Net Pure Product Margin (unit-weighted average margin %) across all marketplaces vs. prior year. Higher Net PPM = stronger product-level profitability.

Visualizations: Four number scorecards, each showing the current YTD value and the prior-year equivalent for direct comparison.

Section 2 — Net Received Revenue by Marketplace (YTD Snapshot)

Two charts to the right of the scorecards show where your sell-in is concentrated and how it is trending across the year.

Visualizations:

• Net Received Revenue – All Marketplaces (YTD) — Pie chart showing the share of total YTD Net Received Revenue contributed by each marketplace.

• Net Received Revenue Development by Marketplace — Bar chart showing Net Received Revenue over time, stacked or grouped by marketplace. Time granularity follows the Reporting Range filter (Weekly / Monthly / Quarterly). For the current year, the chart shows a rolling window of the last 12 months / 12 weeks / 4 quarters; for past years, the full year is displayed.

Section 3 — Marketplace P&L Summary Table

A comprehensive YTD performance table covering every marketplace in one view — the full commercial funnel from sell-in through to margin and pricing.

Columns shown (per marketplace):

• Sell-In: Net Received Revenue (current year, prior year, YoY trend) and Diff. Man.–Sour. — the difference between Manufacturing and Sourcing cost bases, highlighting valuation gaps between the two views.

• Sell-Out Revenue: Ordered Revenue and Shipped Revenue, current and prior year with YoY trends. Ordered Revenue is not available in the Sourcing distributor view.

• Shipped COGS & Units: Shipped COGS plus Ordered Units and Shipped Units (current, prior year, YoY trends).

• Profitability & Pricing: Net PPM (unit-weighted average margin) and Average Sales Price (Revenue ÷ Units, based on the selected Sales View), each with prior year and YoY trend. Average Sales Price is hidden for accounts where average-pricing display is restricted.

Section 4 — Rolling Trend vs. Prior Year (All Marketplaces)

Two side-by-side line charts comparing the last 13 reporting periods of the current year against the same 13 periods one year ago, aggregated across all marketplaces.

• Net Received Revenue – All Marketplaces — Current year vs. prior year sell-in trend.

• Sell-Out Revenue – All Marketplaces — Current year vs. prior year sell-out trend. The metric label adapts to the Sales View filter (Ordered Revenue, Shipped Revenue, or Shipped COGS).

Only periods up to the latest fully available data point per marketplace are included, to avoid incomplete periods distorting the trend.

Section 5 — Net Received Revenue Trend & YoY Development by Marketplace

Two side-by-side charts that break the sell-in trend down by marketplace.

• Net Received Revenue Development by Marketplace — Line chart of Net Received Revenue per marketplace over the selected periods.

• Net Received Revenue YoY Trend by Marketplace — Bar chart showing the percentage YoY change per marketplace per period, making it easy to spot which markets are accelerating or declining and when.

Section 6 — Net PPM Trend Charts

Two side-by-side line charts focused on profitability.

• Net PPM Development by Marketplace — Net PPM (%) per marketplace over the selected periods.

• Net PPM – All Marketplaces — Aggregated Net PPM for the last 13 periods, current year vs. prior year, for a like-for-like profitability comparison across the whole portfolio.

Section 7 — Monthly Development per Marketplace (Detail Table)

A granular period-level breakdown table — one row per marketplace per reporting period — that adds advertising metrics to the funnel view.

Columns shown: Report Date · Marketplace · Sell-In (Net Received Revenue + units, each with YoY trend) · Sell-Out (Ordered Revenue, Shipped Revenue, Shipped COGS, Ordered Units, Shipped Units — each with YoY trend) · Average Sales Price (with YoY trend) · Advertising (Ad Sales, Ad Spend, Ad Units, ROAS — each with YoY trend).

Note on advertising: When a Category, Subcategory, Tag, or ASIN filter is active, advertising figures are sourced from ASIN-level data. Otherwise, campaign-level totals are used. This means advertising numbers in a filtered view may differ slightly from an unfiltered view at the total level.

Available Filters

Filter interaction notes

• Distributor View ↔ Sales View. In Manufacturing view all three Sales View options are available (Ordered Revenue, Shipped Revenue, Shipped COGS). In Sourcing view, Ordered Revenue is not available — Shipped Revenue is used by default because the Sourcing model does not record ordered revenue at the brand level.

• Subcategory depends on Category. Selecting a Category narrows the Subcategory list to values that belong to it.

• Current year vs. past years. When the selected year is the current year, trend charts automatically apply a rolling window (last 12 months / 12 weeks / 4 quarters). For past years, the entire year is shown.

• Currency = Original. Switches every monetary KPI to each marketplace's native currency. Useful for local-team reporting but makes cross-marketplace totals non-comparable.

• Filters affect advertising data sourcing. Applying a Category, Subcategory, Tag, or ASIN filter shifts the advertising columns in the Monthly Development table from campaign-level to ASIN-level totals.

Use Cases

1 — Monthly international business review

You need to brief leadership on global Vendor performance for the closed month.

• Set Year = current year, Reporting Range = Monthly, Distributor View = your reporting standard.

• Read the four YTD scorecards for the headline year-vs-year story across sell-in, sell-out, COGS, and margin.

• Use the Net Received Revenue pie chart to anchor the audience on which marketplaces matter most.

• Walk through the Marketplace P&L Summary row by row to call out the biggest YoY movers — both positive and negative.

• Close with the Net PPM Development by Marketplace chart to flag any margin warning signs.

2 — Identifying your fastest-growing and fastest-declining marketplace

You want to direct investment toward high-momentum markets.

• Open the Net Received Revenue YoY Trend by Marketplace bar chart.

• Rank marketplaces by the YoY % column. The strongest growth candidates are obvious; persistent negatives are flags for deeper review.

• Cross-check with the Marketplace P&L Summary to confirm whether the growth is also profitable (Net PPM YoY) or coming at a margin cost.

3 — Manufacturing vs. Sourcing reconciliation

Your finance team has noticed a gap between manufacturing-entity and sourcing-entity revenue figures.

• Open the Marketplace P&L Summary and read the Diff. Man.–Sour. column per marketplace — this is exactly the gap between the two cost bases at the marketplace level.

• Switch the Distributor View filter between Manufacturing and Sourcing and compare the YTD Net Received Revenue scorecard to validate which view ties out to which entity's books.

4 — Margin deep-dive across markets

You want to know which marketplaces are improving on Net PPM and which are deteriorating.

• Read the Net PPM YTD scorecard for the headline movement.

• Open Net PPM Development by Marketplace to see the trajectory by market — is the YTD figure being pulled up or down by a specific marketplace?

• Use Net PPM – All Marketplaces (rolling 13-period vs. prior year) to confirm whether the trend is structural or a one-off period effect.

• For declining markets, filter by Category to localise whether the margin pressure is portfolio-wide or concentrated.

5 — Category-level international view

You manage a specific product category and want the international picture for it.

• Set Category (and optionally Subcategory) to your assortment.

• All charts, scorecards, and tables now restrict to that category. The advertising columns in the Monthly Development table will switch to ASIN-level totals — note this when reconciling with campaign-level reports.

• Use the Monthly Development per Marketplace table to compare your category's sell-in, sell-out, pricing, and advertising performance across all marketplaces side by side.

Limitations & Notes

• Vendor Central only. Seller Central (3P) revenue is not included. For a combined view, see the International Hybrid Monthly Overview.

• Two distributor models. Manufacturing and Sourcing are shown one at a time — the dashboard does not aggregate across both. The Diff. Man.–Sour. column in the P&L table is the only place both views are reconciled in a single view.

• Sales View restrictions in Sourcing. Ordered Revenue is not available when Distributor View = Sourcing. The dashboard will fall back to Shipped Revenue.

• Currency conversion. Monetary values are converted to the selected display currency using annual exchange rates. Cross-year and cross-marketplace monetary comparisons should be read with that in mind; for native-currency views, set Currency = Original.

• Rolling window for the current year. When viewing the current year, trend charts show a rolling window (12 months / 12 weeks / 4 quarters). When viewing a past year, the full year is displayed — so the same chart can look very different depending on the Year filter.

• Incomplete periods are excluded. The rolling 13-period charts only include periods up to the latest fully available date per marketplace, to prevent partial weeks/months from distorting the trend line.

• Net PPM is unit-weighted. High-volume SKUs influence the figure more than low-volume ones. A small set of high-volume products can mask margin issues elsewhere — drill into the Marketplace P&L table to see margin per marketplace.

• Advertising data sourcing changes with filters. In the Monthly Development table, advertising metrics are campaign-level by default but switch to ASIN-level when Category, Subcategory, Tag, or ASIN filters are applied. Filtered and unfiltered totals are therefore not directly comparable.

• Ignored catalogue entries are always excluded — ASINs you have flagged as ignored in your catalogue do not contribute to any figure on this dashboard.

• Average Sales Price may be hidden. Some accounts have average-pricing display restricted; in those cases the column does not appear.