3 Reports you need to maximize your fundraising

Sure there are the basic LYBNT, and SYBNT reports but what if you could get more details. More nuance.

1. First time donors that gave 335 days ago.

These are your first time donors that are about to lapse. Building a stewardship plan for these donors can ensure they don’t make it to the LYBNT list.

In Salesforce:
Report Type: Account

Filters:
All Accounts
Created Date: All Time
First Gift Date: 335 DAYS AGO
Last Gift Date: 335 DAYS AGO

2. First time donors that gave 90 days ago.

These you your first time donors that need to be checked in on. 

In Salesforce:
Report Type: Account

Filters:
All Accounts
Created Date: All Time
First Gift Date: 90 DAYS AGO
Last Gift Date: 90 DAYS AGO

3. Donors that gave some year, didn’t give last year, and gave this year. (Returning donors)

These are donors that used to support your organization but had to take a year or more off. This is a perfect opportunity to welcome them back to the fold.

In Salesforce:
Report Type: Account

Filters:
All Accounts
Created Date: All Time
First gift date < LAST FISCAL YEAR
Last gift date = THIS FISCAL YEAR

Most database systems can provide these reports with varying levels of automation. It would be worth your while to get them put on your dashboard.

Similar Posts

  • Starting with the right Why

    I recently had the great fortune to be involved with the creation of a first of it’s kind Interpetive Centre. Speaking in very general terms, usually, when you start creating museum exhibits you dig through your collection and figure out what you want to show. You group artifacts together in some meaningful way and you…

  • Reward systems

    As I have written before, it seems to me that in general, non-profit organizations are trapped in the shadow of the for-profit world. Non-profit organizations are structured in a way that mirrors their for-profit counterparts. A structure that has been honed over the past few hundred years to provide the perfect balance between servicing the…

  • Nonprofiting in the cloud

    Nonprofits are constantly faced with the challenge of balancing program capacity, administrative support and donations. Understanding how to leverage a nonprofit organizations donor base requires donor information to be entered into to a relational database, advanced reporting and of course correct and of course the systems and procedures to ensure the data is maintained accurate….

  • Nonprofits and scale

    I had a fascinating conversation at a conference the other day that revolved around why nonprofits don’t seem to be able to really move the the needle on some of the really tough issues we face today (see Dan Pallotta’s – the way we think about charity is dead wrong). Apart from the obvious argument…