Google BigQuery to Google Ads: 2 Easy Methods

on Activate, API, Data Integration, Data Warehouse, Google Ads, Google BigQuery, Hevo Activate • March 8th, 2022 • Write for Hevo

BigQuery Google Ads

Google Ads can play a key role in growing businesses. Every day billions of users rely on Google for their daily searches. If a well-timed ad appears on their Google search when they are looking for something similar to your business, they can easily be turned into valuable customers.

Now comes the crucial part, after advertising, companies then need to gain valuable insights from Google Ads data. And for that, you can easily set up the BigQuery Google Ads connection and seamlessly transfer data from Google BigQuery to Google Ads.

In this article, you will learn how to effectively set up the BigQuery Google Ads connection using 2 different methods. 

Table of Contents

What is Google Ads?

bigquery google ads - google ads logo
Image Source

Through Google Ads, businesses can grow online sales and can increase their store visits with ads that help people find their company on the map. Moreover, businesses can also increase customer calls with ads that feature their phone number and a click-to-call button. The working of Google Ads is pretty straightforward.

First, you will identify where you have to advertise whether you want to stay local or go global. Then you will create a message for your ad to attract customers. You can even add images to make it more compelling.

After that, you will specify the budget cap which means that you can set a budget that works best for our business. The best part about using Google Ads is that you only have to pay for results, like when customers visit your website or click your ad to call your company.

One important thing to note over here is that Google helps improve ads over time. Google ads also provide businesses with reports, insights, and ongoing tips so that they can track their progress and make their ads even more successful by tweaking them according to their requirements.

What is Google BigQuery?

bigquery google ads - google bigquery logo
Image Source

 BigQuery is a cost-effective, serverless, and highly scalable multi-cloud data warehouse with robust security, governance, and reliability controls. Using BigQuery can enable businesses to power decisions from data across clouds with a multi-cloud data analytics solution. BigQuery lets businesses run analytics at scale with 26%-34% lower Total Cost of Ownership (TCO) than other cloud data warehouses. Let’s have a look at some of the benefits that BigQuery provides.

  • BigQuery makes scalability seamless with no operational overhead.
  • Through BigQuery businesses can gain insights by querying streaming data in real-time.
  •  They can also predict business outcomes based on the obtained data with BigQuery’s built-in machine learning models.
  •  BigQuery lets businesses securely access data and share analytical insights with ease in their organizations within no time. 
  • Moreover, businesses can also create reports and dashboards through popular business intelligence tools.
  •  The key features of BigQuery include but are not limited to ML and predictive modeling with BigQuery ML, Multicloud data analysis with BigQuery Omni, Interactive data analysis with BigQuery BI Engine, Geospatial analysis with BigQuery GIS, and bringing data into BigQuery from multiple sources for seamless analysis.

Ways to Set up BigQuery Google Ads Integration

Method 1: Manual BigQuery Google Ads Integration 

This method involves setting up BigQuery to Google Ads Integration manually using Google BigQuery API.

Method 2: Automate BigQuery Google Ads Integration using Hevo Activate

Hevo Activate provides a hassle-free solution and helps you directly transfer data from Google BigQuery, Snowflake, Amazon Redshift, Facebook, etc., to Salesforce, Hubspot, Zendesk, etc without any intervention in an effortless manner. Hevo Activate is fully managed and completely automates the process of not only loading data from your desired source but also enriching the data and transforming it into an analysis-ready form without having to write a single line of code. Hevo’s pre-built integration with Facebook and 100+ data sources(including 40+ free data sources) will take full charge of the data transfer process, allowing you to focus on key business activities.

Get Started with Hevo for Free

How to connect Google BigQuery to Google Ads?

Businesses need to establish a BigQuery Google Ads connection so that they can analyze raw data from different advertising campaigns and gain insights from them. For the aforementioned task, you can follow the 2 methods given below:

Method 1: Manual BigQuery Google Ads Integration 

The BigQuery Data Transfer Service automates data movement into BigQuery from supported sources on a scheduled, managed basis.

Currently, the BigQuery Data Transfer Service supports loading data from different data sources including Google Ads, Google Ad Manager, Campaign Manager, Search Ads 360 (beta), Amazon Redshift, Teradata, Data warehouses, YouTube Channel reports, YouTube Content Owner reports, Google Play, Cloud Storage, External cloud storage providers, Google Merchant Center (beta), Amazon S3, Google Software as a Service (SaaS) apps along with several third-party transfers in the Google Cloud Marketplace. The analytics team of a company can lay the foundation for a BigQuery data warehouse without writing a single line of code.

For Google Ads, the BigQuery Data Transfer Service allows businesses to automatically manage and schedule recurring load jobs for Google Ads reporting data. Now let’s have a look at the steps that are involved to connect Google BigQuery to Google Ads.

Manual BigQuery Google Ads Integration Step 1:  Create a project in GCP

  • Step 1: First, you have to create a project in Google Cloud Platform. From the left pane,l click on the IAM & Admin option and then go to the Manage Resources option.
