Looking for a way to find my peak hours/ busiest times of day

[courtrs]

Hello, I'm not seeing a report that can tell me my peak hours. Specifically, how many sales are taking place during those times. I can see the little graph in the Sales Summary report for the month that tells "time of day" but it only tells the total collected. I would really not like to go day by day to see how many numbers of sales we had during those times.

[TheRealChipA]

Hi @courtrs  i found this by accident once many years ago, and hope it helps. 

Pick your date range for the report. Then on that hourly graph, click on any hour. A pop up like the one below is the displayed showing the number of transactions. 

is this what you are looking for?

 

[courtrs]

Yes, I have looked at that report. We were just hoping there was a way to find a report that aggregates the average of hourly sales per hour per business day, rather than having to click through each day individually and aggregate the data myself. Thanks for your answer!

[TheRealChipA]

@courtrs There is not a standard report I’m aware of. The only solution I can give you is to download your transactions CSV for the desired period and then create a summary spreadsheet to create the report yourself. I have such a spreadsheet if you would like me to share it. 

[courtrs · Accepted solution]

Yes I'd love to take a look at it.

[TheRealChipA]

Ok. Please understand I’m a fellow seller, not a Square employee. I’m on my phone now and that file is not available to me. But I’ll reach out to you tomorrow and facilitate getting it to you with instructions. I think it will give you what you need!

[TheRealChipA]

I sent you a private message here. Just reply and we can chat via email.