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

SQL

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;