Documentation / Product / Integrations / Salesforce / Salesforce Marketing Cloud

Salesforce Marketing Cloud: Export to Data Extension

Exporting a Lytics audience to Salesforce Marketing Cloud data extensions allows you to send email, push notifications, or SMSs to your users based on your own, relevant targeting criteria, such as cross-channel behavior, content affinities, and more.

Integration Details

  • Implementation Type: Server-side.
  • Implementation Technique: REST API and SOAP API.
  • Frequency: Batch (continuous update by default).
  • Resulting data: Data pushed to a Marketing Cloud data extension.

This integration utilizes both the Marketing Cloud REST and SOAP APIs to push a Lytics Audience to a data extension in Marketing Cloud.

  1. When a new work is started, a new Marketing Cloud data extension is created with a single column containing the selected identifier field, usually email or Marketing Cloud subscriber key. The new data extension is named with the Lytics audience slug, prefixed with Lytics_.
  2. That selected ID for the users in the Lytics audience will be continually updated in the data extension, with IDs being added or removed by calling a DataExtensionObject remove call as users enter/exit the audience.
  3. When exporting to an existing data extension, all Lytics fields that you map to data extension fields through the Lytics UI will be populated when available.

Fields

There are no default fields exported into the data extension. If you are creating a new data extension, you will select a field to be the Marketing Cloud subscriber key. Usually email or the Marketing Cloud subscriber key is selected as the identifier. If you are exporting to an existing data extension, you will map the Lytics fields to your data extension fields during the configuration.

Configuration

Follow these steps to set up and configure an export of a Marketing Cloud Data Extension in the Lytics platform.

  1. Navigate to the Integrations page and select Salesforce Marketing Cloud. sfmc tile
  2. Select Workflows from the menu on the left.
  3. Select Export to Data Extension from the list of Workflows.
  4. Select the authorization you would like to use.
  5. Use the Audiences dropdown to select the Lytics audience that contains the users that you would like to export to Salesforce Marketing Cloud.
  6. Using the Data Extension Name dropdown, select New Data Extension if you would like to export to a new data extension. If you would like to export to an existing data extension, select the name of the data extension from the drop down list.
  7. Use the Subscriber Key Field dropdown to select the key field to export to the data extension. This can be used to join the data extension. NOTE: This field must also be mapped as described in the next step and shown in the image below.
  8. If you are exporting to an existing data extension, use the Map Fields section to map Lytics fields on the left, to your data extension fields on the right. NOTE: If you have selected New Data Extension, there will be no mappable fields since they do not exist in the Data Extension yet. marketing cloud mapping
  9. Select the Existing Users checkbox if you want to add users who already exist in the selected Lytics audiences.
  10. Click Start Export. marketing cloud export full

User subscriber keys should be available in the Marketing Cloud data extension within a few minutes of starting the export.