Wednesday, October 24, 2012

Bravely Going Where No One Has Gone Before: Using Metropolitan Statistical Areas in Prospect Research

Once upon a time (fourteen months ago), in a land far, far away (the conference room down the hall), I was sitting in a meeting with a development officer. We’ll call her Janet. (Wow, this is good stuff – I should go into children’s literature!)

Now, Janet wanted me to do a little prospecting for her. At first I understood everything clearly – she wanted to see total giving, areas of interest, and other usual considerations. Then she said she would like to look at the prospects by MSA. What? “MSA?” I asked. “Is that, like, Majorly Serious Assets?” (Note: I did not actually say this.) Befuddled and perplexed, though not at all grumpy, I set out to find an answer.

And find it I did! MSA. Metropolitan Statistical Area. (“Ah, this makes sense,” she thinks to herself.)

Here’s the simplified version: Metropolitan Statistical Areas are geographic areas that typically include a large city (or cities) at the center, as well as surrounding areas that are socioeconomically tied to the urban center. There are also Micropolitan Statistical Areas, which are for smaller cities. Both Metro- and Micropolitan Statistical Areas are lumped into the category of Core Based Statistical Areas. These areas are defined by the U.S. Office of Management and Budget and used by the U.S. Census Bureau for statistical purposes.

Here’s the super-simplified version: Think of MSAs as the Greater ________ Area. Greater NYC. Greater Atlanta. Greater Minneapolis-St. Paul Area. Get the idea?

So, it follows that using MSAs for the purposes of identifying prospects in a certain city can be quite useful. If you’re just looking at street address, you’re bound to miss all the folks in the suburbs.

