# 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](https://toolbelt.treasuredata.com/).
- 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=/](https://login.dotdigital.com/login.aspx?ReturnUrl=/).
2. Navigate to [https://r1-app.dotdigital.com/access/api](https://r1-app.dotdigital.com/access/api) and go to tab: **API users**


![](/assets/screen-shot-2020-08-25-at-9.59.48-pm.ab8ae1140f18c142aa9706cd87d4c0926610da1d2c6422b78d310ac782d5b7ec.3a5b66e1.png)
3. Select **New user.** DotDigital provides you with an email address. Complete the form by adding and confirming a password; a description is optional.

![](/assets/screen-shot-2020-08-25-at-10.04.11-pm.c5b80b12d82e096dd55327a4ed2cdc22f47867d8679a81211ed4aec33d81432e.3a5b66e1.png)
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.

![](/assets/screen-shot-2020-09-15-at-4.22.13-pm.4c757f85087d3a4b4b60f7ee08ef5115ae43cf499b1649292ae00cb05197cbd0.3a5b66e1.png)

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

![](/assets/dotdigital-import-integration-2024-10-29-2.0f7b25496146fe194946fd28102dde31b93aa2d08b4390a0849e445c39876b62.3a5b66e1.png)

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

| Parameters | Description |
|  --- | --- |
| 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 Page** | Page 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 Visibility** | Choose among:- **All**. Read from all address books
- **Public**. Only read from public address books
- **Private**. Only read from private address books

 |
| **With Full Data** | Enable this option to load all dataFields from the contact record |
| **Incremental Loading** | Enables 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.

![](/assets/screen-shot-2020-09-15-at-5.03.10-pm.c5a287eb59de65e1704ca874753e77593ae8dbcaa10150376ae7619edf4d17a4.3a5b66e1.png)

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


![](/assets/screen-shot-2020-09-15-at-5.04.37-pm.6a485701082937975eb1472a444d3f1e324dc2084a55d62f77669a766b3a8f0e.3a5b66e1.png)
4. Select **Next**.

### Define Data Placement

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

![](/assets/image-20200615-153436.ab0982b2e01dc0eaff9b732ea3686b98771af3b92b56da23db3d0243df2d9525.3a5b66e1.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**.