DotDigital
DotDigital ETL connector for data replication
Features | Details |
Release Status | Released |
Source API Version | v2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Dotdigital region id
Dotdigital Api user email
Dotdigital api user password |
Replication Type | Key Based Replication
Full-based Replication |
Replication Key | Date
NA |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | |
AddressBooks | Campaigns |
CampaignSummary | CampaignOpens |
Segments | Contacts |
CampaignActivity | CampaignsClicks |
Programs | Surveys |
ContactsScoring | ContactsDataFields |
DocumentFolders | ImageFolders |
ProductRecommendations | SmsCampaigns |
Templates
- 1.Signin to Daton
- 2.Select DotDigital from Integrations page
- 3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide DotDigital region id, DotDigital api user email and Password to authorize Daton to periodically extract data from DotDigital
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
AddressBooks
Purpose: Gets all address books
Source API Documentation: https://developer.dotdigital.com/reference/address-books#get-address-books
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
visibility | STRING |
contacts | INTEGER |
Campaigns
Purpose: Gets all campaigns
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
subject | STRING |
fromName | STRING |
fromAddress | RECORD |
htmlContent | STRING |
plainTextContent | STRING |
replyAction | STRING |
replyToAddress | STRING |
isSplitTest | BOOLEAN |
status | STRING |
CampaignSummary
Purpose: Gets a summary of reporting information for a specified campaign
Source API Documentation: https://developer.dotdigital.com/reference/campaigns#get-campaign-summary
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
dateSent | TIMESTAMP |
numUniqueOpens | NUMERIC |
numUniqueTextOpens | NUMERIC |
numTotalUniqueOpens | NUMERIC |
numOpens | NUMERIC |
numTextOpens | NUMERIC |
numTotalOpens | NUMERIC |
numClicks | NUMERIC |
numTextClicks | NUMERIC |
numTotalClicks | NUMERIC |
numPageViews | NUMERIC |
numTotalPageViews | NUMERIC |
numTextPageViews | NUMERIC |
numForwards | NUMERIC |
numTextForwards | NUMERIC |
numEstimatedForwards | NUMERIC |
numTextEstimatedForwards | NUMERIC |
numTotalEstimatedForwards | NUMERIC |
numReplies | NUMERIC |
numTextReplies | NUMERIC |
numTotalReplies | NUMERIC |
numHardBounces | NUMERIC |
numTextHardBounces | NUMERIC |
numTotalHardBounces | NUMERIC |
numSoftBounces | NUMERIC |
numTextSoftBounces | NUMERIC |
numTotalSoftBounces | NUMERIC |
numUnsubscribes | NUMERIC |
numTextUnsubscribes | NUMERIC |
numTotalUnsubscribes | NUMERIC |
numIspComplaints | NUMERIC |
numTextIspComplaints | NUMERIC |
numTotalIspComplaints | NUMERIC |
numMailBlocks | NUMERIC |
numTextMailBlocks | NUMERIC |
numTotalMailBlocks | NUMERIC |
numSent | NUMERIC |
numTextSent | NUMERIC |
numTotalSent | NUMERIC |
numRecipientsClicked | NUMERIC |
numDelivered | NUMERIC |
numTextDelivered | NUMERIC |
numTotalDelivered | NUMERIC |
percentageDelivered | NUMERIC |
percentageUniqueOpens | NUMERIC |
percentageOpens | NUMERIC |
percentageUnsubscribes | NUMERIC |
percentageReplies | NUMERIC |
percentageHardBounces | NUMERIC |
percentageSoftBounces | NUMERIC |
percentageUsersClicked | NUMERIC |
percentageClicksToOpens | NUMERIC |
CampaignOpens
Purpose: Gets a list of campaign opens
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
contactId | INTEGER |
email | STRING |
mailClient | STRING |
mailClientVersion | STRING |
ipAddress | STRING |
userAgent | STRING |
isHtml | BOOLEAN |
isForward | BOOLEAN |
dateOpened | TIMESTSMP |
Segments
Purpose: Gets all segments
Replication: Key-Based Replication
Replication Key: Modified_Time
Fields
Name | Target Datatype |
id | STRING |
name | RECORD |
contacts | RECORD |
Contacts
Purpose: Gets a list of created contacts after a specified date
Source API Documentation: https://developer.dotdigital.com/reference/contacts#get-contacts-created-since-date
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
id | STRING |
email | NUMERIC |
optInType | RECORD |
emailType | STRING |
dataFields | STRING |
status | RECORD |
CampaignActivity
Purpose: Gets a list of contacts who were sent a campaign, with their activity
Source API Documentation: https://developer.dotdigital.com/reference/campaigns#get-campaign-activity
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
contactId | RECORD |
email | STRING |
numOpens | STRING |
numPageViews | STRING |
numClicks | STRING |
numForwards | STRING |
numEstimatedForwards | STRING |
numReplies | STRING |
dateSent | STRING |
dateFirstOpened | STRING |
dateLastOpened | STRING |
firstOpenIp | STRING |
unsubscribed | STRING |
softBounced | STRING |
hardBounced | STRING |
CampaignsClicks
Purpose: Gets a list of link clicks for a campaign after a specified date
Source API Documentation: https://developer.dotdigital.com/reference/campaigns#get-campaign-clicks-since-date
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
contactId | INTEGER |
email | STRING |
url | STRING |
ipAddress | STRING |
userAgent | STRING |
dateClicked | TIMESTAMP |
keyword | STRING |
Programs
Purpose: Gets all programs
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
name | STRING |
status | STRING |
dateCreated | TIMESTAMP |
ContactsScoring
Purpose: AGets contact scoring for all contacts in the account
Source API Documentation: https://developer.dotdigital.com/reference/contacts#get-scoring-for-contacts
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
contactId | STRING |
email | RECORD |
dateModified | RECORD |
scoreLabel | STRING |
score | STRING |
engagement | STRING |
suitability | STRING |
ContactsDataFields
Purpose: Lists all contact data fields within the account
Source API Documentation: https://developer.dotdigital.com/reference/contact-data-fields#get-contact-data-fields
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
name | BOOLEAN |
type | RECORD |
visibility | STRING |
defaultValue | STRING |
Description | STRING |
DocumentFolders
Purpose: Fetches the document folder tree structure
Source API Documentation: https://developer.dotdigital.com/reference/document-folders#get-document-folders
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
childFolders | RECORD |
ImageFolders
Purpose:Fetches the campaign image folder tree structure
Source API Documentation: https://developer.dotdigital.com/reference/image-folders#get-image-folders
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
childFolders | RECORD |
ProductRecommendations
Purpose: Gets all product recommendations
Source API Documentation: https://developer.dotdigital.com/reference/product-recommendations#get-all-product-recommendations-1
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
dateLastRefreshed | TIMESTAMP |
dateModified | TIMESTAMP |
dateLastUsed | TIMESTAMP |
name | STRING |
type | STRING |
status | STRING |
fallbackRecommendationId | NUMERIC |
revenue | NUMERIC |
SmsCampaigns
Purpose: Returns existing SMS campaigns
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
message | STRING |
sendingIdentityId | STRING |
sendingIdentity | STRING |
status | STRING |
toggleShortLinks | STRING |
Surveys
Purpose: Gets a list of all surveys in the account
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
url | STRING |
dateSurveyCreated | TIMESTAMP |
dateSurveyModified | TIMESTAMP |
state | STRING |
firstActiveDate | TIMESTAMP |
lastInactiveDate | TIMESTAMP |
scheduledStartDate | TIMESTAMP |
scheduledEndDate | TIMESTAMP |
confirmationMode | STRING |
submissionMode | STRING |
fieldCount | NUMERIC |
notifyCreatorOnResponse | BOOLEAN |
respondentNotificationType | STRING |
respondentNotificationCampaignId | STRING |
isAssignedToAddressBook | BOOLEAN |
assignedAddressBookTarget | STRING |
assignedSpecificAddressBookId | STRING |
firstResponseDate | STRING |
lastResponseDate | STRING |
totalCompleteResponses | NUMERIC |
totalCompleteResponsesInLastDay | NUMERIC |
totalCompleteResponsesInLastWeek | NUMERIC |
totalIncompleteResponses | NUMERIC |
totalViews | NUMERIC |
totalBounces | NUMERIC |
timeToCompleteMax | NUMERIC |
timeToCompleteMin | NUMERIC |
timeToCompleteTotal | NUMERIC |
sourceDirectTotal | NUMERIC |
sourceEmailTotal | NUMERIC |
sourceEmbeddedTotal | NUMERIC |
sourcePopoverTotal | NUMERIC |
sourceFacebookTotal | NUMERIC |
sourceTwitterTotal | NUMERIC |
sourceGooglePlusTotal | NUMERIC |
sourceOtherTotal | NUMERIC |
Templates
Purpose: Gets list of all templates
Replication: Full-Based Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
subject | STRING |
fromName | STRING |
htmlContent | STRING |
plainTextContent | STRING |
replyAction | STRING |
replyToAddress | STRING |
Last modified 3yr ago