I need to do a simple pie chart showing paid vs. unpaid rollover orders in Analytics. I am able to pull out unpaid rollovers, but can't find a way to identify paid rollovers. The solicitor is, for the most part, "Rollover", but I'm told that may change to the current operator once the order is processed. Further, it would appear that many different source codes have been used on new subscription orders, so that's not an option.
Is there some intrinsic way to identify a paid rollover order?
Thanks in advance!
Hi Steven,
From the Seats and Tickets Cube Field Definitions, in the ORDER DETAILS DIMENSION, there's a field called Order Paid Status:
Fully Paid is returned when the total due for an order is equal to the total paid amount. Partially Paid is returned when the total paid amount for an order is greater than 0 but not equal to the total due amount. Unfulfilled Rollover is returned when the Accepting Rollovers flag on the order is set to Y, the total paid amount equals 0, and the total due amount is greater than 0 (to filter out comp orders). Unpaid is returned when the total paid amount equals 0 but the total due amount is greater than 0 (to filter out comp orders) and the order is not an unfulfilled rollover.