---
updatedAt: 2025-01-29T10:30:59.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# 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](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed breakdown

The formula above is derived from the following components:

Conversion Value (CV) = `SUM(conversion_value)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
Ad Spend = `SUM(spend)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) 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

![](https://files.readme.io/87f60fb1016f60c13984e69ed904457e38de76dc0425d008e3d3d7833628a204-image.png)

### 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
```