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)?
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 can do exactly what Nick says.
I am in the middle (it's been quite a while) of creating a report that does this for our Digital and Marketing team; but they wanted some very specific rules about what which customer were returned, based on what the customer bought etc.
Caryl
I think the best way to do this is through Google Analytics. You can create a “funnel” that will show customers pre and post actions based on any URL.
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jennifer Dulik Sent: Tuesday, October 14, 2014 7:47 PM To: Gloria Ormsby Subject: [Tessitura Web Forum] Abandoned Cart
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!
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.
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
From: Nick Insell <bounce-nicholasinsell2570@tessituranetwork.com> Sent: 10/15/2014 7:02:35 AM
So for the non-tech savvy or IT, we would need someone to create this procedure for us?
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!
Thank you, Jamie
After reviewing the tables mentioned by Nick, I see the “web” account is the most common.
I also found, for each performance, the number of abandoned seats, total abandoned dollars, and more.
And, as you noted, the data is ambiguous. When I mention this to Marketing, I’ll explain the complexities.
On my end, it shouldn’t be too difficult to prepare a report.
My initial thought: It may help Marketing gauge interest in a specific performance or genre and use that info when looking for future shows.
We’re still relatively new to Tessitura, and this possible report will probably get a low priority.
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jamie O'Brien Sent: Thursday, October 16, 2014 13:07 To: Wendell Baskin Subject: Re: [Tessitura Web Forum] Abandoned Cart
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:
While every ounce of my being hates reviving a thread from the dead (hey, it's only been about a year, right?), I'm curious about how long T_WEB_ORDER stays populated with data. That is to say, I tried Nick's method because I wanted to investigate how my we did this past season (May-June), but the table only has orders back through September.
Any way to find earlier data to do this same comparison?
Thank you!
Brian Jones
Hey Brain,
LOL!, It is the thread that does not die!
If you are purging data from the web order tables through the use of UP_CLEAR_WEB_TABLES, the answer is how many days you have set to keep. If not, the data is kept indefinitely. The procedure is typically called from a job in SQL server.
Matt