Consolidate tracking data for Journey Builder email sends

When it comes to emails sent from Journey Builder, the tracking data is available either directly in each email activity inside the journey, or in Email Studio under Tracking > Journey Builder Sends. But what if you wanted to see consolidated tracking data for all your journeys' performance in one place? With this simple SQL …

Continue reading Consolidate tracking data for Journey Builder email sends

Synchronize and update email address changes from Sales/Service Cloud to Marketing Cloud using WSProxy

One of the most common pitfalls of using Marketing Cloud Connect is believing that once MCC is in place, all data will magically flow and synch between Sales/Service Cloud and Marketing Cloud. Unfortunately, this is not the case for email addresses. If an email address for a Lead or Contact Object is updated in Sales …

Continue reading Synchronize and update email address changes from Sales/Service Cloud to Marketing Cloud using WSProxy

Securing Marketing Cloud Apps hosted on CloudPages

In one of my previous posts, Simple Marketing Cloud App hosted on a CloudPage, I have outlined a solution for creating apps for use in Marketing Cloud and hosting them on CloudPages. While you can choose to hide a CloudPage from being indexed by Google, it can still be accessed by anyone who has the link. …

Continue reading Securing Marketing Cloud Apps hosted on CloudPages

Masking PII data for display with AMPscript

There are many use cases, especially in the transactional space, where sometimes there is a need to display partially masked data to the end-user – exactly in the same way as you would see it when logging in to Marketing Cloud, when the system tells you which email address it sent the verification code to: …

Continue reading Masking PII data for display with AMPscript

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

Troubleshooting Marketing Cloud Connect Business Unit mapping

This quick tutorial will come in hand for anyone who is making changes to their Marketing Cloud Connect and Business Unit setup. Whether you're trying to remove Business Unit access for an existing Salesforce Marketing Cloud API user or you're disconnecting your current connection and replacing it with a brand new one, it's possible that …

Continue reading Troubleshooting Marketing Cloud Connect Business Unit mapping