Documentation / Product / Integrations / Dotdigital

Dotdigital: Import Contacts & Activity

By importing your Dotdigital contacts and their activity into Lytics, you'll be able to apply Lytics powerful insights to your email and multichannel campaigns.

Integration Details

This integration uses the Dotdigital APIs to import user data. Once the import is started the workflow will:

  1. Request all address books in the Dotdigital account.
  2. Iterate through the address books and for each:
    1. Get all subscribed contacts in that address book since the last import.
    2. Get all unsubscribed contacts from that address book since the last import.
  3. Get all suppressed contacts from the account since the last import.
  4. Get all campaigns with activity since the last import.
  5. Iterate through the campaigns and for each:
    1. If we haven't received send information on the campaign before, get the campaign's activity.
    2. Get campaign's open activity since last import.
    3. Get campaign's click activity since last import.
    4. Get campaign's bounces and unsubscribes since last import.
  6. Schedule next import.

Data will be imported to the dotmailer_contacts and dotmailer_activity streams.

Fields

The following fields are included in the default mapping of the dotmailer_contacts stream:

NOTE: Dotmailer rebranded to Dotdigital in January 2019. Due to backwards compatiblity issues old field and stream names still use dotmailer.

Source FieldLytics User FieldDescriptionType
emailemail unique idEmailstring
iddm_contact_id unique idDotmailer Contact IDstring
BIRTHDAYbirthdateBirthdatedate
account_iddm_accountidDotmailer Account IDs[]string
address_booksdm_address_booksDotmailer address-book membership[]string
account_id, address_book_id, address_book_statusdm_addressbook_statusStatus by Dotmailer Addressbook IDmap[string]string
epochms()dm_addressbook_status_tsDate of Last Addressbook Status Updatedate
emailTypedm_email_typeDotmailer Email Typestring
optInTypedm_opt_in_typeDotmailer Opt-In Typestring
statusdm_statusDotmailer Statusstring
unsubscribed_address_booksdm_unsubscribed_address_booksDotmailer unsubscribed address-books[]string
emailemaildomainEmail Domainstring
FIRSTNAMEfirst_nameFirst Namestring
GENDERgenderGenderstring
LASTNAMElast_nameLast Namestring

The following fields are included in the default mapping of the dotmailer_activity stream:

Source FieldLytics User FieldDescriptionType
contactIddm_contact_id unique idDotmailer Contact IDstring
emailemail unique idstring
campaign_iddm_campaign_idsDotmailer Campaign IDs[]string
campaign_namedm_campaign_namesDotmailer Campaigns[]string
campaign_namedm_campaigns_clickedDotmailer Campaigns Clicked[]string
campaign_namedm_campaigns_opendedDotmailer Campaigns Opened[]string
campaign_namedm_campaigns_sentDotmailer Campaigns Recieved[]string
valuect(event)dm_clickctDotmailer Click Countint
valuect(event)dm_email_eventDotmailer Email Eventsmap[string]intsum
urldm_email_urlDotmailer URLstring
min(epochms())dm_first_hardbounce_tsDotmailer First Hard Bouncedate
min(epochms())dm_first_softbounce_tsDotmailer First Soft Bouncedate
min(epochms())dm_firstopen_tsDotmailer First Opendate
min(epochms())dm_firstclick_tsDotmailer First Clickdate
valuect(event)dm_hardbounce_ctDotmailer Hard Bounce Countint
valuect(hourofday)dm_hourlyopenDotmailer Hourly Eventsmap[string]intsum
valuect(hourofweek)dm_hourofweekDotmailer Hour of Week Eventsmap[string]intsum
keyworddm_keywordDotmailer Email Keyword[]string
max(epochms())dm_last_hardbounce_tsDotmailer Last Hard Bouncedate
max(epochms())dm_last_softbounce_tsDotmailer Last Soft Bouncedate
max(epochms())dm_lastclick_tsDotmailer Last Clickdate
max(epochms())dm_lastopen_tsDotmailer Last Opendate
valuect(yymm())dm_monthlyDotmailer Opens By Monthmap[string]intsum
valuect(event)dm_openctDotmailer Open Countint
epochms()dm_send_tsDotmailer Last Send Timedate
valuect(event)dm_sendctDotmailer Send Countint
valuect(event)dm_softbounce_ctDotmailer Soft Bounce Countint
max(epochms())dm_unsub_tsDotmailer Unsubscribe Datenumber
emaildomain(email)emaildomainEmail Domainstring
valuect(hash(urlmain(url)))hashedurlsHashed URLs Visitedmap[string]intsum
ipAddressip_addressMost Recent IP Addressstring
max(epochms())last_active_tsLast Activedate
mailClientmail_clientMail Clientstring
mailClientVersionmail_client_versionMail Client Versionstring

Configuration

Follow these steps to set up and configure an import of contacts and activity from Dotdigital into Lytics.

  1. Navigate to the Integrations page and select the Dotdigital tile. Dotdigital Logo
  2. Select Workflows from the menu on the left.
  3. Select Import Contacts & Activity from the list of workflows.
  4. Select the Authorization you would like to use.
  5. From the Keep Updated checkbox, click on the Show Advanced Options tab to expand the advanced configuration.
  6. From the Email Field drop-down, select the field that contains the contact's email.
  7. From the Address Book Status Field drop-down, select the field that contains the address book status. This is used to mark users that have unsubscribed from the account as unsubscribed from their address books. This field must be a map[string]string in the format of [accountID]_[addressBookId]:[status]
  8. From the Fields to Import input, select the fields to import for each contact from Dotdigital.
  9. In the Work Tracking Slug text input, enter a slug to use to track the work. This slug should be unique.
  10. Click the Start Import button to start the work.

Dotdigital Import Contacts and Activity Workflow