Google Ad Manager Setup Guide

Find Network Code

1. Go to your Ad Manager network.

2. Find your network code in the URL when you are logged into your network. For example, in the URL https://www.google.com/dfp/2032576#delivery, 2032576 is the network code.

3. Make a note of your network code. You will need it to fill in your connection setup form.

Enable API Access

Fivetran accesses your data using APIs. Follow Google's instructions to ensure that API access is enabled.

Begin Fivetran configuration

1. In the connection setup form, enter the Destination schema name of your choice.

2. Click Authorize to allow Fivetran access to your Google Ad Manager account.

3. In the Historical Sync Time Frame drop-down menu, select how many months' worth of reporting data you'd like to include in your initial sync.

4. Enter the Network code that you found in Step 1.

Add report

1. Click + Add report.

2. Enter the Destination table name. The name must be unique within this connection and must comply with Fivetran's naming conventions.

   Give the table a name you will find easy to identify with the report in the future. When you want to enable or disable the sync for a particular report once it is set up, you can do so by selecting or deselecting its table in the connection's Schema tab in your Fivetran dashboard.

3. Select Ad unit view.

4. Select Dimensions, Dimension Attributes, Columns, Custom fields, and Custom dimensions.

   The DATE dimension is mandatory for reports.

   i. Select at least one Dimension in addition to DATE.

   ii. Select at least one Column.

   iii. Select the Custom fields corresponding to their Dimensions.

   The number of Custom fields you select should not exceed 15.

   iv. (Optional) Select the Custom dimensions.

   The Custom dimensions option is only available if you selected the CUSTOM_DIMENSION dimension.

5. Click Save.

   Repeat the previous five steps if you want to add another Custom report.

Finish Fivetran configuration

1. Click Save & Test. Fivetran will take it from here and sync your Google Ad Manager data.

Find Network Code

1. Go to your Ad Manager network.

2. Find your network code in the URL when you are logged into your network. For example, in the URL https://www.google.com/dfp/2032576#delivery, 2032576 is the network code.

3. Make a note of your network code. You will need it to fill in your connection setup form.

Enable API Access

Fivetran accesses your data using APIs. Follow Google's instructions to ensure that API access is enabled.

Finish Fivetran configuration

1. In the connection setup form, enter your chosen Destination schema name.

2. Enter your chosen Destination table name.

3. Click Authorize to allow Fivetran access to your Google Ad Manager account.

4. In the Historical Sync Time Frame drop-down menu, select how many months' worth of reporting data you'd like to include in your initial sync.

5. Enter the Network code that you found in Step 1.

6. Select Dimensions, Dimension Attributes, Columns, Custom fields, and Custom dimensions.

   The DATE dimension is mandatory for reports, so it is selected by default.

   i. Select at least one Dimension in addition to DATE.

   ii. Select at least one Column.

   iii. Select the Custom fields corresponding to their Dimensions.

   The number of Custom fields you select should not exceed 15.

   iv. (Optional) Select the Custom dimensions.

   The Custom dimensions option is only available if you selected the CUSTOM_DIMENSION dimension.

7. Select Ad unit view.

8. Click Save & Test. Fivetran will take it from here and sync your Google Ad Manager data.