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