bigquery google ads - IAM
  • Step 2: Now you will be taken to a new screen. Here, click on the CREATE PROJECT button.
bigquery google ads - manage resources
  • Step 3: After that, you can provide the project details that include the Project Name and Location. Finally, you can click on the CREATE button.
bigquery google ads - project name

Manual BigQuery Google Ads Integration Step 2:  Check BigQuery API is enabled

  • Step 1: After the first BigQuery to Google Ads connection step, now you have to ensure that the BigQuery API is enabled for your project. For that from the left pane, click on the APIs & Services option and then click on the Enabled APIs & Services option.
bigquery google ads - enabled API
  • Step 2: Here you can see the list of APIs that are enabled for your project by default. Next, click on the BigQuery API option.
bigquery google ads - bigQuery API option
  • It can be seen that the status of BigQuery API is enabled.
bigquery google ads - bigQuery API create credential

Manual BigQuery Google Ads Integration Step 3:  Create Credentials

  • Step 1: Now the next BigQuery Google Ads connection step is to create credentials. From the top right, you click on the CREATE CREDENTIALS button which will lead you to the following screen. Here, specify the API that you will use which in your case is the BigQuery API
  • Step 2: After that, select the type of data that you will access. Here, you can select the Application data option. Note that different credentials are required to authorize access depending on the type of data that you request.
bigquery google ads - credential type
  • Step 3: Since you will not be using this API with Compute Engine, Kubernetes Engine, App Engine, or Cloud Functions that’s why you can select the “No, I’m not using them” option. Note that they use Application default credentials and don’t require that you create credentials.
bigquery google ads - other functions
  • Step 4: Next, provide the Service account details that include the Service account name, ID, and description.
bigquery google ads - service account details
  • Step 5: Now you can grant this service account access to your project so that it has permission to complete specific actions on the resources in your project. Note that this is optional.
bigquery google ads - service account permission
  • Step 6: Next, you can grant users access to this service account that needs to perform actions as this service account. Finally, click on the DONE button.
bigquery google ads - service account permission users

Manual BigQuery Google Ads Integration Step 4:  Enable BigQuery Data Transfer API

  • Step 1: Now you have to enable BigQuery Data Transfer API. For that from the left pane, click on the Data Transfers option under Analysis
  • Step 2: Next, click on the ENABLE button. You can transfer data from partner SAAS applications to Google BigQuery on a scheduled, managed basis through BigQuery Data Transfer API.
bigquery google ads - bigQuery API enable option

Manual BigQuery Google Ads Integration Step 5:  Create a dataset

  • Step 1: Now you can create a dataset. For that, click on the Create dataset button in the Explorer window that shows your project.
bigquery google ads - create data set
  • Step 2: Next, you provide the Dataset ID, Data location and table expiration, and encryption-related configurations. 
  • Step 3: After that, click on the CREATE DATASET button.
bigquery google ads - create dataset details

Manual BigQuery Google Ads Integration Step 6:  Create Data Transfer Service

  • Step 1: Now it’s time to create a Data Transfer service from Google Ads to BigQuery. From the left pane, click on the Data Transfers option under Analysis.
  • Step 2: This will take you to the following screen. Here, click on the CREATE A TRANSFER button.
bigquery google ads - create transfer option
  • Step 3: Now, choose a data source which will be Google Ads. Then, provide the Transfer config name and Schedule options
  • Step 4: You can either start now or set a specific time. For Repeats, choose an option for how often to run the transfer. You can set it to daily, weekly, monthly, Custom, and On-demand.
bigquery google ads - create transfer details
  • Step 5: Provide the Dataset name that you just created above. For Data source details, provide the Customer ID. Note that this corresponds to the Google Ads Customer ID or manager account. Also, provide the Refresh Window. Note that data will be loaded for the last 7 days by default and is configurable for up to 30 days.
  • Step 6: Here, you have two notification options that include Email notifications and Pub/Sub notifications. If an email notification is enabled, the transfer administrator gets an email notification when a transfer run fails. Similarly, if Pub/Sub notification is enabled, a message will be published to the selected Pub/Sub topic on transfer run completions. 
  • Step 7: Finally, click on the Save button. Now, your data warehouse will begin to load data with the Refresh window you have just set.
bigquery google ads - destination settings

Following all these 6 detailed steps you can manually set up the BigQuery to Google Ads connection. Now, you are all set to use BigQuery features on the data that you receive from Google Ads. This method is effective if you rarely transfer data from BigQuery to Google Ads. For cases when you need real-time data transfer frequently, you can automate your workflow by following the second method.

Method 2: Automate BigQuery Google Ads Integration using Hevo Activate

bigquery google ads - hevo logo
Image Source

