T_Web_Order

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

Parents
  • Hi Michelle, 

    We're implementing this at the moment and it hasn't been as painful as I first thought. We've done something similar who's in T_WEB_ORDER and not T_ORDER etc

    What I'm working on now is the List Criteria Marketing can use to select which events they would like to target for Abandon Basket Emails. 

    Kelly

     

     

Reply
  • Hi Michelle, 

    We're implementing this at the moment and it hasn't been as painful as I first thought. We've done something similar who's in T_WEB_ORDER and not T_ORDER etc

    What I'm working on now is the List Criteria Marketing can use to select which events they would like to target for Abandon Basket Emails. 

    Kelly

     

     

Children
No Data