New Members-Visitation Reporting

Num Perfs During Membership is giving me dollar amounts instead of numbers. I don’t think I’m doing this right.

Laura MacKay, CTA
Membership Manager
3801 Broadway | San Antonio, Texas 78209
p 210.357.1863 | f 210.357.1882
www.WitteMuseum.org

The Witte Museum is accredited by AAM and is a Smithsonian Institution affiliated museum.

From: Tessitura Memberships [mailto:forums-memberships@tessituranetwork.com] On Behalf Of Amanda Freeman
Sent: Wednesday, June 14, 2017 7:06 PM
To: Laura MacKay <LauraMacKay@wittemuseum.org>
Subject: Re: [Tessitura Memberships] New Members-Visitation Reporting

Laura, 

Depending on what you're after there are a couple of ways to accomplish this in T-Stats. If you just want to know how many new members attended 1,2 or zero times during their membership, you can do this in the Memberships cube using the Num Perfs During Memb attribute. It automatically calculates the number of performances the constituent has during the dates of the membership in question. To limit to just new members, you can use the NRR status, and also filter on either initiation or expiration date to make sure it's new folks in the time period you're interested in.

If you want to know what performances/seasons they went to, then it might be beneficial to create a list of the members in question first, then use that list as a filter on a report in the Tickets cube.

Alternately, if you want to see new members, but the time period in which you want to review their attendance is not the same as the duration of the membership, then likewise, you'd be best off creating a list in list manager of people with the desired tickets during the timeframe you're after, then using the list as a filter in the Memberships cube, on a report similar to the first one I described, where instead of using Num Perfs During Memb, you're using the list filter instead.

Hope that helps.