1

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.

3
  • 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, 2019 at 23:54
  • @Macca - all of the above. Jul 10, 2019 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, 2019 at 8:59

2 Answers 2

1

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

1
  • @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? Jul 10, 2019 at 7:54
0

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .