BLOG. SMART PRACTICAL BUSINESS ADVICE

3 Super Simple Ways to Clean Up Your Contact List in WORKetc

Garbage in, garbage out, or so the saying goes. Here’s how you can keep your contact data in WORKetc clean and organized.

WORKetc Contact Cleanup -

Picture this: you’re making a follow-up call to a customer regarding a sales inquiry they made a couple of days ago. You find out, however, that two other members of your team had already contacted them and they’re now starting to get pretty irate with all the phone calls.

You quickly scan the customer’s activity history but can’t find any record of the two follow-up calls they told you about. After a bit of digging, you find out that there are three different contact records for the same customer in your CRM system, and each of them had been assigned to different agents!

Keeping a clean and organized contact list in your CRM would have prevented this scenario and the wasted time and effort that comes with it.

Here’s a quick look at the different ways you can clean up your data in WORKetc.

Smartlists and Tags

Tags are a quick and easy way to segment your contacts into groups and organize them more efficiently. When you’re looking to clean up a bunch of tagged contacts, you can use them to quickly filter and search through your contact list.

The “Email Bounced” default system tag can be especially useful here. This tag is applied automatically to a contact if an email sent to them is returned as undeliverable.

As with all tags, you can easily create a smartlist of all contacts with the “Email Bounced” tag and start updating your contact records accordingly. An even faster way is simply to filter your contact list using tags. If you don’t see the tag you want to filter for, just click “more” at the end of the visible tags list.

WORKetc Contact Cleanup - Tag FilteringFiltering the contacts list using tags.

Since you can create as many tags as you want in WORKetc, you should consider creating a “For Deletion” or similar tag and apply it to contacts that you have deemed unneeded. These may be duplicates, dummy contacts that you created while testing the system, or contacts with just outright bad data.

You can then filter for all contacts with a “For Deletion” tag at a later time and start getting rid of them.

Multi-delete

Deleting multiple contacts in one go is straightforward. First, filter your contact list to find the contacts that you want to delete from the system. A “For Deletion” tag or similar, as suggested above, will make this part go much quicker.

Let’s say you’ve given 50 duplicate or dummy contacts the “For Deletion” tag. The contact list will normally show all available contacts in the system by default. By clicking “more” and choosing the “For Deletion” tag in the Tags field next to the contact list search box, you can filter the list to show only those contacts with the “For Deletion” tag.

Once your contact list is filtered to your liking, select which contact records you want to delete by clicking the checkbox to the left of the contact name.

You can also use the checkbox at the top of the contact list, right below the search box, to select all contacts in the list with one click. You’d better be sure that all the contacts displayed in the list are okay to delete, though!

WORKetc Contact Cleanup - Multi-deleteSelecting and deleting multiple items.

Once all the contacts you want to delete have been selected, just click the downward-facing arrow next to the “select all” checkbox and click “Delete” in the drop-down menu that appears.

The Contact Removal Tool (accessible through the Contacts drop-down menu on the main WORKetc toolbar) is another easy way to mass-delete unneeded contacts.

This tool allows you to quickly select which contacts are to be deleted according to their tags. Clicking on the “For Deletion” tag, for example, will immediately select all contacts with that tag. You can also just click the checkbox next to “Contact” at the top of the contact list to select all contacts.

WORKetc Contact Removal ToolWORKetc’s Contact Removal Tool.

 

Note that the Contact Removal Tool will permanently delete contacts from the system. Any invoices, transactions, and other items related to these deleted contacts will become orphaned, so make sure you’re deleting only those contacts you are really ready to delete.

Since this is a permanent and irreversible deletion, it’s highly recommended that you restrict access to this function under Settings > Permissions. For extra safety, you can even disable this function on your own record just to make sure no accidental deletions occur.

 

Contact Merging

When importing data into WORKetc, there are times when you accidentally end up with multiple contact records for the same person. This usually happens when that person has multiple email addresses.

For example, there might be two separate contact records for one person named Michael Smith, with one record tied to his work email address, michael@smithtech.com, while the other is tied to his personal email address, michael.smith@gmail.com.

Situations like this are annoying, but they can be fixed easily enough. One method is to manually add all the email addresses associated with the contact to one record.

In the scenario above, for example, you can add “michael.smith@gmail.com” to the contact record tied to Michael Smith’s work email simply by hovering over the contact record’s primary email, clicking the pencil icon that appears next to it, and then clicking the “Add new email” link.

WORKetc Contact Cleanup - Adding EmailManually adding email addresses to contact records.

Once done, you can then go ahead and delete the contact record associated with his personal email address.

What if you want to add not just his personal email address to the contact record you want to keep, but any and all items in the personal contact record’s activity history as well? Then it’s time to merge the two contacts.

There are two ways of doing this. First, open the contact record that you want to merge from, which in this case would be the one with Michael Smith’s personal email address. Click on the “Manage Contact” drop-down at the top right and select “Merge”.

WORKetc Contact Cleanup - Contact MergeContact merging in WORKetc.

You’ll then get a menu where you can select which contact you want to merge into — in this case, the contact record associated with Michael Smith’s work email address. Once you’re done, just click the “Merge” button. It’s that easy.

