• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 215 views
  • Users 0 members are here
Related

T_Web_Order

Michelle Kosmatka
$organization

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

  • $organization

    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

     

    Mark

  • $organization

    Thanks Mark.  It’s nice to know I’m reading something correctly.

     

    M

     

    Michelle Usadel
    Tessitura Application Specialist | The Phoenix Symphony | Tel.  602-452-0441 | Fax. 602-253-1772
    www.phoenixsymphony.org | 1 N. 1st Street, Ste. 200, Phoenix, AZ 85004


     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Ridley
    Sent: Wednesday, May 24, 2017 1:43 AM
    To: Michelle Usadel <musadel@phoenixsymphony.org>
    Subject: Re: [Tessitura Technical Forum] T_Web_Order

     

    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

     

    Mark

    From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com>
    Sent: 5/23/2017 2:24:55 PM

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization

    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

     

     

  • $organization

    Oh thank you!  This makes my job LOADS easier!

     

    M

     

    Michelle Usadel
    Tessitura Application Specialist | The Phoenix Symphony | Tel.  602-452-0441 | Fax. 602-253-1772
    www.phoenixsymphony.org | 1 N. 1st Street, Ste. 200, Phoenix, AZ 85004


     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom
    Sent: Thursday, May 25, 2017 9:56 AM
    To: Michelle Usadel <musadel@phoenixsymphony.org>
    Subject: RE: [Tessitura Technical Forum] T_Web_Order

     

    Here is the query for our dynamic list that is used to send an email through wordfly.

    BWG

     

    BRIAN WILBUR GRUNDSTROM | Database Administrator
    SHAKESPEARE THEATRE COMPANY
    Recipient of the 2012 Regional Theatre Tony Award®
    516 Eighth Street, SE | Washington, DC 20003-2834
    p 202.547.3230 ext. 2216 | c 917.952.7957
    bwg@shakespearetheatre.org
    www.shakespearetheatre.org
    www.brianwilbur.com
    2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

     

     

     

    select distinct customer.customer_no --,max(cart.order_no) as order_no, max(cart.order_dt) as order_dt 

    from t_customer customer (NOLOCK)

    join V_CUSTOMER_WITH_PRIMARY_AFFILIATES affiliates on customer.customer_no = affiliates.customer_no

    join dbo.T_WEB_ORDER cart (NOLOCK) on customer.customer_no = cart.customer_no

    left outer join dbo.T_ORDER cart_order (NOLOCK) on cart.order_no = cart_order.order_no

    left outer join dbo.T_ORDER customer_order (NOLOCK) on affiliates.expanded_customer_no = customer_order.customer_no and customer_order.order_dt > cart.order_dt

    where (cart_order.order_no is null)

    and (customer_order.order_no is null)

    and (cart.order_dt >= GETDATE()-1)

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kelly Enderwick
    Sent: Thursday, May 25, 2017 9:20 AM
    To: Brian W. Grundstrom
    Subject: Re: [Tessitura Technical Forum] T_Web_Order

     

    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

     

     

    From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com>
    Sent: 5/23/2017 2:24:55 PM

    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




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization in reply to Michelle Kosmatka

    I've been starting to do this sort of analysis recently, as we are looking into getting a service (JavaScript based, I think) to try to sweep up abandoned carts, and I was wondering if anyone had any idea what percentage of abandoned carts we might hope to see completed as a result?  I'm expecting in the <1% range, but at about 1% I think it would at least pay for itself.