Managing imported tables and fields with Google Ads data

Selecting necessary tables from the list

The Google Ads → Google BigQuery pipeline allows you to upload data about your advertising campaigns. When setting up the pipeline, you can select the necessary tables and fields for import into BigQuery. Click on the section:

In the dialog that appears, you'll find a complete list of tables available for import.

Click on the triangle icon to view a list of all fields within a table.

Minimum list of tables required for building a CMO Dashboard

All Google Ads costs are included in 5 tables, which are selected by default:

• accounts
• ad_group_ad_report
• campaigns
• click_view
• keyword_report

How to recognize data from different Google Ads accounts

The pipeline will automatically create the selected tables in BigQuery and append your Google Ads account ID as a suffix to their names for easy identification. For instance, if you choose an Ads account with the ID '1213141516', the names of the tables will incorporate this ID, as shown in the examples below:

• accounts_1213141516
• ad_group_ad_report_1213141516
• campaigns_1213141516
• click_view_1213141516
• keyword_report_1213141516

This naming convention ensures that tables are uniquely associated with your specific Google Ads account, simplifying data management and retrieval.

How to view the table schema

Open the Pipeline page and go to the "Table schema" tab. It displays all the tables into which the Pipeline imports data from Google Ads.

You can quickly open any table in the BigQuery interface by clicking on the "Open in BigQuery" button next to the table name.

Why duplicates of tables appear in BigQuery

Sometimes in BigQuery, you may see duplicate tables that have the same name plus a 7-character suffix, as shown in the screenshot below:

These tables are temporarily created during data loading into BigQuery. The Google Ads → BigQuery pipeline can update data in two ways:

• Incremental update: The Pipeline creates a temporary table in BigQuery, into which it imports all data. Afterward, it copies the data from the temporary table to the original table and then deletes the temporary table.
• Full refresh: The Pipeline creates a temporary table in BigQuery, into which it imports all data. After that, it deletes the original table and renames the temporary table to the original table's name.

How to find out which tables were selected when creating the pipeline

Open the Pipeline page and go to the "Settings" tab. Click on the section "Imported tables and fields".

In the dialog that opens, you will see the complete list of tables that were selected before the Pipeline was activated. Here, you can also view the list of fields in each table by clicking on the arrow icon to the left of the table name.

How to change tables for importing if the pipeline is already activated

If you need to select different tables for import, follow these steps.