Taking Command of Your Contacts

rolodexWhy do you suppose spammers and hucksters and phishers and endless social media promoters desire your email address so badly?

Every time you download something (even for free) the one price of admission they always seek is your email address.  Am I right?

Next to your phone number and your social security number, and maybe your physical address, your email is one of the most coveted pieces of personal information a marketer can glean from a prospect.  You read your email every day, right?

Guess what?  You’re a marketer too, and (without being obnoxious), you too should be coveting the following emails:

  • Prospects
  • Clients
  • Peers
  • Producers
  • Coaches
  • Vendors
  • Agents
  • Friends

YOU’VE GOT SOMETHING TO SAY

I’ve been denying the truth for too long.  All these contacts are gold.  Not only as individuals, but as occasional mass recipients of a message from you.  Obviously, you don’t want to spam, but what if you need to get a timely message out, and you want it to go to the right people, for altruistic reasons, or even for reasons that will benefit the receiver?

What if you have a great marketing campaign, and it needs to go to prospects who need to be reminded that you’re open for business?  Tastefully done, this is a powerful tool.  How are you contacting your friendly repeat customers?  Follow-up is so important.

So if you agree, and you believe management of such lists are important to the health of your voice over business, then the questions becomes how to best manage this — DATA.

KNOW THE LINGO

Once you enter this realm, you’d better be ready to deal with spreadsheets, and .xls files, and Excel, and it helps to understand what a .csv (comma separated value) is.

As the PR guy for WoVO, I’ve spent the better part of the last two weeks educating myself on mailing lists.  Actually, two weeks is nothing.  I’ve barely scratched the surface…but I’ve learned a ton.  It was so overdue.  As a prodigious collector, and a maker-of-lists, I’ve been saving emails, opt-in lists, and subscriber lists for years.  Yes, years.

Have I done anything with it?  No. Almost nothing.

That’s gonna change.

But, lists are funny things.  They tend to be duplicative.  The same names keep popping up in congruent lists.  You don’t want to appear bumbling or spammy by sending the same message to the same guy three times.  That’s counterproductive.

WHEAT AND CHAFF

OK, I’m finally getting to the heart of this blog article.  To arrive at a “CLEAN” list — one without errors, bad addresses, duplicates, and old data – you’ll want to use comparison or what’s called “de-duper” programs.  Without them, you will spend HOURS in manual labor.  Tedious and time-consuming.

Basically, you ask the software to sift through the list you have and find duplicates.  Or you have two similar (or what you believe are very similar) lists, and you want to compare them or even combine them to one “clean” non-duplicating list.

This is not perfect.  At some point, you WILL have to eyeball the list on your own for the names you want and don’t want in the list, but with the comparison and de-duper software, you at least know you’ve got a working (candidate) list worth the time of your review.

Part of my time in the last month, has been searching for the right tools.  I’m going to share them with you now, and I must tell you:  of all the qualified lists I’ve shared in recent years on this blog… I’ve never worked as hard at any of them, as I have this list.

A LIST FOR LIST-MAKERS

Here’s a great start.  Someone has done my work for me (with a caveat — read on):

25+ Useful Document and File Comparison Tools 
This is an extremely useful starting place, but includes comparison software for binary files, source code, pdf files, C++, and even Unix users.  So not all of it is to-the-point for the scope of my needs.  I’m looking for Excel file comparisons.

Reviews of Comparison Software This is also a valuable comparison chart of…well…comparison software.

DQ Gobal Dedupe4Excel seems to be the perfect solution.  You can download a 14-day trial version that handles lists up to 250 lines.  I didn’t spend a lot of time with it, ’cause my lists are longer than that.  And here’s the main rub:  The full version costs $155.  It may be great software, but I was seeking something not as feature-laden, but with a lesser price-tag.

ESQSoft Deduper is free.  There’s nothing to install.  It’s all done online.  Enter your list in the left pane, set your parameters, hit the “dedupe” button, and the resulting “clean” version appears in the right pane.  I like this product, but more than once, I noticed that it didn’t grab all the duplicates.  Maybe I didn’t set the parameters right.  I’m also suspect of free software.  I realize it’s a bias I have.  But why would someone offer such a useful tool for free?

Excel Compare is deduping/comparison software I’m recommending.  The price is right ($35) , it’s an intuitive interface, it’s fast, and it’s effective.

Compare Suite   I REALLY like this software.  There’s a Freeware version which I have not tried.  I’ve downloaded their free trial Standard Edition, which is good for 30 days, and was VERY impressed with the ease-of-use.  It also compares Word docs, PowerPoint docs, PDF, RTF, and Open Office docs.  The Standard Edition is $70 to purchase.  A Pro Edition is $140 but I don’t see THAT much difference between the Standard Edition that a VO would need.

That’s it!  Happy List De-Duping!

CourVO

Comments

comments

faff7

FaffCon2014 Official Announcement

Faffy (Amy Snively) and I sat down for a Skype Video interview last night, and she revealed the location of FaffCon 7. So of course, you want to know where and when....but don't rush to watch for only that.  There are plenty of other gems in this almost 15-minute video  recording. You'll hear from FaffCon's founder: Why she's planning for only 4 more FaffCons How the attendee application process is designed Information about the location's hotel setting (the best EVER, according to … [Read More...]

