Case study 01 Demo data
DTC Kitchen Brand: Amazon Performance Hub
P&L, PPC and search query performance for Amazon US, built on SP-API, Ads API and Brand Analytics data in BigQuery.
This period in plain English
Sales and units
Hover for the numbers. The grain switch changes the buckets.
Traffic and conversion
Sessions against unit session percentage.
Products by category
Click a category to see its SKUs. Click a column to sort.
P&L waterfall
Revenue down to net contribution, after every Amazon fee.
Campaigns
Sponsored Products by category and match type.
Wasted spend
Search terms with spend and no orders in this period.
Search query performance
Brand share at each stage, from Brand Analytics. Green: purchase share above impression share.
Brand share by funnel stage
Weighted by search volume across the queries shown.
When purchase share beats impression share, the listing converts better than the market, so those queries can take more spend.