Alternatively, you can merge multiple contacts via the contact list. This is particularly useful when you’re merging more than two contacts into one.

Again, the first step is selecting which contacts you want to merge from. Then, click on the downward-facing arrow at the top of the contacts list and select “Merge”. On the next menu, select which contact you want to merge the selected contacts into and click “Merge”, and you’re done.

WORKetc Contact Cleanup - List MergeContact merging via the contacts list.

By taking the time and effort to clean up your CRM’s contact list, you minimize run the risk of ending up with a disorganized and overwhelming system that, instead of helping you, ends up hindering your efforts to grow your business.

Garbage in, garbage out, or so the saying goes, so always make sure your data is as clean as possible.

How do you stay on top of and clean up your WORKetc contact records? Share your tips and tricks with the WORKetc community.

COMMENTS

Branden
Thursday 4, Aug 2016 1:24 PM

It would be really good if WORK[etc] could offer a ‘duplicate/possible merge’ filter option, like the way android’s contact system works. That way you could do a quick check BEFORE a problem arises. Or maybe even a ’empty contact’ filter that only shows contact with no/limited information (i.e. ones with no details but a name).

Bryan Oleman
Friday 5, Aug 2016 4:11 PM

For a large DB I find the most effective way is to export to a .csv and then scrub that file with spreadsheet program and finally re-import the file.

As for songs anything by Boston, Elton John, Styx, oh hell 70’s rock is all good.

William Mullane
Tuesday 9, Aug 2016 1:29 AM

Thanks for the tips. Keeping our database clean is a never ending task. In order to preserve links to emails, projects, invoices and such related to old contacts, we have learned to be very careful about deleting contacts or even updating contact info. If a person were to move to a new employer, for example, we’d put an “inactive” tag on the old record (preserving all old linkages) and create a new record with new employment info. We are especially careful about not deleting old employee records as they are usually linked to numerous projects, invoices and such in the system.

It is also a great idea to place all email addresses associated with a person in one record so that any correspondence can be linked to one person in one record.

Rachel McHattie
Thursday 18, Aug 2016 4:31 PM

We find that running a report to see all new users created once per week helps to keep an eye on things and update any accounts required.

We then run the same report between specific dates to keep an eye on old data, this is a pretty good use of Work[etc]’s Smart Lists.

Stephen Gardner
Wednesday 31, Aug 2016 2:59 AM

Smartlists are critical in our daily operations!

Stan Zaslavsky
Sunday 11, Sep 2016 7:51 AM

Thanks for sharing the tips – Haven’t thought about the – “Email bounced” tag – just found we’ve got a whole bunch of people under that tag to go through.

What I’m finding though is contact clean up is a lot easier than Task clean up 🙂

We have a lot of templated projects that when they are created and sub-projects are deleted – the tasks in sub-projects stay and add to the overall list of To-do’s – is there a way to delete tasks along with sub-projects?

Katie Ruiz
Tuesday 13, Sep 2016 8:07 PM

I use the tags and merge very often. It’s nice because it keeps the data in the system but organizes it better. It is easy to view.

See all

Featured Posts

7 Clever Add-Ons That Supercharge Google Drive Productivity

Do more with WORKetc CRM’s Google Drive integration and these clever add-ons. We rolled out a significant new feature to WORKetc CRM’s Google Drive integration a while back, giving users access to Team Drives from within the WORKetc CRM environment. In the spirit of that update, here’s a curated list of seven add-ons for Google […]

4 Key Steps to Turn Your Sales Team into a Deal-Closing Juggernaut

Using WORKetc CRM for a more efficient, productive sales team. Selling is simple. You get a sales lead, you offer goods and services, the customer picks one and pays you. But just because it’s simple doesn’t mean it’s easy. The idea itself may be simple, but the actual execution is a difficult task requiring a […]

3 Must-Know Strategies Your Business Needs For Successful Projects

Stop wasting money with these 3 must-know project management tips. Ever lost money on a project, even one that you managed to complete? Well, you’re not alone. In their 2018 Pulse of the Profession report, PMI estimates that 9.9% of every dollar is wasted due to poor project performance. For every $1 billion invested, that’s […]

WORKetc CRM Success: Celebrating Your Big Wins in 2018

A brand-spanking new Gmail add-on, an overhauled iPhone app, and much faster search capabilities—these are just a few of the massive changes we introduced to WORKetc in 2018. None of these improvements, however, would be at all possible if not for the continued support and dedication of our loyal WORKetc users. And since there’s no […]

4 Simple Tips For Max WORKetc CRM Efficiency From Real Users

WORKetc CRM tips and tricks, tried and tested by real users. A CRM is an investment. And as with every investment, you’ll want to squeeze a much juice as you can out of it. Here’s a new batch of tips on how to do just that, from real WORKetc users running their small businesses on […]

3 Critical Resolutions for Small Business Success in 2019

Keep the fireworks going all throughout 2019 with WORKetc CRM. If you’re anything like me, New Year’s resolutions are never just about your personal life. It’s also about probing deep and seeing what you can do for your business. It’s about identifying changes that have real, tangible, and measurable impacts. Here are a few ideas […]