Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: fix broken link

You can use the Amazon DSP Data Provider Export Integration connectors to export segment data to Amazon DSP.


Table of Contents


  • Basic knowledge of Amazon DSP and an advertiser account

  • Basic Knowledge of Treasure Data: Authentication, Query, Results Export, and (optionally) Workflow.


  1. Open TD Console.

  2. Navigate to Integrations HubCatalog.Search for and select

  3. Click the search icon on the far-right of the Catalog screen, and enter Amazon DSP.
  4. Hover over the Amazon DSP Data Provider connector and select Create Authentication.Image Added
    Image Removed      The following dialog opens.Image Modified
  5. Choose the Region of your advertiser account

  6. Enter your Advertiser ID. Then select Continue.

  7. Enter a name for your connection.

  8. Select Done.

    Image Modified

Export Results to Amazon DSP


When exporting your data to Amazon DSP, you must provide the following parameter values: 



Audience Name (required)

The name of audience you would like to create.

Audience Description (optional)

Description for your audience.

External Audience ID (required)

Unique key for your audience.

Time to live (required)

The time in seconds when the audience will stay valid.

Operation (required)

Operation to perform on the output data (add or remove).

Ignore Invalid Records

During the time data is sent to Amazon DSP, If the check box is ticked and there are incorrect records or errors, they will be skipped and continue to send data to the last row. Otherwise an exception will be thrown

To export results:

  1. Open the TD Console.

  2. Navigate to Data Workbench > Queries.

  3. Select the query that you plan to use to export data.
    For example:

    Code Block
    SELECT a_cookie_column AS cookie,
    a_maid_column AS maid
    FROM your_table;

  4. Select Export Results located at top of your query editor. 

  5. The Choose Integration dialog opens.
    You have two options when selecting a connection to use to export the results:

    • using an existing connection

    • creating a new one


  1. Type the connection name in the search box to filter.

  2. Select your connection.

    Image Modified
  3. Select Next.

  4. Type values for Audience Name, Audience Description, External Audience ID, Time to live, Operation and Ignore Invalid Records.


  1. Select Create New Integration.

  2. Type a Name for your connection.

  3. Select your region from Region.

  4. Type your advertiser id in Advertiser ID.

    Image Modified

  5. Select Next.

  6. Type values for Audience Name, Audience Description, External Audience ID, Time to live, Operation and Ignore Invalid Records.

    Image Modified

  7. Select Done.


Configure Export Results in Workflow

Code Block
timezone: UTC

    database: sample_datasets

  td>: queries/sample.sql
  result_connection: your_connections_name
    region: NA
    advertiser_id: 12345
    audience_name: This is a test audience
    audience_description: This is for testing purpose
    external_audience_id: test_audiences
    time_to_live: 3600
    operation: Add
    ignore_error: false

To learn more about using data connectors in a workflow , review Workflows and Machine Learningcheck out the Workflows section of the docs.