> For the complete documentation index, see [llms.txt](https://docs.acho.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.acho.io/acho-studio/resources/import-data/google-ads.md).

# 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="/files/luUqNwhjG7IZbheUpaBG" alt="" data-size="line">  button.&#x20;
2. Select **Google Ads**.
3. Click the <img src="/files/ddYN0fFcRcn2iFWZT0Pk" 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="/files/ZqVYupCOHNyuqVkAyUDE" 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="/files/-MgBo4LSmdK4OS-NqLZy" 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="/files/X1hJDPeG56kZurjhgeAc" 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="/files/Lk4JfzemABWCBEg8Ek7Q" 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).