Documentation / Product / Integrations / Salesforce / Salesforce Marketing Cloud

Salesforce Marketing Cloud: Import Subscriber and Activity

Importing subscribers and activity data from Marketing Cloud results in new users or existing user profiles supplemented with Marketing Cloud campaign activity data. You can use this data to build and refine your existing Lytics audiences to power better, cross-channel campaigns.

Integration Details

This integration utilizes both the Marketing Cloud REST and SOAP APIs to pull in subscriber and event data.

  1. Every hour the workflow will scan for new subscribers via the SOAP retrieve call for SubscriberList to pull in new subscribers for the imported lists and written to the sfmc_subscribers data stream in Lytics.
  2. If importing subscriber attributes is selected, full Subscriber is retrieved and written to the sfmc_subscribers data stream in Lytics. Note: subscriber attributes are only imported on the initial import, or if the subscriber list membership is updated. If list subscription is not updated, Lytics will not get new subscriber attribute updates.
  3. Every hour, if activity data import is selected, activity data since the last run is retrieved through the SOAP retrieve endpoints for each of the following events, BounceEvent, ClickEvent, ForwardEmailOptInEvent, FowardEmailEvent, OpenEvent, SentEvent, SurveyEvent, and UnsubEvent. All activity data is written to the sfmc_events data stream in Lytics.
  4. If historical subscriber or activity data is selected to be imported, the above calls are repeated for a days worth a data at a time, going backward in time, until all selected historical data is imported.

Fields

sfmc_events fields

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

Source FieldLytics User FieldDescriptionType
subscriber_keysfmc_subscriber_keys unique id[]string
channelsAll Channels Used[]string
urlhashedurlsHashed Urls Visitedmap[string]intsum
last_active_tsLast Activedate
last_channel_activitiesLast Activity By Channelmap[string]time
bounce_categorysfmc_bounce_categorySFMC Bounce Categorystring
bounce_typesfmc_bounce_typeSFMC Bounce Typestring
campaign_namesfmc_campaign_nameSFMC Campaign Namestring
urlsfmc_click_urlsSFMC Urls Clicked on[]string
event_typesfmc_clickctSFMC Click Countint
event_typesfmc_eventsmap[string]intsum
sfmc_firstclick_tsSFMC First Clickdate
sfmc_firstopen_tsSFMC First Opendate
sfmc_hourlyopenSFMC Hourly Opensmap[string]intsum
sfmc_hourofweekSFMC Hour of Week Eventsmap[string]intsum
sfmc_lastclick_tsSFMC Last Clickdate
sfmc_lastopen_tsSFMC Last Opendate
list_namesfmc_list_nameSFMC List Namestring
event_typesfmc_openctSFMC Open Countint
opt_in_sub_keysfmc_opt_in_sub_keySFMC Forward Opt-Instring
send_idsfmc_send_idSFMC Send IDstring
event_typesfmc_sendctSFMC Send Countint
smtp_reasonsfmc_smtp_bounce_reasonSFMC SMTP Bounce Reasonstring
survey_answersfmc_survey_answerSFMC Survey Answerstring
survey_questionsfmc_survey_questionSFMC Survey Questionstring
sfmc_unsub_tsSFMC Unsub datedate
sfmc_yymmSFMC Opens By Monthmap[string]intsum
send_idtotal_clicks_by_messageThe number of clicks for a messagemap[string]intsum
send_idtotal_opens_by_messageThe number of opens for a messagemap[string]intsum

sfmc_subscribers fields

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

Source FieldLytics User FieldDescriptionType
subscriber_keysfmc_subscriber_keys unique id[]string
emailemail unique idstring
subscriber_idsfmc_subscriber_ids unique id[]string
emailemaildomainEmail Domainstring
business_idsfmc_business_idSFMC Business IDstring
business_namesfmc_business_nameSFMC Business Namestring
created_datesfmc_created_dateSFMC Created Datedate
list_id, statussfmc_list_ids_statusSubscription Status by List IDmap[string]string
list_name, statussfmc_list_name_statusSubscription Status by List Namemap[string]string

Configuration

Follow these steps to set up and configure an import of Marketing Cloud subscriber data and activity into the Lytics platform.

  1. Log into your Lytics account.

  2. Open the Salesforce Marketing Cloud integration or click Data > Integrations and select Salesforce Marketing Cloud from the integrations list. (If you have previously authenticated select New Workflow).

  3. Select Import Subscribers and Activity.

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

  5. Select what data you would like to import from Salesforce Marketing Cloud, Subscribers and/or Activity.
    sfmc standard import

  6. Click to > Show Advanced Options to reveal additional integration settings.

    • Business Units: Use this input to select a set of Salesforce Marketing Cloud business units to import. Business unit available to be imported from Salesforce Marketing Cloud are located in the left column. Business units added to the right column will be imported into Lytics. Leave the right column empty to import from all business units. Depending on your authorization settings, leaving empty may cause the import to pull in the All subscriber list from Salesforce Marketing Cloud. To ensure importing from only the business units available to the selected authorization, you must select all the listed business units.
      sfmc business units
    • Get Custom Subscriber Attributes: Check this box if you have custom subscriber attributes to import. This will cause your imports to take a longer time.
    • Subscriber Backfill Start Date: Use in conjunction with Subscriber Backfill End Date to import a set of subscribers who already exist in Salesforce Marketing Cloud. Enter a date string, for example 2019-05-11, in the text box. All subscribers created beginning on this date until the end date will be imported into Lytics.
    • Subscriber Backfill End Date: Use in conjunction with Subscriber Backfill Start Date to import a set of subscribers who already exist in Salesforce Marketing Cloud. Enter a date string, for example 2019-05-11, in the text box. All subscribers created before this date but after the start date will be importing into Lytics.
      sfmc subscriber backfill
    • Activity Backfill Start Date: Use in conjunction with Activity Backfill End Date to import a set of activity data that already exists in Salesforce Marketing Cloud. Enter a date string, for example 2019-05-11, in the text box. All activity recorded beginning on this date until the end date will be importing into Lytics. NOTE: Importing more than 6 months of activity data can slow down processing time with little actionable benefit.
    • Activity Backfill End Date: Use in conjunction with Activity Backfill Start Date to import a set of activity data that already exists in Salesforce Marketing Cloud. Enter a date string, for example 2019-05-11, in the text box. All activity recorded before this date but after the start date will be importing into Lytics.sfmc activities select
    • Activities: Use this input to select a subset of Salesforce Marketing Cloud activities to import. In most cases you can leave the right column empty to import all activities. Activities in left column are Salesforce Marketing Cloud activities available to import. Activities in the left column will be imported into Lytics. NOTE: In large accounts importing all activities, particularly Opens may cause the activity import to not keep up in real time.sfmc activities select
  7. Click Start Import.

Salesforce Marketing Cloud data should start populating in Lytics within a few minutes.