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

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

  1. Open TD Console.

  2. Navigate to Integrations Hub >  Catalog.

  3. Search for and select Dotdigital.

  4. The New Authentication dialog opens.


  5. Select your Region. The API User Name and API User Password fields auto-populate.

  6. Select Continue.

  7. Enter a name for your connection.

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

Create a Source

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

1. Create a Connection

  1. Type a name for your source in the Data Transfer Name field.


  2. Select Next. The Source Table dialog opens.

2. Create a Source Table


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


  1. Select Next. The Data Settings page opens.

3. (Optional) Define Data Settings

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

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.

  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.

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


  • No labels