Returns the data in minutes. Average time spent on each client, Total service hours divided by total number of guest visits
Guest Visits
Total number of unique guest 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 time 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, 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
Zenoti -> Reports NEW(v2 report) -> Financial Reports -> Sales - Accrual report -> Select sale type as Sale , Select all values in Item Type and Payment Type dropdown -> select centers as displayed in ezPulse app
Unhide Invoice Closed Date and Status column
Export the report in excel, open the file remove top 5 rows and last row
Create a new column between Invoice No and Guest Name called UID
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.
Select the table and Go to Insert Tab -> Pivot table
Add Status and Center Name in Filter and select Status as Closed. Add UID in Rows, Pick a center and count number of records displayed which is Number of Guest Visits.
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
Add a column before Serviced Hours
Add Formulae SECOND(K2)+(MINUTE(K2)*60)+(HOUR(K2)*3600)
Sum all the values in the column, now divide this value by 60 which gives the service time in minutes
To Achieve the metric value divide the Service Time/Guest Visits