Over the years I have worked with many clients to deploy countless email campaigns. Over this period I have seen time and time again amendments made to email templates that seek to fix once off style bugs or cater to seasonal creative designs. Oftentimes, these changes are implemented in haste…

NTILE(x) is a window function that distributes rows into a specified number of approximately equal buckets. Each row is assigned a bucket number representing the group to which the row belongs. The input into the function is a positive integer which represents the number of buckets into which the rows…

Using XSLT to transform XML to JSON with the help of AMPscript TransformXML(). Code snippet #1: XSL File An XSL file is a stylesheet that can be used to transform XML documents into other document types and to format the output. The AMPscript function TransformXML(1,2) utilises an XSL file as an input to apply an…

If you’re onboarding on to a new client or SFMC account or business unit, it can be a little tricky to locate the Send Log data extension. Usually it can be found using the SOAP APIP or WSproxy with conditional filters such as the below: { Property…

If a record/row is not processed due to an error during an Import Definition it is logged as a validation error. When validation errors are logged, a Results.txt file is generated and attached to the Import notification that is received. The results file is generated from validation errors. If rows…

Salesforce Marketing Cloud’s Mobile Connect application requires the standardisation of mobile phone numbers in order for it to successfully deploy SMS or MMS sends to contacts. The application expects that mobile numbers are normalized which ensures that the number is in the correct format. Depending how you collect subscriber contact…

My intention for this post was to provide another avenue to access important information on some quirks of the Automation Studio API objects and their relations to each other. There are some fundamental knowledge nuggets buried deep in the official documentation, plus, some documentation is simply flat wrong. I like…

By getting the fields available for retrieval, you can identify what kind of information is returned on a Retrieve call. Use the Describe method to get information about the metadata associated with an object. The Describe method supports a request for object metadata in the form of an ObjectDefinitionRequest and…