Posts Tagged ‘clean data’

When You’re Stuck with the Boss’ Son…

July 12th, 2010. Written by Doreen Ashton Wagner

Nygel PelletierWe help dozens of organizations every year to update their database.  At times we come across some clients who aren’t able to outsource the cleansing process.  This was the case recently with a law enforcement association who couldn’t export their data for cleansing because their CRM had limitations that required too much of their IT consultant’s very expensive time. 

We would have loved to do the work, but it just wasn’t mean to be.  Our recommendation was for them to hire temporary help.  This project would have taken us just two weeks to complete, and now this is going to take them all summer. 

Fortunately we were able to connect them with a candidate with roots in our area in Glengarry County.  Nygel Pelletier is a former AHL referree (that’s him pictured above!) whose next dream is to get into law enforcement; he was only too eager to get the experience for his résumé!

At times association administrators cannot convince their board or their senior executives that outsourcing is a more efficient way to go.  They are simply told to “hire a student”.   We love students, but what if what if you’re stuck with the boss’ son as your intern to help you clean up your database this summer?  Our client was very happy with how things worked out with Nygel, so we compiled the tips we gave them for your reference: 

  1. Establish a clear goal – What information needs to be updated?  What titles/positions or functions are you trying to get information on and why?  For instance, if you’re trying to update a list of potential exhibitors for your tradeshow, outline those potential titles who may oversee the decision to exhibit at events.  Make sure your intern understands how to explain this purpose to the receptionist.
  2. Write out a script – Have your intern write out exactly what they’ll say.  Play act with them any potential objections so they can present themselves professionally.  (e.g. Receptionist: “I’m sorry; I have no idea who would want to exhibit at your Widget Association Show.” Intern: “I understand.  Perhaps someone in your marketing department would know.  Can you please transfer me?”)
  3. Define phone vs. online approaches – The internet is a great tool, but don’t assume contact names are easily found online.  Sometimes it’s quicker to call up a company and talk to a human being than to search for people online.  Also decide whether the intern will have an email address to send requests for update.
  4. Take the time to train – Supervising a less experienced staff member doing tedious work is often a challenge for busy managers.  Updating a list is not rocket science, but it is an art to convince people to give you the time of day to update any information.  Make sure you take the time to show the person what you want, and how they should sound.  Have them listen to you updating the information so they hear how it’s done.
  5. Keep track of progress – If updating is taking place “live” in your database (and not just on an Excel spreadsheet), make sure you print out a master list, by account/organization name or whatever order makes sense.  Have your intern keep track of their progress by checking off organizations as they are completed.
  6. Spot check – Make sure the information is updated correctly and thoroughly.  It’s stating the obvious, I know, but it’s easy do a great job updating names and forgetting to check that the company is still at the same address.   Spot check records if you can by verifying zip/postal codes, and clicking through to websites to make sure the information is correct.  Have someone else check on a few records, just to make sure things are going smoothly.
  7. Establish metrics – After 3-4 days, your intern should be able to tell you how many records he/she has been able to update per hour.  As we’ve discussed in a previous post, an experienced person should be able to update 10-15 records per hour (we define one record as one contact per company; so 2 contacts at the same location = 2 records).  If the information is particularly dated or obscure, the pace may be closer to 8-12 records per hour.  A pace less than that and your intern may have productivity issues or may be overwhelmed with the task.

And last but not least, make sure your intern realizes how vital their work is!  A clean list is the starting point for any effective and sustainable direct marketing effort.  Don’t let them think you undervalue their work!

Growing Your Business: 11 Principles of Business Development

April 14th, 2010. Written by Doreen Ashton Wagner
Gardening and owning my own business are two passions of mine.  As the weather warms up and I get my hands back into the dirt, I realized how much growing a business is like gardening.

The process of developing business includes both marketing (establishing your brand, creating awareness opportunities, offering products & services that appeal to your target market, etc.) as well as sales (prospecting, building relationships, closing business, etc.).

I humbly submit to you my 11 principles of business development, with a green-thumb twist:

#1 – Time & Effort:  Like growing your own vegetables, developing business takes time and effort.  To underestimate this is a recipe for failure.  I often get calls from hotels, CVBs and other suppliers looking to “buy leads.”  I explain that while we can help them clean-up a database or prospect a new list, we don’t magically materialize leads.  Business development is a process which, through ongoing communication with our clients, we can make smoother and more productive.  But expecting a silver-bullet solution from an outside source is unrealistic.

#2 – Plan for the entire process:   Just like you would not want to plant a garden without a plan, it is unwise to jump into a business development endeavour without planning for the business development process. 

