Google Return on Ad Spend (Google ROAS)

Overview

Google Return on Ad Spend (Google ROAS) evaluates the efficiency and profitability of your Google advertising campaigns.

πŸ“˜

Google ROAS = Google Ads Revenue / Google Ad Spend

The calculation is based on data from the Pixel Joined table.

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 Google ROAS the last 30 days?

Response

Query

SELECT
  channel,
  COALESCE(
    SUM(bpm.order_revenue) / NULLIF(SUM(bpm.spend), 0),
    0
  ) AS roas
FROM
  pixel_joined_table AS bpm
WHERE
  bpm.model = 'Triple Attribution'
  AND bpm.channel = 'google-ads'
  AND bpm.event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
GROUP BY
  channel;