Retail Analytics Net PPM

Retail Analytics Net PPM

icon
Table Name: 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:

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.

  1. 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
image