Understanding Lytics / Integrations

Dotmailer

This article covers:

Before you begin

You will need your dotmailer API username and password, see the Dotmailer API documentation for instructions on creating an API user.

Authentication

  1. Navigate to the dotmailer integration in the Integrations section of Lytics.

    dotmailer

  2. Navigate to Authorizations.

  3. Click Add new authorization.

  4. In the API Username field, enter your Dotmailer API username.

  5. In the API Password field, enter your Dotmailer API password.

  6. In the Description box, enter a name for your authorization.

  7. Click Authorize.

    authorization

Export contacts

Export a Lytics Audience to a Dotmailer Address Book.

NOTE: Dotmailer is limited to 2000 API calls per hour (less than 1 call/second) some export options will significantly impact API usage.

Summary
FrequencyReal-time
Exports toAddress Book
NameLytics + segment name or custom name
Identifiersemail
Mapped Fieldsno
Segment Exportsnone
Typeadd, remove, unsubscribe
  1. Log into your Lytics account.

  2. Open the Dotmailer integration or click Data > Integrations and select Dotmailer from the integrations list.

  3. Select Export Contacts.

  4. Identify the authorization you would like to use and click Select.

  5. From the Audience dropdown, select the Lytics Audience to export.

  6. From the Email Field dropdown, select the Lytics user field that contains the email to export.

  7. (Optional) From the ID Field drop-down, select the Lytics user field that contains the the dotmailer ID to export. If not included ID Field will default to dotmailer Contact ID (dm_contact_id).

  8. Click > Show Advanced Options to see additional configuration options.

  9. (Optional) From the Address Book Status Field drop-down, select the user field that contains the user's dotmailer status by dotmailer account ID and address-book ID. This field must be a map using the dotmailer account ID underscore the address book ID as the key and a value of "syncing" for the address books that should be updated (ex: "24114_1324":"syncing"). The status will be updated to reflect the contact's status.

    NOTE: If this is selected, the Address book Name text field and the Create Address Book checkbox will be ignored.

  10. (Optional) From the Address Book Name text field, enter a name for the Address Book, or select one from the list. If left blank, Address Book Name will default to Lytics + audience name.

  11. (Optional) If the Create Address Book checkbox is selected, the export will create the address book if it does not already exist.

  12. (Optional) From the Opt-in Type dropdown, select the opt-in type for this contact. See the dotmailer documentation for details on the different options. If not set, Opt-In Type will default to Unknown.

  13. (Optional) From the Email Type dropdown, select the type of emails to send to these contacts. If not set, Email Type will default to HTML.

  14. (Optional) Use the Map Fields input to map Lytics fields on the left to dotmailer data-fields on the right. If not set, only Email, Opt-in type and Email type will be set in dotmailer. NOTE: Complex fields sutch as arrays and maps are not supported by dotmailer and will be dropped.

  15. (Optional) Select the Unsubscribe on exit checkbox to unsubscribe contacts when they leave the audience. Contacts are not resubscribed when they reenter the audience. Default behavior is to remove contacts from the list when they exit the audience. NOTE: Selecting this option will significantly increase dtmailer API usage.

  16. (Optional) Select the Trigger Join Actions checkbox to trigger join actions in dotmailer. Default behavior does not trigger join actions in dotmailer. NOTE: Selecting this option will significantly increase dotmailer API usage.

  17. (Optional) Select the Resubscribe checkbox to resubscribe users to address-books. If Trigger Join Actions is not selected only users who are unsubscribed at the account level will be resubscribed.

  18. Click Start Export.

Contacts should be available in the dotmailer Address Book within a few minutes of starting the work. Larger audiences may take a few hours to be completely added to the Address Book.

Import contacts and activity

Import all contacts and email activity data.

Summary
FrequencyHourly
Streamsdotmailer_contacts, dotmailer_activity
User fieldsemail, first_name, last_name, email type, email opt-in, custom fields
Provider fieldscontact ID
User activitysends, opens, clicks
Campaign contentno
Click URL paramnone
  1. Log into your Lytics account.

  2. Open the Dotmailer integration or click Data > Integrations and select Dotmailer from the integrations list.

  3. Select Import Contacts & Activity.

  4. Identify the authorization you would like to use and click Select.

  5. (Optional) If Keep Updated is selected, Lytics will continually import contact and activity data.

  6. Click the Show Advanced Options button to see additional configuration options.

  7. (Optional) From the Email Field dropdown, select the lytics field containing the contact's email address.

  8. (Optional) From the Address Book Status Field dropdown, select the lytics field containing the contact's address book status. This field must be KIND map[string]string using the dotmailer account ID underscore the address book ID as the key (ex: "24114_1324":"subscribed").

  9. Click Start Import.

Contact data should be available in the account within an hour.

NOTE: Both the Email Field and Address Book Status Field need to be selected for Lytics to be able to update the address book membership when a contact is suppressed from your dotmailer account. If these fields are not set, the account status will be updated, but the address books' status will remain unchanged. Using default LQL the email field and the dm_addressbook_status field respectivly fill these requirements.