• Replies 2 replies
  • Subscribers 413 subscribers
  • Views 33 views
  • Users 0 members are here
Related

Reporting on Historical Members Engagement?

Nicholas Hudson-Ellis (Past Staff Member)
$organization

Hello all,

I am trying to find a reliable way to report on the rate that members engage by buying single tickets. The challenge seem to be to report over a period and only include purchases by active members.

The type of question I am trying to answer is 'how many seats where purchased by constituents who were an active member at the time of purchase'.

Has anyone worked with this type of analysis before?

Best,

Nicholas Hudson-Ellis

  • $organization

    Nicholas:

     

    If you have a special member discounted rate for your tickets, you can simply pull a report with anyone who bought tickets at that member rate to determine their ticket usage.

     

    Otherwise, you can create selected lists of members during different fiscal years and compare that with ticket purchasers. This method isn’t quite as effective unless the start date for your memberships is all the same for every member.

     

    Hope that helps, and good luck!

     

    --

    Laine Kyllonen

    Database Application Specialist

    Science Museum of Minnesota

    (651) 221-2515

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nicholas Hudson-Ellis
    Sent: Monday, July 29, 2013 9:37 PM
    To: lkyllonen@smm.org
    Subject: [Tessitura Development Forum] Reporting on Historical Members Engagement?

     

    Hello all,

    I am trying to find a reliable way to report on the rate that members engage by buying single tickets. The challenge seem to be to report over a period and only include purchases by active members.

    The type of question I am trying to answer is 'how many seats where purchased by constituents who were an active member at the time of purchase'.

    Has anyone worked with this type of analysis before?

    Best,

    Nicholas Hudson-Ellis




    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!

  • $organization in reply to Laine Kyllonen

    Hi Laine,

    Thanks for the ideas, very helpful. I have started with the second approach you suggested, even if it does mean multiple lists for active members at different intervals (monthly) and compiling the results.

    I think the lesson for me here is to keep a discipline of ongoing engagement reports to look back on, rather than sitting back and doing historical reporting a year or two down the track.

    Best,

    Nicholas