Hi everyone!
This is a very specific question, but maybe someone has run into this before as well.
Our subscription dashboards are currently setup to use lists in order to separate new vs renewing subscribers. Our top level dashboard uses both to get the total numbers. However, it looks like the lists might not be picking up all people/ sales? They are set to automatically generate every day around 5pm, well before our night Analytics load. Additionally, it looks like the main issue is with flex pack numbers.
Here's what the numbers look like with the list filter ON:
And here's what it looks like with the Lists filter OFF:
In case the images are too small, when the lists are on, Flex Packages (CYO) are $4,332. When the lists are off, that number jumps to $36,057. The field that we are using to report that money is Ticket Original Paid Amount, so it shouldn't be contingent on seated vs unseated packages.
Any thoughts? We have a ticket open for this, but I figured I'd ask the brain trust here on the forums as well!
Thanks in advance!!
Kari,
Not sure if you're a SQL User, but we pull our Renewed/Purchased packages List using a query in List Manager when we're still in the middle of renewals and haven't seated FLEX yet. It pulls from Order/Line Item data, so they don't need to have a seated package to qualify. We also filter out unpaid rollovers. You'd just need to update the list of pkg_no's with your package IDs for your season and copy-paste into the Graphical Edit pane in List Manager.
SELECT DISTINCT T_ORDER.customer_no
FROM T_ORDER
JOIN T_LINEITEMON T_LINEITEM.order_no = T_ORDER.order_no
WHERE pkg_no IN (85, 86, 87, 88, 89, 90, 91, 92, 93, 94)AND T_ORDER.tot_paid_amt >= 1;