# How to use the BigQuery Data Transfer Service for Google Ads

> To perform advanced data analysis, you need a powerful data warehouse like BigQuery. Here’s how to extract Google Ads data using the BigQuery Data Transfer Service.

Source: https://www.measurelab.co.uk/insights/blog/bigquery-data-transfer-service-google-ads/  
Author: Natalia Rizzi  
Published: 2022-02-22  
Updated: 2026-10-12

The [BigQuery Data Transfer Service](https://cloud.google.com/bigquery-transfer/docs/introduction) is a tool the GCP provides to automate data movement into BigQuery on a scheduled, managed basis without having to write any custom code. The supported data sources include YouTube, Google Play, Google Ads and many other Google and [3rd party](https://cloud.google.com/bigquery-transfer/docs/third-party-transfer) tools.

To use the [BigQuery](https://www.measurelab.co.uk/insights/blog/reasons-export-ga4-data-bigquery/) Data Transfer Service, first of all, you need to activate the BigQuery API. To do this, go to “APIs & Services” from the GCP side menu and select “Library”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-10-29-at-15-36-08.png)

Once you are in the **Library**, search for “BigQuery API” and check if the API is enabled. If it is enabled, you can go straight to the next step. If the API is not enabled, then click “Enable”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-10-29-at-15-37-55.png)

To use the API, you’ll need to create the credentials. So, from **APIs & Services**, click “Credentials”.

Once you’re on the **Credentials** page, click on the top menu bar on “Create Credentials”, and then click on “Help me choose”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-11-01-at-12-18-33.png)

In this case, we are going to select “BigQuery APIs”, fill out the form (like the one below), and click done.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-11-01-at-12-17-34.png)

After you click done, you’ll need to create the name and the ID of the service account and click done.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-11-01-at-12-23-44-1.png)

#### **Enabling the BigQuery data transfer**

The next step is to enable the BigQuery Data Transfer API, so we go back to the **GCP sidebar menu** and click on “APIs & Services”. Go to **Library** and search for “BigQuery Data Transfer APIs”.

Check if the API is enabled. If it is enabled, you can go straight to the next step. If the API is not enabled, then click “Enable”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-11-01-at-14-19-03.png)

Next, you need to go to “Data transfers” and click on “Create Transfer”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-10-29-at-15-30-21.png)

You’ll need to explore the different data sources and (in this case) select “Google Ads (formerly AdWords)”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-10-29-at-15-30-56.png)

You’ll be asked to create the name of your transfer (it needs to be in a snake case format).

Pick the schedule options depending on your preference.

Add the Google Ads customer/account ID.

You can also set a Refresh Window (the default is the last 7 days, but I suggest 30 days).

Click “Save”.

![](https://storage.ghost.io/c/2b/29/2b2922bc-51da-44ac-8a48-6f70d3ab322e/content/images/2025/07/screenshot-2021-10-29-at-15-31-37.png)

#### Prerequisites

- Have access to the Google Ads account (read-only should be enough)
- Have the [BigQuery](http://cloud.google.com/bigquery/) admin role
- Have a dataset under which you want to transfer the data