Google ROAS

roas

Overview

Google Return on Ad Spend (Google ROAS) refers to the Google-reported conversion value divided by the Google-reported ad spend.

📘

Google ROAS = Google Ads Conversion Value / Google 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
Facebook Ads = where channel = 'google-ads'

Insights and Actions

Google Return on Ad Spend (Google ROAS) is critical for measuring the profitability and efficiency of your Google advertising campaigns. Efficiently leveraging Google ROAS data can guide strategic business decisions:

• Refine Google Ads Strategy: Assess which types of Google Ads (search, display, video) and campaigns yield the highest ROAS to focus your efforts and budget more effectively.
• Improve Ad Content and Targeting: Analyze high-ROAS ads to identify successful content, keywords, and targeting strategies that can be applied to other campaigns.
• Allocate Budget Based on Performance: Shift your advertising budget towards campaigns, ad groups, or keywords with higher ROAS to maximize overall profitability.
• Test and Optimize Landing Pages: Experiment with different landing pages linked from your Google Ads to see which conversions contribute most significantly to ROAS, and optimize accordingly.

Example Use

Prompt

What's my channel-reported Google ROAS the last 30 days?

Response

Query

SQL

SELECT
  COALESCE(
    SUM(a.conversion_value) / NULLIF(SUM(a.spend), 0),
    0
  ) AS roas
FROM
  ads_table AS a
WHERE
  a.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
  AND a.channel = 'google-ads';