Taboola CV
conversion_value
Overview
Taboola Conversion Value (Taboola CV) refers to the total conversion value as reported by Taboola.
Taboola CV = Total Taboola-Reported Conversion Value
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
Taboola Ads = where channel = 'taboola'
Insights and Actions
Taboola Conversion Value (Taboola CV) highlights the revenue generated from your Taboola ads, helping to assess the financial impact of your ad campaigns:
- Evaluate Revenue Generation: High CV indicates strong revenue from Taboola campaigns. Consider allocating more budget to these campaigns to scale results.
- Adjust Ad Spend: If CV is lower than expected, assess campaign elements like creative or targeting. Testing adjustments could improve revenue outcomes.
- Refine Audience Targeting: Targeting highly relevant audiences can boost CV, ensuring ads reach users more likely to convert.
Related Metrics
- Taboola Conversions: Shows the total number of conversions, offering insight into volume relative to CV. Low conversions with high CV might suggest high-value transactions.
- Taboola ROAS: Puts CV in the context of ad spend, helping assess if the revenue justifies the cost.
- Taboola Clicks: Provides a measure of engagement alongside CV, as high clicks with low CV may indicate interest without strong purchasing intent.
Example Use
Prompt
What's my total Taboola-reported conversion value over the last 7 days?
Response
Query
SELECT
pjt.channel AS channel,
SUM(pjt.channel_reported_conversion_value) AS channel_reported_conversion_value
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.model = 'Triple Attribution'
AND pjt.channel = 'taboola'
AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1
GROUP BY
pjt.channel;
Updated 8 days ago