---
updatedAt: 2025-01-29T10:32:04.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# MNTN Ad Spend

spend

# Overview

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

> 📘 MNTN Ad Spend = Ad Spend on MNTN

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\
MNTN Ads = `where channel = 'mountain'`

# Insights and Actions

MNTN Ad Spend shows how much you've invested in MNTN Ads, helping you assess budget allocation and ROI on this channel:

* **Track Budget Allocation**: Regularly monitor your MNTN ad spend to ensure it aligns with your broader marketing strategy and goals.
* **Evaluate Cost-Effectiveness**: Pair ad spend with metrics like ROAS and conversion rate to understand the effectiveness of your budget allocation.
* **Adjust Ad Budgets**: If MNTN spend is high but conversion metrics are underperforming, consider reallocating budgets to improve overall efficiency.

### Related Metrics

* **MNTN ROAS**: Helps determine if the revenue generated by MNTN Ads justifies the spend, offering insights into the profitability of your investment.
* **MNTN Conversions**: Tracks the number of actions or purchases resulting from MNTN Ads, helping you gauge the efficiency of your ad spend in driving outcomes.
* **MNTN Impressions**: Measures the reach of your MNTN ads, giving context to your spend by showing if higher investment correlates with more visibility.

# Example Use

### Prompt

> What's my total MNTN Ad Spend over the past 30 days?

### Response

![](https://files.readme.io/68fe1b48851c6e4a24faa086e6908eba45331932a1b444beece5b15573011bd8-image.png)

### Query

```sql
SELECT
  adt.channel AS channel,
  COALESCE(SUM(adt.spend), 0) AS total_spend
FROM
  ads_table AS adt
WHERE
  adt.channel = 'mountain'
  AND adt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
GROUP BY
  adt.channel;
```