NTB Customers By Campaign Type - AMC Query
SELECT
ae.ad_product_type,
COUNT(DISTINCT ae.user_id) AS total_customers,
COUNT(DISTINCT CASE WHEN ae.new_to_brand THEN ae.user_id END) AS ntb_customers,
SUM(ae.purchases) AS total_purchases,
SUM(ae.total_units_sold) AS total_units,
SUM(ae.total_product_sales) AS total_revenue,
SUM(new_to_brand_purchases) AS new_to_brand_purchases,
SUM(new_to_brand_total_units_sold) AS new_to_brand_total_units_sold,
SUM(new_to_brand_product_sales) AS new_to_brand_product_sales,
SUM(new_to_brand_brand_halo_product_sales) AS new_to_brand_brand_halo_product_sales,
SUM(new_to_brand_brand_halo_purchases) AS new_to_brand_brand_halo_purchases
FROM
amazon_attributed_events_by_conversion_time ae
GROUP BY
ae.ad_product_type
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.
