Google CV
conversion_value
Overview
Google Conversion Value (Google CV) refers to the total conversion value as reported by Google.
Google CV = Total Google-Reported Conversion Value
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
Google Ads = where channel = 'google-ads'
Insights and Actions
Google CV is a key metric for understanding the revenue impact of your Google Ads and guiding your e-commerce strategy:
- Assess ROI: Compare Google CV against Google Ad Spend to evaluate the return on investment (ROI) for your Google Ads campaigns and identify which efforts are most profitable.
- Reallocate Ad Budget: Use Google CV insights to direct more budget toward campaigns, keywords, and audiences that generate higher revenue, maximizing the effectiveness of your ad spend.
- Optimize Targeting and Bidding: Analyze which audiences, ad formats, and bidding strategies yield the highest Google CV, and refine your campaigns to capitalize on these findings.
- Improve Product and Landing Page Performance: Identify which products and landing pages contribute the most to Google CV and optimize them to further increase revenue.
Example Use
Prompt
What's my total Google-reported conversion value over the last 14 days?
Response
Query
SELECT
SUM(adt.conversion_value) AS google_conversion_value
FROM
ads_table AS adt
WHERE
adt.channel = 'google-ads'
AND adt.event_date BETWEEN CURRENT_DATE() - 14 AND CURRENT_DATE() - 1;
Updated 3 days ago