What time of day do you do the most sales?

(Last updated on: June 30, 2015)

Want to have a better idea of when the box office should have the most staff on hand? Or what time to post that notice or deal on social media?

Wintix will show you the amount of tickets you sell each hour.

  • Go to Mailing list | Generate a mailing list | Export email
  • Click on the Edit the query tab. Copy and paste the the code below, then click Export list.

select hour(today_time) as Hour, sum(total_tix) as Tix, sum(total_sale) as Sales from mainsale group by hour(today_time);

NOTE: Wintix operates in a 24-hour clock, so “13” is 1 o’clock, etc.

Here is an example of the report:

what time

 

 

This entry was posted in Desktop Software, Wintix5, Reports and tagged . Bookmark the permalink.

Leave a Reply