Amazon ROAS
roas
Overview
Amazon Return on Ad Spend (Amazon ROAS) refers to the Amazon-reported conversion value divided by the Amazon-reported ad spend.
Amazon ROAS = Amazon Ads Revenue / Amazon Ad Spend
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
Ad Spend = SUM(spend)
--> Ads table
Amazon Ads = where channel = 'amazon'
Insights and Actions
Amazon ROAS is key to understanding the profitability of your Amazon advertising campaigns:
- Assess Campaign Effectiveness: Monitor ROAS to evaluate if your Amazon ad campaigns are driving sufficient revenue.
- Optimize Ad Spend: Shift more budget to high-ROAS campaigns to maximize returns from your Amazon ads.
- Refine Targeting: Analyze ROAS across different audiences and product categories to refine ad targeting for better results.
- Test Ad Strategies: Experiment with ad placements, bidding strategies, and creative to improve ROAS over time.
Example Use
Prompt
What's my channel-reported Amazon ROAS the last 30 days?
Response
Query
WITH
ads AS (
SELECT
COALESCE(
SUM(adt.conversion_value) / NULLIF(SUM(adt.spend), 0),
0
) AS roas
FROM
ads_table AS adt
WHERE
adt.channel = 'amazon'
AND adt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE() - 1
)
SELECT
roas
FROM
ads;
Updated 27 days ago