Skip to content

How to Connect Google Analytics and Advertising Data to BigQuery (2027)

Dean Mitchell
Dean Mitchell

You can connect Google Analytics 4 to BigQuery for free with the native export, bring in Google Ads data with the BigQuery Data Transfer Service, and add Facebook Ads, TikTok Ads, LinkedIn Ads and other platforms with a third-party connector. Once everything lands in BigQuery, you can join analytics and ad spend in SQL and feed clean tables to Looker Studio.

This guide walks through each step: what to prepare, how to link GA4, how to load Google Ads data, how to add non-Google ad platforms, what it costs and how to troubleshoot common problems.

Disclosure: some links on this page are affiliate links. If you buy through them, we may earn a commission at no extra cost to you. Google's menus and limits change, so confirm details in Google's current documentation.

In This Article

Quick Answer

  1. Create a Google Cloud project and enable BigQuery.
  2. In GA4, go to Admin, then Product links, then BigQuery links, and link your project.
  3. Choose daily export and, if needed, streaming export.
  4. In BigQuery, use Data transfers to load Google Ads data.
  5. Use a connector such as Windsor.ai for Facebook, TikTok, LinkedIn and other ad platforms.
  6. Join the tables in SQL and connect BigQuery to Looker Studio.

Why Send Marketing Data to BigQuery

  • Raw event data from GA4 without sampling in reports
  • No API quota problems in dashboards that pull from the Google Analytics API
  • Cross-channel analysis: ad spend, clicks and conversions in one place
  • Longer history than the GA4 interface retains
  • Faster dashboards when Looker Studio reads from BigQuery tables
  • Custom attribution and modeling in SQL

What to Prepare First

  1. A Google Cloud project with billing set up. BigQuery has a free tier and a sandbox, but linking exports usually needs a project you control.
  2. Permissions: Editor access on the GA4 property and appropriate owner or admin access on the Cloud project.
  3. A region choice: pick the data location for your datasets and keep it consistent, because you cannot easily move data later.
  4. Ad account access: admin or standard access to the Google Ads account, plus access to other ad platforms.
  5. A naming plan: datasets such as ga4_raw, ads_raw and marketing_reporting.

Step 1: Connect GA4 to BigQuery

  1. Open your GA4 property and go to Admin.
  2. Under Product links, choose BigQuery links.
  3. Click Link and choose your Google Cloud project.
  4. Select the data location.
  5. Choose which data streams to export, and whether to include advertising identifiers if needed.
  6. Pick the export frequency: Daily (a full export once a day), and optionally Streaming (near real-time, with extra cost).
  7. Review and submit.

The first export usually appears within about a day. Exports are not backfilled, so the data starts from the day you link, which is why it is worth doing early.

What the GA4 Export Looks Like

  • A dataset named analytics_PROPERTYID
  • Daily tables named events_YYYYMMDD
  • Streaming or intraday tables for the current day when enabled
  • One row per event, with nested fields for event parameters, user properties and items

Standard properties have a daily export limit on the number of events, and larger limits apply to paid GA360 properties, so check Google's current limits if you have very high traffic.

Step 2: Load Google Ads Data

The easiest way to bring Google Ads data into BigQuery is the BigQuery Data Transfer Service.

  1. In the Google Cloud console, open BigQuery, then Data transfers.
  2. Click Create transfer and choose Google Ads as the source.
  3. Name the transfer and set a schedule, usually daily.
  4. Choose or create a destination dataset.
  5. Enter your Google Ads customer ID (or manager account ID).
  6. Authorize access and save.

The transfer loads reporting tables for campaigns, ad groups, ads, keywords and more. Check the supported reports in Google's documentation, because the available tables differ from the Google Ads interface. You can also backfill past dates when you set up the transfer.

Other Google sources, such as Search Ads 360, Campaign Manager 360, Display and Video 360 and YouTube, also have transfer options in the same screen.

Step 3: Add Facebook, TikTok, LinkedIn and Other Ad Platforms

