Pinterest ROAS

roas

Overview

Pinterest Return on Ad Spend (Pinterest ROAS) refers to the Pinterest-reported conversion value divided by the Pinterest-reported ad spend.

📘

Pinterest ROAS = Pinterest Ads Conversion Value / Pinterest Ad Spend

The calculation is based on data from the Ads table.

Detailed breakdown

The formula above is derived from the following components:

Conversion Value (CV) = SUM(conversion_value) --> Ads table
Ad Spend = SUM(spend) --> Ads table
Pinterest Ads = where channel = 'pinterest-ads'

Insights and Actions

Pinterest ROAS helps you measure the effectiveness and profitability of your Pinterest ads. Understanding your ROAS can guide important advertising and budget decisions:

• Assess Campaign Performance: Use Pinterest ROAS to evaluate whether your ad campaigns are generating a positive return.
• Optimize Budget Allocation: Focus more budget on campaigns with higher ROAS and cut spending on underperforming ads.
• Refine Targeting: High spend with low ROAS may indicate ineffective targeting. Adjust audience segmentation to improve returns.
• Improve Ad Content: If ROAS is low, test different creative elements to see what resonates best with your audience and improves conversions.

Related Metrics

• Pinterest Conversions: Provides additional context on how many conversions are driving your ROAS.
• Pinterest Ad Spend: To correlate your total ad spend with the returns generated.
• Pinterest CTR: Offers insights into how well your ads are engaging the audience.

Example Use

Prompt

What's my channel-reported Pinterest ROAS the last 30 days?

Response

Query

SQL

SELECT
  p.channel AS channel,
  COALESCE(
    SUM(p.channel_reported_conversion_value) / NULLIF(SUM(p.spend), 0),
    0
  ) AS reported_roas
FROM
  pixel_joined_tvf () AS p
WHERE
  p.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
  AND p.channel = 'pinterest-ads'
  AND p.model = 'Triple Attribution'
GROUP BY
  p.channel