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

SQL

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;