TikTok CV

conversion_value

Overview

TikTok Conversion Value (TikTok CV) refers to the total conversion value as reported by TikTok.

📘

TikTok CV = Total TikTok-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
TikTok Ads = where channel = 'tiktok-ads'

Insights and Actions

TikTok Conversion Value (TikTok CV) measures the total revenue generated from conversions attributed to your TikTok ads, helping you assess the direct financial impact of your campaigns.

• Evaluate Campaign Performance: Monitor TikTok CV to gauge the total revenue generated from your TikTok ads, providing a clear view of campaign profitability.
• Optimize Ad Spend: Focus on campaigns with higher conversion values to allocate more budget where it delivers the most revenue.
• Refine Targeting: Analyze which audience segments yield the highest conversion value to refine your targeting for future campaigns.
• Boost High-Performing Ads: Identify ads that drive higher conversion value and double down on similar strategies to maximize returns.

Example Use

Prompt

What's my total TikTok-reported conversion value over the last 14 days?

Response

Query

SQL

SELECT
  SUM(adt.conversion_value) AS total_tiktok_reported_conversion_value
FROM
  ads_table AS adt
WHERE
  adt.channel = 'tiktok-ads'
  AND adt.event_date BETWEEN CURRENT_DATE() - INTERVAL 14 DAY AND CURRENT_DATE()  - 1