Pinterest CTR

ctr

Overview

Pinterest Click-Through Rate (CTR) represents the percentage of users who clicked on your Pinterest ad after seeing it.

📘

Pinterest CTR = Pinterest Clicks / Pinterest Impressions

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Clicks = SUM(clicks) --> Ads table
Impressions = SUM(impressions) --> Ads table
Pinterest Ads = where channel = 'pinterest-ads'

Insights and Actions

Pinterest CTR measures how effectively your ads are engaging users by showing how many clicks they generate relative to the number of impressions. This metric helps you evaluate the performance of your ad creative and targeting:

• Evaluate Engagement: A high CTR indicates that your ad resonates with your audience. If CTR is low, it may be time to revisit your ad creative or messaging.
• Optimize Ad Creative: Low CTR might signal that your ads aren’t compelling enough. Experiment with new images, copy, or formats to boost interaction.
• Adjust Targeting: If your CTR is low across certain demographics or audience segments, refine your targeting to focus on users more likely to engage.

Related Metrics

• Pinterest Impressions: Helps understand the overall reach of your ads. High impressions with a low CTR may indicate targeting or creative issues.
• Pinterest Conversions: Provides insight into whether those clicks are turning into actual purchases, helping assess the quality of traffic driven by the ads.
• Pinterest CPC: Lets you see the cost per click, helping you evaluate the efficiency of your ad spend relative to how often users are engaging.

Example Use

Prompt

What's my Pinterest CTR for the last 7 days?

Response

Query

SQL

SELECT
  am.channel AS channel,
  COALESCE(
    SUM(am.clicks) / NULLIF(SUM(am.impressions), 0),
    0
  ) AS CTR
FROM
  ads_table AS am
WHERE
  am.channel = 'pinterest-ads'
  AND am.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
GROUP BY
  am.channel;