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

Integrate DotDigital with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select DotDigital from Integrations page
  3. 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. 4.
    Provide DotDigital region id, DotDigital api user email and Password to authorize Daton to periodically extract data from DotDigital
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    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
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
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
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
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
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
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
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
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
Replication: Full-Based Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
name
STRING
childFolders
RECORD
ProductRecommendations
Purpose: Gets all product recommendations
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 1yr ago