Skip to main content

Average time by client

Returns the data in minutes. Average time spent on each client, Total service hours divided by total number of guest visits.

Guest Visits

The total number of unique guests per day added up for all the days within a date range. This includes all types of items and only if the invoice is closed.

Example

The number of invoices with the sale date in the selected period. Multiple invoices on the same day by the same guest are considered as one visit.

A visit can be for any item type. Refunds, recurring invoices, automatic payments, freeze fees, etc. are not considered as a visit.

Guest visits Center A multiple times on 1/10: 1 visit

Guest visits Center A, and Center B on 1/10: 1 visit in Center A, 1 visit in Center B

Guest visits Center A on 1/10 and 1/11: 2 visits.

Validate in Zenoti

  1. Reports NEW(v2 report) > Financial Reports > Sales - Accrual report

  2. Select all values in the Item Type, Sale Type, and Payment Type dropdown.

  3. Select centers as displayed in the ezPulse app.

  4. Unhide the Invoice Closed Date and Status column.

  5. Export the report in Excel, open the file remove the top 5 rows and the last row.

  6. Create a new column between Invoice No and Guest Name called UID.

  7. Add a formulae "=B2&E2&F2", right-click on The UID column, and select Format Cells -> Number Tab and Category as General. Once selected double-click on formulae cell and press enter. Copy formulae for all the below rows.

  8. Select the table and Go to Insert Tab > Pivot table.

  9. Add Status and Center Name in Filter and select Status as Closed. Add UID in Rows, Pick a center, and count the number of records displayed which is the Number of Guest Visits.

  10. Add Status in Filter and select Status as Closed. Select item type in Columns, select Invoice No in Rows, and Select Count of Item Type in Values.

Service Time

Total service hours clocked by employees belonging to a center.

Service Hours - Reports NEW → Employee Reports → Attendance → Select All Schedule Statuses → Export report.

  1. Add a column before Serviced Hours

  2. Add Formulae SECOND(K2)+(MINUTE(K2)*60)+(HOUR(K2)*3600)

  3. Sum all the values in the column, now divide this value by 60 which gives the service time in minutes.

  4. To Achieve the metric value divide the Service Time/Guest Visits.

In this section: