MNTN Conversions (Purchases)

conversions

Overview

MNTN Conversions (Purchases) represent the total number of purchases as reported by MNTN.

📘

MNTN Conversions = Number of Purchases Reported by MNTN

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Conversions = SUM(conversions) --> Ads table
MNTN Ads = where channel = 'mountain'

Insights and Actions

MNTN Conversions help you track the total number of purchases attributed to your MNTN ads, offering insights into campaign effectiveness:

• Evaluate Campaign Success: High conversions indicate your ads are effectively driving purchases. If conversions are low, consider adjusting targeting or creative elements to better engage potential buyers.
• Optimize Budget Allocation: Compare conversions across campaigns to allocate budget towards those that yield the most purchases, maximizing return on investment.
• Adjust Ad Strategy: If conversions are underperforming, experiment with different ad formats or messaging to improve results.

Related Metrics

• MNTN ROAS: Measures the revenue generated from conversions relative to ad spend, providing insight into the profitability of your campaigns.
• MNTN Clicks: Helps gauge if there’s strong engagement leading up to conversions, which can indicate ad appeal.
• MNTN Cost per Acquisition (CPA): Evaluates the cost-effectiveness of your conversions, helping identify if the spend aligns with conversion goals.

Example Use

Prompt

How many MNTN-reported conversions were there in the past 7 days?

Response

Query

SQL

SELECT
  p.channel AS channel,
  SUM(p.channel_reported_conversions) AS total_conversions
FROM
  pixel_joined_tvf () AS p
WHERE
  p.event_date BETWEEN CURRENT_DATE() - INTERVAL 7 DAY AND CURRENT_DATE()  - 1
  AND p.channel = 'mountain'
  AND p.model = 'Triple Attribution'
GROUP BY
  p.channel;