Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

The Top 5 Stress-Busting Tips I have Learnt

Working with any marketing automation platform, especially Salesforce Marketing Cloud, can provide a great user experience and a sense of accomplishment. However, it can also entail many stressful hours dedicated to solving seemingly easy issues.

Here are my top 5 tips that made my daily work less stressed and saved me lots of cursing this year:

5. SQL Queries are case insensitive

This may not be a time or mental well-being saver, but sure now you do not need to spend time on “camel case” structure of any column name ever.

I was in ave when I made typo in one of the column name and the SQL worked anyway. It seems like the SQL queries are case insensitive just as the AMPScript functions are. Would you believe that?

4. Dynamically add any information to Send Logging

Send logging is very useful for tracking the email communication history of contacts. It is similar to data views in _Sent, but it allows you to set the data retention period to more than 180 days.

I was pleasantly surprised to discover that you can store automatically any data, as columns in send logging, coming from source data extension or any of the personalization strings and especially any AMPScript variable defined in the message content. This way you can enhance the send log by any information need to trigger any related email send or data export.

3. Add email variation to the proof subject line automatically

The stakeholder requested that all email variants be sent to them. When 20 different emails arrive, it can end up quite messy in your inbox. To sort things out and identify the variants, I used to add various identifications to the subject line manually. However, this process can be very time-consuming, so there must be a better way to handle it.

   IF _IsTestSend THEN
    SET @sl = Concat( Uppercase(@Country), " ", Uppercase(@Language), " ",  Uppercase(@Segment), " ", Uppercase(@Audience), "]:", @sl)
  1. IF _IsTestSend THEN: This line checks if the email send is a test send. In Salesforce Marketing Cloud, _IsTestSend is a system variable that is set to True when the email send is a test, and False when it’s a live send. So, the code within this IF block will only execute when the email is being sent as a test.
  2. We set variable @sl that is printed – %%=v(@sl)=%% at subjectline email property. You can add as many segments that have impact on the email copy.

2. Proof email preview works but no email is received

This was also discovery after two days of trying to figure this thing out along with great help of salesforce support, which can see the logs on the backend. I have found that some AMPScript written in “certain way” may cause an issue with text version of email. Always take a look at the text version before you send a proof. Look for any ampscript leftovers e.g.

%%=redirectto(Concat(@ProductUrl1, @qpp1, 

1. Landing pages do not publish immediately

If you build a cloud page you know there is time between you publish the page and it actually refreshes is varying from seconds to minutes. But who has a time to wait unknown time and how do I even know that the cache is refreshed and I am looking at the page its contents i have just published?

The solution is to load your page into a content block and on the landing page only use following code to pull content block contents.

//you can use all ContentBlockBy functions ContentBlockByKey,ContentBlockByName,ContentBlockById

One pro tip at the end. Always open a case when there is no logical explanation to the issue you are experiencing. But do only after you do some online search.

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

#AMPScript #cloud page #email template #SQL #ssjs
Marcel Szimonisz
Marcel Szimonisz
MarTech consultant As a marketing automation consultant, I specialize in solving problems, automating processes, and driving innovation in my clients' marketing platforms.

I hold certifications in Adobe Campaign v6 (3x certified) and Salesforce Marketing Cloud (5x certified).

Additionally, I serve as a community advisor for Adobe Campaign, offering expert insights and guidance.

In addition to my professional pursuits, I also enjoy exploring various programming languages, CMSs, and frameworks, further enhancing my technical expertise and staying at the forefront of industry advancements.
Take a look at our subscription offering in case you are looking for a Marketing Automation Consultant.

Leave a comment

Your email address will not be published. Required fields are marked *

Similar posts that you may find useful

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

How to utilize polyfill functions in SFMC

1 minute read

Development in Salesforce Marketing Cloud’s SSJS can be very restrictive, especially when you’re already familiar with the latest EcmaScript6 JavaScript features. We can’t use object spreading or curly bracket functions {}=>() and many, many more. However, we can introduce certain very helpful functions that don’t exist in older versions of JavaScript. The way we do […]

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

Change delivery code after it was sent

1 minute read

Sometimes, it happens that you execute a campaign, and you realize that some information on the delivery is simply not correct. But don’t worry! Before your analysts pick up the raw data, we can change it at any point. You might have tried to change it from the campaign dashboard but found that the data […]

Continue reading
SFMC tips and tricks
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Redirect 500 internal server error inside try catch SSJS 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
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Not able to change data extension fields

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 […]

Continue reading
SFMC tips and tricks
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Data views for transactional emails

1 minute read

Data views in Salesforce Marketing Cloud are very handy, when it comes to getting data insights from various sources inside the platform. I will give you a quick start on how to get data insights for you transactional emails using data views. We will use data from _Sent, _Job, and _Subscriber view s.TriggererSendDefinitionObjectID – object […]

Continue reading