How do I set up auto-delete for my contacts to reduce the number? ie if they haven't opened an email in +2 years, remove them from my database

Hello Abbey Wyatt-Smith , 

If you are running a recent version of Sugar the Auto-Archiver would be the easier option to accomplish this. 

Just create a new archiver filtering for Date Modified. 


You  can check more information here:  

https://support.sugarcrm.com/Documentation/Sugar_Versions/11.0/Serve/Administration_Guide/System/Data_Archiver/#Creating_and_Running_a_Data_Archiver_Job

I hope this helps 

Thanks Andre, 

It looks like this only works for Sugar Cloud customers. Is there a way you can do this if you just have Sugar Market?

It has been a while since I had to deal with marketing in Sugar, how would you know if a contact has not opened or received one of your mailings?  If thats easy enough then the rest is child's play. 

It would have to be done in code though but it sounds like you have a on-site install so that should'nt be hard.

do you also have Sugar Enterprise?
if so, archiving feature is also available for that version

https://support.sugarcrm.com/Documentation/Sugar_Versions/11.0/Ent/Administration_Guide/System/Data_Archiver/#Creating_and_Running_a_Data_Archiver_Job

Abbey Wyatt-Smith - I've moved this question over to the Sugar Market group to help you connect with more Market users and see if anyone here can provide additional insights about keeping your contact database current.

Hi Abbey, 

You can find additional documentation on creating Auto-deletion reports in Sugar Market here: https://support.sugarcrm.com/Documentation/Market/Sugar_Market_User_Guide/Reporting/Creating_Auto_Deletion_Reports/

Auto-deletion reports require you to use viewAccountContact when creating the report, and the criteria you are describing above will require campaign data as well. One option would be, rather than focusing on only on email activity, to use the filter of Contacts.Salesfusionlastactivity is less than or equal to ++DaysSubtract730++, which would show you anyone who has not had any activity (opens, clicks, web activity, form submits) in the past two years. You would then be able to use that report for auto deletion since it doesn't not filter for campaign data specifically, but rather all contact activity. 

There is also this article which helps you create an Unengaged Contact report: support.sugarcrm.com/.../