A comprehensive checklist for an email quality assurance (QA). I’ve found it on the Internet (it is likely made by the Salesforce Team), copied and pasted for a quick reference. The link to the original file within the post…

An ‘epoch’ is the Unix ‘time zero’, also a synonym of the ‘Unix time’. AMPScript time&date functions don’t support Unix timestamp format and require a human-format such as ISO 8601. To convert a timestamp to a date format, simply use the SSJS to create a new Date object…

A short and very useful query to find X latest emails logged in a sendlog. This can be any DE really to query…

A few practical remarks after spending a few days on troubleshooting the Mobile Studio implementation and using it for Push and SMS in Journey Builder…

You have set dozens of variables using the AttributeValue() function and need to change it to the Lookup() function… This is useful for a very specific case; you want to keep the data source as specified in the Lookup() function and skip any fallback values from Profile Attributes…

It’s all about proper, branded content that’s built, tested and delivered just on time. With small, incidental email campaigns it does not sound very difficult. Neither should it for fast-growing organizations who rely on high quality content…

To identify subscribers who were not successfully sent emails, you can utilize Tracking Extract. While Salesforce Premium Support has the capability to access system logs and share details, you can establish a bespoke troubleshooting and reporting process using Tracking Extract:

• Report on ‘Not Sent’ subscribers through email sends
• Email Send Error Codes

In Journey Builder, the Failed status doesn’t mean the Contact failed when analyzing the journey history. Today is the April Fools’ Day but no pun intended…

To add a column with an email domain use the following snippet:

RIGHT(Email, LEN(Email) - CHARINDEX('@', Email) + 1) AS domainName

Triggered Sends managed in Email Studio have two components: content and interaction. The latter part provides information about the message and its behaviour each time it’s triggered. The Interaction in most cases is created and updated using GUI but in some cases, such as bulk update needed, a short SSJS script saves lots of clicks.

Integration between the Salesforce CRM and Salesforce Marketing Cloud is a broad and ambitious subject that deserves attention. It’s also a very practical subject that if mastered benefits in out of the box features for data-driven, engaging campaigns. There is already a complete set of documentation for the Marketing Cloud Connect (MCC), integration guides, blog posts. Here are a few quick ones from the Trailblazer Community topic.

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.