Friends in the SFMC, I’d like to share some knowledge/findings from the SFMC platform that I came across while working on one of the use case using one of the most well-liked functions in SFMC that is primarily used in CloudPages, which is called “API Object Functions” under this “SetObjectProperty”. The SetObjectProperty() function is mostly used to set the properties to add to or update the Subscriber object through CloudPages based on various business logics. Additionally, we’ll discuss nuances of Custom Profile Attributes and how SFMC updates them. Before that let’s go through the use case which I was implementing and got into trouble with the SetObjectProperty and Custom Profile Attribute issue. USE CASE…

In Marketing Cloud, you can use AMPscript functions like UpdateSingleSalesforceObject and CreateSalesforceObject to interact with Salesforce CRM objects and records directly from your email content or landing pages. These functions allow you to update or create records in your Salesforce CRM instance. Here’s an explanation of both functions: UpdateSingleSalesforceObject:The UpdateSingleSalesforceObject function is used to update an existing Salesforce CRM object record with new data. This function allows you to ensure that your Salesforce CRM data is always current and accurate. CreateSalesforceObject:The CreateSalesforceObject function allows you to create new records in your Salesforce CRM from Marketing Cloud. This can be useful for lead generation or…

Aggregate functions allow us to group multiple rows of data by some defining characteristic of the group, such as job department or month, so that summary statistics about the group (averages, totals, maximums etc.) can be calculated. The output is a single value which is based on the set of values in the source data. There are five aggregate functions, namely; SUM, AVG, MIN, MAX and COUNT. These aggregate functions are used in conjunction with the GROUP BY and HAVING clauses as part of our SELECT statement. The GROUP BY clause will divide the rows of a table into groups that have identical values in one or more columns.…

The CloudPagesURL() function provides a secure and efficient way to link out to CloudPages from email messages. <a href="%%=RedirectTo(CloudPagesURL(4132))=%%">Click HERE</a> It generates a URL link to the landing page with an encrypted query string appended —meaning no subscriber information is passed in clear text. https://pub.s10.exacttarget.com/1qVt23cf?qs=92fcbe6d03c54df75b03c7d674f2e836 This encrypted query string (?qs=______) references the email and allows standard system personalisation strings to be used on a landing page.Personalisation Strings | Training | SalesforceThese tables include available personalisation strings for usehelp.salesforce.com When using the RedirectTo(CloudPagesURL(1234)) function, I was curious if it was required to use requestParameter, queryParameter, or possiblyAttributeValue(). In fact, it is A LOT simpler than that. As…

If you asked me “how do you find segmentation in Salesforce Marketing Cloud?” a few years ago, at the beginning of my experience with the tool, I would have rolled my eyes.Yes, I said it, I would have rolled my eyes. Why? Well, I am not a developer, I am not a coder and let’s say the user interface for segmentation in SFMC is quite limited compared to other technologies I have worked with in the past.Sure, we can filter data extensions, split them, clone them and potentially use data relationship to connect multiple tables and cross filter them.However, that day will…

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…