Data Views in Salesforce Marketing Cloud are system-generated tables that provide detailed information about various aspects of your marketing efforts. These tables store 6 months of data about your subscribers, such as email sends, opens, clicks, bounces, and more. Data views play a crucial role in helping to analyze the performance of your marketing campaigns. …
Continue reading Data Views App: Display Data Views data in real-time on a CloudPage
The data that we have to work with in Salesforce Marketing Cloud rarely comes in the format that we need to be able to further use it inside journeys, emails, etc. One of the common use cases that repeatedly comes up on Salesforce Stack Exchange is splitting values from a comma-delimited list into separate rows. …
Continue reading Splitting a string of comma-separated values in a Data Extension field using SQL
The Marketing Cloud Winter ’23 Release, which occurs from 5th October through 28th October 2022, comes with two brand new Data Views, designed to improve the efficiency and success rate of your Automation Studio automations. The new Data Views, _AutomationInstance and _AutomationActivityInstance, allow reviewing automation health to identify points of failure and determine the cause of …
Continue reading New Automation Studio Data Views and Updated Data Views visualization
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
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 …
sfmarketing.cloud 