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
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 …
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: …
Whether you're building a data warehouse or are dealing with a legal compliance issue, access to historical tracking data from your Salesforce Marketing Cloud account using the out-of-the-box features is limited. Data Views are powerful, but only allow you to query for up to six months of subscriber and tracking information. Tracking extracts provide granular …
Continue reading Retrieve tracking data since account inception using WSProxy
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 …
sfmarketing.cloud 