Google All Conversions

all_conversions

Overview

Google All Conversions refers the total number of conversions of all types (e.g. purchases, registrations, subscriptions, applications), as reported by Google.

📘

Google All Conversions = Total Google-Reported All Conversions

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

All Conversions = SUM(all_conversions) --> Ads table
Google Ads = where channel = 'google-ads'

Insights and Actions

Google All Conversions helps you understand the total impact of your Google Ads campaigns across various conversion types:

• Measure Campaign Effectiveness: Track the total number of conversions to assess how effectively your Google Ads campaigns are driving desired actions, whether they be purchases, sign-ups, or other conversion events.
• Optimize for Conversion Variety: Analyze which types of conversions are most common and valuable for your business, and optimize your campaigns to drive more of these conversions.
• Adjust Targeting and Messaging: Use the insights from Google All Conversions to refine audience targeting and ad messaging, ensuring that your ads are resonating with users and driving meaningful actions.
• Maximize ROI: Compare the number of conversions to your ad spend to ensure that your campaigns are delivering a strong return on investment 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;