Haia all
Hoping someone has a magic solution to this one...
We have imported our visitor figures in to Tessitura and I'm looking to show donation per head, so looking at contributions on a specific constituent against the number of tickets booked during that month. (Each museum has it's own constituent).
I know this is affectively mixing Seats and Tickets cube and Contributions cube, but is there any chance this is possible in one widget? Without me having to update it manually?!
It would be a Contribution Amount (Sum filtered by Fund) / Ticket sales (Sum) for a particular constituent in a particular month
All thoughts super welcome!
Thanks all,
Kirsty
Heya Kirsty,
No idea if the below is helpful, but thought i'd drop down my thought:
First suggestion - maybe this is something the interactions cube will help with when it arrives?
Second suggestion - the finance cube would have both ticketing amount and donation amount for you. But not sure if your visitor figures would pull into the cube
Third suggestions - which doesn't help with the percentages - and doesn't help if the visitor figures aren't pulling through. But could you put two widgets side by side - one with the ticketing data and one with the contribution data? At least you could then visibly see them closely.
Fourth suggestion - using the above info for figures and manually updating your widget. So maybe having Contribution Amount (Sum filtered by Fund) / then manually inputting the figure for ticket sales (sum) This is something I'd probably do! It's a bit manual but at least it's only once a month.
Hope something in this was useful!
Diolch Maddie! I am v excited for the interactions cube... potentially a goer for this! I think we might need to go with the widgets side by side by now and monitor, and then perhaps work out a spend per head for the month before manually. I may also look into custom analytics fields to see if that can help us out too...
I'll report back..!