Microsoft CPM
cpm
Overview
Microsoft Cost Per Mille (Microsoft CPM) measures the Microsoft-reported cost per 1,000 Microsoft ad impressions.
Microsoft CPM = (Microsoft Ad Spend / Microsoft Impressions) x 1000
The calculation is based on data from the Ads table.
Detailed Breakdown
The formula above is derived from the following components:
Ad Spend = SUM(spend)
--> Ads table
Clicks = SUM(impressions)
--> Ads table
Microsoft Ads = where channel = 'bing'
Insights and Actions
Microsoft CPM is essential for evaluating the cost-effectiveness of your ad campaigns. Use this data to:
- Monitor Spend Efficiency: Track your CPM to ensure you're not overspending to reach your target audience.
- Compare Campaigns: Identify which campaigns have the lowest CPM to allocate more budget towards them.
- Refine Targeting: A high CPM may indicate overly broad targeting, so focus on more specific audience segments to lower costs.
- Optimize Ad Formats: Test different ad formats to find which provides the best value for impressions.
Example Use
Prompt
What's my Microsoft-reported CPM for yesterday?
Response
Query
SELECT
adt.channel AS channel,
COALESCE(
SUM(adt.spend) / NULLIF(SUM(adt.impressions), 0),
0
) * 1000 AS cpm
FROM
ads_table AS adt
WHERE
adt.channel = 'bing'
AND adt.event_date = CURRENT_DATE() - 1
GROUP BY
adt.channel
ORDER BY
cpm DESC;
Updated 20 days ago