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!
I happened to be playing around in the Interactions cube in my Dev environment when your email came through. There are fields for "Most Recent Performance Name" and "Most Recent Performance Date". And there is a field called "Interaction Amount" that seems to pull in the amount of whatever is you are looking at (ticket, contribution, etc.). I think this will get you what you are after, but, unfortunately, it requires v16.
I think you'd then have to use the Interaction Action field to limit to Scans for the last attended (rather than including the last purchased).