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

# Taboola ROAS

roas

# Overview

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

> 📘 Taboola ROAS = Taboola Ads Conversion Value / Taboola 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\
Taboola Ads = `where channel = 'taboola'`

# Insights and Actions

Taboola Return on Ad Spend (ROAS) gives a snapshot of the revenue generated per dollar spent on Taboola ads, helping you evaluate campaign profitability:

* **Optimize Budget Allocation**: High ROAS suggests effective ad spend; consider increasing budget to capitalize on profitable campaigns.
* **Identify Underperforming Campaigns**: Low ROAS indicates inefficient ad spend; review targeting, creative, and bidding strategies to improve performance.
* **Refine Targeting**: If ROAS is inconsistent across audiences, focus on higher-performing segments to improve overall campaign efficiency.

### Related Metrics

* **Taboola Conversion Value (CV)**: Puts ROAS in context by showing total revenue generated, helping assess if high ROAS corresponds to substantial revenue.
* **Taboola Ad Spend**: Essential for understanding the cost aspect of ROAS, highlighting where costs could be adjusted for better returns.
* **Taboola Impressions**: Helps gauge overall ad reach, as low impressions may limit ROAS potential even with high conversion rates.

# Example Use

### Prompt

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

### Response

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

### Query

```sql
SELECT
  COALESCE(
    SUM(pjt.channel_reported_conversion_value) / NULLIF(SUM(pjt.spend), 0),
    0
  ) AS reported_roas
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
  AND pjt.channel = 'taboola'
  AND pjt.model = 'Triple Attribution'
```