Hi!
I am trying to create a list of monthly transactions by order number that includes the date & time of the transaction and constituent info (like name & email). When done in Analytics, we can't figure out how to get the timestamp on the transaction date. Any help on this would be much appreciated!
Thanks!
Genevieve
Hi Genevieve,
Analytics doesn't support time generally across date fields (you can find Hour on a few fields in the Seats and Tickets cube). Please vote here Enhance Tessitura Analytics date fields to include time - Ideas - Ideas - Tessitura Network.
Would also like to add that if there's a transaction report that would include contributions and ticket transactions for the month, and could show constituent info, I'm also interested in that! Thanks!
Thanks, Chris! I just voted. Would love to see a combined date and time option.
I didn't see your response before I added my sub-comment below. Is there a transaction report that would show a list of all contributions and ticket transactions in a month, with the option of adding in constituent info? I need to provide this info all together to the digital marketing agency we use. Thanks!
Check out Transactions by Posting has time stamps in the CSV output.
The Batch Payment Details Report has the timestamp as well, but can only be run for one post at a time.
Order Hour is good for some metrics on "busyness", but I've wondered for a while about hour in the other date fields. Is it an issue of the amount of data being pulled from the warehouse into the dashboard?
Nah… well, sort of. It’s kind of weedy. Sort version is, yes, if we needed to inflate every date dimension to include a row for every distinct datatime that exists in the data warehouse so that the join between the fact table and date dimensions work. But, also no, because we'd take a different approach to meet this need: probably adding a datetime field to the fact table from which the date dimension is joined.
Thanks! It looks like these are giving the timestamp of when a batch is posted, rather than when the transaction is completed. I'll keep looking around to see if I can find a work around. Thanks again!