Fiscal year comparison of donations by ticket purchasers

Hi All - We need a report that will show increase/decrease of new donors that were solely ticket purchasers.  I have looked everywhere, and there is not a criteria for first gift.  Someone must have a dashboard or report that would give this information.  I am going to try an extraction and see what happens.  

Criteria - ticket purchaser, first gift FY19 compared to same time period FY20.  

OR

No donation past 3 years, ticket purchaser, new gift FY19, compared to same tome FY20

We do have appeals - ticket add on and pre-sale memberships which would count in that process, but we also want to show people who have purchased tickets and then went on to give a gift that year regardless of how the gift came in.

Thanks,

Angela

Parents
  • I tried this:

    In extractions - 

    Supressed corps/orgs

    Supressed donations three years prior to the target year

    Ask - Ticket purchaser target year/donation target year.

    I get counts that way, and will pull into a list - which may work for total fiscal year, but i want to do year to date comparisons with this fiscal year.

    Messy Messy Messy Slight smile

Reply
  • I tried this:

    In extractions - 

    Supressed corps/orgs

    Supressed donations three years prior to the target year

    Ask - Ticket purchaser target year/donation target year.

    I get counts that way, and will pull into a list - which may work for total fiscal year, but i want to do year to date comparisons with this fiscal year.

    Messy Messy Messy Slight smile

Children
No Data