You can consolidate multiple databases and still retain the opted out date values in the new, consolidated database.
When you perform Import/Opt out Contacts, fields are typically mapped in a one to one ratio, but to retain the opted out date values, you must map differently.
To successfully update the opted out date, you must perform two imports to update the new database:
- Import the records in with an opted in status. Do not choose opt out contacts radio button in the first import.
- Import the records a second time with the opt out contacts radio button selected.
Tip: If the records already have an opted out date value in the new database, the opted out date cannot be updated and stays the same.