Adobe Campaign, Marketing Automation

Incremental query activity: All you need to know

Adobe Campaign Classic Incrememental query

Adobe Campaign Classic provides a range of activities that allow you to query data from your database. Today we will take a look at the incremental query, which allows you to periodically select a target based on a specific criteria, while excluding individuals who have already been already targeted.

The population that has already been targeted is stored in memory based on the workflow instance and activity. This means that two workflows started from the same template do not share the same log. However, if two tasks are based on the same incremental query for the same workflow instance, they will use the same log.

If there is no Incremental query activity available, we would need to use a set of activities to achieve similar results. Additionally, we would have to save the target population every time the workflow starts. Below is an example of one possible implementation for an incremental query:

  1. Use Scheduler actity to set repetition of workflow run.
  2. Use a Query activity to retrieve the target population based on the desired criteria.
  3. Add a Deduplication activity to remove any duplicate records from the saved population.
  4. Use a Read list to separate the new records from the previously targeted ones. This can be based on a specific field or condition.
  5. Use Exclusion activity
  6. Save the result of the query into a List
  7. Continue the workflow with the desired activities or processes for the newly targeted population.

Even with all the above mentioned activities, we will not be able to fully replicate this activity. However, for the purpose of understanding how the Incremental query works, it will be sufficient.

The query is defined in the same way as standard queries, but its execution is scheduled to occur at specific intervals. The scheduler features are exactly the same as in the scheduler activity. Additionally, we can configure the history settings.

Two main settings How many days we keep the history of records. If the value is set to 0 history is never purged. After the value set in days will pass, the workflow history log table will be purged and recipients can reenter the workflow again. We can also descide wether to keep history when workflow is restarted / stopped and started again. Additionally we can specify table name, that will replace the default name in database.

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.

#Activity deepdive #adobe campaign classic #SQL #workflow
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

Adobe campaign tips and tricks
ACC Tips & Tricks, Adobe Campaign

How To Convert Base64 to PDF attachment

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

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

Load the first workflow in campaign view

1 minute read

Every campaign manager, sooner or later, finds their way into marketing automation tools like Adobe Campaign Classic. However, one common challenge, for some order loving campaign managers, is encountered when navigating through campaign workflows. By default, the system loads the first-added workflow as a first on the list, which can lead to confusion to some. […]

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

How to use MD5 in SQL and AMPScript

1 minute read

Message Digest 5 (MD5) is a hash function used for data integrity, but it is not suitable for security-critical applications. It has found use for various applications, one of which is to create an encrypted contact subscriber key. MD5 takes any string and produces a fixed-size (128-bit) hash value, that cannot be easily decrypted. To […]

Continue reading
Salesforce Marketing Cloud Tips
Salesforce Marketing Cloud, SFMC Tips & Tricks

How to add indexes to the data extensions

1 minute read

Maybe the title got you a bit curious because there is no such thing as adding indexes in Salesforce Marketing Cloud data extensions. But what can be done instead? If the indexes cannot be managed by the admins and cannot be requested from support we can try to apply one of the following workarounds. Filtered […]

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

SFMC TIP – Double quotes in AMPScript break email template

less than a minute read

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.

Continue reading