While I was putting together a Yesterday's Performance - Known Constituents widget (sort of like the Major Donor Attendance Yesterday Widget in the Analytics recipe book), I got to thinking. Is it possible to build a widget that would display the last attended performance for a constituent, including the count of tickets purchased and the amount paid.
There is a request for something like this as a query element but the amount paid isn't part of the query element (at least not out of the box).
The data must be in the Seats & Tickets cube, just not sure if it could be presented in a useful manner in Analytics. Just thought I'd pose the question to see if anyone had done something like this in Analytics or even created a query element that would pull last performance paid amount and ticket count.
Thanks!
You got me thinking, and I put together a quick widget that seems to hit all those points you mentioned. The Dashboard has filters for Title ('General Admisison' in my case), but you could swap that out:
I also put a filter in for 'Constituent Display Name', to allow for easy searching.
The widget pulled in 'Values' for all the information you wanted, and was set to only display 1 row of 'Perf Date'. I then set the 'Row' to be descending (latest to earliest).
The result is it that shows (for that Title and Constituent), the most recent Performance. You could filter that perf by 'Attended Count' > 0 to ensure that there aren't dates for which the guest bought tickets but didn't attend. I think there has to be a more elegant way to filter for 'last performance with attendance', but this gets you there, I think.
This is interesting and might be useful. How do you get the Perf Date row? I don't see that as an available field (v15 here) and can't figure out how to create it in my widget. Also, I don't see the Sales and Revenue fields as available in our Seats and Tickets cube. I have Total Ticket Paid Amount - is that the same as the Revenue field? Not sure what value the Sales field is pulling in either. Suggestions?
I used 'Performance Date' as the row, then updated the label on it (double-clicking the 'Row' title).
'Sales' is 'Ticket Count', and 'Revenue' is 'Ticket Paid Amount'. I use those often enough that I saved 'custom' formulas as those names to reduce me having to re-name things every time!
I'm close...but I cannot for the life of me, get my Perf Date column date format to change to days. It wants to stay in years no matter what I do! I'm sure I'm missing something. Any tips?
Be sure to use the 'Performance Date' > 'Date' Row
You can hover over it, then select 'More' on the right-hand side there, and then choose 'Day'
Or, once it's already a row, you click on the 'Y' in the top left of the 'Perf Date', it will let you choose the interval you want: