---
updatedAt: 2025-09-29T11:35:05.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Axon by Applovin CPM

cpm

# 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](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

* Ad Spend = `SUM(spend)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table
* Clicks = `SUM(impressions)`  --> [Ads](https://triplewhale.readme.io/docs/ads-table) 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

<Image border={false} src="https://files.readme.io/6d325ef8c5093e5f6abd5bc118be7ebd206d87612719b02a4c5fdd964fcbb184-image.png" />

### Query

```sql
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;

```