freesound

FreeSound

My wife is having heart surgery this morning, and there was lots of preparation in advance of the procedure, so this is a short blog today. ‘Came across an interesting site called FreeSound. From the website: Freesound aims to create a huge collaborative database of audio snippets, samples, recordings, bleeps, … released under Creative Commons […]

friendly persuasion

5 Ways to “Turn” A Producer

We’ve talked about this.  All the best laid plans of ipDTL, and Source-Connect NOW, and SoundStreak, and even Skype will be for naught as long as the big guns decide they’re gonna hang on to their ISDN until the TelCos come over and rip the copper wires out of their wall. It’s not that they’re […]

audiotx stl-ip

Uh-Oh…Here’s Another One!

Let’s recap.  ISDN is dying. IP-based technologies are scrabbling to fill the void ISDN will leave behind. Top contenders in this space are: ipDTL Source-Connect NOW SoundStreak Skype Another possibility that hasn’t done much with their patented technology is ConnectionOpen. That’s about it. Just yesterday ipDTL upped the ante by offering enhanced features, and a […]

EWABS

Don’t Miss EWABS’ 3rd Anniversary, Monday…

…At least not if you want to hear the answer to the question I posed late last week on this blog:  “SourceConnect NOW…Free?” The response to that mention of “free” was viral!  Source-Connect is up to something, and EWABS is the perfect place to make a big announcement about their pricing. ‘Hard to believe that […]

competition

Source-Connect NOW….Free?

No other question dominates discussions about the recent spate of ISDN-replacement technologies:  How much will it cost? Kevin Leach at ipDTL has tinkered with his subscription fee a little since the first release.  SoundStreak offered their service at no cost for the longest time.  Now that it’s out of Beta, it’s STILL free for talent…but […]

bizcard

It’s In The Cards

Business cards are like FAX  machines.  No matter how advanced the rest of the world gets, those two business left-overs just. won’t. go. away. It’s OK… when the grid goes down because of Iranian or Russian hackers, we’re gonna be glad we hung on to SOMETHING from the physical world.  :)) I’m actually on the […]

newsletter

Constant Contact Alt?

What do you use for sending out newsletters, tracking email lists, and handling CRM? There are plenty of products that offer simple-to-full-spectrum features in this online space.  And that full spectrum includes the price they charge for it. Am I wrong in thinking Constant Contact and MailChimp have risen to the top of the heap? […]

groups

Groups are Gold

There is a point of diminishing returns in creating meaningful relationships whenever you become part of a population that’s too big. For that reason, FaceBook Groups and Google Communities, and Twitter Lists, and LinkedIn Groups are where the real action is. Even the Voice-Over Friends FaceBook group that I administer (now 1300+ members) remains fairly […]

chuck&stacey

It’s All About Relationship….

…and an occasional selfie. Some weeks are busier than others.  This one was a blur.  Luckily, smartphones are handy, and well, you know how that goes.  We take pictures of ourselves with friends, ’cause we want to remember the moment, and savor it later.  I’m grateful for that this week….because of the blur, the timeline, […]

source-connect now

Interview with Source-Elements’ Rebekah Wilson

As voice-actors, we get used to being regarded as the lost stepchild of target marketing.  For some reason, musicians, broadcasters, and audio engineers are pursued as viable product-purchasers, but not voice over talent. What do they think?….we make our own microphones, pre-amps, and DAWs? That thought finds refinement on the NAB exhibit floor.  Vendors do […]

ipdtl-a

ipDTL’s Kevin Leach at NAB

My dogs are tired. Walking the floor of the NAB exhibit hall requires stamina, a plan, and a good pair of sneakers.  Without the plan, you need a GREAT pair of sneakers. Luckily, without planning, I ran into plenty of help.  Mike Laponis and his twin-brother-of-different-mothers Tim Keenan walked up to the Source-Connect booth while […]

skype-c

Skype Goes Pro Audio: What This Means for VO’s

Sure, everybody loves to bash Microsoft, the most recent owner of Skype…but the truth is, the lion’s share of Skype employees live in Luxembourg, and the development team is mostly in Estonia (the birthplace of Skype).  That’s hardly a typical Redmond-based mishandling of some browser brouhaha.  Skype is one of the smartest things MS did, […]

nab2014

NAB Week in Vegas

The National Association of Broadcasters hits town this week. Broadcasting?  I thought broadcasting was dead…taken over by the internet, tablet computers, Netflix, and Twitter. …and yet, there it is, the National Association of Broadcasters convention…among the top-5 best attended conferences in a town that hosts the biggest international conventions anywhere on the globe. The event […]

googleplus

Put Your Demo on Google+

How many times have I said lately, that Google + is the future of Social Media?  I might even be right!  :) SoundCloud is also a form of social media that is ascending to a safe place as the de facto program for embedding or linking to audio (much as YouTube serves that purpose for […]

Comments

  1. says

    Another great article, Dave! I’ve been considering steps for creating a marketing funnel for an astounding landing page idea, yet collating contacts from disparate lists seemed overwhelming until now.

    • says

      Michael,

      ‘Glad you found something of value, Michael… I really researched this area… and feel I was giving out good info. Good luck with it!

      Dave C

Add Comment Register

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>