Hevo Activate helps you directly transfer data from Google BigQuery, Snowflake, Amazon Redshift, Facebook, etc., and 100+ other sources (including 40+ free sources) to CRMs such as Salesforce, HubSpot, various SaaS applications, Data Warehouses, and a lot more, in a completely hassle-free & automated manner. Hevo Activate is fully managed and completely automates the process of not only loading data from your desired source but also enriching the data and transforming it into an analysis-ready form without having to write a single line of code. Its fault-tolerant architecture ensures that the data is handled in a secure, consistent manner with zero data loss.

Hevo Activate takes care of all your data preprocessing needs and lets you focus on key business activities and draw a much powerful insight on how to generate more leads, retain customers, and take your business to new heights of profitability. It provides a consistent & reliable solution to manage data in real-time and always have analysis-ready data in your desired destination. 

Check out what makes Hevo Activate amazing:

  • Real-time Data Transfer: Hevo Activate, with its strong Integration with 100+ sources, allows you to transfer data quickly & efficiently. This ensures efficient utilization of bandwidth on both ends.
  • Data Transformation: It provides a simple interface to perfect, modify, and enrich the data you want to transfer. 
  • Secure: Hevo Activate has a fault-tolerant architecture that ensures that the data is handled in a secure, consistent manner with zero data loss.
  • Tremendous Connector Availability: Hevo Activate houses a large variety of connectors and lets you bring in data from numerous Marketing & SaaS applications, databases, etc. such as Airflow, HubSpot, Marketo, MongoDB, Oracle, Salesforce, Redshift, etc. in an integrated and analysis-ready form.
  • Simplicity: Using Hevo Activate is easy and intuitive, ensuring that your data is exported in just a few clicks. 
  • Completely Managed Platform: Hevo Activate is fully managed. You need not invest time and effort to maintain or monitor the infrastructure involved in executing codes.
  • Live Support: The Hevo Activate team is available round the clock to extend exceptional support to its customers through chat, email, and support calls
Sign up here for a 14-Day Free Trial!

With Hevo Activate, you can configure Google BigQuery as a Warehouse to load data to your desired Target application by following the simple steps given below: 

  • Step 1: To set Google BigQuery as your source you need to extract details such as your Project ID, Dataset ID, and GCS bucket. First, go to the Google API Console, and in the top left corner, besides the hamburger menu icon, click the drop-down to view all the projects. Copy the ID of the required project.
Image Source
  • Step 2: Go to your BigQuery instance & select the Project ID. Copy the Dataset ID and Data Location. The dataset ID is displayed as project-name:dataset-ID. Copy only the dataset ID. For example, in the image shown below, the dataset ID is test-dataset.
  • Step 3: Go to Storage in Google Cloud Platform. In the Storage browser, check for the bucket Name and Location.
  • Step 4: Read Enable billing for a project to set up the billing details of your project.
  • Step 5: To configure BigQuery Data Warehouse for Activate, Click ACTIVATE in the Asset Palette, and in the ACTIVATIONS tab, click + CREATE ACTIVATION.
Create Activation
  • Step 6: In the Select Warehouse page, click + ADD WAREHOUSE. In the Select Warehouse Type page, select Google BigQuery.
bigquery google ads - Add Warehouse
  • Step 7: In the Configure your Google BigQuery Account page,
    • Step 1: Click + ADD GOOGLE BIGQUERY ACCOUNT.
    • Step 2: Sign in as a user with BigQuery Admin and Storage Admin permissions.
    • Step 3: Click Allow to authorize Hevo to access your data.
  • Step 8: In the Configure your Google BigQuery Warehouse page, specify the following details:
bigquery google ads - Google BigQuery Warehouse settings
  • Step 9: Click TEST CONNECTION to test and SAVE DESTINATION or SAVE WAREHOUSE, as applicable, to complete the setup.

Conclusion

In this article, you have learned how to effectively set up the BigQuery Google Ads connection. It is really important for companies that use Google Ads for advertising to get analytical insights with ease in their organizations. BigQuery Data Transfer Service addresses this problem in a seamless fashion and that too within no time.

Though, this manual BigQuery to Google Ads connection method can be tedious and time-consuming if you require to frequently transfer data from BigQuery to Google Ads. For a more effortless and efficient approach, you can go for the second method and use a Cloud-based Reverse ETL tool like Hevo Activate!

Visit our Website to Explore Hevo

Hevo Activate helps you directly transfer data from a source of your choice such as Snowflake, Amazon Redshift, Facebook, etc., to any SaaS application, CRMs like Salesforce, etc., in a fully automated and secure manner without having to write the code repeatedly. It will make your life easier and make data migration hassle-free. It is user-friendly, reliable, and secure.  

Hevo, with its strong integration with 100+ sources and BI tools(Including 40+ Free Sources), allows you to not only export & load data but also transform & enrich your data & make it analysis-ready in a jiffy.

Want to take Hevo for a ride? Sign Up for a 14-day free trial and simplify your Data Integration process. Do check out the pricing details to understand which plan fulfills all your business needs.

Tell us about your experience of setting up the BigQuery Google Ads Connection! Share your thoughts with us in the comments section below.

No-code Data Pipeline for Google BigQuery