Query data views for up to six months of Marketing Cloud subscriber and journey information using Automation Studio. You compose the SQL statement that describes the query when you create a SQL Query activity. You can write the query against a data extension or the system’s data views. Tracking data displayed by clicking and opening is in Central Standard Time, does not observe Daylight Savings Time, and is rounded to the nearest second. NOTE When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results…

This function returns the value of an attribute. This value is taken by the function from the data sources associated with the Contact or Subscriber to who the message is sent. Theses data sources can be: Email Subscriber Profile Attributes Sendable Data Extension Fields Journey Builder Entry Source Attributes MobileConnect List Attributes MobilePush Attributes Note: This function will return null if the attribute is not available in the data source Syntax  The AttributeValue() function has one parameter: x (data type= string): The name of the attribute to return the value of is x with string as a data type, this one parameter is required. Usage …

This function concatenates one or more attributes which have string as a data type. With this Contact function we can concatenate as many attributes as necessary. Syntax Concat (string1, string2, [string3], …) The Concat() function has two parameters at least: string1 (string): Required. A string of text. string2 (string): Required. Usage  This function requires two strings in minimum. Strings are concatenated sequentially. This function creates a full name from a first, middle, and last name. You must explicitly include space characters in the function to incorporate spaces between strings. %%[ Var @firstName, @middleName, @lastName, @fullName Set @firstName = “Kjell” Set @middleName = “Jakob” Set…

So, in the past, the only way you could refresh a filtered Data Extension was utilizing the Filter Activity (in Automation Studio) or via the UI, performing a manual refresh. Now admittedly this is not too bad of a hurdle, but it does not help if you already built out the filter inside the UI or otherwise outside of a Filter Activity. Surprisingly, there is a public facing, undocumented endpoint that will let you refresh your filtered Data Extensions with the Object ID. First you need to collect the ObjectID of your Filtered DE via a REST endpoint: GET /data/v1/customobjectdata/key/{{yourFilteredDEKey}}/rowset?$pageSize=1…

The segmentation features of a marketing automation software are crucial for marketers sending email, text, push messaging, or targeted adverts. Likewise, how easy it will be for platform users to construct their own parts. Today I’ll discuss Salesforce Marketing Cloud’s filtering possibilities and their advantages and downsides for contacts targeting. Queries and Data Filters are Marketing Cloud’s key filtering techniques. Each method has strengths and flaws and is powerful. Data Filters Marketing Cloud data filters let you create segments using a simple drag-and-drop interface. In the image above, I’ve dragged a field from my Data Extension on the left of…

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…