Come adatteresti questa query per limitare i risultati al solo targeting per parole chiave in Sponsored Products? 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

Domanda: Come adatteresti questa query per limitare i risultati al solo targeting per parole chiave in Sponsored Products? 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

• Modificando l'istruzione WHERE in: WHERE match_type IN('PHRASE', 'BROAD', 'EXACT') AND ad_product_type = 'sponsored_products'
• Modificando l'istruzione FROM in: FROM sponsored_products
• Modificando l'istruzione SELECT in modo da includere il campo sponsored_products
• Aggiungendo la clausola LIMIT: LIMIT sponsored_products

La/le risposta(e) alla domanda è/sono evidenziata(e) nel testo IN GRASSETTO sopra. Puoi anche trovare altre domande e risposte relative agli esami nella pagina “Certificazione Amazon Marketing Cloud”.