Obtaining the Unsubscribed Records from the Salesforce V2 Managed List
|Knowledge Article Number||000231431|
When migrating to the new Marketing Cloud Connect (V5) from the V2 integration, the safest way to ensure that records who have previously opted out will not be sent again by accident, is to retain and utilize the Opt-out record already stored. This Opt-Out information, along with the unsubscribe date, is already recorded within the Marketing Cloud, and just needs to be placed into the All Subscribers list utilized by the new Marketing Cloud Connector.
This only applies to accounts needing to migrate from the V2 Integration (ExactTarget for AppExchange 2007) to MC Connect (V5).
Upgrading to the V5 will NOT work if integrated with a Salesforce Professional Edition Org.
The process outlined below will result in alternate SubscriberID Values being created for the records that are migrated over. This may present itself when viewing legacy V2 Tracking Data that is migrated over as a mismatch between the records within Salesforce and the newly created records on the All Subscribers list for these Unsubscribed records. SubscriberID values are utilized by the Marketing Cloud backend systems only, and SubscriberKey values will be retained moving forward as the unique identifier for all Integration Sends within the Marketing Cloud.
This should not be a determining factor preventing this overall migration from V2 to V5, as the records being manipulated have already Opted-out of Email Communications.
SELECT EmailAddress,SubscriberKey,[Status] FROM _Subscribers WHERE SubscriberType in ('Salesforce Lead','Salesforce Contact') and [Status] in ('unsubscribed','held')
This query will provide you with records that are in a Held status as well. Held indicates that these records have been deemed 'undeliverable' by the Marketing Cloud system from previous, failed send attempts following the Bounce Mail Management process outlined here. The Marketing Cloud system will not allow you to import records that are in a Held Status, so the options for these records are:
1. Adjust their status to 'unsubscribed' and import the records in that status. This option will follow Best Practice so that your account does not take a hit with Deliverability rates.
2. Import them in an 'Active' status. With this option, there may potentially be a decreased deliverability rate with your next few sends while the system re-analyzes these records of their deliverable status.
3. Leave them out of the Query entirely. This option will prevent these records from being brought back and will bypass the need to alter the exported file that results from the following steps, and also has the potential of decreased deliverability rates.