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
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;
Updated 5 months ago