Author name: Pankaj Jangir

Avatar of Pankaj Jangir
Certification Amazon Marketing Cloud

Comment adapterez-vous cette requête pour limiter les résultats au ciblage par mots-clés Sponsored Products uniquement? SELECT ad_product_type, targeting, customer_search_term, match_type, SUM(spend)/100000000 AS total_cost_dollars,((SUM(spend)/100000000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions, SUM(clicks) AS clicks, (SUM(clicks)/SUM(impressions)) AS ctr FROM sponsored_ads_traffic WHERE match_type IN(‘PHRASE’, ‘BROAD’, ‘EXACT’) GROUP BY 1,2,3,4

Question : Comment adapterez-vous cette requête pour limiter les résultats au ciblage par mots-clés Sponsored Products uniquement? SELECT ad_product_type, targeting, […]

Scroll to Top