Hello!
I am hoping someone in a similar situation has cracked the code on this, but I am looking to see how many people, who visited the Museum in a particular period, using a particular price type, purchased a membership after their visit and the average time between visit and membership purchase. Our memberships are booked as tickets in a different title than the admission tickets which is important context. Originally, I did:
([Order Days in Date],[Title of Membership])-([Order Days in Date1],[Title1 of General Admission], [Price Type contains "+all")
However, that clearly does not work as the days in date field in Analytics is not a numeric value. Any ideas on how to covert the date fields into numeric values with a filter would be apricated!
Thanks!
Rhiannon
I'm not much help with the formula itself, but there is a way to turn dates into numbers. It's one of my favorite analytics tricks! Thanks Chris Wallingford !
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/30055/labelled-manual-data-points-on-analytics/79778?_ga=2.169306849.1126488198.1666643361-337791811.1666363344
Thank you!