TAMATO October meeting - video

Hi folks,  In case you are interested here is the slide deck that I presented for this meeting on setting up simple Custom Categories to better analyse by List or Constituency.  

Cheers,

Heath

2084.TAMATO SDC OCT 19.pdf

Hi Staci Stickovich and Terry Stevens

New is people who have bought a ticket for the first time this year (we run performance seasons Jan-Dec)

Renew is people who have bought a ticket in the last TWO years (we're pretty small and because of business rules went with this)

Re-engaging peeps are those who bought a ticket greater than 2 years ago but not in the last 2 years (and also don't appear in the above 2 lists).

I regenerate these lists (dynamic) by scheduling the Maintain Constituency Utility as delete and update every night so deduped "New" records end up with their correct history.

List criteria is  ....

New:

• HAS Ticket History Prod Season (anything with 2019)
• DOES NOT HAVE Ticket History Season - anything < 2019

Renew:

• HAS Ticket History Prod Season (anything with 2019)
• ALSO HAS Ticket History Prod Season 2019

Reengage: 

• HAS Ticket History Prod Season (anything with 2019) 
• ALSO HAS Ticket History Season < 2017 
• DOES NOT HAVE Ticket History Prod Season 2017-18
• ALSO isn't in Renew list (which I check for overlaps from time to time)

This is awesome, thank you so much for sharing!

Thank you Heath!  I can't wait to share all of this with our ticketing team and get it working in Analytics for us.  

Hi Heath, I have been closely following the steps from your Tamato presenation. I've got as far as the lists and attached New, Renew and Reengaged consituencies to them. I am stuck on "TX_ANALYTICS_DIVISION_ELEMENT' This might be really silly, but how do I get this into the Systems table?  

Hey Danielle,  That's not silly at all.  Whose your Tessitura Admin?  They can give you access to system tables via the Security App (give me a yell if you need help with that as that's a small world unto itself).

Once they've done that you should be able to find that from the GoTo menu in System Tables

Hey Danielle Barlow, think I can do that for you

That would be great! Thank you both 

Actually I think I need to check this with Andrew Chew, sorry Danielle, will get back to you

Danielle Barlow try now!

Hi Heath, thanks so much.I have progressed to getting that into the systems table. I am have to wait til tomororw to have the constituencie lsits in analytics but i was playing around with the ticket order and order days since on sale line graphs. I see in one of your screenshots from your presentation you have the Ticket Count RSum. I am not sure maybe it's just because I dont have the data yet, but I can't seem to get it working. Would you mind sharing how you set up these widgets? (I have add my filters etc but just can't get mine to be cumulative). Thank you so much for all your help

Hi Danielle,

Hope this helps.  

1. I used Ticket Count for my Value
2. it'll default to SUM which is ok but won't be what you want
   1. NB  SUM([Ticket Count]) and [Total Ticket Count] are the same thing and it'll give you either of these depending on what you are doing.
3. Pencil the Value
4. this is where it might get tricky.   
   1. Place your cursor BEFORE The formula.
   2. you can free-type functions OR search for them.  I recommend typing RSUM and a "(" open round bracket. 
   3. Then put a ")" close round bracket at the end of the formula 
   4. Now you have RSUM ( SUM([Ticket Count])  )

Pro Tip using Formulas:  You can add spaces and returns between brackets and formula elements to make them easier to see

Holler if you need anything and we can do a skype thing :) 

Hi Danielle,

Hope this helps.  

1. I used Ticket Count for my Value
2. it'll default to SUM which is ok but won't be what you want
   1. NB  SUM([Ticket Count]) and [Total Ticket Count] are the same thing and it'll give you either of these depending on what you are doing.
3. Pencil the Value
4. this is where it might get tricky.   
   1. Place your cursor BEFORE The formula.
   2. you can free-type functions OR search for them.  I recommend typing RSUM and a "(" open round bracket. 
   3. Then put a ")" close round bracket at the end of the formula 
   4. Now you have RSUM ( SUM([Ticket Count])  )

Pro Tip using Formulas:  You can add spaces and returns between brackets and formula elements to make them easier to see

Holler if you need anything and we can do a skype thing :) 

Great! Thank you so much. That's worked a treat! :)

Excellent.  Well done