Sales per guest
Total Sales Per Guest
Total sales accrual based (closed and open invoices) divided by guests of all the employees in the center Total number of unique guests per day added up for all the days within a date range. This includes all types of items (closed and open invoices).
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 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
Zenoti > Reports > Finance > Sales-Accrual report
Select Sale Type as Sale and Charges.
Select All values in the Item Type and Payment Type dropdown.
Select the desired date range in the Sale Date field.
Select centers as displayed in the ezPulse app.
Export the report CSV, and open the file.
Select the table and Go to Insert Tab > Pivot table
Add Guest Code in Rows.
Use formula =COUNTA(select rows in pivot table)
The number of cells in the pivot table that contain data is the Number of Guest Visits.
Total Sales
Zenoti > Reports > Finance > Sales-Accrual report
Select Sale Type as Sale, Refund, and Charges.
Select All values in the Item Type and Payment Type dropdown.
Select the desired date range in Sale Date.
Select centers as displayed in the ezPulse app.
Export the report CSVSum the data in column Sales (Exc. Tax).
Total Sales Per Guest = Total Sales / Total Guests