Transferring data to Google Ads Audiences

This guide explains how to transfer data to Google Ads Audiences to store and further process information.

Concept

Google Ads Audiences is an Active Destination. After you set Google Ads Audiences as the Destination of a Datastream, data is transferred to Google Ads Audiences each time data is fetched for the Datastream. For more information, see Destination types.

You can assign multiple Destinations to a Datastream. For more information on possible limitations, see Assigning multiple Destinations to a Datastream.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a Datastream whose data you want to transfer to Google Ads Audiences. For more information on creating a Datastream, see Introduction to collecting data.

  • Ensure the account you use to connect to Google Ads Audiences is assigned to the Standard or Admin role.

Procedure

To transfer data from a Datastream to Google Ads Audiences, follow these steps:

  1. Add Google Ads Audiences as a Destination to the Workspace which contains the Datastream or to one of its parent Workspaces.

  2. Assign the Google Ads Audiences Destination to the Datastream.

  3. Configure the Schema Mapping of your Datastream to conform with Google Ads Audiences Destination standards.

  4. Enable data transfer to the Destination from the Datastream.

  5. Configure transfer settings.

Adding Google Ads Audiences as a Destination

To add Google Ads Audiences as a Destination to a Workspace, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Click + Add.

  2. Click Google Ads Audiences.

  1. Click Setup a new Authorization.

  2. Click Next.

  1. Log in to your Google account.

  2. Click Allow to grant Adverity access to your Google Ads Audiences account.

  1. In the Configuration page, fill in the following fields:

    Customer

    Select the customer for the Google Ads Audiences account where you want to transfer data.

  1. Click Create.

Assigning Google Ads Audiences as a Destination

To assign the Google Ads Audiences Destination to a Datastream, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, click + Add Destination.

  2. Click Assign Existing Destinations.

  1. Select the Google Ads Audiences checkbox in the list.

  2. Click Save.

Configuring Schema Mapping for Google Ads Audiences Destination

All data that you transfer to Google Ads Audiences must conform with Google Ads Audiences standards. To configure Schema Mapping for the Google Ads Audiences Destination, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the top navigation panel, click Schema Mapping.

  1. In the Name column, find the field in the Data Extract used to identify users.

  2. In the cell in the Target column and the user identifier's row, write one of the following and press Enter. If you cannot find any value, click the blue link to create the target field with type string.

    • If first name is the user identifier, write first_name.

    • If last name is the user identifier, write last_name.

    • If city is the user identifier, write city.

    • If state is the user identifier, write state.

    • If postal code is the user identifier, write postal_code.

    • If email address is the user identifier, write email.

    • If phone number is the user identifier, write phone_number.

  3. Click Save.

Enabling data transfer to Google Ads Audiences Destination

To enable data transfer to the Google Ads Audiences Destination from the Datastream, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the list in the Destinations section, find the Google Ads Audiences Destination, and enable the toggle.

  2. In the All tasks tab, find the top element, and click Requeue for Import on the right.

Configuring transfer settings

To configure transfer settings, follow these steps:

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the chosen Datastream.

  1. In the Destinations section, find the Google Ads Audiences Destination in the list, and click on the right.

  2. Click Destination Settings.

  1. Fill in the following fields:

    List Mode

    Select one of the following:

    • Select Update existing Audience to add data from the Data Extract to an existing table.

    • Select Create new Audience (for each Extract) to create a new table for each Data Extract.

    • Select Create new Audience (once, then update) to create a new table the first time you transfer data from this Datastream, and then update this table with all subsequent data from the Datastream.

    Audience Name Template

    Specify the target table in the Destination where to transfer data from the Datastream. The name can contain alphanumeric characters and underscores. For example, target_table. To specify a schema, use the syntax schemaName.tableName.

    By default, Adverity saves data from each Datastream in a different table named [{datastream_name}] Custom Audience (for example, [mailgun_83] Custom Audience).

    You can specify the same target table for several Datastreams. If a column is shared between Datastreams, Adverity performs a full outer join and concatenates values. If a column is not shared between Datastreams, Adverity writes null values in the relevant cells.

    Placeholder

    Description

    {datastream_id}

    The Datastream ID.

    {datastream_name}

    The Datastream name.

    {datastream_type}

    The Datastream Type.

    {filename}

    The automatically generated filename of the Data Extract.

    {scheduled_day}

    The day from the start date of a date range for a scheduled data fetch.

    {scheduled_month}

    The month from the start date of a date range for a scheduled data fetch.

    {scheduled_year}

    The year from the start date of a date range for a scheduled data fetch.

    Identifiers

    Select the columns in the Data Extract used to identify users. These are the same columns you used when you configured the Schema Mapping for the Datastream.

    If you select Address, choose the additional identifiers to transfer in Address Fields.

    Personal identifiers (such as name and phone number) are automatically encrypted by Adverity.

  2. Click Save.