The challenge becomes finding a way to bring MSAs into your data. Well, my friends: problem solved. Here is a way to get MSAs and corresponding zip codes into a spreadsheet for any or all 50 states. From there you can use your ninja Excel skills (using VLOOKUPS, but that’s for another day) to pull in MSAs based on constituents’ zip codes.
Here are the instructions for running the report (for reference, original found here: http://nysdca.blogspot.com/2008/07/zip-code-to-msa.html):

1. First, open this fabulous database run by the Missouri Census Data Center: http://mcdc.missouri.edu/websas/geocorr12.html  (Thanks, MO!)
2. Pick a state or states.
3. Select one or more SOURCE codes. (5-digit zip).
4. Select one or more TARGET codes. (I chose Core Based [Metro/Micro] Statistical Area).
5. I left the default options for weighed variable and export type (population 2010, CSV, codes & names, etc.).
6. Click Run Request button.
7. After it processes, save the CSV as a .txt file, then open it in Excel. Voila!

Now go forth and prospect! Just don’t steal any of mine.

Caroline Rossini, Treasurer, APRA MidSouth treasurer@apramidsouth.org

Thursday, October 18, 2012

APRA Symposium in Nashville

What I like about the upcoming Advanced Relationship Management Symposium in Nashville that Big APRA is putting on (November 8-9) is that it puts some organization… into the organization!

One of my earliest fundraising jobs was in a development shop of about 12, including all development officers. I was the prospect researcher. Our group would regularly meet to plan, strategize, theorize, document, and predict how to get work done and dollars raised. We were young and eager. We were kicking off a new campaign. The world was our oyster. Let’s do this!

Then we’d find out – the senior-most leaders of our organization already had a long-term narrative in place with almost each of the best prospects we’d worked hard to strategize for them to see. “Did we not already know? Did no one tell us?”

No, we did not know our senior leaders had all of this history with thus and so. At that time, they weren’t required to use the development database. That was for our department. They didn’t attend our development meetings. Needless to say, a sense of spinning our wheels was constant. Who kept track of what relationship? We were supposed to, but how? Frustrations stayed high and staff turnover was common.

That was years ago. I’ve changed as a professional. I bet that shop has too.

All of us are now at the exciting intersection of quantitative analysis and development work. That is where this APRA symposium succeeds. It is a rich spread of cutting-edge philosophy, techniques, and take-aways on how best to organize the work of fundraising for your shop so that all parts of a fundraising enterprise can get on the same page. From setting prospect capacity ratings, tracking moves, setting up prospect portfolios, and more, the brochure is making me think: it is all here. I can only imagine this symposium being a boon for shops large and small.

Our APRA MidSouth chapter is pleased to be helping with a elements of the welcome here to Guitar Town (Nashville). Look for a few of us during the cocktail hour at the hotel’s Park25 Bistro restaurant area in the late afternoon/early evening of November 8.

Look forward to meeting you!

Geoff Little, President, APRA MidSouth
president@apramidsouth.org

Thursday, October 4, 2012

202,000,000 Thank-Yous

In several of my blog posts, I have alluded to the fact that we at Western Kentucky University completed our New Century of Spirit Campaign on June 30, 2012. We gathered recently for our Gala to celebrate the campaign’s conclusion and finally find out the total that has been held secret for almost three months.

Drum roll, please…..$202,305,534. So excited that we met and surpassed the goal! Whoops….shout outs….high fives….confetti….champagne…..pats on the pack….HUGE smiles…..and lots of relief.

Our mid-major university has completed not one, but TWO, major capital campaigns back to back in 14 years. (Well, almost back to back... the first campaign ran from 1998-2003 and raised $102M – the goal was $68M; this campaign started in 2005, going public in 2007). I wasn’t a part of the first, but joined WKU just as the second campaign got underway…..man, what a journey it has been.

That’s why it was so fun to see people I worked with from our Campaign Cabinet to WKU faculty to our wonderful donors and my dedicated and truly devoted colleagues to get dressed up Hollywood style and celebrate this great accomplishment.

WKU went public with the New Century of Spirit campaign in 2007, just before our nation went into our economic crisis. While it didn’t make things easier, we were able to weather that storm and now we are seeing the gold at the end of the rainbow.

Yes, my colleague, Cheryl Kugler (WKU’s new Director of Prospect Research) and I are busy laying the groundwork for the NEXT campaign. That’s part of the job in Prospect Research, isn’t it? But we are taking lessons learned to make us better prepared and to have a firm foundation on which to launch our fundraisers to that next level of success.

But enough of that. This weekend was about CELEBRATION! And how we did! With lots of glitz and glam and fun!

And with that thought in mind, I wanted to share one of the best parts of the evening. All year long our celebration committee had been coming up with great ideas to do things up right, and this movie “Hilltopper of the Century” – starring WKU junior (class of 2014) Marquon Bartee and WKU faculty, staff and students (yes, our division is right in there waving red towels). A shout out has to be given to Madhouse Creative from Toledo, Ohio. They produced and directed the video. Just fabulous people to work with. (www.madmadmad.com)

Without further ado…. and in the spirit of this campaign, I’ll let WKU seize the day and be efficient with every single rhyme and each and every thank-you - 202,000,000 of them.



Theresa Clark, WKU Senior Research Analyst, APRA MidSouth
at-large@apramidsouth.org

Tuesday, September 25, 2012

Wide Open Spaces

When researching a prospect, I often look first for real estate assets.  I search to find how many homes, vacation homes, or condominiums a prospects owns.  Occasionally I find that a prospect owns numerous acres of land or a ranch in another state.  One real estate source that highlights these hefty land owners and
large tracts of land is The Land Report.  

As a visual person, I have a great appreciation for this resource.  The publication provides news, information, and photos on American land and land owners.  The source highlights noteworthy sales of land, farms, and ranches, and it includes upcoming auctions of large lots of land.  The monthly newsletters include a list of the top ten rural land listings.  It is a helpful resource to keep up with current trends outside of residential holdings.  

The Land Report website allows you to look at back issues of the publication.  Each year the publication updates a list of the top 100 landowners in the country.  The leader of the 2011 list is John Malone, who owns 2,200,000 acres of land.  I am still amazed by that number.  

Melissa Sridaromont, Secretary, APRA MidSouth
secretary@apramidsouth.org

Wednesday, September 12, 2012

Covering New Territory: Prospect Research in China

A couple months ago, a few of our key leaders decided to make a little tour around China to meet with donors.  Sounds wonderful, doesn’t it?! I thought so, too. Until they asked for research…. Research folks in China?! Where to even start?

On a day-to-day basis, I use a pretty extensive arsenal of resources for my work. They are tried, true, and as it turns out, completely useless for researching folks in China. Oh dear.  In quick-like fashion, I needed to find some new “tried and true” resources. Oh yeah, and on the cheap! Since this was a first-round trip, it didn’t make sense to pay for something we might not be using again. So like any good researcher, I took to the Internets in search of some comprehensive – but free – resources. Here’s a little of what I found and some advice on researching your Chinese prospects… you know, now that I’m an expert. (Totally kidding.)

* Before we start, please note that some of the links below are in Chinese. These webpages are easily translated through Google Translate, BabelFish, or something similar.

General Searching
  • I started my international search like I start everything in life: with Google. So, start there. But, keep going! Google only carries 23% of market share for Chinese Internet search engines. I had great returns using Baidu, which has around 73%. The site searches more than 740 million web pages, 80 million images, 10 million multimedia files and Baidu Baike, an online collaboratively built encyclopedia. If you want to keep going, also try Sina, which caters largely to the global Chinese community and often produces unique results, and Hudong, which is like a Chinese Wikipedia.

Biographical Information
  • Hands-down my favorite site for biographical information is China Vitae, which profiles more than 4,000 (and counting!) leaders in Chinese government, politics, military, education, business, and the media. Profiles are lengthy and include biographies, detailed career information, and recent travel/speaking appearances. For those familiar with American-based Leadership Directories, the format is very similar.
  • If your prospect is prominent enough to be listed on wealth/philanthropy lists, they typically have a great amount of information. A couple of favorites: Hurun Report, International Who’s Who (which isn’t free, but we have a subscription through our library), and various lists by Forbes, Fortune, and Asia, Inc. (Note: I searched my prospects’ name – or part of it – along with “Forbes,” etc. in a search engine to see what came up. Lists are also available by going to the individual sites, which is probably a better method. Ahem…. Moving on.)
  • A wonderful way to find biographical information is through the use of social media. After all, this is information that an individual has put out there themselves! The four main social media sites in China are 1) Ushi.com, a professional platform with the look and feel of LinkedIn; 2) Sina Weibo, a micro-blogging site similar in form and market saturation to Twitter; 3) Sina Quing, a light-blogging site that enhances Sina Weibo and operates similarly to Tumblr; and 4) RenRen, which is most similar to Facebook and requires key information such college, high school, and hometown to establish a profile. All fabulous, but I’m a sucker for Ushi… If you’ve been reading this blog long, you know we APRA MidSouthers love LinkedIn, or anything like it!