Several years ago we worked with an Ottawa-based custom-steel manufacturer.  Because they designed extra-deep sinks and stainless counters, they wanted us to target pet grooming centres.  We usually stick with the meetings industry but this was a special project for the father of an MPI friend…!

We generated an appreciable number of leads for this client, but when I followed up after our campaign, I was told they did not have the sales capacity to continue working the leads!  We were so focused on getting the campaign started that we had not discussed what would happen once they had the leads and how they would close deals.

The lesson: look at your entire process.  Whether you handle a campaign in-house or you outsource, be clear about where you’re going to sow the seeds (your message), how you’re going to care for your growing garden (lead nurturing), and who will be in charge of the harvest (the close).

#3 – Pick the right seeds for your soil:  Consider the communication about your products or services as your “seeds”.  If you want your message to bear fruit, then you must ensure it has the appropriate tone, content and delivery mechanism.

Most hotels and CVBs are doing e-marketing nowadays.  But is email the right way to get your message across?  With spam filters your message may not get to your intended recipient.  And because planners are getting so much email, if you expect a response, as in the case of an invitation to a client appreciation event, consider reverting to mail or even making a call to follow-up.

#4 – Make your soil a priority:  If your company’s offerings are the seeds, then the soil is your market.  Make sure your database offers fertile ground for healthy business relationships.  Are you targeting the right prospects?  Have you segmented by geography, industry, demand period or other client attribute?  Do you have the right list or do you need to boost your database (fertilize!) by adding new records?

#5 – Biodiversity:  Variety in the garden is a very good thing.  Similarly, ensure you appeal to a variety of markets with different types of messages… This way, if one of your crops fail, you have other sources of business. 

During the recent economic downturn, we observed shifts in target marketing.  One high-end hotel chain started actively soliciting family reunions and events such as dance contests, bridge tournaments, etc.  That was not their traditional market, but when other business waned, they shift focus quickly.  They dropped their rates but they did so with groups that appreciated getting a deal and who wouldn’t expect the same pricing for years to come.

#6 – Cultivate:  When business relationships begin to take root, they’re still very fragile.  You need to strengthen and nurture them.  According to sales training expert Colleen Francis of Engage Selling Solutions Inc., for every 30-day period that elapses after an initial contact, a prospective buyer’s recall is reduced by 10%.  As Francis puts it, “Ten months of no contact with your customers means your list is worth nothing…and you might as well start cold call again.” (For more information please see “Engage Selling Sales Training Tips – Getting Inside the Vortex” at www.engageselling.com).

What mechanisms do you have in place which will keep prospects informed and engaged until they are ready to buy?  Do you send out a regular e-newsletter?  Do you direct mail information to announce new programs or renovations?  Have your considered sending out cards for “different” holidays?  Around Chinese New Year I received a lovely card announcement from Mandarin Oriental.  This card had been sent out to clients, as well as partners and suppliers.  Nearly three months later, that card is still pinned on my bulletin board.  Think of how you can be top of mind with your brand, on the planner’s desk.  

#7 – Consistency:  With time, an untended garden will perish.  Sprouts (leads!) get choked by weeds (competitors!).  Mature plants may die for lack of watering and fertilizing…  The same goes for business relationships! 

During the recent recession, those salespeople who consistently prospected continued to fill their funnel.  The rest sat back dazed and confused, and looked for silver-bullet solutions to find them business.

Live and learn: business development is not just a seasonal thing.  It should be done consistently throughout the year.

#8 – Fertilize:  Just as you need to boost plant growth, sometimes you need to bolster your business development efforts with outside sources.  Look for creative ways to boost your exposure.  Partner with other non-competitive firms (e.g. hotels with AV companies, CVBs and speakers’ bureaux, etc.).  Pool your lists together and do co-op mail or email programs.  Host client events together.  If you’re an independent hotel in one city, is there another independent in another city that you could work with?

Even competitors can work together!  Recently we saw two Florida CVBs, one on the East Coast, the other on the West Coast of the state, work together to target clients in the U.S. Midwest.  They set aside their differences, and realized that many groups could in fact alternate between the two coasts.  The result was more client appointments and potential business for both bureaux.

#9 – Pest & Weed Control:   Pests and weeds can be a minor nuisance or a major problem.  Your garden invaders may be the new hotel that just opened its doors across the street or the public’s perception that all resorts host boondoggle meetings (think AIG effect).  But pests and weeds are a fact of life.  Your preparedness to deal with the situation is what may dictate the severity of the problem.

A great example of dealing with perception problems is those resorts who dropped the word resort from their name (see Wall Street Journal article).  

Any other examples of pests and weeds you’ve had to deal with recently?  Share them with us by commenting!

