How to copy query conditions to another split

ACC Tips & Tricks, Adobe Campaign, Marketing Automation
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 a point where I could no longer ignore it and decided to investigate the root cause behind this mind-boggling behavior.

It appears that copying extensive queries with numerous nested attributes might pose a challenge. Instead, you can opt to copy them in separate sections and subsequently paste each section into a text editor. Once all sections are copied, you can then aggregate the complete query conditions from the text editor and paste them into the new query builder. This workaround allows for a smoother handling of complex queries while ensuring accuracy and completeness during the transfer process.


The aforementioned conditions have been divided into three distinct sections, sequentially copied, and subsequently transferred to the new query editor. Lo and behold we copied complex query to another query builder.

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

Troubleshooting web applications

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

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

Column must appear in GROUP BY clause

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

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

Fast select field in query builder

less than a minute read

Working with Adobe Campaign Classic often involves frequent mouse movements and clicks. However, after a while, you’ll discover certain tricks to work with this tool more efficiently and quickly. Today, I’ll show you a simple trick that will help you enter fields in the query builder faster and without having to move your mouse across […]

Continue reading
Adobe Campaign Classic enrichment activity
Adobe Campaign, Marketing Automation

How to use enrichment activity in workflow

6 minutes read

The Enrichment activity in Adobe Campaign Classic is a versatile tool that allows campaign managers to enrich their targeting data with additional information from various data sources. In technical terms, the Enrichment activity can be likened to performing a JOIN operation. A JOIN operation is a fundamental concept in database management systems (DBMS), where data […]

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

How to aggregate data in technical workflow

1 minute read

Every now and then, you may receive a request to aggregate data within an Adobe Campaign Classic workflow. However, if you group by something other than the targeting dimension, you may encounter an error such as “‘w0.iid’ must appear in the GROUP BY clause or be used as an aggregate function. The reason behind Adobe […]

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

Workflow stuck in pending start status

1 minute read

Have you ever found yourself waiting for a campaign workflow to start, only to experience delays or long waiting times? I’ve got a handy trick to share with you that can help you initiate the workflow immediately or significantly faster. I know that campaign managers schedule sometimes can be tight and waiting for pending start […]

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

Reselect temporary schema in query

less than a minute read

When working with the Query activity in Adobe Campaign Classic, you have the choice to select either the Temporary schema or the Database schema. If you opt for the Temporary schema, it is essential to reselect it even if it is preselected with a default value. Here’s why it’s important to explicitly reselect the Temporary […]

Continue reading
Adobe Campaign Classic OOP concepts in ES5
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

Using OOP techniques in ES5: A Guide

3 minutes read

In this blog I will be exploring object-oriented programming (OOP) and Adobe Campaign Classic in ES5. As you may already know, Adobe Campaign Classic relies on ES5, the version of JavaScript specifically used by the platform. In ES5, there are a few limitations in terms of what you cannot do compared to newer versions of […]

Continue reading
Adobe Campaign Classic Sub-workflow activity
Adobe Campaign, Marketing Automation

Sub-Workflow Activity: Best Practices

5 minutes read

The Sub-workflow activity in Adobe Campaign Classic is a very powerful tool that allows you to incorporate and execute reusable workflows within your main workflow. It enables you to modularize and streamline your workflow design by breaking down complex processes into smaller, manageable components. With the Sub-workflow activity, you can create separate workflows that handle […]

Continue reading