You can connect Iterable to import Campaign metrics or a user's email into Treasure Data.



Prerequisites

Limitation

About Incremental Data Loading 



Obtaining API Key

  1. Navigate to https://app.iterable.com/settings/apiKeys
  2. Click New API KEY
  3. Select Standard (Server-side)


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.

  1. Open TD Console.

  2. Navigate to Integrations Hub  Catalog.

  3. Search for and select Iterable.

  4. The following dialog opens.

  5. Enter your API Key
  6. Enter a name for your connection.

  7. Select Continue.


Transfer Your Data to Treasure Data

After creating the authenticated connection, you are automatically taken to Authentications. Search for the connection you created. 

  1. Select New Source.

  2. Type a name for your Source in the Data Transfer field.

  3. Select Next.
    The Source Table dialog opens.
  4. Edit the following parameters:

    Parameters Description
    Data Type

    Data type to import:

    • Campaign
    • List

    Canpaign id(s)An array of campaign's id, separated by commas. Leave it blank to import all campaigns
    List idList id to fetch all users belong to it
    Start Time

    For UI configuration, you can pick the date and time from the supported browser, or input the date that suits the browser expectation of date-time. For example, on Chrome, you will have a calendar to select Year, Month, Day, Hour, and Minute; on Safari, you need to input the text such as 2020-10-25T00:00.

    For CLI configuration, we need a timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: "2014-10-02T15:01:23Z".


    End Time

    For UI configuration, you can pick the date and time from the supported browser, or input the date that suits the browser's expectation of date-time. For example, on Chrome, you will have a calendar to select Year, Month, Day, Hour, and Minute; on Safari, you need to input the text such as 2020-10-25T00:00.

    For CLI configuration, we need a timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: "2014-10-02T15:01:23Z".


    New format

    Receive data in New Format if it is true and Old format if is false


    Number of Ids for Each RequestThe number of ids for one request. From 1 to 20
    Incremental

    Import new data only from the last run. See About Incremental Loading.



Data Settings

  1. Select Next.
    The Data Settings page opens.

  2. Skip this page of the dialog.

Data Preview 


Data Placement