Google Data Manager Export Integration

Copy

• Copy for LLM

  Copy page as Markdown for LLMs
• View as Markdown

  Open this page as Markdown
• Open in ChatGPT

  Get insights from ChatGPT
• Open in Claude

  Get insights from Claude
• Connect to Cursor

  Install MCP server on Cursor
• Connect to VS Code

  Install MCP server on VS Code

This TD export integration lets you send audience data to multiple Google advertising products as Google Adwords, Display Video Partner, Display Video Advertiser with a single call

Prerequisites

• Basic Knowledge of Treasure Data™
• The user OAuth has direct admin access to the target Google Ads or Display Video Partner or Display Video Advertiser account

Requirements and Limitations

Limitations

• The user list size is displayed as zero until it reaches a minimum of 1,000 members. Beyond this threshold, the size is rounded to the nearest two significant figures
• It can take up to 24 hours for a list to be populated with members
• It is recommended to append audience data to a user list once per day
• Avoid running multiple uploading jobs of the same user list

Requirements

It is recommended to follow Google's policies for Customer Match, in particular:

• A good history of policy compliance​
• A good payment history.
• Upload only customer information that you collected in the first-party context
• Restrictions on sensitive categories

Create a new Connection

On TD Console, you must create and configure the data connection before running your query. As part of the data connection, you provide authentication to access the integration following the below steps

1. Open TD Console
2. Navigate to Integrations Hub > Catalog
3. Search for and select Google Data Manager
4. Select Create Authentication, and provide the credential information for the integration as described below
5. Select **Continue,**enter a name for the Authentication, and select Done.

Authentication Fields

• OAuth Connection : Authorize from an account having ADMIN access to the target Google Ads or Display Video Partner or Display Video Advertiser account

Configure a Query Result for Export

The TD Console supports multiple ways to export data. Please follow the below steps to export data from the Data Workbench

1. Navigate to Data Workbench > Queries
2. Select New Query, and define your query
3. Select Export Results to configure the data exporting

1. Select an existing authentication, or create a new one following the above section
2. Configure the exporting parameters as described in the Configuration Parameters below, and select Done

Define your Query

Your query should include the required columns for the target Identifier type, other columns will be ignored. Required columns don't accept a null or empty value (else the record is considered invalid and skipped).

Data requirement:

• Normalization: all plain text data should be in lowercase, and be removed any extra spaces before, and after
• SHA-256 hashing: email, phone, first name, and last name should be hashed using the SHA-256 algorithm. If not, they are hashed automatically by the connector

Configuration Parameters

Activate a Segment in Audience Studio

You can also send segment data to the target platform by creating an activation in the Audience Studio.

1. Navigate to Audience Studio.
2. Select a parent segment.
3. Open the target segment, right-mouse click, and then select Create Activation.
4. In the Details panel, enter an Activation name and configure the activation according to the previous section on Configuration Parameters.
5. Customize the activation output in the Output Mapping panel.

• Attribute Columns
  • Select Export All Columns to export all columns without making any changes.
  • Select + Add Columns to add specific columns for the export. The Output Column Name pre-populates with the same Source column name. You can update the Output Column Name. Continue to select + Add Columnsto add new columns for your activation output.
• String Builder
  • + Add string to create strings for export. Select from the following values:
    • String: Choose any value; use text to create a custom value.
    • Timestamp: The date and time of the export.
    • Segment Id: The segment ID number.
    • Segment Name: The segment name.
    • Audience Id: The parent segment number.

1. Set a Schedule.

• Select the values to define your schedule and optionally include email notifications.

1. Select Create.

(Optional) Export Integration Using the workflow

Within Treasure Workflow, you can specify the use of a data connector to export data.

Learn more at Using Workflows to Export Data with the TD Toolbelt.

_export:
    td:
        database: google_data_manager
+google_data_manager_export_task:
    td>: export.sql
        database: ${td.database}
        result_connection: new_created_google_data_manager
        result_settings:
            type: google_data_manager
            product: GOOGLE_ADS
            mode: add
            advertiser_id: 123456789
            list_name: test
            list_description: desc
            list_type: mobile_data
            app_id: app_id
            membership_life_span: 100
            terms_of_service: ACCEPTED
            ad_user_data: CONSENT_GRANTED
            ad_personalization: CONSENT_GRANTED
            skip_invalid_records:true

_export:
    td:
        database: google_data_manager

+google_data_manager_export_task:
    td>: export.sql
    database: ${td.database}
    result_connection: new_created_google_data_manager
    result_settings:
        type: google_data_manager
        product: GOOGLE_ADS
        mode: remove
        advertiser_id: 123456789
        list_name: test
        list_type: user_data
        skip_invalid_records: true

(Optional) Export Integration Using the CLI

You can also use CLI (Toolbelt) to export results to Google Platform.

You need to specify the information for export to your Google Account using the *--result option of*the td query command. For more information about the *td query*command, refer to this article.

The format of the option is JSON, and the general structure is as follows.

Add mobile data

type: google_data_manager
product: GOOGLE_ADS
mode: add
advertiser_id: 123456789
list_name: test
list_description: desc
list_type: mobile_data
app_id: app_id
membership_life_span: 100
terms_of_service: ACCEPTED
ad_user_data: CONSENT_GRANTED
ad_personalization: CONSENT_GRANTED
skip_invalid_records: true

Add user data

type: google_data_manager
product: GOOGLE_ADS
mode: add
advertiser_id: 123456789
list_name: test
list_description: desc
list_type: user_data
membership_life_span: 100
terms_of_service: ACCEPTED
ad_user_data: CONSENT_GRANTED
ad_personalization: CONSENT_GRANTED
skip_invalid_records: true

Remove user data/mobile data

type: google_data_manager
product: GOOGLE_ADS
mode: remove
advertiser_id: 123456789
list_name: test
list_type: user_data
skip_invalid_records: true

Parameters

Example for Usage

OAuth authentication

$ td query --result '{"type":"google_data_manager","oauth_credentials_id":"xxx","product":"GOOGLE_ADS","mode":"add","advertiser_id":"xxx","list_name":"xxx","list_description":"xxx","list_type":"user_data","membership_life_span":540,"terms_of_service":"ACCEPTED","ad_user_data":"CONSENT_GRANTED","ad_personalization":"CONSENT_GRANTED","skip_invalid_records":true}' -d sample_datasets "select ........ from ........" -T presto

Others

• You can use Scheduled Job  with Result Export to periodically upload data to a target destination