Hello all,
I'm working on abandoned cart numbers for the Marketing team. I've pulled my data from T_WEB_ORDER and I want to verify that I'm interpretting things correctly. I can't find the system table listed in the system table documentation for Tess or TNew.
When I'm looking at a customer_no that ties back to the TN Express Web User, can I make the assumption that they dropped out of the process before logging in?
When I see a customer_no tied to an actual patron account in Tessitura but not acorresponding order in T_Order, I'm assuming they dropped after logging in but before completing the purchase.
Obviously, if it's in T_WEB_ORDER and T_ORDER, I can see the completed order in Tessitura.
I want to be sure I'm interpretting things correctly before moving along in the process. Also, if anyone knows where I can find table details on T_WEB_ORDER, I'd appreciate the direction.
Implementing abandoned cart emails is going to be a slow process.
Thanks!
M
Yes you are interpreting that correctly.
If you are seeing the anonymous user account as the customer_no on T_web_order then the custoemr never logged in during that session.
If the custoemr_no is in then the customer had logged in (may have done so initially which we get as members ahve to log in to get their benefits) but then never completed the order.
You may also want to check that the customer didn't place another order on the same day for that show. I have had a few instances where a customer has placed a successful order but has maybe not seen it acknowledged correctly and started to place the order again before the email confirmation came through and then abandoned that order.
Mark