thread Re: Is there a report for number of transactions and / or average ticket price? in Archived Discussions (Read Only)

Is there a report for number of transactions and / or average ticket price?

cafeevoke — Thu, 09 Nov 2017 21:57:49 GMT

It'd be super helpful to be able to run a report with the average ticket price and number of tickets for a given period of time. Does this exist? I have looked but never found one! Hopefully I'm just missing it!

Cheers.

Re: Is there a report for number of transactions and / or average ticket price?

RHatch — Thu, 09 Nov 2017 22:08:17 GMT

You can get the number of transaction for a given period in the Payment report. Then you have to do the math to get average transaction price. Note this price will include tax.

Re: Is there a report for number of transactions and / or average ticket price?

cafeevoke — Thu, 09 Nov 2017 22:09:26 GMT

Right. We do that now... Since Square has the average ticket price and the number of tickets on the register for the current open drawer - thought maybe that could just pull that into a report to make keep us as lazy as we can be!

Re: Is there a report for number of transactions and / or average ticket price?

RHatch — Thu, 09 Nov 2017 22:16:24 GMT

Okay, I figured this out.

Go to custom report

Create new Report

the top header should be what you want. If nothing is there click add report and select key statistics. This will give you want you want.

Title and save report.

Click on your newly created report.

Set the date range and Bam!!! you got it.

Re: Is there a report for number of transactions and / or average ticket price?

cafeevoke — Fri, 10 Nov 2017 02:46:34 GMT

Yes! For sure never clicked that before! You are the icing on our cinnamon roll right now. Cheers!

Re: Is there a report for number of transactions and / or average ticket price?

BKovac — Mon, 11 Dec 2017 14:49:15 GMT

I see the header info on the Custom Report, but is there a way to get the # of transactions and the Avg per Ticket by day?

Re: Is there a report for number of transactions and / or average ticket price?

RHatch — Mon, 11 Dec 2017 15:02:20 GMT

Yes, Once you have saved your custom report click on it and set your date range. Let me know if you need further example.

Re: Is there a report for number of transactions and / or average ticket price?

yumyos — Wed, 31 Jan 2018 22:58:10 GMT

I'm looking for the number of transactions per HOUR. I base my staffing needs on how many people come in the door during a certain time (10-11 I only need 1 because we may only have 4-5 customers; 2-3 I need about 3 because that's when our business picks up, etc). I can't find a way to get the number of transactions PER HOUR. The dollar sales doesn't really matter because if we have 1 big transaction for $500, I still only need 1 person - if we have 50 transactions for $10 each, I need to schedule more staff. Is there any way to get that information?

Re: Is there a report for number of transactions and / or average ticket price?

RHatch — Thu, 01 Feb 2018 01:33:17 GMT

So, the easiest way is to just go to sales summary report Set your date and hover over the timeline. When you do this it will tell you how many payments (transactions) you had during that hour. Notice that this gives you a comparison to last year. I don't have any sales last year. But I had 31 Sales during the 10:00 am Hour.

The other way is with a custom report.

Re: Is there a report for number of transactions and / or average ticket price?

yumyos — Thu, 01 Feb 2018 03:12:22 GMT

OK thanks. I'll just have to do an excel spread sheet and enter the number for each hour for each day of the week myself so I can see which hours are the busiest.

Re: how do I get a report for the average ticket price?

octopuscoffee2 — Wed, 11 Apr 2018 17:02:50 GMT

Hi, it is now 2 years after you posted a manual workaround to this issue...average ticket sales does not seem like it would be so terribly difficult for Square to auto-generate right onto the sales screen. Is there a timeline for implementing this feature? Thanks, Alexis

Re: how do I get a report for the average ticket price?

Kpay — Fri, 13 Apr 2018 18:48:51 GMT

@octopuscoffee2, thanks for your post! I went ahead and moved your comment to another thread where others were discussing how to get at the average ticket price. Take a look at the discussion on the first page and let us know what you think!

How to find the largest transaction and average transaction size?

dougusa — Wed, 28 Oct 2020 19:15:47 GMT

The title of this thread has been edited from the original: largest and average transaction

Is there a way to find my largest transaction (for a particular time period) and also average tranasction?

Re: largest and average transaction

JustinC — Wed, 28 Oct 2020 19:14:18 GMT

I wish there was a way to sort transactions from largest to smallest but that kind of filter doesn't exist at the moment.

As for finding the avg transaction size, I suggest exporting your Transaction report into a spreadsheet then using a mean/average function built into Excel, Google Sheets, etc....

@dougusa

Re: largest and average transaction

NessRecords — Wed, 27 Apr 2022 17:09:45 GMT

Considering how robust the reporting and analytics already are, how much data Square collects on each sale and customer, *and* how much money we pay them for their services, it's pretty ridiculous that we can't easily access "highest ticket" with one or two clicks.