Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 02-28-2008, 02:13 PM   #1 (permalink)
Query Queen

Robin's Avatar

Join Date: May 2006
Location: Helena, MT
Posts: 45
Rep Power: 0 Robin is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Question Lapsed Donors

I've been asked to give the number of donors who have not contributed in the last 3, 5, and 10 years. I need to do a query on date ranges in which donors did give for each before I run the non-contributors report. But what should my criteria be? For example, for the 3 year one should I only look at those donors who gave in the year previous to 3 years ago? Or should I go back further than that? How do others report on lapsed donors?
__________________

Robin Lyda
Database Strategist
Intermountain
Helena, MT
robinL@intermountain.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 02-28-2008, 02:25 PM   #2 (permalink)
ah one, and ah two

Michael Sherman's Avatar

Join Date: May 2006
Location: Sarasota, FL
Posts: 431
Rep Power: 3 Michael Sherman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- Patron's Edge (PE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)

In your query use the "Last Gift Date" as criteria:

Last Gift/Gift Date/Less than 01/01/05
__________________
Michael J. Sherman
Database Administrator
Sarasota Orchestra (name change 9/3/08)
The new Florida West Coast Symphony

msherman "at" SarasotaOrchestra "dot" org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 02-28-2008, 04:02 PM   #3 (permalink)
Query Queen

Robin's Avatar

Join Date: May 2006
Location: Helena, MT
Posts: 45
Rep Power: 0 Robin is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Thanks, Michael!
__________________

Robin Lyda
Database Strategist
Intermountain
Helena, MT
robinL@intermountain.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
lapsed


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Gas - Loans - Mobile Phone - Arizona Pools
All times are GMT -6. The time now is 06:10 PM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70