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

Continue reading...

Adobe Campaign, Marketing Automation

Enable newest ES6 JavaScript features

2 minutes read

You may have noticed, when working with the tool for some time, that the JavaScript used around the Adobe Campaign Classic platform is not the newest version. Adobe Campaign Classic relies on ES5 JavaScript, released in 2012. This may cause some first world problems for those accustomed to modern features like Array.indexOf, Array.find, classes, object […]

Continue reading
The image is a wide-format representation of a modern coding environment, specifically focused on the latest ES6 JavaScript features. It prominently displays a computer screen with a code editor, where JavaScript code is shown with highlights on ES6 features such as arrow functions, classes, and template literals. The code is adorned with vibrant syntax highlighting, making elements like code brackets and semi-colons stand out, emphasizing the JavaScript language. The background is infused with digital and technological elements like binary code patterns and abstract tech-inspired graphics, symbolizing innovation in coding. The overall color scheme is dynamic and lively, reflecting the advanced and cutting-edge nature of ES6 in the realm of web development.
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

WOW! SQL queries are case insensitive

1 minute read

I recently discovered that when querying data views, case sensitivity in column names doesn’t make a difference; it consistently picks up the column when named correctly. Let’s explore where else column case sensitivity doesn’t play a significant role. First let’s create a data extension with some columns so we can test following in Query studio, […]

Continue reading
split-screen comparison: one side displays a user typing a SQL query in uppercase, while the other side shows the same query in lowercase, both leading to identical database results. The design emphasizes equivalence through elements like equal signs or arrows and features a digitally inspired background with matrix-style code or abstract tech imagery.

Troubleshooting issues in automation studio

Automation studio, Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks
2 minutes read

Another series of troubleshooting automations in Salesforce Marketing Cloud. I will regurarly add any new additions that I have already resolved and spend great deal of time and life energy. So hope it will help resolve someones issues.

I will try to add, throughout my daily life as an SFMC consultant, all the errors that I have experienced and resolved. Many resolutions can be found on the Salesforce help page. For those not listed there, I’ll make a point to list them out, sharing my hands-on experiences and solutions to help others facing similar challenges.

The value is too long to store into a data type.

This error often lacks specific information about which field to examine, and even Salesforce support may not provide a direct answer initially. However, they usually identify the issue upon further investigation. The error could arise from two main scenarios: when attempting to save records to the database or due to a problem in your SQL query or code.

Attempting to save records to the database

It seems like the field values you have selected are out of range for their corresponding fields in the database. To resolve this, try adding restrictions to fields or increasing field lengths or their types that you think may cause this issue. In my case, the issue was with the language field, which was set to accept only two characters, but often we received language values that were more than two characters in length.

Another issue I recently encountered was when I tried to save a numeric string into a number field in a data extension. This numeric string was outside the integer boundaries, causing an syntax error. In such cases, it’s important to ensure that the data types and their limits in the data extension match the actual data being inputted.

#for any field string that is of lenght 255 to make sure we will save the same lenght
LEFT(255)
Problem in your SQL query or code.

This occurred directly in my SQL query, where I was creating a compound field out of an integer and a numeric string, and somehow it was interpreted as a number that was way beyond the length of the integer field.

It’s likely due to the way SQL handles data types in operations. When you try to create a compound field using an integer and a numeric string, SQL might automatically attempt to convert all operands to a common data type. If this common type is a numeric type and the resulting value exceeds the maximum size that can be stored in that type, it results in a data overflow error or a syntax error. By explicitly converting the number to a string, you can control the data type and avoid these errors.

SELECT CAST(your_integer_column AS VARCHAR) AS converted_string
FROM your_table;
A visually engaging image representing 'SFMC Essentials: What You Need To Know' through digital and futuristic themes, tailored for Salesforce Marketing Cloud. The artwork includes symbols of marketing like graphs, analytics, and communication icons, combined with cloud computing motifs such as cloud shapes and digital network patterns. The color palette features dark blues and blacks, emphasizing the concept of advanced technology. The design is sleek, professional, and tailored to appeal to a tech-savvy audience, with a focus on clarity and visual appeal.
Marketing Automation, Salesforce Marketing Cloud

SFMC Essentials: What You Need To Know

3 minutes read

Let me show you the essentials I use in my day-to-day adventures with Salesforce Marketing Cloud. As we dive into this blog, I’ll share key insights and strategies that have been integral to my journey. I’ll provide you with practical advice for maximizing your experience with this marketing automation platform. Documentation Who wouldn’t guess this […]

