Audience List Upload

This sync enables moving Audience List data from a user specified datawarehouse to the Google Ads platform.

SETUP

Configuring the Credentials

Select the account credentials which has access to relevant Google Ads account from the given list & Click Next

Credentials not listed ?: Click on + for adding new credentials and fill the form that pops-up.

Data Sync Details

Data Sync: Select Audience List Upload & click Next
Customer: Select one or more customers from the drop-down

All customers which your credentials have access to should be available here. If they are not, please check the credentials selected / configured by you. While you can add multiple customers, the table size may become too large and so it is advisable to add one customer per pipeline and use Union queries in the data warehouse to join the data for consumption

How do you want to fetch data?: Select whether you want to fetch data from the Data Model or from Table/ View.
Data Model: In case you want to fetch data using Data Model, select the data model that you would like to use for this sync. Checkout how to configure a model here.
Data Warehouse: In case you want to fetch data using Table/ View, select the data warehouse that you would like to use for this sync.
Table / View: Select the Table/ view in the data warehouse that you would like to use for this sync.
Select Segment: Select the segment that you would like to use for this sync. Checkout how to configure a model here.

Setting Parameters

Parameter Description Values

Parameter	Description	Values
Fetch Mode	*Required* This refers to the manner in which data will get updated : FULL will update the entire column(s) from the selected data, INCREMENTAL will update the fresh record(S) added since last fetch	{Incremental,Full} *Default Value:* FULL
User List Type	*Required* Specify whether to create a new list or update an existing one with the data being fetched in this run.	{Create, Update}
User List Name	*Required* Specify the list name that needs to used when creating or updating a list.	String value
Insert Mode	*Required* This refers to the manner in which data will get updated in the data warehouse, with 'Upsert' selected, the data will be upserted (only new records or records with changes) and with 'Replace' selected, the table is dropped and recreated with fresh data on each run. Recommended to use "Upsert" option unless there is a specific requirement.	`Upsert`, `Replace` *Default Value:* UPSERT

Fetch Mode

Required

This refers to the manner in which data will get updated : FULL will update the entire column(s) from the selected data, INCREMENTAL will update the fresh record(S) added since last fetch

{Incremental,Full}

Default Value: FULL

User List Type

Required

Specify whether to create a new list or update an existing one with the data being fetched in this run.

{Create, Update}

User List Name

Required

Specify the list name that needs to used when creating or updating a list.

String value

Insert Mode

Required

This refers to the manner in which data will get updated in the data warehouse, with 'Upsert' selected, the data will be upserted (only new records or records with changes) and with 'Replace' selected, the table is dropped and recreated with fresh data on each run. Recommended to use "Upsert" option unless there is a specific requirement.

Upsert, Replace

Default Value: UPSERT

Data Sync Scheduling

Set the schedule for the sync to run. Detailed explanation on scheduling of syncs can be found here

Dataset & Name

Give your sync a name and some description (optional) and click on Finish to save it. Read more about naming and saving your syncs including the option to save them as templates here

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.