We use Salesforce Marketing Cloud and have thousands of records that don't appear to be in Salesforce. Hence, I want to delete these records so the two systems are in sync and we can save some money in database size.

I have a Data Extension of several thousand Email Addresses from Leads and Contacts.

I would like to know the best/easiest way to cross-check and verify this list against Salesforce data, so I can be sure it's safe to delete the records from SFMC.

Has anyone else battled a similar scenario? Thanks in advance.

  • Where are you wanting to "delete records" from - your data extension with several records, All Subscribers, Contact Builder Contacts or all of the above? – Macca Jul 8 '19 at 23:54
  • @Macca - all of the above. – Greg Beazley Jul 10 '19 at 7:51
  • Thanks. So, is the problem that these records have already been sent to and are counting towards your Contacts count for billing purposes and you want to clear marketing cloud out of non-CRM based data? Or are you intending to use this CSV data to send with in some way? Just need to be clear what we're trying to achieve. – Macca Jul 10 '19 at 8:59

Use Data Loader or Dataloader.io to export all Leads and Contacts with the email field. Create a single google workbook or excel workbook to cross-check the resulting lists with your Data Extension emails.

Here's some instructions on doing this in excel

| improve this answer | |
  • @ayloola - thank you for the suggestion. Is there any other way of doing it without exporting data from Salesforce, but running the query against data in Salesforce? – Greg Beazley Jul 10 '19 at 7:54

To extract data from lead and contact use data loader. Use Vlookup in Excel to cross-check against salesforce data.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.