NTB Customers Overall Business Broken By ASIN - AMC Query
SELECT tracked_asin,
COUNT(DISTINCT user_id) AS total_customers,
COUNT(DISTINCT CASE WHEN new_to_brand THEN user_id END) AS ntb_customers,
SUM(total_product_sales) AS total_product_sales,
SUM(CASE WHEN new_to_brand THEN total_product_sales END) AS ntb_product_sales,
SUM(total_units_sold) AS total_units_sold,
SUM(CASE WHEN new_to_brand THEN total_units_sold END) AS ntb_total_units_sold
FROM conversions
WHERE user_id IS NOT NULL AND event_category = 'purchase' GROUP BY tracked_asin
Instruction to run this query(SS are below):
1. Open Amazon Ads
2. Under Measurement and reporting go to AMC
3. Select Account and Marketplace
4. Go to Query Editor and Paste this query
5. Select date range for which you would like to execute
6. Run the query
7. Once you see the output click on download result
8. Once result is downloaded you can either import this csv into Google sheet or Microsoft Excel.
