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
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.
So for the non-tech savvy or IT, we would need someone to create this procedure for us?
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