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 guest 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 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, 1visit 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 Item Type and Payment Type dropdown -> select desired date range in Sale Date -> select centers as displayed in ezPulse app
Export the report CSV, 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)
Number of cells in pivot table that contain data are 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 Item Type and Payment Type dropdown -> select desired date range in Sale Date -> select centers as displayed in ezPulse app
Export the report CSV
Sum the data in column Sales (Exc. Tax)
Total Sales Per Guest = Total Sales / Total Guests