Hi
I am not sure if anyone can help, but i was wondering if anyone knows if there is a report set up for the following, or if anyone has had a similar report custom made for their organisation.
I require a report that shows the daily sales for a show in one report for the whole campaign identified by the date i.e
5 December 10 tickets6 December 50 tickets7 December 22 tickets8 December 0 ticketsETC
This is so we can then put next to our the marketing that has occurred i.e advert in the paper, email sent out, direct mail. to see what may of increased the sales of tickets.
we use to manually record this in an excel spreadsheet, but was hoping that there is a report in Tessitura that can show this.
Once the show has finished i would then use the above report to convert into a graph.
There is the report which puts it into a graph 60, 90, 120 days out but doesnt show the daily sales amounts or the dates that sales occurred.
If anyone can help with this that would be great.
I don't suppose your organization has T-stats, does it? You could do that really quickly with T-stats.
no we dont have that yet. We are getting it soon.
I assume a report is in there that i can use!
HI Amanda ,
Good day.
You can do something then you can create the daily sales.
Part1,
you can run the PT report or other kind of summary report, and save the records in a local table.
tomorrow you run it again and save it again.
Part2,
you can compare day one with day two. you have the daily sales report.
Part3,
schedule a sql job to this work. So you can pick up the report everyday.
Done.
you should use the canned report as the data source. so no one can blame you the info is incorrect, and you only need to do very little effort to achive this.
1, one or two local tables.
2, one sotred procedure executing the canned report and save data in local table(s).
3, one sql job.
4, final report shows daily sales.
have fun.
Ben