Hi all,
I'm trying to create a widget in Analytics that tells me "how much money we've lost from decreases and downgrades and vise versa, what we've gained from increases and upgrades."
I'm working in both the Memberships and Contributions cubes, trying to figure out which one has the data points I'm looking for. I'm having trouble finding a dollar amount for the macro trends. Is there a macro total amount option?
I'm also looking for "how many have moved up from the lower General Membership to the higher VIP Membership category" using the Micro trend data.
Thanks for any help.
Sara.
Hi Sara,
In v16 there's a new widget in the Membership Renewals pre-built dashboard titled Renewal Level Movement that may have what you're looking for:
https://www.tessituranetwork.com/Help_System_v160/Tessitura-Analytics/TN-Dashboards/Membership-Renewals.htm#Renewal
You can probably produce this in v15. The [+/- Amount] is the value of the Next Membership minus the value of the base membership.