SFMC TIP | Add html variation to proof subejct

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks
1 minute read

Issues arise when an email’s HTML contains personalization that includes multiple different variants, that is altering the appearance of the personalized email. Quality assurance (QA) of such proofs can become exceptionally challenging, particularly in cases where there are minor changes across variants or a substantial number of variants present.

You can devide your variants by country language segment etc. To address this issue, there is a simple solution that I use with other platforms. You can simply add all the needed variants to your subject line, but only if the email send is a test send. This ensures that the production send will not be affected.

   IF _IsTestSend THEN
    SET @sl = Concat( Uppercase(@Country), " ", Uppercase(@Language), " ",  Uppercase(@Segment), " ", Uppercase(@Audience), "]:", @sl)
   ENDIF

The QA team can readily identify and differentiate any variant, simplifying their task.

Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Troubleshooting Data Extensions

1 minute read

There are other aspects that I find rather unknown; while there is likely a rational explanation, the platform doesn’t provide straightforward answers. Here are some learnings of mine while working with data extensions: Importing in Contact Builder throws a validation error on the date field. The same file has been successfully imported via Email Studio.

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

SFMC TIP | Change data extension settings

less than a minute read

Sometimes, it can happen that you want to modify field properties, such as adding a primary key or changing the length of certain fields. However, even in these situations, you might encounter some unusual behaviors that you should be prepared for. To modify attributes, like changing from nullable to non-nullable or setting a different primary … Read more

Continue reading
Queries in SSJS and AMPScript
Marketing Automation, Salesforce Marketing Cloud

SFMC | Query data extension in SSJS and AMPScript

1 minute read

There’s another topic for which official documentation often lacks sufficient information, but it can be incredibly useful when needed. It’s important to note that in AMPScript, we use the data extension name to reference the table for any query. On the other hand, in SSJS, we utilize the data extension’s external key to reference the … Read more

Continue reading
Adobe Campaign Classic tips
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | How to copy query conditions

1 minute read

Perhaps you’ve encountered an unusual occurrence while attempting to copy complex query conditions to your clipboard. In some instances, only a portion of the content was copied, while in others, nothing was copied at all. I’ve personally faced similar situations over the years but never delved deeper into the matter. However, one day, I reached … Read more

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

SFMC TIP | Journey validation fails for no reason

less than a minute read

There is an error with starting the journey, specifically related to the email template, but it gives you no explanation whatsoever. I’m sure there can be many problems with the template that prevent the journey from being started. One of the problems I have experienced most recently is that the template has not been approved. … Read more

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

SFMC TIP | Track links in AMPScript variables

1 minute read

When you save links as part of an HTML code in an AMPScript variable, such as a paragraph containing a link to a page, you may face challenges in tracking these links. Salesforce offers a great feature that allows tracking of such links using the “httpgetwrap” inserted right before the URL protocol. When dealing with … Read more

Continue reading