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

SQL

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;