Twitter CV
conversion_value
Overview
Twitter Conversion Value (Twitter CV) refers to the total conversion value as reported by Twitter.
Twitter CV = Total Twitter-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
Twitter Ads = where channel = 'twitter-ads'
Insights and Actions
Tracking Twitter Conversion Value helps you assess the total revenue your Twitter ads are generating, which is essential for evaluating campaign effectiveness. This data can guide strategic advertising decisions:
- Assess Campaign Performance: High conversion value indicates successful campaigns. Pair with Twitter Ad Spend to ensure your investment is delivering adequate returns.
- Identify Top-Performing Ads: Use Twitter CV to pinpoint which ads contribute most to revenue and allocate budget accordingly.
- Refine Strategies: If conversion value is lower than expected, consider revisiting targeting options, ad placements, or creative strategies to boost performance.
Related Metrics
- Twitter Conversions: Helps quantify how many purchases contributed to the conversion value, providing insight into conversion quality.
- Twitter ROAS: Indicates the return on ad spend, ensuring the revenue generated justifies the expenditure.
- Twitter CPA: Complements conversion value by showing the cost per acquisition, helping balance revenue with cost-efficiency.
Example Use
Prompt
What's my total Twitter-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 = 'twitter-ads'
AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1
GROUP BY
pjt.channel;
Updated about 1 month ago