BigQuery Audience Export for Google Ads Remarketing

Why BigQuery-Based Audiences

Standard Google Ads remarketing audiences are built from pixel data (who visited certain pages). BigQuery-based audiences are built from your complete data set — enabling segments that website behavior alone cannot define: customers who purchased more than £200 in the last 90 days, users who viewed a specific product category 3+ times but never purchased, or customers who purchased in 2024 but not in 2025.

Method 1: BigQuery Export to Google Ads Customer Match

The most common approach: build an audience list in BigQuery, export email addresses, and upload to Google Ads Customer Match:

1. BigQuery query: select user_pseudo_id and associated email from your CRM data joined to GA4 purchase data
2. Export query result to Google Sheets or CSV
3. Google Ads → Tools → Audience Manager → Customer Match → upload email list
4. Google hashes the emails and matches to Google accounts

Method 2: Google Analytics 4 Audience Builder with BigQuery Input

GA4 allows importing audience definitions from BigQuery via the GA4 → Admin → BigQuery Links → Export feature. This is more complex to set up but enables native GA4 audiences based on BigQuery-computed user segments.

Example BigQuery Query for High-Value Customer Audience

-- Users who purchased 2+ times with total revenue > 200:
SELECT
  user_pseudo_id,
  COUNT(DISTINCT (SELECT value.string_value FROM UNNEST(event_params)
    WHERE key = 'transaction_id')) as order_count,
  SUM((SELECT value.double_value FROM UNNEST(event_params)
    WHERE key = 'value')) as total_spend
FROM `project.analytics_PROPERTY.events_*`
WHERE _TABLE_SUFFIX >= '20250101'
  AND event_name = 'purchase'
GROUP BY user_pseudo_id
HAVING order_count >= 2 AND total_spend >= 200

Match user_pseudo_id to email via your CRM (if user_id is also in GA4, join on that). Export the email list.

Performance Expectations

BigQuery-defined Customer Match audiences typically show higher ROAS than standard website visitor remarketing because they target users with demonstrated high intent or high value — not just anyone who visited the website. High-LTV customer reactivation campaigns and high-spend lookalike audiences built from Customer Match seeds consistently outperform generic remarketing.

Summary

BigQuery audience export enables sophisticated advertising targeting beyond page-visit-based remarketing. The most practical implementation: BigQuery query to identify valuable user segments (high-spend customers, high-frequency buyers, category loyalists), match user_pseudo_id to emails via CRM, export to Google Ads Customer Match. This approach leverages the full depth of your analytics and CRM data for advertising targeting.

See our BigQuery Setup service for audience export development.

Need BigQuery audiences for Google Ads? Contact Adslytics.