SOLVED

Re: Delete Program Members

Go to solution
Anonymous
Not applicable

Delete Program Members

bad /nonsensical data was recently uploaded into MKTO following an event. We want to start from scratch with all the members of a specific campaign with the status "invited". How can I delete all 2000+ members but keep the program and those members with "attended" and "registered" statuses? I do NOT want to remove them from the program, I want to delete the records entirely. Thanks!
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Delete Program Members

If I am reading this correctly, it sounds like you have 2000+ Leads within a program. Most of those Leads do not have a status of "Registered" or "Attended", but some do. You would like to delete all Leads from the system entirely if they do not have one of the aforementioned statuses. That right?

If so, run a smart list based on progression status. Filter out those who have a progression status of "Attended" or "Registered", then delete the rest of the Leads from the system. When you import the list back in, the Leads you wanted to keep will have the right status and the rest of the Leads will have the default status, which in your instance sounds like "Invited." 

The filter you will need is "Not Progression Status was Changed". Reference the program, then you will need to add the constraint "New Value" and enter "Attended" and "Registered". Make sure to change the timeframe so that the length of the Program is included in the smart list. The remaining Leads should be the ones you are looking to delete.

Hope that helps!

View solution in original post

4 REPLIES 4
Jep_Castelein2
Level 10

Re: Delete Program Members

I'm not sure what you're trying to do, can you clarify?
Anonymous
Not applicable

Re: Delete Program Members

If I am reading this correctly, it sounds like you have 2000+ Leads within a program. Most of those Leads do not have a status of "Registered" or "Attended", but some do. You would like to delete all Leads from the system entirely if they do not have one of the aforementioned statuses. That right?

If so, run a smart list based on progression status. Filter out those who have a progression status of "Attended" or "Registered", then delete the rest of the Leads from the system. When you import the list back in, the Leads you wanted to keep will have the right status and the rest of the Leads will have the default status, which in your instance sounds like "Invited." 

The filter you will need is "Not Progression Status was Changed". Reference the program, then you will need to add the constraint "New Value" and enter "Attended" and "Registered". Make sure to change the timeframe so that the length of the Program is included in the smart list. The remaining Leads should be the ones you are looking to delete.

Hope that helps!
Anonymous
Not applicable

Re: Delete Program Members

Thank you so much Jeff S! Very very helpful.
Anonymous
Not applicable

Re: Delete Program Members

Not a problem! Glad I could help.