We are in our subs renewal period, and I'm trying to show renewed vs non-renewed counts in my dashboard.
Unpaid renewals seem to have a null source and order date in the database, but I can't seem to figure out how to return the count in Analytics. Selecting "(none)" for source returns no orders.
I believe, when I simply use the solictor "Rollover", I'm getting paid renewals only, but this is just a guess based on the number.
Any help greatly appreciated!
Hi Steven,
https://www.tessituranetwork.com/Help_System_v151/Content/Tessitura%20Analytics%20Setup/T_DEFAULTS%20Settings.htm
Check out your Include Unfulfilled Rollovers setting in T_DEFAULTS (change requires a FULL load). You can then use the [ORDER DETAILS].[Order Paid Status] field in addition to the techniques you mention.
How often does a full load occur? I thought it was every weekend, but I changed the t_detaults setting and still don't see the "Unfulfilled Rollover" option in Order Paid Status. Thanks!
Once a week on Mondays. You should see the result of that change tomorrow. Please open a support ticket if you find otherwise.
Thanks!