I am assuming the way to do this is perhaps through some of the Custom fields for constiuents in Analytics...but not sure how so looking for some potential insight.
We have an constuent attribute for School Division, so that we can easily see how much business all the schools in a Division have done with us...
Ideally, I would love to be able to pull this into Analytics and essentially have a widget that shows ticket counts/revenue, but then be divided by the School division attribute and therefore, group together all the schools properly.
Currently, we have 40 different lists that group together the schools based on the attribute, run reports separately based on the lists, and then add everything up (very time consuming!). So if anyone has any ideas on how or if attributes can be pulled directly into Analytics, that would be amazing.
Thanks in advance
Hi Derrek,
Yes! This is exactly what the Constituent Elements are intended to help with:
https://www.tessituranetwork.com/Help_System_v151/Content/System_Tables/TX_ANALYTICS_DIVISION_ELEMENT.htm
Also Tessitura Analytics Technical Orientation Part 2: Configuration at 11m:30s:
https://www.tessituranetwork.com/Items/Videos/Training/Analytics-Technical-Overview
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network Office +1 888.643.5778 ext 553 chris.wallingford@tessituranetwork.com Tessitura Learning & Community Conference July 28-August 1, 2019 #TLCC2019
Thanks Chris, this is very helpful! I figured this is what the custom elements were for, but the video was key!
Hi Chris, I have looked at the resources above, but I need a bit more guidance specific to Attributes. Is there anything else available please?
Hi Katie,
Derrek and I were able to meet up at TLCC in the Solution Center, and for his attribute, we went to the TX_ANALYTICS_DIVISION_ELEMENT system table and found the first Custom Category XX row without a definition. For Derrek that was Custom Category 01 in the Default Division. If you have more than one division, pick the Custom Category field for the division that intends to view this attribute in Analytics.
Once that's in place, the CONSTITUENT field for Custom Category XX in Analytics should reflect the value of that attribute for all your constituents. If you have trouble beyond this point, please open a support ticket with a link to this post.
Many thanks!Chris
Chris Wallingford Director, Business Intelligence Tessitura Network office: +1 888.643.5778 x553 chris.wallingford@tessituranetwork.com
Thanks Chris! I had literally started drafting a response and you beat me to it. Really appreciate your help with this, it is working great.
That's great, thanks - I've adapted that for the attribute we wanted. It sounds like a lot of Analytics learning was shared at TLCC and it's great to see it filtering through the forum!