ACC | Installing Adobe Campaign 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#data views #SQL

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#delivery #JavaScript #jsapi #programming

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 | Google Analytics Integration 1

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Published on November 27, 2022Last updated on November 27, 2022 by Marcel Szimoniszless than a minute read#AMPScript #email studio #Google Analytics #journey builder

When you integrate with Google Analytics, marketing cloud will add tags to all your links. When this happens, all dynamic links will be broken.

Links that are defined programmatically as variable, field or attribute with GA integrated will look as if the tracking link also appends google analytics tags. This will make such link not behave the way we would expected

https://example.com?qs=346cfddaac52baf7865cb0f27d25ff46?utm_medium=email...

Good practice is to wrap all links that are created dynamically in the function RedirectTo

%%[
SET @link = "https://google.com/search?q=martechnotes"
]%%
%%=RedirectTo(v(@link)))=%%

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Open a case

Published on November 6, 2022Last updated on November 27, 2022 by Marcel Szimoniszless than a minute read#case #support

As the title says open a case every time you experience issue or some feature you used on another instance and now is gone. Why open a case? For example when you automation fails with detailed error “Error has occurred”. Simple solution is to “open a case”. Support will tell you exactly what happened. You […]

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Data views for transactional emails

Published on October 14, 2022Last updated on October 14, 2022 by Marcel Szimonisz1 minute read#data views #SQL

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

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SMFC TIP | NULL value comparison in IF statement

Published on September 26, 2022Last updated on October 14, 2022 by Marcel Szimoniszless than a minute read#AMPScript #cloud page #email template #programming

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

ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | Escalate user rights

Published on September 15, 2022Last updated on September 27, 2022 by Marcel Szimonisz1 minute read#JavaScript #programming #webapp

Normally web apps run under the web app user (which is anonymous and has very little to zero rights by default) and for certain operations you would need to require to grant additional access, or even grant full admin. To grant full admin for web app user is not solution to go with. Instead I […]

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Invalid links in HTML

Published on August 1, 2022Last updated on September 27, 2022 by Marcel Szimonisz1 minute read#AMPScript #programming

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

Salesforce Marketing Cloud

SFMC | Link campaign to delivery send

Published on July 15, 2022Last updated on May 12, 2023 by Marcel Szimonisz3 minutes read#data views #programming #SQL #ssjs

Are you aware of Salesforce Marketing Cloud’s additional marketing feature known as Campaign? This tool allows you to group similar journeys together, providing greater organization for your marketing activities. However, one drawback is that the campaign information is not available in the data views. While waiting for a fix from Salesforce, you can establish a […]

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP – Double quotes in AMPScript break email template

Published on June 24, 2022Last updated on September 26, 2022 by Marcel Szimoniszless than a minute read#AMPScript #email template

Very recently I have found that when I add any AMPScript function to eg. button URL field SFMC will just ignore everything that follows after the first occurrence of the double quote. Simple fix is to use single quotes instead.

ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | Export connection strings

Published on May 1, 2022Last updated on September 27, 2022 by Marcel Szimoniszless than a minute read#configuration #xml

Whether you change your laptop or want to save actual configuration for your colleagues. You can easily achieve that by taking all connection strings as XML. ims – connection over adobe id SSO Also similar approach is to directly change the connection string file nlclient_cnx.xml that is located under your local AppData folder. To quickly […]

Marketing Automation, Salesforce Marketing Cloud

SFMC | Multi-cloud preference center

Published on April 28, 2022Last updated on September 27, 2022 by Marcel Szimonisz5 minutes read#AMPScript #cloud page

With majority of the implementations the out of the box center is not sufficient for the client and we are tasked to build custom preference center for them. We can assume that the preference center is only applicable for known subscribers most likely coming from email communication. When we send email in salesforce marketing cloud, […]

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.