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 Conversion Value / 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

SQL

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;