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

# Axon by Applovin Ad Spend

spend

# 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](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
* 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

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

### Query

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