---
updatedAt: 2025-01-29T10:30:29.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# 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](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

All Conversion Value (CV) = `SUM(all_conversion_value)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) 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

![](https://files.readme.io/0dd8be7f5b9f7b57b21f92faecbbd8e97a276f5f2632c133ab419da26f3b8b8a-image.png)

### 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;
```