Analysing the number of orders placed

From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Susan Farma
Sent: 11 August 2015 21:19
To: Alison Atkinson
Subject: RE: [Tessitura Marketing Forum] Analysing the number of orders placed

Thanks Susan – much appreciated.

Unfortunately it’s still not getting the results though –  Set up as you suggested, but adding the ‘number of orders’ filter either doesn’t change the results at all, or returns an empty dataset.   Any thoughts on why the filtering might not work?

Best wishes

Alison

Hi Alison,

I would use T-Stats:

In The Tickets cube - Use Ticket  - Season as the slicer 

Use Ticket Price Types as the Category

Use Number of orders and Number of constituents as the Measures under series and filter the order numbers to be more than three.

You can save this to a list in Tessitura.

Good Luck

Susan

We want to look at the following:

The list of constituents who have placed 3 or more orders over the past two seasons, buying at a selected Price Type.     

We've run into problems where the list generated doesn't contain the right results, which must mean we're selecting the wrong criteria in list builder.  Or perhaps two of the criteria are referencing different tables?  

Has anyone else done any analysis by orders rather than performances booked?    Any tips / help / solutions greatly appreciated.

thanks
Alison Atkinson
London Philharmonic Orchestra

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!

From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Susan Farma
Sent: 11 August 2015 21:19
To: Alison Atkinson
Subject: RE: [Tessitura Marketing Forum] Analysing the number of orders placed

Thanks Susan – much appreciated.

Unfortunately it’s still not getting the results though –  Set up as you suggested, but adding the ‘number of orders’ filter either doesn’t change the results at all, or returns an empty dataset.   Any thoughts on why the filtering might not work?

Best wishes

Alison

Hi Alison,

I would use T-Stats:

In The Tickets cube - Use Ticket  - Season as the slicer 

Use Ticket Price Types as the Category

Use Number of orders and Number of constituents as the Measures under series and filter the order numbers to be more than three.

You can save this to a list in Tessitura.

Good Luck

Susan

We want to look at the following:

The list of constituents who have placed 3 or more orders over the past two seasons, buying at a selected Price Type.     

We've run into problems where the list generated doesn't contain the right results, which must mean we're selecting the wrong criteria in list builder.  Or perhaps two of the criteria are referencing different tables?  

Has anyone else done any analysis by orders rather than performances booked?    Any tips / help / solutions greatly appreciated.

thanks
Alison Atkinson
London Philharmonic Orchestra

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!