Skip to content
/
Dotdigital Import Integra...
Last updated

Dotdigital Import Integration

Dotdigital Engagement Cloud is an omnichannel marketing solution designed to send data-triggered campaigns across channels including email, SMS, social media, push notifications, and more. You can import data from Dotdigital directly into Treasure Data.

Prerequisites

  • Basic knowledge of Treasure Data, including TD Toolbelt.
  • An account in Dotdigital.
  • An API account in Dotdigital.

Obtain your API account

  1. Log in to DotDigital. Navigate to https://login.dotdigital.com/login.aspx?ReturnUrl=/.
  2. Navigate to https://r1-app.dotdigital.com/access/api and go to tab: API users

3. Select New user. DotDigital provides you with an email address. Complete the form by adding and confirming a password; a description is optional.

4. Select Save.

Import from Dotdigital via TD Console

Create a New Connection with TD Console

When you configure a data connection, you provide authentication to access the integration. In Treasure Data, you configure the authentication and specify the source information.

  1. Open TD Console.
  2. Navigate to the Integrations Hub > Catalog.
  3. Select the search icon on the far-right of the Catalog screen, and enter dotdigital.
  4. Hover over the dotdigital connector and select Create Authentication.

The New Authentication dialog opens.

  1. Select your Region. The API User Name and API User Password fields auto-populate.
  2. Select Continue.
  3. Enter a name for your connection.
  4. Select Done.

Transfer Your Dotdigital Account Data to Treasure Data

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

  1. Search for the connection you created.
  2. Select New Source.
  3. Type a name for your sourcein the Data Transfer Name field.
  4. Select Next. The Source Table dialog opens.

Create a Source Table

Edit the parameters in the Source Table based on your objectives.

ParametersDescription
Data Type
  • All Campaigns Since Date. Fetch campaign data.
  • Contacts - Since Date. Fetch contact data.
  • Contacts - Address Book. Fetch contacts from Address Books

Statistics Type

All Campaigns - Since Date

  • Activities Since Date. Fetch campaign activities based on a specific date.
  • Clicks Since Date. Fetch campaign clicks based on a specific date.
  • Open Since Date. Fetch campaigns that have been opened based on a specific date.
  • Page Views Since Date. Fetch campaign page views based on a specific date.
  • ROI Activity Since Date. Fetch campaign ROI activity based on a specific date.

Contacts - Since Date

  • Created Since Date. Fetch contacts created based on a specific date.
  • Modified Since Date. Fetch contacts are modified based on a specific date.
  • Suppressed Since Date. Fetch contacts that have been suppressed based on a specific date.
  • Unsubscribed Since Date. Fetch contacts that have been unsubscribed based on a specific date.
  • Unsubscribed from Address Book Since Date. Fetch contacts unsubscribed from an address book based on a specific date.

Contacts - Address Book

  • All. Fetch all current contacts from one or more address book(s)
  • Modified Since Date. Fetch all contacts which was modified since a specific date from one or more address books
  • Unsubscribed Since Date. Fetch all contacts which unsubscribed since a specific date from one or more address books
Number of Records Per PagePage size when fetching data from Dotdigital API. Default 1000, min 1, max 2000
Start Time (Required)A timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: "2014-10-02T15:01:23Z".
Address Book Id List (Optional)Comma-separated list of address book IDs to filter only the address books to ingest contacts from
Address Book Name Filter (Optional)A Regular Expression string to filter only the address books to ingest contacts from
Address Book VisibilityChoose among:
  • All. Read from all address books
  • Public. Only read from public address books
  • Private. Only read from private address books
With Full DataEnable this option to load all dataFields from the contact record
Incremental LoadingEnables incremental report loading with automatic calculation of new Start Time. For example, if you start incremental loading with Start Time = 2014-10-02T15:01:23Z to 2014-10-03T15:01:23Z, the next jobs run new Start Time will be 2014-10-03T15:01:23

Skip Filter By Incremental Field

When false, the connector will do an additional filter after fetching the DotDigital API:

  • All Campaigns - Since Date: filter by incremental column
  • Contacts - Since Date: filter by incremental column
  • Contacts - Address Book: filter by incremental column when incremental false

When true, the connector will disable this additional filter.

  1. Select Next. The Data Settings page opens.

Define Data Settings (Optional)

Edit the data settings or skip this section.

Preview Your Data (Optional)

Data preview is optional; you can skip to the next section of the dialog.

The data displayed in the data preview is approximated from your source; it is not the actual data that is imported.

  1. Select Next.
  2. To preview your data, select Generate Preview. Optionally, select Next to skip to the next section.
  3. Verify that the data looks approximately like you expect it to.

4. Select Next.

Define Data Placement

Specify where your data is placed and schedule how often it runs this import.

In the Schedule section, you can choose when and how often you want to run this query.

Run once:

  • Select Off.
  • Select Scheduling Timezone.
  • Select Create & Run Now.

Repeat the query:

  • Select On.
  • Select the Schedule. The UI provides these four options: @hourly, @daily and @monthly or custom cron.
  • You can also select Delay Transfer and add a delay of execution time.
  • Select Scheduling Timezone.
  • Select Create & Run Now.

After your transfer has run, you can see the results of your transfer in Data Workbench > Databases.

Previous page
Next page