Hello, my team is looking to overhaul our preference center form choices as they no longer are serving our business needs. This will involve adding new preference options and possibly removing a few.
I am having trouble finding information on best practices when adding new preference options to an existing database. Our new records are automatically opted in to all preferences when their record is created, and then they are able to opt-out of certain preferences or unsubscribe altogether.
Has anyone done this with an existing database before and any advice on how to manage new preferences that are added?
There isn't a single best practice for migrating/expanding because people store preferences in different ways to begin with. For example, I like to at minimum use DateTime fields, not Boolean fields, because they store richer information. (They tell you when somebody set a preference/subscription and that they they did.) In some cases a Custom Object is even richer.
If you're only using Booleans and intend to keep doing so, your choices are limited. You might decide that people haven't explicitly opted out of a new preference, so you can start them with it set to true. On the other hand, this isn't ethical if you've previously said they'll only get certain types of content, so you'd start them at false and try to upsell the new subscription options in existing mailings and on your site.
Ultimately, these are a combo of business, ethics, and regulatory decisions and it wouldn't be prudent to give advice unless you can provide more detail (and maybe not even then!)