This post is for subscribers Type your email… Subscribe ..read more

The data that we have to work with in Salesforce Marketing Cloud rarely comes in the format that we need to be able to further use it inside journeys, emails, etc. One of the common use cases that repeatedly comes up on Salesforce Stack Exchange is splitting values from a comma-delimited list into separate rows. Unfortunately, in Marketing Cloud, the usual SQL methods such as STRING_SPLIT are not supported, which results in a heavy dependence on makeshift solutions. Below you will find two SQL-based solutions that I found most reliable, although you need to be warned of a limitation that comes ..read more

I couldn’t resist the hype surrounding ChatGPT, so I’ve decided to jump in on the trend and see how it could be used by marketers in Salesforce Marketing Cloud. ChatGPT claims that some of the common use cases for generative AI in email marketing are: Personalization: ChatGPT can be trained on customer data, such as purchase history, browsing behavior, and demographic information, to generate personalized messages that resonate with each recipient. Marketers can use this information to create more targeted and relevant email content, such as product recommendations or special offers. Content ..read more

One-Time Passwords (OTPs) are unique codes that are generated for one-time use and are widely used in various industries to verify a user’s identity. Usual OTP use cases include two-factor authentication (2FA) and password resets, but OTPs can also be used in marketing to verify a subscriber’s email address upon, for example, newsletter signup, event registration, or coupon redemption. In this article, we will walk through a very simple use case, where a subscriber enters a CloudPage, provides their email address and receives an email with a one-time password. They then type in the OTP into a ..read more

The Marketing Cloud Winter ’23 Release, which occurs from 5th October through 28th October 2022, comes with two brand new Data Views, designed to improve the efficiency and success rate of your Automation Studio automations. The new Data Views, _AutomationInstance and _AutomationActivityInstance, allow reviewing automation health to identify points of failure and determine the cause of why some activities take a very long time to run. Automation Instance Data View The Automation Instance Data View allows you to get a high-level view of all Automation Studio automations within a tenant, an ..read more

A lot of advanced use cases related to building dynamic, highly personalised CloudPages in Salesforce Marketing Cloud require developers to jump between using AMPscript, Server-Side JavaScript and Client-Side JavaScript on one page. This can be a challange, as both AMPscript and Server-Side JavaScript are server-side languages and they are processed on a web server, while Client-Side JavaScript is processed on the user’s computer. Source: https://www.educative.io/answers/client-side-vs-server-side Server-side processing runs on the web server and requires interaction with the server. It allows ..read more

Starting February 21st 2023, Salesforce Marketing Cloud will stop processing nested AMPscript within email subject lines. The change comes as a result of Salesforce’s efforts to provide more efficient and secure processing of customer data. With this change, the subject line will treat any nested AMPscript as content — similar to how AMPScript is processed in the email body today. Source: https://help.salesforce.com/s/articleView?id=000364408&type=1 What does this mean exactly? Currently, upon sending an email, Marketing Cloud processes the subject line twice in order to evaluate any neste ..read more

QR codes and barcodes can make your subscriber’s life much easier and drive engagement with your platform. Barcodes are typically used for sending tickets, vouchers and discounts to your subscribers. Similarly, QR codes can also be used for sending tickets, etc., and allowing your subscribers to use their smartphones to easily access information or websites or personalized links. This short article will cover how to quickly generate them and include them in Salesforce Marketing Cloud emails and on CloudPages. Generate Barcodes with AMPScript AMPscript has a function dedicated solely to generat ..read more

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 query, you can make this available for your Salesforce Marketing Cloud users. Create a Data Extension to hold results First, let’s create a Data Extension where you will keep the results of your query. Here’s is a proposed structure I have used: JourneyName – text, 10 ..read more

One of the most common pitfalls of using Marketing Cloud Connect is believing that once MCC is in place, all data will magically flow and synch between Sales/Service Cloud and Marketing Cloud. Unfortunately, this is not the case for email addresses. If an email address for a Lead or Contact Object is updated in Sales Cloud or Service Cloud, the corresponding email address is not updated in the All Subscribers list. Eliot Harper, THE DATA HANDBOOK There are ways to get around this, for example, if you’re only sending from Journey Builder, you can configure it to always take the latest email ad ..read more