-
READ MORE
Retrieving delimited values from String in SQL utilizing XML and the Value() function.
-
READ MORE
So many people have wanted to check the status or gather relevant Journey information from those they push in. This endpoint may not be the most efficient way, but currently it is one of the easiest ways to get the context and status of each subscriber entered into a Journey. An undocumented endpoint in the […]
-
READ MORE
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 […]
-
READ MORE
I have seen many people interested in keeping tabs on their Automations all in a single place. This usually involves at least the Automation Name and current status. There are also quite a few other items that can be grabbed as well inside the ‘Automation’ Object and pulled in to your Dashboard. First thing you […]
-
READ MORE
For a long, long time – the only way to do this was to first build the Automation in SOAP API, via the Automation Object, and then build out the file trigger in the ‘FileTrigger’ Object and attach it to the original Automation. It was a very confusing and very buggy endeavor. To this day, […]
-
READ MORE
This one took a LOT of digging and trial and error to figure out. Most of the normal SQL ways to accomplish this (like STRING_SPLIT, etc) are not supported in SFMC, making it heavily reliant on duct tape and bubblegum. Due to my recent exposure to the XML aspects of SQL, I thought that perhaps […]
-
READ MORE
If you are like me, no matter how often you use AND/OR logic, it will ALWAYS trip you up, then man have I got a cool little ‘trick’ for you! The theory behind it is that each logic statement is a boolean (returning true or false) and turning the whole complex logic into a simple […]
-
READ MORE
This is a bit of a niche use case, but honestly, those are usually the ones that are the most powerful to know. Keep in mind this is for use in SFMC SQL Query Activities and is not optimized for use outside of this platform. Ok. So you have a specific naming convention for your […]
-
READ MORE
**EDIT 10/04/2019** – Thank you to CAR from SFSE for pointing out my original code had a few weak points and needed to be updated. I have now updated my code to a much more elegant solution (and one that actually will work in all situations). I would ask that you go on and make […]
-
READ MORE
Ampscript is a server side scripting language used by Salesforce Marketing Cloud and can pick up where basic personalization strings leave off. For instance if your database contains first names that are empty or are only a first initial, it can make for awkward personalization. Dear J, is not going to win many people over… […]