retail_analytics_net_ppm
PPM stands for Pure Profit Margin. The Retail Analytics Net PPM table provides daily, weekly and monthly snapshots of Amazon’s PPM on your products. It measures Amazon’s profit margin on your products inclusive of your funding (e.g. coupon clip fee) and sales discounts (e.g. coupon face value). It excludes Amazon’s operating costs such as shipping, fulfillment costs, etc. The net PPM formula is as follows:
Net PPM
= Shipped Revenue
– Shipped COGS
+ Vendor Terms
– Sales Discount
.
For example, if you sell widgets to Amazon for $50, and they are retailing for $100, the PPM is 50% if there are no other factors in play. If you provide Amazon $5 in funding, then Net PPM is 55% (Amazon's net margin after selling your product) through product costs, co-op agreements and accrual agreements.
The accrual agreement includes the freight allowance, which is where the vendor uses Amazon's freight network and then Amazon charges them a percentage for the privilege. It also includes damage allowance, where Amazon handles damaged products instead of the vendor for a percentage fee.
Read more:
- Whitepaper: Understanding Amazon’s Approach to Vendor Profitability
- Whitepaper: Amazon and 1P Vendor Remittance
Business questions & scenarios
What is this data useful for?
- Profitability monitoring: How profitable are Amazon’s sales of our products, before factoring in variable costs? Which products do they make the most and least money on?
- QBR and negotiation prep: What funding requests should we expect and how can we get ahead of them?
Schema & update details
UI Report path | |
Amazon update frequency | Daily, with 48-72 hour latency. Learn more |
Reason update frequency | Every 8 hours |
Time Zone | Country local time zone |
Granularity [?] | 1 row per:
- ASIN
- Date
- Period
- Program
- Distributor View |
Historical data & change management
Time Period | DAILY | WEEKLY | MONTHLY |
History available from Amazon [?] | 1095 days | 6 weeks | 36 months |
Reason lookback period [?] | 14 days | 2 weeks | 2 months |
Data dictionary: fields in this table
Table & data nuances
- Time periods may not match: All retail analytics tables are available at DAILY, WEEKLY, MONTHLY granularity. There may be Amazon-driven discrepancies between different granularities that Amazon has not explained. For net PPM, it will be hard to evaluate these discrepancies since data provided are averages for a given ASIN and date range. We recommend using the highest-granularity data you can, to minimize discrepancies and stakeholder questions.
- Manufacturing only: This table ONLY contains data for the Manufacturing distributor view (Amazon does not provide this data for the Sourcing view).
- Amazon wants you to connect a product catalog. This table contains data by date by ASIN, but does not provide any product attributes like category, size, or even product title to help you identify or aggregate products. Amazon expects you to connect this table to a catalog/dimension table that maps ASINs to attributes, such as the Product Catalog table or our custom catalog upload.
How to query this table
It’s important to filter this table by period to avoid duplication. This table also has program and distributor_view, although there is no risk of duplication with these columns as for net PPM data, they are always set to ‘Amazon Retail’ and ‘Manufacturing’ respectively.
- Adjust dates as needed. The example query below will provide ASIN-level net PPM data for Q1 2024 at the daily grain.
SELECT
_partneruuid,
date,
period,
asin,
net_ppm
FROM retail_analytics_net_ppm
where period = 'DAILY'
and program = 'Amazon Retail'
and distributor_view = 'Manufacturing'
and date_trunc('day',date)::date between '2024-01-01' and '2024-03-31'
Example query output
_partneruuid | date | period | asin | net_ppm |
abcde12345 | 4/23/2024 0:00 | DAILY | B123456789 | 0.4453 |
abcde12345 | 3/15/2024 0:00 | DAILY | B234567890 | 0.571 |
abcde12345 | 3/15/2024 0:00 | DAILY | B345678901 | 0.2229 |
abcde12345 | 3/21/2024 0:00 | DAILY | B456789012 | 0.5283 |
abcde12345 | 3/21/2024 0:00 | DAILY | B567890123 | 0.397 |