Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

How do I schedule a list purge every 6 months in Adobe Campaign Classic?


Level 2

Hi all,

I have set up a marketing workflow where every time I execute a monthly marketing campaign, the recipients are filtered to remove anyone who is on a list "list of campaign X recipients". The recipients who make it through that filtration processed get added to that "list of campaign X recipients" then go through the marketing workflow as per usual.

I dont want to send someone marketing emails more than once in a 6 month period, thus I have been manually checking the list pre-campaign each time and removing people who have been in the list for 6 months. Surely there is a way to automate this so that it happens automatically and I don't have to manually remove people from this exclusion list.

Please tell me how I can schedule an automatic process that removes people from a list who have been in that list more than 6 months.

Thanks so much in advance to you all


5 Replies


Employee Advisor

To add to Marcel's point, there is a 50 minute Office Hours session recording which you can view and fast track your learning about Pressure Rules Adobe Campaign: Campaign Optimization using Pressure rules



Hello Marcel,

Apart from using a pressure rule you can also probably have the list purged every six months. While creating the list you need to mention an expiry date for the list and on reaching this date , the cleanup workflow will purge that list.

Creating and managing lists




Level 2

Hi Adhiyan,


Is there any way to update expires on date automatically when we import from SFTP.





Level 1

You can create a SQL activity and add:


select table_name
from all_tables
inner join bradapps.nmsgroup tmp
on instr(table_name,to_char(tmp.igroupid)) > 0
where table_name like 'GRP%'
and trunc(sysdate) - trunc(tmp.tscreated) > 31
and trunc(sysdate) - trunc(tmp.tslastmodified) > 31
order by table_name
--BEGIN dbms_output.put_line ('table Name is') c.table_name;
EXECUTE immediate 'DROP TABLE '||c.table_name || ' CASCADE CONSTRAINTS';

With this code, ACC will drop all the lists when lastModified date is older than 31 days.
So you are purging lists every month if tha

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now