Data Views App: Display Data Views data in real-time on a CloudPage

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

New Automation Studio Data Views and Updated Data Views visualization

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

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

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