Business Information
  • I’ve fallen hard for Investor Relations Asia Pacific (or IRASIA). The database is searchable by company name or stock ticker, and it provides business profiles, including annual reports, stock information, insider information, etc. (Sigh, eyelash bat…)
  • The old love of my life was (maybe still is…) Hoover’s. Did you know Hoover’s is searchable by geography?! Sure enough! The company’s database is easily broken down by country and then region. Even if your company isn’t listed, this is still a great way to do some benchmarking.
  • I also had great luck with business media sites like Reuters Investor and Bloomberg. Both have sections specifically geared toward Asian markets and are great resources for general information and targeted searching.
  • Note: This is one area where paid resources/subscriptions can definitely help. Sources such as LexisNexis, OneSource, Merchant Online, Factiva Companies/Markets, and the Asian Company Handbook all have great information for Asian companies and business leaders. We already have subscriptions to some of these, and I was able to use the others through our local business library. (#librariesforever!)

Wealth Indicators
  • Compensation came surprisingly easy. There are several great salary surveys online: Robert Walters Global Salary Survey 2012 (in downloadable pdf) and Gemini Personnel, which is great for those hard to find middle-level employees. Where it made sense, I also benchmarked with American companies to see what a person would be compensated here (for example, if they just recently moved to China for a promotion, etc.)
  • Real estate was a little more difficult. I essentially used what I knew (an address) and found out what flats would rent/sell for in those areas using various real estate firms. The search functions of Colliers International and CB Richard Ellis were particularly helpful. For Hong Kong, I had great luck with HongKongHomes and LuxeHomes, though there are a ton of similar sites out there.
  • Art Collection. Did you know in 2011, China overtook the U.S. to become the world’s largest art and antiques market in terms of auction and dealer sales? According to CNN, it’s true. The China Guardian and Beijing Poly, as well as standard favorites Christie’s and Sotheby’s, are very easy to search.
 
Philanthropy
  • The climate of philanthropy in China is FASCINATING. If you haven’t researched it yet, I HIGHLY suggest it for your own knowledge/enjoyment. But, that’s the dork in me, and that’s a post for another time. Today, you want to know how to find information on Chinese charities. So, I give you: China Foundation Center, a searchable databases of private foundations in China. Think Foundation Directory Online. I have also heard good things about GrantMakers Online, though I didn’t have great returns there. Maybe next time!
  • For Hong Kong specifically, try WiseGiving, a searchable database for public charities and foundations with the similar feel of Guidestar.

News Sources

So, that’s it from me! If you have a minute and want to keep this party going, take a virtual wander and meet some folks who are doing amazing things in international prospect research: 1) Beth Bandy at International Fundraising Intelligence. Seriously, I bow down. I don’t know her, but she’s awesome. And, so is her blog. She also has a guide for prospect research in China that looks amazing and reasonably priced. If our leadership continues to travel there, we’ll definitely be purchasing it! 2) The folks in the Stanford University Development Research department. Their list of resources is amazing. They also have links to old APRA presentations and resources for other parts of the globe. I definitely bookmarked it and will be visiting again. Thank you!

