Posts

Sample Code for Sending SMS Messages and Logging Responses in SFMC Using QueueMO API

  Introduction In this tutorial, we will walk through the process of sending SMS messages to mobile numbers stored in a data extension and logging the responses in another data extension using Salesforce Marketing Cloud (SFMC). We will be using the QueueMO API for sending SMS messages. This guide will cover creating the necessary data extensions, writing the script, and ensuring everything works seamlessly. Step 1: Create Data Extensions 1.1 Data Extension for Mobile Numbers First, we need a data extension to store the mobile numbers to which we will send SMS messages. This data extension should have the following fields: mobile_number  (Text, Primary Key) subscriberkey  (Text) Processed  (Boolean) Example: Data Extension Name: SMS_Mobile_Numbers Fields: - mobile_number (Text, Primary Key) - subscriberkey (Text) - Processed (Boolean) 1.2 Data Extension for Logging Responses Next, we need a data extension to log the responses from the SMS messages. This data extension...

Enhancing Multilingual Capabilities in Salesforce Marketing Cloud

In today's global market, businesses often need to communicate with customers in multiple languages. Recently, I had a client who wanted to understand the capabilities of Salesforce Marketing Cloud (SFMC) for sending emails in Spanish and using the platform in a language other than English. Here's what I discovered.  Language Settings in SFMC  Salesforce Marketing Cloud primarily operates in English, and there is no setting to change the language of an entire business unit or account. However, administrators can change the interface language for individual users through the Culture Code setting in their Cloud Preferences. This allows users to see the platform in their preferred language, such as Spanish. Here’s how an admin can do it:  Click your name in the upper right corner.  Select Cloud Preferences from the dropdown menu.  Go to the User Settings tab and click Edit at the top.  Choose a language from the Culture Code dropdown menu.  Log out and lo...

Creating Tracking Extract Data Extensions in SFMC

 Introduction  Creating tracking extract data extensions in Salesforce Marketing Cloud (SFMC) can be a time-consuming task, especially when done manually. To streamline this process, I've created a JSON package that includes all the necessary data extensions, fields, primary keys, and nullable/non-nullable fields. This package can be used to quickly set up tracking extract data extensions in your SFMC instance, saving you valuable time and effort. Data Extensions Overview  The JSON package contains several data extensions, each designed to track different aspects of email performance. Below is a detailed overview of each data extension, including its fields and structure. 1. Tracking_Extract_Opens Description: Tracks email open events. Field Name Data Type Primary Key Nullable Length ClientID Number Yes No SendID Number Yes No SubscriberKey Text No No 254 EmailAddress EmailAddress No No 254 SubscriberID Number Yes No ListID Number Yes No EventDate Date Yes No EventType Te...