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)?
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.
Wendell
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:
Thank you, Nick and Patrick
This will really help with my conversation with Marketing.
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!