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

SQL

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;