Last appeal received - need ability to build query on this date

We are currently undergoing a reactivation campaign and part of this process is to be able to have a query export the date a donor last received an appeal eg if an active donor’s last appeal received was in 2007 and they have/havenot donated since this date we may want to send them a reactivation campaign letter. Unfortunately RE will only allow me to report on ‘Assigned Appeals’ not export the last appeal received. I am a little surprised this is not standard as it is important information for reactivation campaigns.

  • Guest
  • Mar 16 2015
  • Attach files
  • Guest commented
    December 08, 2016 21:04

    It's problem we have this problem not  solved

  • Liz Walsh commented
    September 06, 2016 15:04

    Was just about to ask for the same thing.  Sad that this was asked for over a year ago and it hasn't been implemented yet.  Would be hugely helpful!