Overview

Axon Ad Spend refers to the total amount of money spent on advertising through Axon Ads.

📘

Axon Ad Spend = Ad Spend on Axon

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

• Ad Spend = SUM(spend) --> Ads table
• Axon Ads = where channel = 'applovin'

Insights and Actions

Axon Ad Spend measures the total cost of your campaigns on Axon, offering visibility into your investment and guiding budget allocation decisions:

• Assess Campaign Efficiency: Regularly track ad spend to ensure campaigns remain within budget and deliver desired outcomes.
• Compare Channel Performance: Align Axon ad spend with other channels to determine where your budget yields the best ROI.
• Refine Budget Strategies: If ad spend is high but returns are low, consider adjusting targeting, creative, or bidding strategies to optimize performance.

Related Metrics

• Axon ROAS: Complements ad spend by revealing how much revenue you earn per dollar spent, helping evaluate campaign profitability.
• Axon Conversions: Shows how many conversions your ads generate, offering a fuller picture of ad effectiveness.
• Axon CTR: Reflects ad engagement, indicating if the level of spending is driving sufficient user interest.

Example Use

Prompt

What's my total Axon (Applovin) Ad Spend over the past 30 days?

Response

Query

SELECT
  COALESCE(SUM(adt.spend), 0) AS total_ad_spend
FROM
  ads_table AS adt
WHERE
  adt.event_date BETWEEN CURRENT_DATE() - INTERVAL 30 DAY AND CURRENT_DATE()  - INTERVAL 1 DAY
  AND adt.channel = 'applovin';