Google All CV
all_conversion_value
Overview
Google All Conversion Value (Google All CV) refers to the revenue generated from conversions of all types (e.g. purchases, registrations, subscriptions, applications), as reported by Google.
Google All CV = Total Google-Reported All Conversion Value
The calculation is based on data from the Ads table.
Detailed Breakdown
The formula above is derived from the following components:
All Conversion Value (CV) = SUM(all_conversion_value)
--> Ads table
Google Ads = where channel = 'google-ads'
Insights and Actions
Google All Conversion Value provides a comprehensive view of the total revenue impact of your Google Ads campaigns across multiple types of conversions:
- Assess Total Revenue Impact: Use Google All CV to evaluate the overall financial contribution of your Google Ads campaigns, not just from purchases but from other valuable actions like registrations and subscriptions.
- Optimize for High-Value Conversions: Identify which types of conversions contribute the most to Google All CV and focus on optimizing campaigns to increase those conversions.
- Refine Targeting and Creative: Analyze the audiences and ad creatives that are driving the highest conversion values and optimize future campaigns to replicate that success.
- Measure Campaign ROI: Compare Google All CV to your total ad spend to assess the return on investment (ROI) of your campaigns across all conversion types.
Example Use
Prompt
What's my Google all conversion value over the last 7 days?
Response
Query
SELECT
p.channel AS channel,
SUM(p.all_conversion_value) AS all_conversion_value
FROM
ads_table AS p
WHERE
p.channel = 'google-ads'
AND p.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1
GROUP BY
p.channel;
Updated 9 days ago