# Google Ads

## Connect to Google Ads

Before the following setup steps, make sure you have your Google Ads account available (both normal and manager accounts are fine). 

1. Go to the **Resources** page and click the <img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2Fct5RJC2cjHhrvymOWWGx%2Fimage.png?alt=media&#x26;token=b4ff0c44-5510-49d1-97dd-a155af254113" alt="" data-size="line">  button.&#x20;
2. Select **Google Ads**.
3. Click the <img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FZVNP3W33GXMRho8nSwb3%2FScreen%20Shot%202022-06-29%20at%2010.11.56%20AM.png?alt=media&#x26;token=36766929-0855-42da-9682-b5f98a294de2" alt="" data-size="line"> button to connect with your Google account.
4. If you wish to connect with a different account, click the <img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FtGFx8vtNNbwISOfIETOq%2FScreen%20Shot%202022-06-29%20at%2010.19.19%20AM.png?alt=media&#x26;token=b25f7aaa-8347-4d49-9b4e-55cf78b33c99" alt="" data-size="line"> button and log in with another account.
5. Enter the required fields and click **Connect**.&#x20;
   * Resource Name
   * Customer ID(s)
   * Start Date (UTC)
6. Choose tables to import and click **Finish Setup**.&#x20;
7. You will see a  <img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MB_fx7PCUqvFEdrucJC%2F-MgBh5PshcmRFk38itib%2F-MgBo4LSmdK4OS-NqLZy%2Fsyncing.png?alt=media&#x26;token=452494f9-e4be-48fa-9644-bee7d969c46c" alt="" data-size="line"> icon next to your resource. It may take a few minutes to several hours depending on the data size and the number of your tables. Once your data is ready, you will receive a notification email.&#x20;

## Get Customer ID(s) from Google Ads

### If your account is NOT a manager account

* If the Google account you connect with (Step 3.) is associated with a normal (not manager) Google Ads account, you can find the 10-digit Customer ID in the up-right corner of your account dashboard

<div align="center"><img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2F8Uju7BJlV43dfoCRM1gI%2FScreen%20Shot%202022-06-29%20at%2010.52.40%20AM.png?alt=media&#x26;token=5b706763-59eb-4696-bc3d-c4ce6a404f5c" alt=""></div>

* Enter the ID in the Customer ID(s) field without the dashes.
* If you wish to sync data from multiple accounts, separate each ID with a comma (,).

### If your account is a manager account

* If the Google account you connect with (Step 3.) is associated with a Google Ads Manager account, which means your access to the account you wish to sync is through a manager account, you'll need to fill in **BOTH** **Customer ID(s) and Login Customer ID**.
* To get the Login Customer ID, log in to your Google Ads Manager account and get the 10-digit Login Customer ID at the up-right corner.
* To get the Customer ID(s), click on the icon in the up-right corner, and you'll find the list of the accounts in the dropdown.

  <img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FkXMW1qdFM4YtpTsVXXLQ%2FGoogle%20Ads.png?alt=media&#x26;token=2dcb71b3-a6c5-47fa-ba8d-4ef9fd1beb91" alt="" data-size="original">
* For more information about the Google Ads Manager account, check out Google's document [here](https://support.google.com/google-ads/answer/6139186?hl=en).

## 3. Available Tables

#### Main Tables

* [accounts](https://developers.google.com/google-ads/api/fields/v8/customer)
* [ad\_group\_ads](https://developers.google.com/google-ads/api/fields/v8/ad_group_ad)
* [ad\_group\_ad\_labels](https://developers.google.com/google-ads/api/fields/v9/ad_group_ad_label)
* [ad\_groups](https://developers.google.com/google-ads/api/fields/v8/ad_group)
* [ad\_group\_labels](https://developers.google.com/google-ads/api/fields/v9/ad_group_label)
* [campaign](https://developers.google.com/google-ads/api/fields/v8/campaign)
* [campaign\_labels](https://developers.google.com/google-ads/api/fields/v9/campaign_label)
* [click\_view](https://developers.google.com/google-ads/api/reference/rpc/v8/ClickView)
* [keyword](https://developers.google.com/google-ads/api/fields/v8/keyword_view)
* [geographic](https://developers.google.com/google-ads/api/fields/v8/geographic_view)

Note that `ad_groups`, `ad_group_ads`, and `campaigns` contain a `labels` field, which should be joined against their respective `*_labels` streams if you want to view the actual labels. For example, the `ad_groups` stream contains an `ad_group.labels` field, which you would join against the `ad_group_labels` stream's `label.resource_name` field.

#### Report Tables

* [account\_performance\_report](https://developers.google.com/google-ads/api/docs/migration/mapping#account_performance)
* [ad\_group\_ad\_report](https://developers.google.com/google-ads/api/docs/migration/mapping#ad_performance)
* [display\_keyword\_report](https://developers.google.com/google-ads/api/docs/migration/mapping#display_keyword_performance)
* [display\_topics\_report](https://developers.google.com/google-ads/api/docs/migration/mapping#display_topics_performance)
* [shopping\_performance\_report](https://developers.google.com/google-ads/api/docs/migration/mapping#shopping_performance)
* [user\_location\_report](https://developers.google.com/google-ads/api/fields/v9/user_location_view)

**Note**: Due to constraints from the Google Ads API, the `click_view` stream retrieves data one day at a time and can only retrieve data newer than 90 days ago

**Note**: Due to constraints from the Google Ads API, [metrics](https://developers.google.com/google-ads/api/fields/v8/metrics) cannot be requested for a manager account. Therefore, report streams are only available when pulling data from a non-manager account.

**Note**: For incremental streams data is synced up to the previous day using your Google Ads account time zone. The reason is that Google Ads can filter data only by [date](https://developers.google.com/google-ads/api/fields/v8/ad_group_ad#segments.date) without time. Also, some report cannot load data in real time due to Google Ads [limitations](https://support.google.com/google-ads/answer/2544985?hl=en).