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.

  • 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

    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.

  • 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

    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.

  • Smartlists are critical in our daily operations!

  • 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

    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

Don’t Use a Driver When You’re in a Sand Trap: Boosting Growth with Automated Tags

Small business marketing is a bit like golf. You don’t use a driver for every single stroke. Yeah, you might luck out and get a hole in one, but it’s more likely you’ll end up spending way too much effort for too little return. What matters is that you identify exactly which club best fits […]

The Underperforming 10% of Your Team Can Burn Your Small Business

WORKetc is a small business. Tiny, really, compared to others in the CRM industry. But still—we’re able to provide our services to over a thousand companies, big and small, all over the world. How? Well, by using a complete business management solution to run day-to-day operations, for one, but also by obsessively making sure that […]

Unlock Your Site’s Potential With Automated CRM Web Forms

Don’t believe what the “gurus” tell you: lead generation is hard. It costs money, time, and a whole lot of effort. So it stands to reason that business should do everything they can to at least make the process of actually capturing the leads they generate be much smoother and easier. That’s where WORKetc’s web […]

Still Using Spreadsheets? Here’s Why It’s Time to Graduate to a CRM

One of the most mind-blowing conversations I’ve ever had was with a potential client whose support team used spreadsheets to track everything. They had one guy list down every support ticket and conversation he had during the day, and then another person would add those daily lists to one big spreadsheet. That left me speechless […]

Tools of the Trade: What Makes a Good Business Management Platform?

When I started my first content marketing business I had a very basic idea of what I needed to do: find a customer, do work for them, get paid. That was it. Once I was busy and in business, I realized that I had missed a few important steps. I had to come to grips […]

4 Time-Saving WORKetc Tricks for Power Users

Every minute and second you save, every dollar and cent that you bill—everything counts when you’re running a small business. This is a lesson every entrepreneur needs to learn quickly if they want to stay in business. WORKetc already helps streamline business processes and workflows by integrating CRM, projects, billing, support, and more into one […]