How do I schedule a list purge every 6 months in Adobe Campaign Classic? | Community
Skip to main content
A
alb52547777
Level 2
July 19, 2018

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

  • July 19, 2018
  • 3 replies
  • 6935 views

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

Bob

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    Marcel_Szimonisz
    Community Advisor
    Marcel_SzimoniszCommunity Advisor
    Community Advisor
    July 19, 2018

    Hello Bob,

    you can create pressure rule in  typology

    Managing marketing fatigue with pressure rules

    About campaign typologies

    Marcel

      vraghav
      Adobe Employee
      vraghavAdobe Employee
      Adobe Employee
      July 20, 2018

      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

        Adhiyan
        Adobe Employee
        AdhiyanAdobe Employee
        Adobe Employee
        July 20, 2018

        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

        Regards,

        Adhiyan

          P
          parthibanb28349
          Level 2
          April 17, 2020

          Hi Adhiyan,

           

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

           

          Thanks

          Parthiban

          M
          malanga1985
          August 9, 2022

          Hello,
          You can create a SQL activity and add:

           

          BEGIN
FOR c IN
(
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
)
LOOP
--BEGIN dbms_output.put_line ('table Name is') c.table_name;
EXECUTE immediate 'DROP TABLE '||c.table_name || ' CASCADE CONSTRAINTS';
END LOOP;
END ;
/

          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

          Terms & ConditionsAccessibility statement

          Loading footer...