Deleting test leads as a batch on a weekly basis | Community
Skip to main content
October 9, 2013
Solved

Deleting test leads as a batch on a weekly basis

  • October 9, 2013
  • 7 replies
  • 1935 views
I'm sure many of you create test leads or see a lot of junk in your DB.

I want to understand how I can set up a trigger campaign that will delete all leads that have the word test in the fname/lname and/or email address.

I've tried to use the fields as above but maybe the fitlering is not right because I get zero results or it certainly isn't picking up the tests I know exist.

When I use filters like 'is not' or 'contains' - does the term or keyword need to be written a certain way or can it be just e,g TEST

If anyone has set up this type of clean up or can advice - it'll be a great help!

Hope I've explained myself coherently! :)

Thanks,
Rashida 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
Yes indeed. I have a working filter for my lead life cycle campaign (for incoming leads) to exclude new leads containingen "@quintiq.com". This works perfectly. So you could create 2 filters:

Email Address / Contains / "@companyname.com"
AND
Email Address / Contains / "test"

Now you can just use emails like: "test0001@companyname.com", "test0002@companyname.com", "test0003@companyname.com".

7 replies

October 9, 2013
I think this is happening because you are just putting the word "test" as part of the name? Without knowing the specifics or how you're labeling these I think the best way to create test leads so they can easily be filtered is to make their company name  = Test so that you they all belong to the same list and it's easier to pull.

You could test this now with those already created and see if it'd work.

Hope this helps!
October 10, 2013
I should work just on contains test. However what if it's a company that has the word "Test" in their name? You don't want to delete them. I previously had a list of 400 x-rated words to blacklist fake leads. However surprisingly how many names or company names partially match.
October 10, 2013
Thanks guys,

The forms that we have ask for Fname, Lname, Email and Tel No. as data entry fields so I'm only able to work with these to determine what are test sign ups.

If the word test exists in any other field i.e. Company then that's a user entry from an internal source and post-sign up so not much can be done there since it cannot be determined when someone decided to add the word test to the sign up profile. Hope that makes sense.

Plus as you say, someone later down the line could be genuine lead but didnt want to give the company name and added test.

I'll keep trying different strings to see if it picks up the leads I can see as clearly test sign ups.

Thanks
October 10, 2013
Are only people from your company testing? If so you can limit to contains @companyname. of course. Or limit on ip-range. BTW we don't use test emails at all. Me and my colleagues just use our own company email addresses to test.
October 10, 2013
Yes, There's only about 4 people internally that can sign up as tests for website dev purposes including myself.

It gets complicated for us to use our actual company addresses as the sign up records get merged each time if the same email is used so the purpose of a test isn't as accurate if it's updating an existing record, so we would end up spending time deleting older tests before sign up. This kind of defeats the purpose of setting up an automated process to clean up test leads.

But what you're saying is that whenever anyone sets up a test lead, they must use a specific @companyname - in which case it can work because the first bit of the email address can be anything and so it wouldn't be looked as a duplicate lead and merged. - Is that right?
Accepted solution
October 10, 2013
Yes indeed. I have a working filter for my lead life cycle campaign (for incoming leads) to exclude new leads containingen "@quintiq.com". This works perfectly. So you could create 2 filters:

Email Address / Contains / "@companyname.com"
AND
Email Address / Contains / "test"

Now you can just use emails like: "test0001@companyname.com", "test0002@companyname.com", "test0003@companyname.com".
October 10, 2013
Sounds good to me. I will run some tests using this process and method - I'm confident it will work now :)

Many thanks for your feedback.

Rashida