I need to remove a bunch of contacts from our account because we are over our allotment. My plan was to use the "Subscribers Not Sent To" and "Unengaged Subscribers" reports to create a list of contacts that we haven't email or that haven't interacted with our emails in the last year, and then delete those.
My problem is that both of these reports only give me the email address and don't include the subscriber key. Support tells me that these reports in fact do not include the subscriber key and that they can't be modified. To get this information I would need to have a custom report built.
Has anyone ever encountered this issue? Any ideas on how to get this info that doesn't involve paying for a custom report or manually trying to sort this out in excel?
Thanks in advance for your help.
@Nate Snipes I've been there! Not with these reports exactly, but being told I would need a custom report in order to identify the contacts I needed to delete. I wish that Salesforce made this easier.
In your case, have you considered doing a data extract? According to the documentation, the NotSent tracking extract can include the SubscriberKey as one of its elements:
https://help.salesforce.com/articleView?id=mc_as_notsent.htm&type=5. So that could be useful for those contacts, at least, to get you started.
Also, you may know this already, but use Contact Delete in Contact Builder to ensure these contacts are completely deleted for the purposes you're describing:
https://help.salesforce.com/articleView?id=mc_cab_contact_deletion.htm&type=5.
If you can put all of these contacts in a new data extension or list, you should be able to use Contact Delete to delete all of the contacts in that data extension or list from your account.