Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: updating against UI and export template

...

You can create audience lists in your Google DoubleClick Bid Manager (DBM) using data held in Treasure Data. Follow these steps to This integration helps you move cookies and Mobile Advertising Identifiers to new or existing audience lists within Google DBM.


Info

Google has rebranded DoubleClick Bid Manager to Display & Video 360, as part of the Google Marketing Platform.


For sample workflows on how to export to Google DoubleClick Bid Manager, view Treasure Boxes.

...

Table of Contents
maxLevel1
excludeLimitations

Prerequisites

  • Basic knowledge of Treasure Data, including the TD Toolbelt

  • A Google DBM Account

  • Authorized Treasure Data DMP access to your Google DBM Account

Limitations

It may take up to 24 hours for updates to audience lists to be visible in Google DoubleClick Bid Manager (DBM). Expect to wait up to 24 hours from the time of the query completion for changes to be reflected in DBM.

Google Data Platform Policy (Identifying Users and Obtaining User Consent) requires that each segment identifies at least 100 users.

Grant Access for Treasure Data

Treasure Data’s DDP (DoubleClick Data Platform) connector requires permissions to create audience segments in your Google DBM account. Use the Google Contact Us form to reach the DoubleClick Bid Manager Support team and request that Treasure Data be granted access to your DBM account. Provide the following information in the form:

...

You are sending information so that Google recognizes Treasure Data and connects your Google DBM account to Treasure Data.

Usage

To export data, you create or select an existing connection, create or reuse a query, and then run the query to export your audience lists.

Create or Reuse a Query

...

Go to TD Console

...

Go to Query Editor. You can pick the query language and write your query.

...

Select your database and table.

Access the query that you plan to use to export data. Here is a sample query:

Code Block
linenumberstrue
SELECT DISTINCT "cookie", "list_name", "time" FROM "google_dbm_ddp"

Create or Select an Existing DBM on DDP Connection

...

Option

...

Task Steps

...

Tip

...

Create a connector

...

Use the TD Console to Create Your Connection

Create a New Connection

In Treasure Data, you must create and configure the data connection prior to running your query. As part of the data connection, you provide authentication to access the integration.

...

Select a connector

...

You can also create a new connection from here by selecting Create New Connection.

Go to catalog and search 'Display & Video 360'.

Creating a new connection:

Image Removed

Selecting an existing connection:

Image Removed

Configure the Connection by Specifying the Parameters

After you select your Google DoubleClick Bid Manager DDP connection, the Configuration dialog pane appears:

Image Removed

Numbered Headings
start-numbering-with1
start-numbering-ath5
Open TD Console.
Navigate to Integrations Hub Catalog.
Search for and select Display & Video 360.

...

Sometimes you need to define the column mapping before writing the query.

Image Added

Select Create Authentication.
Type the credentials to authenticate.

Image Added

Select Continue.
Type a name for your connection.
Select Done.



Column Mappings

Source Column Name Mappings (Optional)

Define the mapping between Google DDP column names to the output column names that you specify in your query. You specify the target column and then the source column. For example, if google_cookie is the identifier column in your TD data source, you should define the mapping as cookie:google_cookie. If the source column in the mapping is missing, the target column name will be used. For example, a cookie is the same as cookie:cookie mapping.

See "Additional Connector Configuration Information" below for more information about supported column names and usage.

Cookie or Mobile Identifier Column Header

Specify the original source of the user cookie or mobile identifier.

...

  • cookie_encrypted: Encrypted identifier (for example, Web), a cookie hash of user-id

  • cookie_idfa: iOS Advertising Identifier

  • cookie_adid: Android Advertising Identifier

  • cookie_epid: cookie externally provided id

See "Additional Connector Configuration Information" below for more information on how identifier names are handled.

Execute the Query

Either save the query with a name and then run the query or just run the query. When the query completes successfully, the result is automatically processed. Plan to transfer your data at least 24 hours ahead of when you need the audience lists (also referred to as segments) to be in Google DoubleClick Bid Manager.

Additional Connector Configuration Information

The manner in which Google handles your data from Treasure Data affects how you configure the connector.

Column Mappings

The Google AdWords (via DDP) reads data source table by columns and uses the following column name mappings to process each row data:

  • cookie: The encrypted Google ID or Mobile Advertising Identifier that DDP will use in id matching. This column contains the cookie hash or mobile identifier of your users.

  • list_name: This column contains the name of the audience list (segment) that you want to create in your DBM audience. If the list name does not exist in DBM, a new list is created. If the list name exists, the existing list is updated.

  • timestamp (optional): The timestamp (seconds since EPOCH). If this column does not exist or is missing, a current timestamp is used.

  • delete (optional): This column contains boolean values (false or true) or numbers (0 or 1) to indicate if the cookie is to be added or removed from the given audience segment. By default, the value will be false if the value is left blank or if the column is not provided.

Define your Query

Sometimes you need to define the column mapping before writing the query.

Plan to transfer your data at least 24 hours ahead of when you need the audience lists (also referred to as segments) to be in Google DoubleClick Bid Manager.


Numbered Headings

Excerpt Include
PD:Exporting Your Query Data to Your Destination
PD:Exporting Your Query Data to Your Destination
nopaneltrue


Integration Parameters for Display and Video

Image Added

ParameterDescription

Source Column Name Mappings (Optional)

Define the mapping between Google DDP column names to the output column names that you specify in your query. You specify the target column and then the source column. For example, if google_cookie is the identifier column in your TD data source, you should define the mapping as cookie:google_cookie. If the source column in the mapping is missing, the target column name will be used. For example, a cookie is the same as cookie:cookie mapping.

Cookie or Mobile Identifier Name

The upload process supports several different identifiers, and it is important that types of identifiers are uploaded to the segment using the correct upload file format. Generally, the identifiers fall into one of two categories: encrypted identifiers (anything obtained from Google systems), and raw identifiers (obtained from an external system or source). Any encrypted identifier is uploaded using the cookie_encrypted file format, and raw identifiers are uploaded in a type-specific upload file format such as Mobile Advertising Identifiers, for example, cookie_idfa or cookie_adid.

Supported cookie types are cookie_encryptedcookie_epid, cookie_idfa, and cookie_adid.

Membership Lifespan

The number of days a user's cookie stays on the user list.

Temp filesize thresholdMaximum file size (in bytes) of local temp file, that temp file will be flushed to remote file when it reaches a threshold

Example Query


Code Block
linenumberstrue
SELECT DISTINCT "cookie", "list_name", "time" FROM "google_dbm_ddp"


Optionally Schedule the Query Export Jobs

You can use Scheduled Jobs with Result Export to periodically write the output result to a target destination that you specify.

Numbered Headings
start-numbering-with1
start-numbering-ath5

Excerpt Include
PD:Scheduling Jobs Using TD Console
PD:Scheduling Jobs Using TD Console
nopaneltrue


Optionally Configure Export Results in Workflow

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

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