Transactional email classification disregards Subscriber’s status. A Subscriber does not need to be Active to receive transactional emails. However, the status Held prevents from sending even a transactional message to a held Subscriber.

A short SQL snippet to find single records of different kind. For example one of each Clients that speak different languages.

Contact deletion is an elaborated an sophisticated process. Not due to the number of steps to perform but due to sometimes unforseen repercussions. For example after deleting a Contact you also opt-out that Contact from SMS and Push in the future. Read twice the SFMC documentation prior to deleting Contacts especially in larger batches.

All Contacts in Contact Builder represent all records for all the channels. All Subscribers are Contacts but not the other way around. Therefore you can preview Subscribers or Mobile Contacts separately using Contact Builder or Data Views. Odly enough, there is no unique table to query All Contacts so to find a specific Contact from All Contacts just query the _Subscribers table.

To filter a sendable data extension using the Filters functionality is a way to go in any project. However, for repetitive, regular tasks to filter dozen of sendable data extensions into tens of filtered data extensions (e.g. by language or a country) a script is my preferred method.

A snippet to build a bullet list using a process loop in AMPscript. It simply demonstates how to replace repetitve lines of AMPscript with a shorter process loop. There are at least two more practial cases to use a dynamic bullet list for example a bullet list from a delimited string.

Quick tip to use quotation marks in a formula for example to wrap a value from the cell A1 around single quotes and add a comma: =CONCAT("'",A1,"'",",").

Back to school starts today and it’s a good moment to remind that every problem has usually more than one solution. If a feature stops working in SFMC - check out if it is available from a different menu.

I wondered whether SFMC is one of its kind (it certainly is) and what are email service provider alternatives for large companies to configure and send dynamic, personalized emails. For example, what kind of service could handle millions of triggered emails within a busy e-commerce site or a global airline platform.

This is a post with references to interesting resources that answer questions about the Salesforce cloud infrastructure. Where are SFMC instances located? What kind of cloud services does the SFMC use? As of today the resources are up to date…

A short ‘hack’ to clear records from a data extension using a SQL query activity. It’s fast and useful in a multistep automation. Use it as a safety measure to clear data from a data extension before loading new data into it in the following step.

This is a small but significant enhancement to my blog posts. I’ve added a button to copy code to the clipboard. This was missing from the default setup of the Jekyll.