Giving by class year
If we define “participation” as giving a gift (of any size), then one thing we can do is measure and track the “participation rate” of a given class year over … Continue reading
Predicting income based on job titles
Some background: As I’ve discussed in previous posts, we use people’s home address, along with block-group and census tract level demographics from the American Community Survey, in order to generate income … Continue reading
Revisiting geography as a major gift indicator
From time to time on the Prospect-DMM list-serve, and on insightful blogs like CoolData, there is some debate about whether there is much value in geographically aggregated data when it … Continue reading
Introducing: rcrunchbase
In case you were intrigued by the last couple of posts about mining CrunchBase, I wanted to make you aware that the development has progressed quite a bit and you can … Continue reading
The cost of premature aggregation
Here is a common situation: a client calls, asking to know the average giving for the year for any prospect in her unit’s portfolio. As an analyst, I want to … Continue reading
Mining CrunchBase, part II
In part one, we created some basic functions that handle the nuts and bolts of interacting with the CrunchBase API — authorization, sending GET requests, parsing the response data, and … Continue reading
Mining CrunchBase, part I
My colleague asked me this week if we could quickly discover Cal alums listed in CrunchBase. I spent some time clicking around on the site, and reading the documentation for … Continue reading
Some teamwork, a map
My colleague, a prospect researcher, had queried our database to pull a list of several thousand suitable technology related alumni in response to a request from one of her clients. … Continue reading
How do you do documentation?
This post includes a PDF that I couldn’t embed but that I would love for you to take a look at: Capacity Model Among the many things about my job that … Continue reading
Correct link for the SF map
In my previous post I gave an incorrect link for the interactive San Francisco map. The post has since been fixed, the correct link is: http://tarakshah.org/demos/sfmap.html