Continue reading
An image showcasing the 'Introduction of Salesforce Data Cloud', featuring a fusion of cloud computing and data analytics themes. The design includes visual elements like stylized cloud shapes, flowing data streams, and intricate network connections, set in a digital and futuristic style. The color palette blends blues, whites, and subtle tones of Salesforce's brand colors. The overall impression is one of innovation, data management, and advanced cloud technology, conveyed in a visually appealing and professional format, aimed at an audience with an interest in cutting-edge tech solutions.
Customer data platforms, Saleforce Data Cloud

Introduction to Salesforce Data Cloud

4 minutes read

Companies face significant challenges when it comes to managing data silos within their CRM systems, Which hinders their ability to make informed decisions and develop effective strategies based on data. Data is undoubtedly crucial for the success of any organization. However, if it remains isolated within records without being utilized to its fullest extent, its […]

Continue reading
A professional and sleek image showcasing a modern office environment with a focus on Adobe Campaign Classic. In the center, a computer screen displays the Adobe Campaign Classic interface, surrounded by symbols of digital marketing challenges and solutions like flowcharts, graphs, and analytics data. The background features a dynamic office setting, emphasizing the fast-paced nature of digital marketing. Text overlays include key terms such as 'Strategies', 'Analytics', and 'Campaign Management', highlighting the essential elements of Adobe Campaign Classic.
Adobe Campaign, Marketing Automation

ACC Essentials: What You Need To Know

2 minutes read

When you go hiking, it’s crucial to always take essentials with you to stay prepared for any situation that may arise. This is similar to working with Adobe Campaign Classic or engaging in any other skill-requiring activity. Just as you wouldn’t hike in sweatpants in the middle of winter, like I once did, you’ll want […]

Continue reading
Digital-themed graphic illustrating the extraction of data deltas from a data extension, featuring a computer screen with a data analysis interface, flowing data streams, and abstract digital patterns and circuitry in the background.
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Extract data deltas from the data extension

5 minutes read

Exporting data deltas from a marketing automation platform like Salesforce Marketing Cloud has been a widely discussed topic. I’ve seen numerous approaches to tackling this challenge. In this post, we’ll explore various methods for extracting data deltas and delve into my personal favorite. Stay tuned to uncover practical strategies that could revolutionize your data management […]

Continue reading
How to map enumeration with file extract
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

How to map enumeration with file extract

1 minute read

I was recently asked about the purpose of a checkbox, and believe it or not, it turned out to be the function I thought was missing in Adobe Campaign Classic – but it’s actually there. It’s the File Extract activity feature hidden in one of the final steps of the extraction wizard. It is simple […]

Continue reading
An interactive whiteboard in an educational setting displays a query expression builder, highlighting the use of variables in a complex query. A group of engaged learners discuss the color-marked variables. The room is equipped with data analysis and programming resources, enhancing the learning atmosphere.
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

Use variables in query expression builder

2 minutes read

When the time comes, you will find yourself in a situation where you would like to set up query builder condition expressions as dynamic values. We can achieve this and more with Adobe Campaign Classic. But what are those situations? For example, I had to build a reporting workflow for automated campaigns that was divided […]

Continue reading
Fork Bomb on Adobe Campaign A Controlled Test
Adobe Campaign, Marketing Automation

Fork Bomb on Adobe Campaign: A Controlled Test

3 minutes read

It was around 10 years ago when I first encountered the term ‘fork bomb’. I tried it, it worked, and it made me happy that my virtual server went down quicker than a lightning strike. And that was it – my fork bomb adventure back then. After all these years, I don’t know why I […]

Continue reading
How to fetch code snippet with AMPScript
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

How to fetch code snippet with AMPScript

1 minute read

If you have ever experienced troubles when referring to your content block within another resource, either an email template or a cloud page, using ContentBlockBy AMPScript functions, I will show you a hopefully better way to include your snippets in your content. Dynamic content creation and personalization within Salesforce Marketing Cloud, can often grapple developers […]

Continue reading
Exploring the Dynamic World of Email Marketing: Diverse Template Designs in Salesforce Marketing Cloud
Salesforce Marketing Cloud, SFMC Tips & Tricks

Proof multiple template variants in SFMC

2 minutes read

When working with dynamic email templates that can generate multiple unique variants of the email, you are most probably tasked to proof all the variants to your stakeholder for review. Create data extension When proofing email templates, traditionally, we select subscribers from production or testing data extensions used in the actual send. This process involves […]

Continue reading