I am a direct mail marketer/database marketer. I work with direct postal mail lists with tens of thousands of records. I need a database that can track and manage multiple lists/records that are used to send this direct mail. The functions are:
3) track mailing history and schedule future mailings,
4) de-duplication of identical addresses (so as to NOT send 2 or more mail pieces to the same address),
5) matching/compare & "reassign" records to a "deactive" state that acts as a "do not mail" list.
Database traits: delete duplicate addresses; match queries and save to a separate table; export from excel and export to excel.
Example: I send 5000 pieces of mail in one mailing campaign on May 1st. From May 4th through June 15, I get returned pieces because of a vacant address, forwarding address order expired, etc. I get calls from recipients that they want to be removed from the list, and I get calls from recipients who are interested in my services. The returns, do not mails, and actual contacts will be deactivated for mailing in future campaigns.
--have a user interface that allows a lookup/text search so as to execute a "search and deactivate" function for each piece of mail returned. The interface will also allow an address correction to the record therefore no deactivation will occur
--keep track of past mailings by date/calendar function (with notes)
--schedule future mailings by date/calendar function (with notes)
Additionally, over time, the valid addresses on the list become a little stale, and the original source data needs to be refreshed. When the primary sourced data is refreshed, the refreshed data, which could include a record that has previously been deactivated. Upon import into the utility of the new data, it is compared to records that are already in the database that have been deactivated. For matching records to the deactives records, that imported record will not be added to the active mailing list.