Pinterest CPM
cpm
Overview
Pinterest Cost Per Mille (Pinterest CPM) measures the Pinterest-reported cost per 1,000 Pinterest ad impressions.
Pinterest CPM = (Pinterest Ad Spend / Pinterest 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
Pinterest Ads = where channel = 'pinterest-ads'
Insights and Actions
Pinterest CPM helps you assess the cost-efficiency of your Pinterest ads and can guide your advertising strategy:
- Optimize Ad Content: Compare CPM across different types of ads to see which formats (e.g. video, image) are most cost-efficient.
- Improve Targeting: A high CPM could indicate that your audience is too broad or not well-targeted, leading to wasted impressions.
- Adjust Bidding Strategy: Reevaluate your bidding to ensure you're getting the best deal on impressions, especially during competitive times.
- Monitor Seasonal Trends: Use CPM trends to adjust your budget during high-demand periods (e.g., holidays) when ad costs can fluctuate.
Related Metrics
- Pinterest Impressions: Track how many times your ad is being seen to better understand how CPM impacts your overall reach.
- Pinterest ROAS: Ensure that your ad impressions are translating into revenue, not just visibility.
- Pinterest CTR: See if impressions are turning into engagement, providing a fuller picture of ad performance.
Example Use
Prompt
What's my Pinterest 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 = 'pinterest-ads'
AND adt.event_date = CURRENT_DATE() - 1
GROUP BY
adt.channel
ORDER BY
cpm DESC;
Updated 20 days ago