🚀 Why Analyze Audience Segment Insight Data? Audience Penetration!
Wondering how your Amazon ads perform with different audiences? Amazon Marketing Cloud (AMC) Audience Segment Insights can tell you. It shows you the reach of your ads and who's buying, offering a glimpse into potential growth areas and your marketing wins.
🔍 Our SQL Code Unleashed
SELECT b.segment_id, b.segment_name, b.segment_marketplace_id, b.segment_description, COUNT(DISTINCT a.user_id) AS total_users_in_segment, COALESCE(SUM(impressions.impression_count), 0) AS impressions_served, COALESCE(SUM(purchases.purchase_count), 0) AS total_purchasers
FROM audience_segments_amer_inmarket a INNER JOIN segment_metadata b ON a.segment_id = b.segment_id AND a.segment_marketplace_id = b.segment_marketplace_id LEFT JOIN ( SELECT user_id, COUNT(DISTINCT user_id) AS impression_count FROM ( SELECT user_id FROM dsp_impressions UNION ALL SELECT user_id FROM sponsored_ads_traffic ) combined_impressions GROUP BY user_id ) impressions ON a.user_id = impressions.user_id LEFT JOIN ( SELECT user_id, COUNT(DISTINCT user_id) AS purchase_count FROM conversions_all WHERE event_category = 'purchase' GROUP BY user_id ) purchases ON a.user_id = purchases.user_id
WHERE b.segment_marketplace_id = 1
GROUP BY b.segment_id, b.segment_name, b.segment_marketplace_id, b.segment_description;
📊 Interpreting the Output
Running this query gives us:
- Total unique users per segment.
- Impressions served (audience viewership penetration)
- Number of purchases (audience purchase penetration).
It’s an overview of your audience's interaction with your products.
🛠 Actionable Insights
With this data:
1. Find segments with high views but low purchase rates - great audiences to remove!
2. Customize ads for promising segments.
3. Identify the size of the prize for our most important/top-performing audiences.
AMC data guides strategic decisions to enhance your campaign's impact. Keen to leverage these insights? Let’s connect! 🌟
#amc #amazonads #amazonadvertising #amazon