Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Schema Information of DotDigital Connector

This topic provides a structured reference to assist you in working with Daton's DotDigital connector and the associated fields and tables.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      Schema Information of DotDigital Connector

      This topic provides a structured reference to assist you in working with Daton's DotDigital connector and the associated fields and tables.

      Tables/APIs

      The following is the list of tables or APIs associated with the DatonDigital connector:
      • AddressBooks
      • Campaigns
      • CampaignSummary
      • CampaignOpens
      • Segments
      • Contacts
      • CampaignActivity
      • CampaignsClicks
      • Programs
      • ContactsScoring
      • ContactsDataFields
      • DocumentFolders
      • ImageFolders
      • ProductRecommendations
      • SmsCampaigns
      • Surveys
      • Templates

      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
      email
      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
      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
       
      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
      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
       
      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
      connector information dotdigital schema

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • How to Integrate Daton Docs with Daton
      • Essential Attributes and Supported Tables

      Table of Contents

      Tables/APIs DotDigital Data

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand