0

I have over 2 million records stored in my Individual Email Results object (created by Marketing Cloud Connector) which I would like to remove. I have tried using the Tracking Data Cleanup Tool in the Switchboard but it only returns 3 records, when I press "Delete All" it only deletes those three records it mentioned.

Can I simply wipe out the data using Data Loader (extract and then delete)?

and secondly why weren't the rest of my records be deleted?

(The only thing I can think of that may affect this is that I have upgrade the connector twice this year)

0

Deleting the records via Data Loader is totally fine, have done it for several orgs in the past. You'll only need the individual record ID's in the CSV file to process, but be prepared for a long processing time.

I would advise splitting up the 2M records to 10x files containing 200K records each and just go through these one by one. You will also need to mind your SF org API limits per 24h.

As for the other question I have no comment, if your current MC package is up to date and you haven't configured any custom additions on top then it should've worked. I would open up a support case with MC support to get that cleared up.

  • Can you confirm which objects are safe to delete? There are a number of them related to Marketing Cloud so I don't wan't to remove anything vital to the package to run, just the tracking records. – Deployment Failure Aug 30 '18 at 9:36
  • I hope you meant which records. Anyway, if I recall it correctly it was called et4ae5__IndividualEmailResult__c. Easiest way is to create a Salesforce Report for Individual Email Results and export only the record ID's for Data Loader. – Rain Aug 30 '18 at 9:43
  • Sorry yes I meant records in which objects are safe to delete from, I can see the following: Individual Email Results, Individual Link Level Details, Aggregate Link Level Details. – Deployment Failure Aug 30 '18 at 9:45
  • 1
    From these it's up to you which you are going to remove. The Individual Link Level Details and Aggregated Link Level Details are related to the Individual Email Results, on how your subscribers behaved with any of the links/CTA's on the specific Email. Personally if I were to remove all Individual Email Results I would also clean up both Link Level Details. – Rain Aug 30 '18 at 9:48
  • Is there a way to disable it ? I mean a way to not receive Individual Email Results in ServiceCloud – AshBringer Feb 15 at 11:43

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.