MNTN CV

conversion_value

Overview

MNTN Conversion Value (MNTN CV) refers to the total conversion value as reported by MNTN.

📘

MNTN CV = Total MNTN-Reported Conversion Value

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Conversion Value (CV) = SUM(conversion_value) --> Ads table
MNTN Ads = where channel = 'mountain'

Insights and Actions

MNTN Conversion Value (CV) provides the total revenue generated from MNTN-reported conversions, giving insight into the financial impact of your ad campaigns:

• Assess Campaign Revenue Impact: A high conversion value indicates strong revenue generation from your ads. If conversion value is low, consider optimizing your ad targeting to reach a more profitable audience.
• Identify High-Performing Campaigns: Compare conversion values across campaigns to focus on those delivering the most revenue, helping to inform budget allocation.
• Optimize Ad Content: If conversion value is lower than expected, try experimenting with different ad creatives or offers that might resonate better with your audience.

Related Metrics

• MNTN ROAS: Evaluates revenue relative to ad spend, helping assess the efficiency and profitability of your campaigns.
• MNTN Conversions: Tracks the total number of purchases, providing context to understand if high conversion value results from many conversions or high individual purchase amounts.
• MNTN Clicks: Shows engagement levels, offering insight into whether high click engagement aligns with high conversion value.

Example Use

Prompt

What's my total MNTN-reported conversion value over the last 7 days?

Response

Query

SQL

SELECT
  pjt.channel AS channel,
  SUM(pjt.channel_reported_conversion_value) AS total_conversion_value
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.model = 'Triple Attribution'
  AND pjt.channel = 'mountain'
  AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
GROUP BY
  pjt.channel;