dotdigital V2
dotdigital ETL connector for data replication
Snapshot
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 Account Username Dotdigital Account Password Dotdigital Region |
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 | CampaignsClicksAndLinkGroups |
Programs | Surveys |
ContactsScoring | ContactsDataFields |
DocumentFolders | ImageFolders |
ProductRecommendations | SmsCampaigns |
Templates
Integrate DotDigital with Daton
Signin to Daton
Select DotDigital from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide DotDigital region id, DotDigital api user email and Password to authorize Daton to periodically extract data from DotDigital
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
DotDigital Data
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
Source API Documentation: https://developer.dotdigital.com/reference/campaigns#get-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
Source API Documentation: https://developer.dotdigital.com/reference/campaigns#get-campaign-opens
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
contactId | INTEGER |
STRING | |
mailClient | STRING |
mailClientVersion | STRING |
ipAddress | STRING |
userAgent | STRING |
isHtml | BOOLEAN |
isForward | BOOLEAN |
dateOpened | TIMESTSMP |
Segments
Purpose: Gets all segments
Source API Documentation: https://developer.dotdigital.com/reference/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 |
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 |
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 |
CampaignsClicksAndLinkGroups
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
| fullname | type |
|---|---|
contactId | NUMERIC |
STRING | |
url | STRING |
ipAddress | STRING |
userAgent | STRING |
dateClicked | TIMESTAMP |
keyword | STRING |
_daton_user_id | NUMERIC |
_daton_batch_runtime | NUMERIC |
_daton_batch_id | NUMERIC |
Campaign_Id | STRING |
Programs
Purpose: Gets all programs
Source API Documentation: https://developer.dotdigital.com/reference/programs#get-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 |
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
Source API Documentation: https://developer.dotdigital.com/reference/sms#copy-sms-campaign
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
Source API Documentation: https://developer.dotdigital.com/reference/survey-and-forms#get-surveys
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
Source API Documentation: https://developer.dotdigital.com/reference/templates#get-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 updated