This integration lets Fresh Relevance upload contact data to Salesforce Marketing Cloud and trigger email sends.
You configure lists or data extensions, emails, and interactions in Salesforce Marketing Cloud, then connect them in Fresh Relevance.
The setup requires configuration in both platforms.
Before you start
Things you need to know:
You must have:
Login details to Fresh Relevance.
Login details to a Salesforce Marketing Cloud account, with permission to create Data Extensions, Lists, Emails, Data Fields, Users and Interactions.
Decide where you want Fresh Relevance data loaded (see the relevant section below). Note that you will require a List regardless of which option you choose, but this can be an existing one.
Understand the required components
The integration requires:
A List or Data Extension in Salesforce Marketing Cloud
An email in Salesforce Marketing Cloud
An Interaction or Journey Builder setup
A Salesforce Marketing Cloud API user
A messaging channel in Fresh Relevance
A trigger program in Fresh Relevance
Check the email address field name
Be aware of the email address field name in the Data Extensions/Lists you plan to use (or create) in Salesforce Marketing Cloud, for example "email" or "email address", because you must use the exact same name whenever these instructions refer to the email address field.
Upload data to Salesforce Marketing Cloud
Fresh Relevance can upload data into different locations within Salesforce Marketing Cloud:
a List
a Data Extension
Most accounts use a Data Extension.
Learn more in Salesforce's HelpCentre.
Load Data to a Data Extension
Login to Salesforce Marketing Cloud.
Select Email under Email Studio.
Hover over Subscribers in the top menu and then select Data Extensions.
Select Create > Standard Data Extension, then select OK.
Select Create, set the Creation Method to Create from Template, choose TriggeredSendDataExtension and select OK.
Enter a name for the Data Extension (something obvious is recommended), and for an external key (without spaces ideally) and select Next.
Configure data retention if required.
Select the Fields tab.
Confirm these fields exist (this may vary based on your account's setup):SubscriberKey
EmailAddress
SubscriberKey - Text - 254 - (Should already be present)
EmailAddress - EmailAddress - 254 - (Should already be present)
To upload other data, you can add additional fields and these then need to be added to the Field Mapping within Fresh Relevance.
To do this, in Fresh Relevance, expand the User menu, then go to Settings > Triggers and Messaging integrations > Messaging Providers. Then select field mappings next to the relevant channel.
Select the Send Relationship setting.
Choose the correct relationship option.
EmailAddress relates to subscribers on Email Address
EmailAddress relates to subscribers on Subscriber Key (if your Salesforce Marketing Cloud account is setup with a primary key other than email address)
The first option is generally the most common scenario.
The send relationship setting will be dependent on your Salesforce Marketing Cloud account setup as well as the Fresh Relevance data you wish to use to identify a recipient when sending. Contact support should you need any assitstance or have a query about this.Select Create.
Load Data to a List
Login to Salesforce Marketing Cloud.
Hover over Subscribers in the top menu and select Lists.
Create a folder if required.
You can do this by right-clicking on an existing folder and selecting New Folder. Type in a name and select Enter to save it.
Select Create, and complete the Name and External Key fields, then select a folder to save the list inside if required:
Select Save.
Create an email to send
The main email body will typically sit within Salesforce Marketing Cloud, allowing you to build it as you would any other email campaign and to use existing templates. The cart content can then be pulled into this email to display the personalized content for the recipient.
You may wish to create a new folder to store your email(s) in, to do this, right-click on the Content Builder folder, or any sub-folder, and select Create Folder.
Select Content in the top menu.
Select Create > Email Message.
Expand the Create Email drop-down menu, then select the appropriate option for how you wish to create the email, for example, from a template, using HTML.
Name your email, for example, Cart Abandon Stage 1.
Select the location you wish to save your email, for example, the folder you may have created earlier
Optional: add URL parameter values to one of the Parameter fields if these are required (and the fields are exposed, only Salesforce Marketing Cloud can enable these). See the Campaign-based ID instructions for more details.
Select Next and build the email. See the section below on including cart content to show carted/browsed/purchased products
Once complete, select Next and perform a test send.
At this stage you may see an error.
One reason for this may depend on the list/Data Extension you select and the name of the email field entered in your AMPScript to merge in the cart contents. Check the two values match exactly. In the example below, the field is called EmailAddress in the AMPScript, but it should be Email Address.
Select Save and Exit. Once you are happy, the email renders as intended.
Include the Cart Layout in your Cart/Browse Abandonment messages
The approach for this depends on your messaging provider.
To merge the carted/browsed/purchased items you can use AMPScript. Copy the following and paste into the HTML of your email template at the point where you want the cart to be shown.
When the abandoned cart email is sent, fetches the cart contents from Fresh Relevance and merges them into the email.
Example cart merge AMPScript
Insert AMPScript where cart content should appear.
Example:
%%[
Set @url = Concat(
'https://c8.dycdn.net/[website ID]/content/email/?k=[key]&f=cart_html&e=', URLEncode([EmailAddress],1,1)
)
]%%
%%=HTTPGet(@url)=%%
Be aware of the email field name
Make sure the final "email" matches your email address field name.
For example, if your email address field name is "email address", use the following:
Example AMPScript with alternative field name
%%[
Set @url = Concat(
'https://c8.dycdn.net/[your Website ID here]/content/email/?k=ocemgn4&f=cart_html&e=',URLEncode([email address],1,1))]%%
%%=HTTPGet(@url)=%%
Note that when you are testing your email template, the personalized content will only display if you use the "send preview" function or send the campaign to your test list.
Create an Interaction
An Interaction is the most common way to trigger an email send, but it's also possible to load data to a list/Data Extension and then use the Salesforce Marketing Cloud Journey Builder to pick up newly added records and trigger emails to them. This will not be real-time, instead running on a batched basis at the interval you set. To use the Journey Builder method, you still need to create an Interaction, but leave it paused rather than activate it.
Hover over Interactions.
Select Triggered Emails.
Select Create.
Enter an Interaction name.
Enter an external key.
Select the email.
Select the List.
Select the Data Extension.
Select Save.
Field | Value |
Name | Pick a name for the Interaction, for example, Cart Abandon Stage 1 |
External Key (Customer Key) | Set the external key of the Interaction, for example, CartAbandon1 |
Send Classification | Leave as Default Transactional unless you have a reason to change |
Content | Navigate to and select the email you want to send (i.e. the one you created earlier) |
List | Select the list you wish to use (an existing one or the one you created earlier) |
Data Extension | Select the data extension you wish to use (i.e. the one(s) you created earlier) |
Activate an Interaction
Once you have saved an Interaction, you need to activate it to allow sends to be dispatched.
If you do not activate the Interaction, it will look like the email has sent from the Fresh Relevance side, but the email will never be delivered.
Open the Interactions page and find the new Interaction in the list (note that the Status column should say New)
Select the checkbox to the left of the name
Select Start/Restart in the menu bar
You should see a confirmation that the Interaction has started (and the Status column will change to Running)
Reactivate an Interaction
If you make changes to an email, these will not be picked up by the Interaction until it has been restarted. To do that:
Open the Interactions page and find the affected Interaction in the list.
Seelct the checkbox to the left of the name.
Select Pause in the menu bar.
You should then see a confirmation message and the value in the Status column changes to Paused.Select the checkbox to the left of the name again.
Select Start/Restart in the menu bar.
You should see a confirmation that the Interaction has restarted, and the Status changes again.
Errors when creating an Interaction
When you save the Interaction, it validates the Data Extension and the email and can throw an error message if it finds a problem.
The usual cause of this issue is that the email contains fields that are not present in the Data Extension, so check the email and update it or the Data Extension as appropriate.
For example, a common scenario is the email address field has been referred to in an incorrect way -- unlike other ESPs, Salesforce Marketing Cloud does not use a consistent name so the field can be email, email address or EmailAddress, and potentially others. Check the value in the Data Extension and confirm the email using the same value.
Create a sending user account
In order for Fresh Relevance to trigger emails it needs a user account with the correct privileges.
To configure these:
Hover over your username and select Setup.
Select Users.
Select Create in the menu above the list of users
Enter the required fields (name, email address, username, external key).
Select both the Enabled and API User checkboxes.
Select the Grant the user access to the web services option.
Find your API endpoint URL
Each Salesforce Marketing Cloud account uses a unique API endpoint (what our code calls to load and send). To get this value for your account you need to:
Hover over your username and select Setup.
Select Account Settings under Company Settings, which is below the Settings heading on the left-hand menu.
Copy the SOAP Service Endpoint URL. This should end in ASMX.
Update the ESP Settings in Fresh Relevance
The final step is to enter the details of the elements you have created into the ESP Settings page.
Initial Settings
Enter the following required information on the initial settings page:
Field Name | Description |
Username | Enter the username of the new user you created earlier |
Password | Enter the password of the new user you created earlier |
API Endpoint | Enter the SOAP Service Enpoint value you copied in the preview step |
Select Next to move to the next screen.
Additional settings
These settings largely relate to the other elements you set up in the previous steps.
Field Name | Required? | Description |
Business Unit | Optional | The Business Unit to use within your account. This must be an integer (whole number). |
Optional List used for Triggers Programs | Optional | The List to load data to in your account |
Optional Data Extension used for Cart Abandons | Optional | The Data Extension to load data to in your account |
Triggered send External Key for Cart Abandonment | Recommended | The default Interaction to use when a Template ID is not set in the Trigger Program |
List ID to use to check Send Permission on your ESP | Optional | The List to check against before allowing a send and to only send if the address is on that list |
Data Extension to use to check Send Permission on your ESP | Optional | The Data Extension to check against before allowing a send and to only send if the address is on that list |
Use EID Instead of Email Address | Required | Defaults to false. Whether to use an external ID in place of email address as the unique ID |
New Contact Permission Behavior | Required | Defaults to Add the contact with a status of "subscribed". This dictates how addresses that are not on the List/Data Extension are handled |
Contact Exists Permission Behavior | Required | Defaults to Change status of the contact to "subscribed"... This dictates how addressed that already exist on the List/Data Extension are handled |
Conclusion
All of the steps have now been completed, and you should have a working integration. Head to the Triggers page to configure a trigger and perform a test send.
If you experience any issues during any of the steps, or in sending a test email, please contact our support team.