• Replies 10 replies
  • Subscribers 248 subscribers
  • Views 490 views
  • Users 0 members are here
Related

Abandoned Cart

Jennifer Dulik
$organization

My Marketing department would like to know if there is a way to track the number of people who looked at buying but ultimately did not complete the order.  Is there a way to tell what they were looking at (performance and prices)?

Parents
  • $organization
    To add a word of "caution"--an important aspect to consider is when your website requires log in. We looked into Abandoned Cart data before the holiday season last year and found that, because we prioritized anonymous browsing for UX reasons, we had a limited amount of data with which we could really do anything. I imagine if our goal had been primarily about discerning traffic patterns or theorizing why people might abandon carts it might have been effort that paid off, but we quickly realized there wasn't enough information in regard to constituents to pursue as an email program, etc.

    Another tip: I also looked at whether or not the customers we could track had returned to buy the tickets they had abandoned--and many of them had, further reducing the pool as to who might even get a follow up email. Sadly, I can't offer an easy way to look these up since I had a group small enough to review manually, but a worthwhile consideration point for the Marketing folks.

    Jamie

    On Thu, Oct 16, 2014 at 8:50 AM, Wendell Baskin <bounce-wendellbaskin7249@tessituranetwork.com> wrote:

    Thank you, Nick and Patrick

     

    This will really help with my conversation with Marketing.

     

    Wendell

     

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Patrick Drew
    Sent: Wednesday, October 15, 2014 19:28
    To: Wendell Baskin
    Subject: Re: [Tessitura Web Forum] Abandoned Cart

     

    The way we went about it was to create a stored proc that dumps the details of abandoned web orders into a local table and then create list criteria elements for the marketing team to use in extractions. This way, they can add their own logic to complete their analysis without the intervention of IT, and once they decide what to do with the data we can potentially develop Output Set elements for WordFly integration or reports based off this same table.

     

    Early days yet but it has generated a lot of excitement.

    From: Nick Insell <bounce-nicholasinsell2570@tessituranetwork.com>
    Sent: 10/15/2014 7:02:35 AM

    Hi Jennifer

    Actually you can look at this using the existing Tessitura order tables. 

    Each time a order is created on your website it creates an entry in T_WEB_ORDER & T_WEB_SUB_LINEITEM.  When an order is paid the details of these web tables are transferred across to the T_ORDER and T_SUB-LINEITEM tables.  So to check for abandoned cart items you just need to check that the web tables that haven't been transferred across. 

    I started looking at generating a report on this but the person who wanted it left the organisation before we could get exactly what they wanted.  The performance IDs are stored in the T_WEB_SUB_LINEITEM table so you can report by specific performances if you want.

    Thanks

    Nick




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

Reply
  • $organization
    To add a word of "caution"--an important aspect to consider is when your website requires log in. We looked into Abandoned Cart data before the holiday season last year and found that, because we prioritized anonymous browsing for UX reasons, we had a limited amount of data with which we could really do anything. I imagine if our goal had been primarily about discerning traffic patterns or theorizing why people might abandon carts it might have been effort that paid off, but we quickly realized there wasn't enough information in regard to constituents to pursue as an email program, etc.

    Another tip: I also looked at whether or not the customers we could track had returned to buy the tickets they had abandoned--and many of them had, further reducing the pool as to who might even get a follow up email. Sadly, I can't offer an easy way to look these up since I had a group small enough to review manually, but a worthwhile consideration point for the Marketing folks.

    Jamie

    On Thu, Oct 16, 2014 at 8:50 AM, Wendell Baskin <bounce-wendellbaskin7249@tessituranetwork.com> wrote:

    Thank you, Nick and Patrick

     

    This will really help with my conversation with Marketing.

     

    Wendell

     

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Patrick Drew
    Sent: Wednesday, October 15, 2014 19:28
    To: Wendell Baskin
    Subject: Re: [Tessitura Web Forum] Abandoned Cart

     

    The way we went about it was to create a stored proc that dumps the details of abandoned web orders into a local table and then create list criteria elements for the marketing team to use in extractions. This way, they can add their own logic to complete their analysis without the intervention of IT, and once they decide what to do with the data we can potentially develop Output Set elements for WordFly integration or reports based off this same table.

     

    Early days yet but it has generated a lot of excitement.

    From: Nick Insell <bounce-nicholasinsell2570@tessituranetwork.com>
    Sent: 10/15/2014 7:02:35 AM

    Hi Jennifer

    Actually you can look at this using the existing Tessitura order tables. 

    Each time a order is created on your website it creates an entry in T_WEB_ORDER & T_WEB_SUB_LINEITEM.  When an order is paid the details of these web tables are transferred across to the T_ORDER and T_SUB-LINEITEM tables.  So to check for abandoned cart items you just need to check that the web tables that haven't been transferred across. 

    I started looking at generating a report on this but the person who wanted it left the organisation before we could get exactly what they wanted.  The performance IDs are stored in the T_WEB_SUB_LINEITEM table so you can report by specific performances if you want.

    Thanks

    Nick




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

Children
No Data