• Replies 2 replies
  • Subscribers 333 subscribers
  • Views 130 views
  • Users 0 members are here
Related

Identify Single Ticket Buyers

Brad Watkins
$organization

My marketing committee would like me to pull the number of constituents who only bought tickets to a single performance over the last three years.  In other words, I'm looking for people who did not attend any other performance within the same season.

Luckily we only produce three mainstage shows a season, but I'm blank in figuring out the easiest way to find this.  

Any help would be appreciated. 


Brad

Parents
  • $organization

    Hello,

    You could use list manager and put something like the following in the manual edit field.

    select customer_no
    from t_lineitem l
    join t_order o on o.order_no=l.order_no
    join t_perf p on p.perf_no =l.perf_no
    join tr_season s on s.id=p.season
     and s.fyear in (2009,2010,2011)
    group by customer_no
    having count('x')=1



    [edited by: Jon Ballinger at 6:48 AM (GMT -6) on 22 Apr 2010]
Reply
  • $organization

    Hello,

    You could use list manager and put something like the following in the manual edit field.

    select customer_no
    from t_lineitem l
    join t_order o on o.order_no=l.order_no
    join t_perf p on p.perf_no =l.perf_no
    join tr_season s on s.id=p.season
     and s.fyear in (2009,2010,2011)
    group by customer_no
    having count('x')=1



    [edited by: Jon Ballinger at 6:48 AM (GMT -6) on 22 Apr 2010]
Children
No Data