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

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 = 'pinterest-ads'
  AND adt.event_date = CURRENT_DATE() - 1
GROUP BY
  adt.channel
ORDER BY
  cpm DESC;