Overview

Axon Cost Per Mille (Axon CPM) measures the Axon-reported cost per 1,000 Axon ad impressions.

📘

Axon CPM = (Axon Ad Spend / Axon Impressions) x 1000

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
• Clicks = SUM(impressions) --> Ads table
• Axon Ads = where channel = 'applovin'

Insights and Actions

Axon Cost Per Mille (CPM) indicates how much you pay for every 1,000 ad impressions on the Axon network, offering a key benchmark for evaluating the cost-effectiveness of your advertising reach:

• Assess Ad Reach Efficiency: Monitor CPM to determine if your campaigns are cost-effective in reaching a broad audience. High CPM may signal a need to adjust targeting or creatives.
• Compare Placement Strategies: Track CPM across different ad placements or inventory sources to find where your spend achieves the most impressions at a lower cost.
• Refine Budget Allocation: Combine CPM with click or conversion metrics to ensure that higher costs for impressions are justifiable by strong engagement or sales.

Related Metrics

• Axon Impressions: Shows how often your ads are displayed, providing the foundation for CPM calculations.
• Axon Ad Spend: Represents total advertising costs, giving context to CPM by revealing how much you invest for audience reach.
• Axon Conversions: Reveals the outcomes of those impressions, clarifying whether high CPM leads to valuable user actions.

Example Use

Prompt

What's my Axon (AppLovin) CPM for yesterday?

Response

Query

SELECT
  adt.channel AS channel,
  COALESCE(
    SUM(adt.spend) / NULLIF(SUM(adt.impressions), 0),
    0
  ) * 1000 AS cpm
FROM
  ads_table AS adt
WHERE
  adt.channel = 'applovin'
  AND adt.event_date = CURRENT_DATE() - 1
GROUP BY
  adt.channel
ORDER BY
  cpm DESC;