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

SQL

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;