From emails to chains of SQL queries, having a multi-step list is a great best practice to follow when things are breaking, but should be working. Building a beautiful, but complex code, where multiple requirements are accomplished in a few lines of code may seem like an efficient approach, but sometimes the best solution is […]
Data Investigations – Part 4: Turn It Off And On Again
Last time on Dr. Frankendata, we talked about finding the break by asking, “where does the data stop behaving?” to help guide us towards a solution. In this next step, we hone in on the time honored strategy that continues to work an embarrassingly large amount of the time – turning it off and on […]
Data Investigations – Part 3: Find The Break
Previously on Dr. Frankendata, we walked forwards and backward through the flow of data. While this step can uncover most issues, other problems can hide outside of the data trail. Those issues are not always easy to identify what’s wrong. This next step aims to expand our understanding of where and why the data is […]
Data Investigations: Part 2
Welcome back to the Lab! I assume you’ve read Part 1, the debut of Dr. Frankendata and you’re ready for a second dose of my mad data sciencing. Today, we delve into my go-to best practices for CRM and email marketing data investigations. While the examples below are specific to Salesforce Marketing Cloud, SQL and […]
Data Investigations: Part 1
Fact: Data-driven communications break. Whether you’re a veteran data engineer, mid-level developer, or new to email marketing, we all have those WTF (What the Facts?!) moments. Problems, conundrums, and troubles are inevitable in data-driven marketing. Data stops syncing. Emails display wonky …ahem, Outlook. Dynamic components break. Personalization loads incorrectly, or not at all. Audience processes […]
iOS 15 MPP: What You Need To Know
You’ve made the Salesforce Marketing Cloud investment and now it’s time put this powerful enterprise platform to work. Here are some tips to get you started.
