Salesforce Marketing Cloud destination

Prerequisites for setting up Salesforce Marketing Cloud Loader

1. The first step is to set up the loader within Meiro Integration by following the instructions given in this article.

After you finalize the first step, you can proceed with the following:

2. Connect Meiro CDP to Salesforce Marketing Cloud. Described here.

3. Grant API access to the user profile on Salesforce Marketing Cloud. Follow instructions on how to do this.

4. Set up the loader as a destination in CDP below in this article.

5. Proceed with exporting segmented customer profiles to the destination. Refer to this part of the article.

7. Obtain the URI from the Meiro team. Grant Meiro with the following access and click “Save”.

• Email: Read, Write
• Web: Read, Write
• Automations: Read, Write, Execute
• Journeys: Read
• List And Subscribers: Read, Write
• Data Extensions: Read, Write
• Tracking Events: Read
• Webhooks: Read, Write  

Destination ID

(required, not editable)

"The Destination ID" is a numeric value that analysts will refer to within the Meiro Integrations environment. After you choose the ID, it will not be possible to change it later on.

Find the right workspace in Meiro Integrations and check Destination ID:

Insert Destination ID in the Meiro Business Explorer.

Name (required)

The name will be visible across the Meiro Business Explorer for the users (Data library/ Destination tab, segment detail)

Description (optional)

It is possible to add a description to the destination. The description will be displayed for use in the Data library/ Destination tab.

Icon (required)

The icon will be visible across the Meiro Business Explorer for the users (insights, Data Library/  Attributes, Sources and Destinations tabs,  segments, and customer profiles).

Exported & Mandatory   attributes

(required)

"Exported attributes" - values of exported attributes will be sent to the dedicated Meiro Integrations workspace, then to the destination. "Mandatory attributes" all customers in the export must have those attributes' values known.
 

For Salesforce Marketing Cloud exported & mandatory attributes are custom per client. For more information, reach out to the Meiro team.

Meiro Integrations

(required)

"MI workspace" refers to the workspace in Meiro Integration which will be executed when the segment is exported.

To run exports you need to know the name of the workspace. You should get the name of the respective workspace from the Meiro data analyst.

Meiro data analyst takes care of the Meiro Integration's workspace preparation, and data transformation for a specific destination (e.g. Facebook, Twitter, Google Analytics). Each destination requires a different (very specific) data structure.

Parameter: 

Data Extension Key

(required)

Meiro Integrations Key (required):  data_extension_key

It is set up by analysts and needs to be the same key as in workspace variables in Meiro Integrations.

Name (required): Data Extension Key

The name will be displayed for the user in the segments export parameter section.

Required field (checkbox): ticked

This field is required to be filled in to export to Salesforce.

Value from the list (checkbox): _{not ticked}

Ticked makes a possible selection from the value drop-down list. Unticked disables drop-down list.

User input (checkbox):  ticked

This field is required to be filled in to export to Salesforce.

Warning: The fields in the data extension have size limits that can be defined. If any value exceeds the size limit on the field, it will fail the whole export! For email and phone number fields, if any value fails the validation from Salesforce Marketing Cloud, the whole export will fail. Do validate the fields before sending them.

Learn more: about data extension limits from the Salesforce documentation.

5. Fill in the information and select the relevant data retention policy required for your use case. 

Learn more: about Data Retention Policy

6. Add in all the fields that are set on Meiro CDP Salesforce Marketing Cloud destination. Click “Create”.

Warning: All fields have to be added to the data extension otherwise it will result in an error.

Example:

4. Fill in the information and select the relevant data retention policy required for your use case. 

Learn more: about Data Retention Policy

Warning: The fields in the data extension have size limits that can be defined. If any value exceeds the size limit on the field, it will fail the whole export! For email and phone number fields, if any value fails the validation from Salesforce Marketing Cloud, the whole export will fail. Do validate the fields before sending them.

5. Add in all the fields that are set on Meiro CDP Salesforce Marketing Cloud destination. Click “Create”

Warning: All fields have to be added to the data extension otherwise it will result in an error.

Exportable shows how many customers will be exported to your destination.

This number is defined by the conditions you choose to segment the audience but also by mandatory attributes that have been set up by the administrator (that must be present to export to your destination).

For example, if you segment 1000 profiles but only 10 profiles have mandatory attributes present, only those 10 will be exported to your destination.

Mandatory attributes are visible in the Data Library/ Destinations tab and are to be defined according to the use cases.

Parameters

Data Extension Key (required)

Data extension key can be obtained as described above in chapter 1. 

New data extension in Salesforce Marketing Cloud and export setting in Meiro

Load is incremental (to the data extension indicated in the export settings), the primary key is an email.

Warning: The fields in the data extension have size limits that can be defined. If any value exceeds the size limit on the field, it will fail the whole export! For email and phone number fields, if any value fails the validation from Salesforce Marketing Cloud, the whole export will fail. Do validate the fields before sending them.

Is the load overwriting the content or incremental?

Load is incremental (to the data extension indicated in the export settings), the primary key is an email.

If changes need to be made to the data extension, it can be done within the Salesforce Marketing Cloud.

How long does it take to load the data from Meiro to Salesforce?

Exported data can be seen in the Salesforce Marketing Cloud almost immediately.