Non-Google platforms do not have native BigQuery links, so most teams use a connector or ETL tool:

  • Windsor.ai: sends data from many marketing sources to BigQuery, with a free plan reported.
  • Supermetrics, Coupler.io, Funnel and others: also support BigQuery destinations on certain plans.
  • Custom pipelines: use each platform's API with your own scripts, which takes more engineering and maintenance.

When you pick a connector, check that BigQuery is included in your plan, how often data refreshes and how far back it can backfill. Our guide to the best marketing data connectors compares the options, and our Windsor.ai pricing guide explains plan limits.

Try Windsor.ai

Step 4: Join Analytics and Ad Data

After the data is in BigQuery, create a reporting table that combines it. The typical approach:

  1. Flatten GA4 events into sessions or conversions by date, source, medium and campaign.
  2. Aggregate ad data by date and campaign across platforms.
  3. Standardize names: align UTM campaign values with ad campaign names.
  4. Join on date plus campaign, or on a campaign ID if you tag consistently.
  5. Calculate cost per acquisition, return on ad spend and other metrics.
  6. Save the result as a scheduled query or a view.

Consistent UTM tagging is the most important factor in whether the join works.

Step 5: Connect BigQuery to Looker Studio

In Looker Studio, choose Add data, then the BigQuery connector, and select your reporting table or view. Pointing dashboards to a small, pre-aggregated table keeps them fast and cheap to query.

BigQuery Costs

Cost Type What It Is How to Control It
Storage Data stored in tables Set table expiration for old raw data if you do not need it
Queries Data scanned by queries Select only needed columns, filter by date, use partitioned tables
Streaming export Near real-time GA4 data Use daily export unless real-time matters
Connector fees Third-party tools Check plan limits and destinations

BigQuery includes a free tier for storage and query processing each month, and many small sites stay within it. Set budget alerts and query limits in Google Cloud to avoid surprises.

Troubleshooting

  • No data appearing: wait up to a day after linking, and confirm the link shows as active in GA4.
  • Permission errors: check roles on both the GA4 property and the Cloud project.
  • Google Ads transfer fails: confirm the customer ID and that you authorized with an account that has access.
  • Numbers differ from the GA4 interface: expected differences include sampling, thresholds, attribution and processing time, so reconcile on totals rather than expecting identical numbers.
  • Joins return nothing: campaign names and UTMs do not match, so standardize them.
  • High costs: avoid SELECT * on raw event tables and partition by date.

Best Practices

  1. Link GA4 to BigQuery as early as possible because there is no backfill.
  2. Keep raw data separate from reporting tables.
  3. Use consistent UTM tagging across all channels.
  4. Schedule queries to build daily reporting tables.
  5. Document your definitions for conversions and revenue.
  6. Respect privacy rules: limit access to user-level data and follow consent requirements.
  7. Review costs monthly.

FAQs

Is the GA4 to BigQuery export free?

The export itself is free to set up, but you pay normal BigQuery storage and query costs beyond the free tier, and streaming export has extra cost.

Can I backfill old GA4 data into BigQuery?

No. The export starts from when you link, so connect early.

How do I get Google Ads data into BigQuery?

Use the BigQuery Data Transfer Service and choose Google Ads as the source.

How do I send Facebook Ads data to BigQuery?

Use a connector such as Windsor.ai, Supermetrics or Coupler.io, or build a custom pipeline with the Marketing API.

Why do my BigQuery numbers differ from GA4 reports?

Differences come from sampling, thresholds, attribution methods and processing delays.

Do I need to know SQL?

Basic SQL helps a lot. Some connectors provide ready tables to reduce the amount of SQL.

Should I use daily or streaming export?

Daily is fine for most reporting. Use streaming only if you need near real-time data.

Can I connect BigQuery to Looker Studio?

Yes, using the native BigQuery connector.

Final Verdict

Link GA4 to BigQuery now, load Google Ads with the Data Transfer Service, and use a connector for other ad platforms. Standardize your UTMs, build a clean reporting table and point Looker Studio at it for fast, accurate dashboards.

Share this post