In Salesforce Marketing Cloud’s Journey Builder, when entering contacts via API in commercial emails, previously, only one contact could be included per request. However, with the Winter ’24 release, a new Batch Event API has been introduced, enabling the entry of up to 100 contacts per request. ▶ Interaction: Enter Contacts into a Journey in BatchesSalesforce DevelopersCreate an entry event that asynchronously inserts a batch of subscribers into a journey.developer.salesforce.com Please enter the information as follows. This sample serves as an example of entering three contacts with a single request. --- MethodPOST--- HeadersContent-Type: application/jsonAuthorization: Bearer [Access Token]--- Endpoint[REST Base URL].rest.marketingcloudapis.com/interaction/v1/async/events--- Body (Sample){…

In the ever-evolving landscape of Salesforce Marketing Cloud, developers often grapple with the challenge of efficiently extracting contact lists from specific journey activities. While Data Views offer a solution for email activities, the elusive task of extracting contacts who traverse wait activities remains a puzzle. In the pursuit of this extraction, a workaround emerged: the setup of an “Update Contact” activity on the Journey Builder path. This involved crafting a mechanism to accumulate contacts passing through that activity into a data extension. Yet, this approach came with its own set of challenges. The “Update Contact” activity necessitated advance preparation on…

In some companies, there are cases where a central team at the headquarters sends out emails to customers managed by various branches. In situations where you want customers to reply to the received emails and have the ability to reply to the email addresses of each branch, it can be convenient to dynamically set the reply-to email addresses for each branch. At first glance, it may seem that Salesforce Marketing Cloud’s standard features allow you to select only one reply-to email address. However, it is possible to achieve dynamic reply-to addresses. Note that this feature is not enabled by default,…

One of the most critical knowledge that marketers must have is a clear vision of how to launch a campaign and an accurate understanding of how to measure performance. That being pointed out, in this article, we’ll go over one of the most important settings to make when tracking metrics in Email Studio’s engagement report. If this is not a new topic to you, I’m sure you’ve seen these unusual numbers of clicks in the engagement report for just one record, for example. And, like me, you might be wondering why and how someone might have clicked on a specific…

This function ‘upserts’ a Contact in Marketing Cloud. If the Contact does not already exist, then a new record is created. If the Contact exists, then the record is updated. The function will output 1 if an error occurred when upserting the Contact and 0 if the upsert was successful. Example The following example inserts or updates a mobile Contact record. Output A value of 0 is set by the function, indicating that no errors occurred.

The V function outputs the value of a variable. Example: Output: Hello World! Explanation: The string “Hello World!” is set as the @variable in this example. In your data extension, variables can be utilized for data attributes.

A financial company wants to send a promotional email to its subscribers about their new products. The company would like to display the recipient’s first name in the email and also getting the first name properly capitalized. In this specific use case, the AttributeValue function is used to retrieve the subscriber’s first name from a sendable data extension. The first name value then passed as an argument into the ProperCase function to return the first name with the first letter capitalised. The result is stored in a variable @firstName, which is then used in the email.

Like the image above, a subquery is a query written inside another query. It is a nested query that can retrieve data from several tables. It can also be used as a special filter based on the results of other queries. The SQL execution order usually starts from the subquery, the nested query, then the parent query. In this article, we will look at the use cases of subqueries and how you can use them to make a big difference. SCENERIO 1: Company A was trying to upskill her employees and asked them to purchase a course with an offer…

The term Upsert in SQL allows you update a table if the specified condition already exists or insert a new row if the specified condition does not exist in the table. That is, Upsert automatically allows you write a query to detect a record in a database if it exists or not by performing the functionality of either updating the table or inserting a new record into a table which in turn allows for efficiency in database operation. The Upsert syntax varies based on the database system you use and in this article we will be exploring different methods in SQL to achieve this! Now, let’s…

There are numerous scenarios in which rows of data must be created into a Salesforce CRM via API. After reading this article, you will know how to create or edit a account via REST API. 1- Backend/Salesforce connection Get Access Token : Data Authentication  :  “Account” object interface definition Account fields list :  Selection values list :  Gender :  Label API Name Femele F Mal M Others O 3- Account record creation 4- Updating an Account record