To help increase awareness for an upcoming product launch, your manager increases paid promotion funds by 300%. Which channels could you disperse these funds to?

Written by Justin Foley in HubSpot Inbound Certification Answers Last Updated January 29, 2023
  • Twitter
  • LinkedIn
  • Google
  • A and B
  • All of the above

Recent Posts

link to How would you adapt this query to obtain cost and impression metrics by supply_source? SELECT device_type, operating_system, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2

How would you adapt this query to obtain cost and impression metrics by supply_source? SELECT device_type, operating_system, SUM(total_cost)/100000 AS total_cost_dollars, ((SUM(total_cost)/100000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_impressions GROUP BY 1,2

SELECT supply_source, SUM(total_cost)/100000000 AS total_cost_dollars, ((SUM(total_cost)/100000000)/SUM(impressions))*1000 AS avg_cpm, SUM(impressions) AS impressions FROM dsp_inventory GROUP BY 1 ...

Continue Reading
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.