extraction based on most recent attendance

Hi, and thanks for all the replies.

I was definitely overthinking the extraction and right at the end of the day I sussed it!

It isn’t about when people came in terms of year by year, its their last attendance that is the most pertinent one – therefore by reducing the suppressions from other years, I managed to get the three extractions to work, without any crossover and to the total I was expecting should I just pull all the years sales.

Thanks so much for all the advice, tips etc though – much appreciated.

Rich

From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Charles Buchanan
Sent: 18 June 2012 17:14
To: Richard Surgay
Subject: Re: [Tessitura Marketing Forum] extraction based on most recent attendance

Hi Rich,

I would recommend doing three individual extractions without suppressing the seasons so that you have the accurate number of constituents who booked during each of the three time periods (including those that fall into 2 of the 3 or 3 of the 3 groups).  Since you can not pull based on order date, can you pull by season (i.e. 2006-07 season)? Or, do you only have the lists of buyers for each year in List Manager?

Chuck Buchanan

Manager, Direct Marketing and List Management

92nd Street Y

Hi all

I've got a problem with three extractions I'm trying to do. and would appreciate some help.

I'm trying to find people who attended at various times. The first one is our oldest list 2004 - 2006. The second is the middle group of people who attended 2006 - 2009, and the final one is for recent attenders 2010 - present day.

the problem I'm having is that people who booked in two (or three) of these periods aren't being picked up. For example someone who booked in 2006 and 2011 isn't being picked up. For the extraction I'm trying to find people who attended in 2006 - 2009 I have suppression sets 2010-2012 and so they are excluded at that point. In the other extraction of finding people who attended in 2010-12, I have suppression sets for people who attended in 2006 so they are ruled out at that point as well.

Could anyone point me in the right direction of resolving this please? I can't think of a way! I would have done it by order date but we're only 18 months into using Tessitura and this information was not brought over from our legacy system. Curses!

thanks

Rich

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!