Multiple gifts

Thanks to you and to Michael for the assist. It helped me get the task completed!

The Campaign Giving Comparison report in the Campaign and Appeals folder returns a column of number of gifts, header is gp1_cont_count.  You can select the campaign(s) for group 1 that you are interested in, and select any campaign for group2 and just ignore those columns in the output.  Another great thing about the report is that you can include soft credits if you want.  Filtering on the gp1_cont_count, you can select anyone who has 2 or more.

Hope that helps.

T.C. Brown

Database Administrator

412.392.4834

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Michael Joyal
Sent: Monday, September 12, 2016 4:51 PM
To: TC Brown <TBrown@pittsburghsymphony.org>
Subject: [Tessitura Development Forum] Multiple gifts

I am trying to find donors who make two or more gifts a year and was wondering if anyone out there has a way they do this?

My though was to run my list of yearly donors through the fund activity report and search for those with multiple payments. I would suppress my monthly donors.

Thoughts?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thanks to you and to Michael for the assist. It helped me get the task completed!

The Campaign Giving Comparison report in the Campaign and Appeals folder returns a column of number of gifts, header is gp1_cont_count.  You can select the campaign(s) for group 1 that you are interested in, and select any campaign for group2 and just ignore those columns in the output.  Another great thing about the report is that you can include soft credits if you want.  Filtering on the gp1_cont_count, you can select anyone who has 2 or more.

Hope that helps.

T.C. Brown

Database Administrator

412.392.4834

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Michael Joyal
Sent: Monday, September 12, 2016 4:51 PM
To: TC Brown <TBrown@pittsburghsymphony.org>
Subject: [Tessitura Development Forum] Multiple gifts

I am trying to find donors who make two or more gifts a year and was wondering if anyone out there has a way they do this?

My though was to run my list of yearly donors through the fund activity report and search for those with multiple payments. I would suppress my monthly donors.

Thoughts?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!