New 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, this is the first visit for the customer 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. Also, this would only be considered if this is the first visit ever with the business for the guest.
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, Center Name and First Visit in Filter. Select Status as Closed, First visit as Yes. Add UID in Rows, Pick a center and count number of records displayed which is Number of New Guest Visits.