Help with LYBNT extractions

I'm new to this database.  The e-calsses have been very helpful, but I'm still having troubles with extractions.  I need to generate a list of donors who made a contribution LAST YEAR of $250 or less, but have not made a donation this year.  What is the best way to go about this?

  • Former Member
    Former Member $organization

    Hi Jessica,

    If you're putting together an extraction, one simple approach would be to create a suppression segment with your current donors.  Then create a separate (non-suppression) segment with last year's donors of $250 or less.

    Because you have the suppression segment, the results should only include your LYBUNT customers.

    Good luck!

  • Hi Jessica,

     

    The Campaign Giving Comparison report is intended to provide you with LYBNT lists.  You can run the report and then save the results to a list.  And if you wanted to use it with an extraction, you can create a segment in an extraction that references the list.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com