Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 07-28-2008, 08:30 AM   #1 (permalink)
Junior Member

Join Date: Dec 2007
Posts: 23
Rep Power: 0 PamelaBryman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Records Count Vs Donor Count

My system stats show that I have 64,306 CONSTITUENTS. How do I figure out how many of those are DONORS?

Thanks!
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 07-28-2008, 10:11 AM   #2 (permalink)
defygravity

Matthew's Avatar

Join Date: May 2006
Location: New York NY
Posts: 320
Rep Power: 3 Matthew is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- NetCommunity (BBNC)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

query-->New Constituent Query-->Summary Information-->Total Gift Amount >0

don't put anything in the output tab

click the results tab. the number of records you see there is the number of constituent records with gifts that total more than $0.

you can adjust for soft credits in query options. From within the query: Tools-->Query Options
__________________
things haven't been the same since that house fell on my sister.
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 07-28-2008, 10:18 AM   #3 (permalink)
ggs ggs is offline
Gerhard

Join Date: Feb 2008
Location: South Carolina
Posts: 32
Rep Power: 0 ggs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

I can think of a few ways, but maybe easiest is to run a financial Gift detail and summary report for ALL dates and look at the bottom where it says X gifts listed, Y donors listed.
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 07-29-2008, 04:28 AM   #4 (permalink)
Charlotte Ory
Guest

Posts: n/a


If you have a constituent code of donor, you could use a tallies report under statistical reports. This will list numbers and percentages of constituents with a constituent code or another field of your choosing. Well worth a look.
Thanks
Charlotte
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 07-29-2008, 11:11 AM   #5 (permalink)
RE/FE trainer and consultant

SandyWilder's Avatar

Join Date: Aug 2007
Location: Summerville, SC
Posts: 92
Rep Power: 2 SandyWilder is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)

I would do a Constituent query on a required gift field (i.e. gift date, amount, type or fund) NOT BLANK. You may hav donors who only do gifts in kind; this method would identify ANY donor, regardless of amount or type.
__________________
Sandy Wilder
President
Leading Edge Software Solutions
www.LESSllc.com
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 08-04-2008, 10:20 AM   #6 (permalink)
my feet hurt.

Melissa Siobhan's Avatar

Join Date: May 2006
Location: Connecticut
Posts: 1,460
Rep Power: 4 Melissa Siobhan is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Sorry to pipe in late - just back from vacation.

All of this depends on your definition of a donor. Do you mean cash or does in kind count? What if they made a pledge and never paid it. What about donors who designate to you through United Way. Some of the above suggestions do not account for these situations.

I would be looking likely for cash or stock donors so I would use gift amount >$0 and gift type = one of cash, pay-cash, stock, etc. Because I use other for United Way gifts I can choose to include or not include them by gift type.
__________________
Melissa S. Graves

Director of Development Services
The Village for Families and Children
www.villageforchildren.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


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 On
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Rent Games - Cheap Gas - Loan - Credit Cards
All times are GMT -6. The time now is 12:58 AM.

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