SMFC TIP – NULL value comparison in IF statement

in  Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks
less than a minute read

If you have field in DE that its value is not always populated for a particular row (customer) and you test field value against any value cloud page will throw an 500 – internal server error.

To fix this you will need to add another AND-condition to test field value for NULL

%%[
var @field;// null value


if @field == 4 then
//500 
endif

]%%
in  Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Invalid links when own HTML with UTM tags is used

1 minute read

When the HTML template is used (loading your own HTML code) all the links that use query parameters (?a=b) will resolve to invalid links when they redirect upon user click. This happens when web analytics UTM tags are being attached to the delivery. To resolve this issue all the links with additional query parameters has […]

Continue reading
in  Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SMFC TIP – Form submission handling

1 minute read

On many occasions when handling any form submission single cloud page application is used. This is great as all of error handling, form submission and processing is on one page so it is actually simpler to implement. But here are some thing you need to take into consideration. Handle GET form submissions I have seen […]

Continue reading
in  Salesforce Marketing Cloud, SFMC Tips & Tricks

SMFC TIP | Query filtered data extension

less than a minute read

Easy way to segment your data is to use filtered data extension. Here we can use user interface to set up conditions as we like. When you want to add this newly filtered data extension to the SQL activity you will find that data extension cannot be found in the file browser. But it is […]

Continue reading
in  Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC tip #3 – redirect error in try catch block

1 minute read

If you have redirect function inside the try catch block, either as mixture of SSJS with AMPScript or only in SSJS, it will throw an 500 – Internal Server Error. Let’s take a look on few examples what can create an error that will take you some quality debugging time to figure it out. And […]

Continue reading
in  Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC tip #2 – Column names with suffix _dat, _call, _from fail to validate

less than a minute read

Data extension column names with _dat, _call, _from, _join suffix will fail to validate, due to using old style JOIN The fix is really easy you only need to wrap the column name like [test_from] and the problem with validation is history If you know more suffixes that will throw an error let me know

Continue reading
in  Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC tip #1 – Creating data extension throws Error: updating filter

less than a minute read

When creating new Data Extension from the email studio you might get the very generic message that says Error: updating filter at the very last step of the process. One of the most probable if not the reason is that, the data extension name already exists. To solve this try to add more uniqueness to […]

Continue reading