vDotdigital 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 write job results from Treasure Data directly to Dotdigital.
Basic knowledge of Treasure Data, including the TD Toolbelt.
An account in Dotdigital.
An API account in Dotdigital.
Treasure Data does not create a campaign.
A transactional email action does not count over the rate limit of API calls.
As per the rate limit of dotdigital API (https://developer.dotdigital.com/docs/getting-started-with-the-api#restrictions): one Upload bulk contacts action requires two API calls, which count into the overall rate limit.
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.
Create a New Connection with TD Console
In Treasure Data, you must create and configure the data connection, to be used during export, prior to running your query. As part of the data connection, you provide authentication to access the integration.
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.
Enter a name for your connection.
Configure Export Results in Your Data Connection
Next, you need to create or reuse a query. In the query, you configure the data connection. You might need to define the column mapping in the query.
Configure the Connection by Specifying the Parameters
Open the TD Console.
Navigate to Data Workbench > Queries.
Select the query that you plan to use to export data.
Run the query.
Select Export Results located at top of your query editor.
The Choose Integration dialog opens.
You have two options when selecting a connection to use to export the results:
Use an existing connection:
Type the connection name in the search box to filter.
Select your connection.
Create a new Dotdigital connection
Complete the field values to create a new connection.
Type the required credentials for your new dotdigital connection. Set the following parameters.
There are two different ways to move data:
The ID of the triggered campaign.
JSON Personalization Columns
The JSON columns names, separated by commas.
Ignore Invalid Records
Ignore invalid records and complete the job.
Address Book ID
Address book ID to add contacts.
Add to Address Book
Add to address book.
The following merge options are available:
Example of a Query to Populate Dotdigital
From Treasure Data, run the following query, and export results into a connection for Dotdigital. Transactional emails use case-sensitive column names while bulk contacts use case-insensitive column names.
Transactional Emails Query
Bulk Contacts Query
Optional: Use of Scheduled Jobs for Export
You can use Scheduled Jobs with Result Export, to periodically write the output result to a target destination that you specify.
Optional: Configure Export Results in Workflow
Within Treasure Workflow, you can specify the use of this data connector to export data.
Example Workflow Exporting Transactional Email
Example Workflow Exporting Bulk Contacts
For more information on using data connectors in a workflow to export data, see Using Workflows to Export Data with TD Toolbelt.