Comparing Age Demographics Across Years

-

Hey you guys!

Here's a question posted to the Facebook RE support group last week (but I've seen it many times): "How can I compare my donor age demographics to what they were 10 years ago?"   RE isn't exactly built to answer that question. With a couple of calculated fields in Tableau, you can quickly visualize this comparison from a simple RE export.  Check it out here.  

What do you think?  Comments are welcome!

Next time, I'll discuss ways to display the dates of donors' first gifts and perform some quick data analysis. I will also do it in a fraction of the time it would have taken to export this from RE as a summary field.


Yours in Data

-Dave

Comments

Post a Comment

Popular posts from this blog

Split Gift Analysis

-
 Hey you guys! It’s not a big secret that one of the more controversial features for many long year in Blackbaud's Raiser's Edge is the split gift feature. On one hand it offers a great way to divide a single contribution into multiple funds, campaigns, or appeals. On the other hand it makes analysis somewhat difficult.  Many institutions simply don’t use split gifts at all and would enter a single check or credit card gift as multiple gifts in the batch. One of the things that makes analyzing split gifts difficult is the lack of a split gift ID in the Query and Export modules. While it is technically possible to get the split gift ID from the administrator import function, there’s another way that you can create a unique ID for each split gift segment.   In this demo , I show example examples using Excel and tableau how this can be quickly accomplished.  What do you think? What are some of the other issues working with split gifts    in Raiser’s Edge!...
Read more

Analyzing First Gift and Last Gift Data

-
 Hey you guys! A very common topic on the Facebook Raiser's Edge Support group is "how can analyze giving between more than two years, without having to run multiple reports?"  I must maintain some hope that eventually Blackbaud will dramatically beef-up the built-in reporting abilities of RE, but for now there are third-party options.   I've been doing multiple year analysis of donors for a decade now in Tableau.  There are some very quick methods to tackle this issue.  You only need four fields to do a considerable amount of analysis: Gift ID Constituent ID Gift Amount Gift Date It will take FAR less time to export these as Gift Records rather than Constituent Records with summaries.  With ALL gift records, you can analyze your data and trends at any scale (three years, five years, ten years, etc.). Here's the simple version . A much more thorough take on deep retention and KPI metrics can be found on YouTube by Concourse Hosting.   They do some real...
Read more

Quick Takeaways from the Raiser's Edge PUB

-
 Hey you guys! Just a few quick takeaways from the Raiser's Edge Product Update Briefing last week... Overall, I commend Blackbaud for finally articulating its clear vision for its flagship product. I believe that nonprofits new to Blackbaud will find a wealth of valuable resources. However, long-standing customers may not be as pleased with the new bold direction.   The total RE web view solution is not for long time Blackbaud customers. Blackbaud hopes they come along for the ride, but it clearly wasn’t made for them      While Blackbaud will offer an array of products, as far as extending the abilities of RE goes, this will largely be up to third-party services Blackbaud offers many tools to extend the abilities of RE (some might argue not enough) but it demands end users pick up skills they didn’t have during the classic era Almost no mention of Insights Designer. This is interesting given how Blackbaud has shackled the product with very limited fields and n...
Read more