Adobe Campaign, Marketing Automation

ACC Activity | How to use incremental query

How to use Adobe Campaign Classic Incremental 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 #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 Classic tips
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | 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 … Read more

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

SFMC TIP | 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 … Read more

Continue reading
Queries in SSJS and AMPScript
Marketing Automation, Salesforce Marketing Cloud

SFMC | Query data extension in SSJS and AMPScript

1 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

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

ACC TIPS | Workflow in pending start

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 … Read more

Continue reading
Adobe campaign classic hot clicks extract workflow
Adobe Campaign, Marketing Automation

ACC | How export hot clicks in workflow

3 minutes read

In the world of email marketing, tracking recipient activity is essential to understanding the effectiveness of your campaigns. One valuable report that marketers often rely on is the “Hot Clicks Report,” which provides insights into recipient interactions, such as email clicks. The report is included with the Adobe Campaign Classic installation, and you can simply … Read more

Continue reading