Treasure Data can send user list data to DAC AudienceOne. You can make a user list in Treasure Data that targets a segment and then send the list to AudienceOne to use in your advertisement campaigns. Refer to AudienceOne webpage.


Prerequisites

  • Basic knowledge of Treasure Data

  • An AudienceOne account

Required access information from AudienceOne

Treasure Data and AudienceOne have collaborated to ensure a secure data exchange. You must request access to the AudienceOne account on behalf of Treasure Data. Ask your AudienceOne account administrator for the following information:

  • API Key

  • Database name

  • Table name

Usage

To export data, you create or select an existing connection, create or reuse a query, and then run the query to export your user lists. You can use td_global_id lists as user lists.

Create or reuse a query

  • 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.

Query output should include following columns:

  • time: unix timestamp of data transferred.

  • crm_category_name: Name of the segment that is shown in the AudienceOne console.

  • crm_value: Id of the segment.

  • customer_id: td_global_id.

Create or Select an Existing AudienceOne Connection

Option

Task Steps

Tip

Create a connector

- Go to Connections.
- Select the AudienceOne icon from Sources Catalog.
- Complete the required fields on the first pane.
- In the API Key field, enter the API Key you get from AudienceOne.

Next you complete the Configuration fields.

You don't have to modify Endpoint field.

Select a connector

- Go to TD Console.
- Go to Query Editor.
- Access the query that you plan to use to export data.
- Select Output results. The Choose Saved Connection dialog opens.
- Type the connection name in the search box to filter and select the connection that you want.

Next, you complete the Configuration fields.

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

Creating a new connection:

  1. Open TD Console.

  2. Navigate to Integrations Hub >  Catalog.

  3. Click the search icon on the far-right of the Catalog screen, and enter AudienceOne.
  4. Hover over the AudienceOne connector and select Create Authentication.

          The following dialog opens. Enter the information, and then click Continue. Give the connection a name and click Done.



Selecting an existing connection:

Configure the Connection by Specifying the Parameters

After you select your AudienceOne connection, the Configuration dialog pane appears:

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.

  • No labels