Arvin Saclolo ← Back to the case study

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.