• Replies 3 replies
  • Subscribers 961 subscribers
  • Views 67 views
  • Users 0 members are here
Related

Finding Last Attended Production?

Amy Culliford
$organization

Hi all -

Trying to figure this one out - we have a list of constituents made, and we need to know what the last production was that they attended.
Is this possible? Either using a report, or analytics? The closest thing I've found is the Attendance by Performance report, but involves a lot of cross-referencing in excel.

Any tips would be much appreciated! Thanks in advance!

Parents
  • $organization

    Hi Amy,

    In addition to Maery's suggestion, Analytics has CONSTITUENT fields for:

    • First Performance Name
    • First Performance Date
    • Most Recent Performance Name
    • Most Recent Performance Date
    • Next Performance Name
    • Next Performance Date

    The "Name" fields are populated with the performance name as opposed to the production or production season name, but in case it's helpful.

Reply
  • $organization

    Hi Amy,

    In addition to Maery's suggestion, Analytics has CONSTITUENT fields for:

    • First Performance Name
    • First Performance Date
    • Most Recent Performance Name
    • Most Recent Performance Date
    • Next Performance Name
    • Next Performance Date

    The "Name" fields are populated with the performance name as opposed to the production or production season name, but in case it's helpful.

Children
No Data