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

Data Views in Salesforce Marketing Cloud

Data Views are a powerful feature of Salesforce Marketing Cloud. They store subscriber information and the last six months of tracking data for your account. While they cannot be accessed or viewed from the UI, they can be used like any other data extension: you can write a query against a data view in Automation …

Continue reading Data Views in Salesforce Marketing Cloud

Query Studio for Salesforce Marketing Cloud

The ability to write and automate SQL queries in Automation Studio is an indispensable feature when it comes to working with data in Salesforce Marketing Cloud. The current SQL query editor in Automation Studio is very rudimentary and makes it almost impossible to debug SQL queries. It can be very time consuming and frustrating to …

Continue reading Query Studio for Salesforce Marketing Cloud