CRM Auto and Improve Manual Delete

This is a similar request to this one for Custom Modules Auto Delete, but for the CRM section of the Admin.

Reason needed:

  • Manage CRM quantities to keep the item count under control, thereby controlling costs.
  • Regularly purge data for Privacy and security reasons.
  • Regularly purge data that is only needed for a single purpose and does not require storage.

Important consideration.

  • Deleting CRM Contacts will delete the corresponding Form Submissions and Orders.

Manual Deletion
Here are some filter options the could be used on there own or together.

CRM Contacts

  • by date range
  • older than XX days. ei: 30 days, 60 days
  • by non-confirmed members.
  • by members area
  • Any contact with no Form submission, order, or member area.

Form Submissions

  • by date range
  • older than XX days. ei: 30 day, 60 days
  • by form name

And the ability to delete all based on the above filters, not just 50 at a time.

Auto Deletion

  • Need the ability to set deletion rules separately for CRM Contacts, Form Submissions, and Orders.
  • All filters noted above can be set for auto-deletion rules.
  • If you are auto-deleting CRM Contacts, you must confirm the selection of associated Forms Submissions and Orders before activating the rule.
  • Ability to delete CRM Contacts after a specific date associated with a particular Member Zone.

Use Cases

  • I have a client who runs a contest every year. Once complete, after 30 days, they purge all CRM Contacts associated with the contest. This prevents data leaks from one year to the next.
  • I have a client who receives numerous form submissions. These are emailed to them and handled internally. I purge the data monthly to keep the CRM under the limits.
  • I have an Orthodontic site that collects new patient information online. This is only needed for collection and is then integrated into their operating software. Data is regularly deleted to prevent private information from being exposed in the event of a site compromise or hack.

Anyone else have any thought on how we can manage the CRM more efficiently?