Overview

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

📘

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

Insights and Actions

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

• Evaluate Revenue Impact: Track Axon 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

• Axon Conversions: Shows how many purchases or desired actions drive the CV, helping connect revenue to actual user behavior.
• Axon Ad Spend: Indicates the total campaign costs, giving context to the revenue generated so you can measure net gains.
• Axon 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 Axon (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;