CoolData blog

20 May 2010

External data project: “Do Not Call” as a predictor

Filed under: External data, Phonathon, Predictor variables — Tags: , — kevinmacdonell @ 7:40 am

Here’s a little variable-creation project which shouldn’t cost much and might yield new insights into the behaviour of your database constituents, especially in connection with propensity to give over the phone: Have they registered their home phone numbers with the Do Not Call list?

A number of US states and some countries such as Canada and the United Kingdom have created these registries forĀ  citizens keen on avoiding getting solicited at home by telemarketers. Here in Canada, all a person has to do to register is go to a website and enter their phone number(s). Commercial telemarketers are prohibited from calling any numbers on the list; violations bring stiff penalties. (If anyone can catch them.)

Charities such as my employer are exempt from the ban, so it doesn’t affect the phonathon program (although we must adhere to the stated preferences of our alumni and maintain an internal do-not-call list). But it stands to reason that there might be some connection between not wanting a call from a telemarketer, and not wanting any phone solicitation whatsoever, including from us. If being registered with the DNCL is negatively correlated with phone-solicited giving, we might gain a useful predictive variable about the people who have not already taken the step of adding themselves to our internally-maintained exclusion list.

In Canada, organizations may sign up to access this list of banned phone numbers. (Visit National DNCL page.) If they are businesses seeking to solicit Canadians by phone, they have no choice: They have to sign up and pay for the lists in order to exclude them from their calling efforts. But there’s nothing to stop exempt charities from signing up as well for the purposes of research.

So that’s what I did. In January 2009, I registered our university as a user of the Do Not Call service, and downloaded six lists of phone numbers. Each list, comprised of a single area code, cost $55. I chose the codes that captured the primary geographic areas where our alumni live. The top six area codes covered 80% of living alumni. After that it would have been a case of diminishing returns — I would have had to purchase seven more area codes to get to 90%. For this experiment, I was good with 80%.

What you get is just a list of phone numbers, but these files are huge — several megabytes in some cases, even in compressed format. If you purchase more than one file, open the smallest one in Excel to inspect the data. In order to match up these numbers with the home phone numbers in your database, you’ll need to ensure that they’re formatted in exactly the same way (i.e., no dashes, full 10 digits, whatever).

That done, now you can simply bring in the file as a new variable in your model. (If you’re using Data Desk, follow these directions for adding a new variable to an existing data set.) You may need to create a variable name, as the file you’ve downloaded might not have a column label and will use the first phone number by default. Code your matches as ‘1’ and everyone else as ‘0’, and test the results against ‘Giving’, or whatever your predicted value happens to be. Keep in mind that your list is specific to a geographic region; while you’re testing for a Do Not Call effect, you will want to exclude records outside the country or state you’re studying.

I’ve tested against both lifetime giving AND phonathon-only giving, and got some interesting results, which I’ll write about later. Give it a try.


1 Comment »

  1. […] week I told you how I obtained a list of phone numbers from Canada’s Do Not Call List (two million phone numbers!). I matched these up with phone numbers from an alumni database in […]

    Pingback by Is the Do Not Call List bogus? « CoolData blog — 25 May 2010 @ 9:42 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: