Adobe Campaign Classic - Scripted Removal Of Old Camp...

[Ken_Qrious]

Is it possible to create an adobe campaign work flow process to check for campaigns which finished more than x number of days ago and remove or archive them?

[DavidKangni · Accepted solution]

Hi,

Yes, query your campaign and then use an update activity to move them into your archive folder.

Thanks,

David

[Ken_Qrious]

Thanks David. I can see the campaign table and the link to the program table which holds the folder information. What I can't see is a how the folder can be changed for the campaign as the program file foreign key isn't visible or accessible.  If I look at the documentation tab of the schema definition for nms:campaign I can see foreign key iprogramid.  

[Sukrity_Wadhwa]

Hi @DavidKangni, Can you help @Ken_Qrious further here? Thanks!

[DavidKangni]

You should be able to change it in a update data activity