Using the Wait Until API Event Activity in Journey Builder

The Wait Until API Event Activity is a new Journey Builder activity released as part of the April 2021 Salesforce Marketing Cloud Release. It allows you to create a real-time experience for contacts by allowing an external event to trigger an action mid-journey. You can add the Wait Until API Event activity at any point …

Continue reading Using the Wait Until API Event Activity in Journey Builder

Consolidate tracking data using SQL

There are many use cases for consolidating and transforming email tracking data in Salesforce Marketing Cloud, and they are usually related to a requirement for sending the tracking data in a given format to external systems, such as databases and data warehouses. We will use Salesforce Marketing Cloud's Data Views to get all the details …

Continue reading Consolidate tracking data using SQL

Updated Data Views visualization

It's been one and a half years since the original article about Data Views has been published and since then, it's become the most viewed article on sfmarketing.cloud. I've received many questions and comments about it over time, and have decided it's high time to update the Data Views visualization. Here's what has been revised: …

Continue reading Updated Data Views visualization

Add multiple contacts to a Journey in one batch using REST API

Firing an Entry Event is great for injecting single contacts into a Salesforce Marketing Cloud journey from external systems or websites - but what if you need to inject contacts to a journey in bulk? After reading a recent question on Salesforce Stack exchange, I found myself playing with the unofficial REST endpoint /interaction-experimental/v1/batchcontactevents, which …

Continue reading Add multiple contacts to a Journey in one batch using REST API

Working with Salesforce Multi-Select Picklists in AMPscript

Custom Multi-Select Picklists in Sales/Service Cloud allow users to select one or more values from a predefined list: When a user picks more than one value, the selected values show in a field separated by a semicolons: The values will be in the same, semicolon-delimited format, if you synchronize the picklist field into Marketing Cloud …

Continue reading Working with Salesforce Multi-Select Picklists in AMPscript