You’re starting a project and don’t have a past campaign to use as a benchmark. How can you secure executive buy-in?

Written by Justin Foley in HubSpot Social Media Marketing Certification Answers Last Updated December 22, 2022
  • Research the costs of agencies that can do the work.
  • Consider industry research to back up your plan.
  • Position your program as an experiment or pilot.
  • Create a robust PowerPoint with statistics to back up your plan.

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.