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?