For those of you who have been at this a little longer, what resources do you find helpful?? Leave us a comment and let us know! Or, if you would like to chat off-line, find me on LinkedIn.

Angie Stapleton, Vice President, APRA MidSouth
vice.president@apramidsouth.org

Friday, August 24, 2012

What Was the Deal With the 2012 Big APRA Conference?

Was it the number of attendees? On the second day of the conference, I ran into outgoing APRA board president Michael Quevli. I cornered him and said “I keep going to these packed conference sessions. Wow. Are random people sneaking in this year or what?” He assured me, the registration desk was on top of things, and the room monitors were as polite, and firm, as ever. They were trained to spot missing lanyards miles away. No bling, no sing. Michael noted that the numbers this year were set to break 1,000 total registrants; it looked like the best APRA conference numbers anyone remembered.

Was it the strong analytics curriculum available in a variety of formats throughout the conference? It’s no secret to those of us who have been in prospect research for a while: analytics is where the excitement and energy is for our field. Our work is to harness analytics curiosity, follow it up by expertise, then implement model findings into front line strategy. Fundraising programs collect a lot of information; it’s time to seriously use it, for ourselves, and for our senior leaders. Analytics drives the prospect research individual or shop to more compelling, less banal work (read: manually updating written profiles). Defining subsets of constituents, identifying unique patterns, and truly gaining insight into donor behavior is where today’s prospect researcher is headed.

Was it realizing many of our vendors are truly committed to advancing our profession? For example, I give you Tony Glowacki. What I like about the WealthEngine chief is that during the analytics symposium’s first day – he gives a workshop talk before lunch, Why We Love Big Data. Now, it was a pleasant overview of our nonprofit industries’ being able to do more than ever technologically, intuitively, with information we already have. But this isn’t why I like Tony. I like that he dismissed us to lunch over in the big ballroom (a delightful multi-course affair paid for by his company), only to pop up again minutes later – as the featured lunch speaker! Tony! Toni! Toné! We weren’t eating sandwiches, we were inside a Tony Glowacki/Wealth Engine three-meat club deluxe. The lunch turned feast when he gave us the world premier of the WealthEngine Institute. It’s gobs of premier industry resources – free. Once back home at my Vanderbilt desk, I had time to more deeply review the institute’s offerings. MUCH relevant, recently researched, and handsomely presented bits of industry content here. Need to share the nature and scope of an analytics project with unconvinced superiors? The 84-page Growing Individual Gifts: An Analytic Approach to Data-Driven Success resource should do the trick. The graphics are especially helpful. Tony and WealthEngine’s passion to connect with their audience, and to help lead the industry in this conversation make a strong impression. 

Was it the ace conference sessions? Here are a few I attended that were particularly inventive. They reminded me of a meta-theme I too often forget: we prospect researchers work (or should!) in a tech field. Using Game Theory in Analytics by Rachel Link and Gregory Duke; Innovative Patient Prospect Identification by Elizabeth Dollhopf-Brown and Alex Oftelie, and Portfolio Support and Tracking Performance by Stephen Hardy. Also excellent was Ethics: Go Fish! by Christy Wineland. Finally, the APRA Roundtable Networking Event was an enlightening occasion to meet attendees in my city, state, and/or region. We are a whole lot different, a whole lot the same.

