Hi!
I feel awful even saying the words "Conversion Rate", but I'm going to go there anyway lol. We used to have a report that followed our in-house definition of Conversion Rate, but it might not be accurate anymore and the person who made it isn't here anymore. Additionally we would LOVE for this to be a self updating widget in Analytics if possible. Since people can't buy a membership and tickets in the same transaction online we widened out definition of "Converted" to people who bought a membership and tickets in the same day/all the people who bought any tickets. Our rationale is that they had a choice to buy full price tickets and no membership, or buy a membership and tickets. Even those who are renewing have that option so we include them too, not just non members. I know that this mixes Membership and Seats & Tickets data, but I thought maybe I could cobble something together with the data options that cross over into other areas. I have my eye on Campaign Category in the Membership cube. I have categories for Admissions and then two for our Membership categories? What I'm unsure of is how to I ask for when that happens on the same day. Likely I won't be able to get to the data I want, but I thought I'd drop a line in the water here and see what I come up with.
Jenny
Hi Jenny,
Might it work to look at daily figures in the Finance cube for counts of constituents with both a ticket and membership purchase? For example, with Days in Transaction Date on Rows, having a Value for
SUM ( [Constituent ID] , IF ( [Total Ticket Purchase Amount] > 0 AND ( [Total Contribution Amount] , [Fund IN your membership funds] ) > 0 , 1 , NULL ))
If you need to see it at a higher level, like monthly rather than daily, then we need to add Transaction Date in the formula...
SUM ( [Constituent ID] , SUM ( [Days in Transaction Date] , IF ( [Total Ticket Purchase Amount] > 0 AND ( [Total Contribution Amount] , [Fund IN your membership funds] ) > 0 , 1 , NULL ) ))
Thank you Chris, this is great. And they make total sense. For some reason though it doesn't like the greater than sign, in both cases. The formula is so basic though, I can't see why it's giving me the "unexpected token '>' in FunctionParameters definition" error.
Screenshot and copy / paste in here? Maybe attach .dash?
Sure! I'd share the .dash but I can't save as it is.But I can share these Sorry they're so shrimpy. The error, in both cases is "Function Syntax Error: Unexpected token '>' in FunctionParameters definition.
It might require a closing parenthesis before the ' > 0' portion.
It’s me, hi, I’m the problem.
I'm going to update my original post, but this needs a "> 0" appended to it in both examples...
AND ( [Total Contribution Amount] , [Fund IN your membership funds] ) > 0
That helped the formula and I can save it now, but I'm not getting any results. SMM Conversion Rate In Progress 6.6.23.dash
It's all the CONTRIBUTION DATE fields and filters that are segmenting contributions from ticket purchases. Change the Rows fields for Months and Days to use TRANSACTION DATE, and replace the Cont Dt in Last 2 Mo with TRANSACTION DATE in the Last 2 Months.
Wow, I really fell off on this one!I changed the type of date I used (cont dt to trxn dt), I didn't even realize I had mixed them, haha! I was still coming up with zeros in the results. Interestingly, when I changed the Total Ticket Purchase Amount to ">=0" in the Value formula instead, THEN I got some results. The problem with these is that it includes orders with just memberships. I've tried adding pieces to the formula with no luck (Price Types, Campaign Category, etc.) with no luck. The error said I can't use 4 parameters in that function. I tried changing that zero to NULL (worth a shot), nope. I added Order Shipment Method PAH to the Widget filters, which helped some but there were some membership-only orders that had used that too. I am really stalled out now. Do you have any ideas?
Or is there a way to get at this from Seats & Tickets? Initially I ran into some bumps with this and thought that it wouldn't be possible, but now that I've come a little farther I'm wondering if I was wrong. I backed up to my original question, "how many orders have both a membership purchase and tickets ($0+ tickets)?" Does that have any potential? So far I haven't had much luck that way either.
Could you make a list of records with an active membership and then use that list (as a filter) in the Tickets & Seats cube to look for those with tickets?