Overview

Axon Conversions (Purchases) represent the total number of purchases as reported by Axon.

📘

Axon Conversions = Number of Purchases Reported by Axon

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

• Conversions = SUM(conversions) --> Ads table
• Axon Ads = where channel = 'applovin'

Insights and Actions

Axon Conversions (Purchases) show how many sales result from your Axon ads, reflecting the direct impact of your campaigns on revenue:

• Measure Campaign Success: Regularly review conversions to see if your ad spend is translating into actual sales, helping validate campaign effectiveness.
• Identify Top-Performing Creatives: Compare conversions across different ad variations or audiences to discover which ones drive the most purchases.
• Optimize Funnel Strategy: Use conversion data to refine user journeys—from targeting to checkout—to boost overall sales and customer satisfaction.

Related Metrics

• Axon Conversion Rate: Provides context on how many visits turn into purchases, offering insight into user engagement and ad effectiveness.
• Axon Ad Spend: Shows the cost side of your campaigns, helping evaluate the return on your AppLovin conversions.
• Axon ROAS: Complements conversion data by indicating revenue generated per dollar spent, highlighting the profitability of your campaigns.

Example Use

Prompt

How many Axon (AppLovin) reported conversions were there in the past 7 days?

Response

Query

SELECT
  SUM(pjt.channel_reported_conversions) AS total_conversions
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.channel = 'applovin'
  AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;