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.)

Reply
  • 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.)

Children