Amazon CV
conversion_value
Overview
Amazon Conversion Value (Amazon CV) refers to the total conversion value as reported by Amazon.
Amazon CV = Total Amazon-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
Amazon Ads = where channel = 'amazon'
Insights and Actions
Amazon Conversion Value helps you understand the total revenue generated from your Amazon ad campaigns. Leveraging this metric can guide key business decisions:
- Assess Campaign Profitability: Track the total conversion value to ensure your campaigns are generating enough revenue relative to your ad spend.
- Optimize High-Value Campaigns: Identify campaigns with high conversion values and explore whatโs working in terms of creative, targeting, or offer to replicate success.
- Refine Targeting: If conversion value is lower than expected, consider adjusting your targeting to attract higher-value customers or improving the landing pages to drive more valuable sales.
- Adjust Budget Allocation: Use the conversion value data to direct more budget toward campaigns that are generating the most revenue.
Related Metrics
- Amazon ROAS: Provides a clearer picture of the revenue generated relative to ad spend, helping assess the overall profitability of your campaigns.
- Amazon Ad Spend: Helps you understand how much you're investing in ads compared to the conversion value generated, offering insight into the efficiency of your ad spend.
- Amazon Clicks: Gives context to conversion value by showing how many clicks led to those conversions.
- Amazon Conversion Rate: Measures how efficiently clicks are turning into purchases, further helping to assess campaign effectiveness.
Example Use
Prompt
What's my total Amazon-reported conversion value over the last 14 days?
Response
Query
SELECT
SUM(adt.conversion_value) AS total_conversion_value
FROM
ads_table AS adt
WHERE
adt.channel = 'amazon'
AND adt.event_date BETWEEN CURRENT_DATE() - 14 AND CURRENT_DATE() - 1;
Updated 25 days ago