Overview

AppLovin Conversion Value (CV, Revenue on Conversions) refers to the total conversion value as reported by AppLovin.

📘

AppLovin CV = Total AppLovin-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
AppLovin Ads = where channel = 'applovin'

Insights and Actions

AppLovin Conversion Value (CV) reflects the total revenue generated by AppLovin-driven conversions, allowing you to gauge the direct financial return of your campaigns:

• Evaluate Revenue Impact: Track AppLovin CV to see if your ad spend is translating into meaningful revenue, helping justify and optimize your budget.
• Identify High-Value Audiences: Compare CV across different segments or creatives to locate audiences that contribute the most revenue, guiding targeting efforts.
• Adjust Campaign Strategies: Combine CV with conversion and spend metrics to refine bidding, creatives, or scheduling for better profitability.

Related Metrics

• AppLovin Conversions: Shows how many purchases or desired actions drive the CV, helping connect revenue to actual user behavior.
• AppLovin Ad Spend: Indicates the total campaign costs, giving context to the revenue generated so you can measure net gains.
• AppLovin ROAS: Reveals how much revenue you earn for each dollar spent, complementing CV by highlighting overall campaign efficiency.

Example Use

Prompt

What's my total AppLovin-reported conversion value over the last 7 days?

Response

Query

SELECT
  pjt.channel AS channel,
  SUM(pjt.channel_reported_conversion_value) AS total_conversion_value
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.channel = 'applovin'
  AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
GROUP BY
  pjt.channel;