ACC | Installing Adobe Campaign Classic on Debian

Psst! Listen up, fellow campaigners! Did you know that you can actually install Adobe Campaign Classic locally and it won’t cost you a penny? Of course, you won’t be able to run actual marketing campaigns with it, but you can use it as your personal development playground. It’s like having a sandbox, but for grown-ups. […]

SFMC TIP | How to Link Journey to Delivery

Published on March 27, 2023Last updated on May 12, 2023 by Marcel Szimonisz1 minute read

In Salesforce Marketing Cloud, you can link the customer journey to delivery using data views. Custom views that contain e.g. all tracking information. Here are some steps you can follow to link the journey to delivery using data views: This SQL view will return data such as the subscriber key, event date, journey and activity […]

ACC Tips & Tricks, Adobe Campaign

ACC TIP | How To Convert Base64 to PDF attachment

Published on March 16, 2023Last updated on May 11, 2023 by Marcel Szimonisz1 minute read

In this article, I will provide a simple trick for converting Base64 encoded data to PDF using JSAPI in Adobe Campaign Classic. Due to AC’s inability to attach Base64-encoded files directly to emails, this method can prove to be highly useful. Base64 data format that would be easy to use when supperted by Adobe Campaign […]

SFMC TIP | Add html variation to proof subejct

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Published on August 25, 2023Last updated on August 25, 2023 by Marcel Szimonisz1 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.

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Troubleshooting Data Extensions

Published on August 22, 2023Last updated on September 5, 2023 by Marcel Szimonisz1 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.

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Change data extension settings

Published on August 22, 2023Last updated on August 22, 2023 by Marcel Szimoniszless 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

Marketing Automation, Salesforce Marketing Cloud

SFMC | Query data extension in SSJS and AMPScript

Published on August 19, 2023Last updated on August 19, 2023 by Marcel Szimonisz1 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

ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | How to copy query conditions

Published on August 15, 2023Last updated on August 16, 2023 by Marcel Szimonisz1 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

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Journey validation fails for no reason

Published on August 7, 2023Last updated on August 8, 2023 by Marcel Szimoniszless 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

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Track links in AMPScript variables

Published on August 2, 2023Last updated on August 25, 2023 by Marcel Szimonisz1 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

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | How to publish cloud page immediately

Published on July 31, 2023Last updated on August 15, 2023 by Marcel Szimonisz2 minutes read

You know the struggle when developing a cloud page application and trying to debug some issues or make changes. You publish the cloud page and wait and wait. Sometimes it takes ages, and other times it is right away. Why does this happen? How can we make it work immediately? Why we have to endure … Read more

ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | Troubleshooting web applications

Published on July 29, 2023Last updated on July 29, 2023 by Marcel Szimonisz1 minute read

When building any web application (webapp), you may have experienced a syntax error on, for example, line 200. This can be perplexing, especially when your custom JavaScript code does not even have 200 lines. Why is that? The reason for this discrepancy is that the web applications you create in the visual editor are compiled … Read more

ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | Column must appear in GROUP BY clause

Published on July 25, 2023Last updated on July 25, 2023 by Marcel Szimonisz1 minute read

Creating aggregated data reports may not be a daily task, but there are times when you might be tasked with generating such reports. For instance, you could group and track log clicks to create the coveted ‘Hot Clicks Report’. You tell yourself, ‘It’s nothing major,’ and believe you have an idea of how to do … Read more

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.