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
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;
Updated 25 days ago