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

Inventory of Data Extensions and their data sources

It's very likely that at some point in your career you will inherit or take over a Salesforce Marketing Cloud instance that has been set up and used by someone else in the past. In case it hasn't been well documented, it can be a struggle to understand all the data related processes and clean …

Continue reading Inventory of Data Extensions and their data sources

Exception handling in Salesforce Marketing Cloud emails

"Hope for the best and prepare for the worst" should be every marketer's motto when it comes to creating contextual personalized content. Your company's reputation could be easily tarnished if you send out buggy emails, that's why exception handling should be an essential element of your email strategy. In this article, you will learn about …

Continue reading Exception handling in Salesforce Marketing Cloud emails

Retrieve tracking data since account inception using WSProxy

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 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