Retail Analytics Net PPM

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:

• 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?

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

• Business questions & scenarios
• Schema & update details
• Historical data & change management
• Data dictionary: fields in this table
• Table & data nuances
• How to query this table
• Example query output
• Related pages

Related pages

Manufacturing View vs. Sourcing View