Google Conversion Rate

Overview

Google Conversion Rate refers to the percentage of Google-attributed purchases on your website relative to sessions, as tracked by Triple Whale Pixel.

📘

Google Conversion Rate = Google Orders / Google Sessions

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

Insights and Actions

Google Conversion Rate is a vital metric for understanding how effectively your Google-sourced traffic converts into purchases. Efficiently leveraging Google Conversion Rate data can guide strategic business decisions:

• Optimize Google Ads Campaigns: Assess which campaigns and keywords lead to the highest conversion rates and reallocate budget to maximize ROI.
• Refine Landing Pages: Use conversion rate insights to tailor landing pages for Google traffic, ensuring they're optimized for conversion based on user intent.
• Adjust Targeting Strategies: Analyze the demographic and behavioral patterns of converting visitors to fine-tune your targeting on Google Ads.
• Improve User Experience (UX): Identify potential UX barriers for Google-referred sessions that could be hindering conversions, and implement changes to streamline the purchase process.

Example Use

Prompt

What's my Google conversion rate for the last 30 days?

Response

Query

SQL

SELECT
  bpm.channel,
  COALESCE(
    SUM(bpm.orders_quantity) / NULLIF(SUM(bpm.sessions), 0),
    0
  ) AS conversion_rate
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
  bpm.channel;