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, 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
Reports NEW(v2 report) > Financial Reports > Sales - Accrual report
Select all values in the Item Type, Sale Type, and Payment Type dropdown.
Select centers as displayed in the ezPulse app.
Unhide the Invoice Closed Date and Status column.
Export the report in Excel, open the file remove the top 5 rows and the 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 the number of records displayed which is the Number of Guest Visits.
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.