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 the TD Toolbelt.
An account in Dotdigital.
An API account in Dotdigital.

Obtain your API account

Log in to DotDigital. Navigate to https://login.dotdigital.com/login.aspx?ReturnUrl=/.
Navigate to https://r1-app.dotdigital.com/access/api and go to tab: API users
Select New user. DotDigital provides you with an email address. Complete the form by adding and confirming a password, a description is optional.
Click Save.

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 then specify the source information.

Open the TD Console.
Navigate to the Integrations Hub > Catalog.
Click the search icon on the far-right of the Catalog screen, and enter dotdigital.
Hover over the dotdigital connector and select Create Authentication.
The New Authentication dialog opens.
Select your Region. The API User Name and API User Password fields auto-populate.
Select Continue.
Enter a name for your connection.
Select Done.

Transfer Your Dotdigital Account Data to Treasure Data

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

Search for the connection you created.
Select New Source.

Create a Source

The following procedure will step you through five sections to create a source.

1. Create a Connection

Type a name for your source in the Data Transfer Name field.
Select Next. The Source Table dialog opens.

2. Create a Source Table

Integrations > Dotdigital Import Integration > image-20200916-200955.png

Edit the parameters in Source Table based on your objectives.

Parameters	Description
Data Type	Campaigns. Fetch campaign data. Contacts. Fetch contact data.
Statistics Type	Campaigns 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 Created Since Date. Fetch contacts created based on a specific date. Modified Since Date. Fetch contacts 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 that have unsubscribed from an address book based on a specific date.
Start Time (Required)	A timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: `"2014-10-02T15:01:23Z"`.
Incremental Loading	Enables incremental report loading with new Start Time automatic calculation. 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`

Select Next. The Data Settings page opens.

3. (Optional) Define Data Settings

(Optional) Edit the data settings or skip this section.

Integrations > Dotdigital Import Integration > Screen Shot 2020-09-15 at 5.03.10 PM.png

4. (Optional) Preview Your Data

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

The data that displays in the data preview is approximated from your source. It is not the actual data that is imported.

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

5. Define Data Placement

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

Integrations > Dotdigital Import Integration > image-20200615-153436.png

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.