• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 31 views
  • Users 0 members are here
Related

Identifying $ Ticket buyers within a date range

Adam Sachs
$organization

Using List Manager I'm trying to identify (for example): People who bought tickets totaling between $1500 and $2000 in 2009.

I can't seem to figure out how to qualify the total ticket $ amount within a certain date range. It's giving me people who have ticket histories of that amount regardless of the date range.

I've tried: Ticket Total Amount along with a Ticket Performace Date range, Ticket Order Date Range etc. No luck.

Any ideas?

-Adam, Brooklyn Academy of Music 

Parents
  • $organization

    Yes, you’ll need to talk to your IT team.  They will need to go into the T_KEYWORD table and probably adjust what is in the Detail Col column (probably more technical detail than you need but it might help you make a specific request) so that it correctly summing the amounts of ticket history rows.  You should also confirm with IT what the Amount column in your ticket history is being populated with (maybe it is the per seat amount but it just isn’t labeled that way).

     

    One more thing to check.  Be sure that the Performance Date and Order Date criteria you are using are actually looking at the ticket history.  We don’t ship or recommend criteria that look directly at the ticket order tables, but I know people add them.  If you are using one criterion that looks at the order tables and another that looks at the ticket history tables you won’t get the desired result.  Essentially in that scenario the results you get will be as if you are using HAS.  You can easily check this yourself by right clicking on the criteria in the list of available criteria, then noting what’s in the Detail Tbl.  You don’t have to understand it, just match it.  If the same thing is listed for both criteria then they are looking at the same table and you can use IN they way you want to.  If they are not the same, then you can’t use IN effectively and you need to find other criteria that are looking at data in the same table.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Reply
  • $organization

    Yes, you’ll need to talk to your IT team.  They will need to go into the T_KEYWORD table and probably adjust what is in the Detail Col column (probably more technical detail than you need but it might help you make a specific request) so that it correctly summing the amounts of ticket history rows.  You should also confirm with IT what the Amount column in your ticket history is being populated with (maybe it is the per seat amount but it just isn’t labeled that way).

     

    One more thing to check.  Be sure that the Performance Date and Order Date criteria you are using are actually looking at the ticket history.  We don’t ship or recommend criteria that look directly at the ticket order tables, but I know people add them.  If you are using one criterion that looks at the order tables and another that looks at the ticket history tables you won’t get the desired result.  Essentially in that scenario the results you get will be as if you are using HAS.  You can easily check this yourself by right clicking on the criteria in the list of available criteria, then noting what’s in the Detail Tbl.  You don’t have to understand it, just match it.  If the same thing is listed for both criteria then they are looking at the same table and you can use IN they way you want to.  If they are not the same, then you can’t use IN effectively and you need to find other criteria that are looking at data in the same table.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Children