#10 – You can’t control the weather:  And you can’t control the economy either.  But you can prepare for that too! When the weather man forecasts frost after I’ve planted my tomatoes, I cover them.  This last recession was likely predicable though it caught many of us by its seemingly sudden arrival.  We know the economy is cyclical, so what can be done to mitigate damage in the future?

For one thing, make sure you keep your team primed with sales training and coaching.  I can’t tell you how many really bad cold calls I’ve received in the last 18 months.  No wonder planners tune out salespeople!  Training and coaching is an essential part of sales, regardless of seniority.  If your veterans insist they don’t need training, that’s a sure sign they are jaded in their job. 

#11 – Be ready for the harvest:  This too would sound straight-forward except that it isn’t always.  How many times do we really get busy servicing business that we forget to make time for more business development?  A good gardener can really extend the season with successive sowings… yes, spreading out the harvest so that stuff ripens at intervals.

Remember to gather seeds to plant for the next harvest.  In your post-sale, ask for the business again.  And really great business cultivators also ask for referrals to other planners in the company or other contacts in the industry. 

With these 11 principles I leave you with words of wisdom from Ancient Greek philosopher Plato, “Without effort, you cannot be prosperous. Though the land be good, you cannot have an abundant crop without cultivation.”

Keeping on Top of Your Database

March 8th, 2010. Written by Doreen Ashton Wagner

When I was mailing out holiday season cards I felt quite smug because our list had been updated just six months prior to the mailing.

I mailed 230 cards this year, and six where returned as undeliverable.  Only six, you say?  That’s a rate of 2.6% – I was appalled!  Being in the data business I am fanatical about keeping information current. 

None of the cards were returned because of an undeliverable address since all addresses had been verified and certified with our address correction software.  The six returns included two from the same organization whose office had moved just five months earlier (and I guess they didn’t feel it was worthwhile to pay the $$ that Canada Post charges to have the mail follow to a new address…).  The other three had left their organization and one had been transferred.

In spite of my very best efforts, 2.6% of my data had gone bad within six months.  According to industry standards, this is a very low percentage.  The average database perishes at a rate of 15-25% per year.  This rate accelerates when the economy is in turmoil, when an industry is growing at a fast pace or is facing consolidation.

So what to do if your database is a mess?

Here are a few tips:

  1. Unlike me, accept that the minute you’ve finished updating your database, something in it will be obsolete.  It’s the circle of life!
  2. Don’t throw the baby out with the bath water…  The data may not be current but if the list includes relatively large companies and phone numbers, chances are you can re-coup some data with a little time and effort.  Buying new data isn’t cheap — Dun & Bradstreet, Hoover’s, InfoCanada, charge anywhere from $0.50/record for a simple list to $3-$4/record for detailed data.  And it’s no guarantee that those lists will work for your purposes because the meeting planning function isn’t one that is collected by list brokers and agencies.
  3. Update in small chunks.  Set aside a few hundred records, get those updated, and feel good about what you’ve done… And keep this part of the database clean from hereon!
  4. Be brutal.  If a record can’t be updated in a pre-determined number of phone calls, archive it, delete it, or do whatever, but get it out of your regularly accessible records.
  5. When you make a call, start at the top – the executive assistant to the President often will know who plans meetings.  To get by a particularly tenacious receptionist, ask for the Sales Department.  Sales is a great place to start since it’s the department that has client events, incentive programs, and sales meetings. 
  6. Organize a “data cleansing party”:  I remember the days when the boss would have us stay late, ply us with chocolate and coffee and have us purge hundreds of files over an evening or on the weekend (I’m seriously dating myself here… that’s when we had paper files!).  Pull from your departments that may be seasonal or under-employed in winter, like reservations.  Set them up in a room with the phones and access to only those records that require updating.  Give them a short script, and let them dial! 
  7. Offer an incentive to keep the data up to date, and be creative!  Send out an eblast with the help of a professional firm so that the message will have a better chance of passing by spam filters.  Offer a free service, a heavily discounted rate or even a gift if the person clicks on the link to update their information.
  8. Make sure you continually replenish your database.  Plan to keep your funnel full by topping it up with new sources of data.  Upload that list from the tradeshow, or cross-reference the new MPI membership list you just received.  Enter the new contacts in your database and start marketing to them!
  9. What should you expect?  Using the telephone and the internet to look up phone numbers, an experienced person should be able to update 10-15 records per hour, depending on whether they are only updating the contact information (the easy part) or if they have to seek the person who plans meetings and events (a more difficult task as we all know).

Some much wiser person than me said that “it’s the simple things that are difficult to do, but those simple things are often all that it takes to be successful.”  Data cleansing isn’t rocket science but it’s time-consuming and requires consistency.  Remember that clean client and prospect data will make you a more efficient sales organization!