Was it the fundamental theme of generosity set by the big APRA leadership? Yes, and certainly not just them. The conference planning committee, the presenters, the many chapter presidents and chapter leaders, the tireless volunteers, and of course the spirited, curious attendees – all gave shape to the nature of this professional, original, important, and fun occasion. So, yes. Yes to this and each of the preceding questions. The deal is that there is an energy, enlightenment, and excellence associated with APRA. Next year’s conference is in Baltimore, Maryland, from August 7-10, 2013.  It will be held at the Baltimore Marriott Waterfront. I plan to be there! I hope you also will make plans to attend.

Geoff Little, President, APRA MidSouth
president@apramidsouth.org

Wednesday, August 15, 2012

Notable Connections from Wikipedia

In 2006, taking over as the full-time prospect researcher at Western Kentucky University, I was charged with finding new ways to discover prospects.   I subscribed to the daily e-mail generated by the Media Relations office which compiled news feeds where “Western Kentucky University” was mentioned.   I compiled various lists from the database based on different parameters (colleges, student activities, sports, locations, etc.) but going through those lists often became a daunting and monotonous task.  One day, after crossing my eyes looking at one more row on a spreadsheet, I realized I had to come up with something that would put a little spice into my research day.

You know what I mean:  it’s like you can only eat so many PBJs for lunch.  Sometimes you need to have the turkey and swiss on rye for a change. (I’ll take mine with spicy brown mustard please!)  So, in a moment of what seemed like pure insanity, I googled “Western Kentucky University” to see what came back.  I had no preconceived notions of what I might get in return, but the reward was more than I could have imagined.

First, I got my very first LinkedIn name.  I have already blogged about how helpful LinkedIn has been to this small shop prospect researcher.  Second, I got WKU’s Wikipedia page.  Hmmm….I hadn’t really used Wikipedia before so I wasn’t sure what I would find.  As I read through the history of our university, my eyes lit up as I saw:

I felt like I had won the lottery!  Give me a cupcake for dessert!  It was just what this new researcher needed to help her get started in the quest for new names.  As I researched the list, I did find that many were fully documented in our database.  For others, Wikipedia provided the jumping off point for discovery (especially those who did not complete their degrees).

From that first hit, I’m happy to report that I discovered someone who had not previously been qualified and cultivated.  The fundraisers took it from there, and now this prospect is fully engaged with the university on a personal and philanthropic level.  And yes, I have found others worth pursuing and passed on the information as well.

I return to WKU’s Wikipedia page several times a year to see if any new names have been added.  I’m usually not disappointed.  It’s always fun to see a new name and it certainly gives that little “extra” treat you need every so often.  When writing this blog, I decided to use my original search terms, I googled “Western Kentucky University” and added the terms “notable alumni.”  A new website appeared: www.ranker.com

The page of notables automatically popped up using my terms, but by going directly to the website and typing “Western Kentucky University” in the search box on the list tab, the notables list also generated.  While many of the names were repeats from Wikipedia, a few new ones did appear.  So, in the future I will partake of this new menu addition as well.

Dessert, anyone? (Think it will be chocolate chip cookies for me this time.)

Theresa Clark, WKU Prospect Research Coordinator, APRA MidSouth Director-At-Large
at.large@apramidsouth.org

Wednesday, August 8, 2012

Maximizing Connections

Maximizing connections is an important part of work in advancement.  Most noticeably, gift officers are trying to gauge and maximize an individual’s connection to the organization.  However, the importance of connections goes far beyond this level.

It is useful to think of our prospects as people who can connect us to more prospects.  If a prospect cares about your cause, perhaps she has like-minded friends.  Or, if not, perhaps she can share that enthusiasm with her friends.  In conducting research, it is important to be thinking:  who does this person know? Questions I like to focus on include:

  • Who are their colleagues at work?
  • Where do they volunteer or sit on a board and with whom?
  • Who are their neighbors?
  • Who else is a member of that club or alumni chapter?

Thinking in these terms and exploring these possibilities can open up exciting new possibilities.  Where do you look for connections in your work?

Caroline Rossini, Treasurer, APRA MidSouth
treasurer@apramidsouth.org