Lists in Analytics

Why, when trying to just use One list as a filter on a dashboard my only options are the list I am looking for but pared with other lists I don't want?

Parents
  • This is how Lists work with Analytics, which is weirdly and counterintuitively.  Each customer has a value which is a comma-separated string of all the Analytics flagged lists they are a member of.  In order to filter on a list you search for "contains" and your list number wrapped in commas, so if the list number is 12345 it would be Contains: ",12345,".

    More on using Lists in Analytics here:

    docs.tessitura.com/.../Tessitura.htm

  • thank you.  I do see what you and the documentation are talking about but it still didn't just give me the one list.

  • I think maybe you still don't quite have it.  You can't select from the List of "Lists" in a filter and have it work in any normal sense.  You have to choose "Text" and then "Contains".

    Let's say

    1. Tessitura List 23 contains Customer A only
    2. List 59 contains Customer B only
    3. List 123 contains Customer A and Customer B

    Each customer in Analytics has a "List" value associated with them.  In this case, Customer A's looks like ",23,123," and Customer B's is ",59,123,".

    Customer List
    Customer A ,23,123,
    Customer B ,59,123,

    To filter down to everyone in List 123 you would Filter on List using Text:Contains ",123,", which will match to the List value for both Customer A and Customer B.

    (I've chosen those numbers to further illustrate why you need to put a comma on both sides of the List number you are selecting: if you just put in "23" it would give you anyone in List 23 and anyone in List 123, 223, 231, etc.)

  • Maybe this isn't going to work then how I am hoping. I was trying to use Keywords to pull a list of patrons/shows my list ,681, (keyword is to find our family show patrons)

    To use in analytics to then only show sales numbers, ticket counts, price type counts for Adults vs Youth price types for all FY or just selected ones based on that list of patrons.

Reply
  • Maybe this isn't going to work then how I am hoping. I was trying to use Keywords to pull a list of patrons/shows my list ,681, (keyword is to find our family show patrons)

    To use in analytics to then only show sales numbers, ticket counts, price type counts for Adults vs Youth price types for all FY or just selected ones based on that list of patrons.

Children