Click the Report you're investigating within the Table of Contents on the right.
β οΈ Please note: Terms for Appointment, Service, Staff Member, etc. may be different within your account's configuration.
π Appointment Report
Click here to learn more
Click here to learn more
π Overview
The Appointment Report allows Headquarters and Location Administrators to retrieve Appointment and Customer details based on selected criteria. Users can select specific items or groups of items to organize data in a way that best meets their reporting needs.
π Appointment Report Uses
The Appointment Report allows users to view, export, print, and analyze appointment and customer details, track appointment activity, identify availability, and save report settings for future use.
π οΈ Running the Appointment Report
Below are the steps to generate the Appointment Report.
Click here to learn more about Running the Appointment Report
Click here to learn more about Running the Appointment Report
β οΈ Please note: Running reports with large data sets may cause a connection timeout and display an Internal Server Error. If this occurs, reduce the selected date range and run the report again.
Click the Reports tab.
Select Appointment Report on the left.
View Appointment details based on a specific Location or all Locations. (Optional)
Report on up to one year of Appointment data based on either Appointment Date or Created Date.
Select Appointment Types you'd like included in the Appointment Report. (Optional)
Select a specific Staff Member or Service from drop-down lists to limit results. (Optional)
Select Staff Member Types you'd like included in the Appointment Report. (Optional)
Select specific Customers to limit results. (Optional)
Select one or more Appointment Status types. (Optional)
Select Created By to filter Appointments on created by a certain Staff Member or via Customer View. (Optional)
Customer details can also be included, with the exception of Customer credit card information. If your Terms for these specific fields have been altered, that name will appear within this section of the Appointment Report.
Select the Total number of Appointments, Cost or Duration to show in the Appointment Report for additional information. (Optional)
Select your View Option.
HTML
The HTML view opens the report in a new browser tab.
Excel View
The Excel view downloads an XLS file containing the same raw data as the HTML report, excluding View and Print options. Giving you options to perform deeper data analysis, create charts and graphs, track trends by Staff Member, Service, or other criteria.
Click Run Report.
βοΈ Setting for Selecting Fields
Users can enable additional field options by updating Settings > General Preference #7 to Yes.
π¨οΈ Printing Appointments
You may print confirmation pages for one or multiple Appointments:
πΎ Saved Report Templates
Saved Report Templates allow users to quickly rerun customized reports without reselecting fields each time.
Click here to learn more about Saved Report Templates
Click here to learn more about Saved Report Templates
Once you've configured the Appointment Report fields to show in report, enter a Report Name at the bottom the report.
Click Save and Run Report.
Running a Saved Report
Select a saved report from the dropdown at the top of the page.
Adjust the date range as needed.
Click Run Report.
β οΈ Please note: Clicking Save and Run Report again will create a duplicate template. To overwrite an existing template, use Update & Run Report instead.
β° Scheduled Reports
Scheduled Reports allow reports to be automatically emailed on a recurring basis.
π₯ Customer Report
Click here to learn more
Click here to learn more
π Overview
The Customer Report allows you to access and export Customer data based on criteria you define. Similar to the Appointment Report, this report can be used to export Customer data; however, Appointment information cannot be exported from the Customer Report.
π‘ Please Note: This report is only available to the following user roles:
Headquarters Administrators
Location Administrators
Location Users (if enabled in Settings)
Call Center Users (if enabled in Settings)
π Customer Report Uses
You can use the Customer Report to export your Customer data, create lists of specific types of Customers, merge your Customer database with a Microsoft Word document to create mailing labels.
π οΈ Running the Customer Report
Below are the steps to access the Customer Report.
Click here to learn more about Running the Customer Report
Click here to learn more about Running the Customer Report
Click Reports tab.
Click Customer Reports on the left.
In the Filter section, customize the Location(s), Customer Type, Customer Statuses, Genders, Cities, Heard Via, and Birthdates to be included in the report. (Optional)
Customize the Customers Sign up Dates and contact permissions to be included in the report.
In the Include in Report section, select the Customer fields you want displayed in the Report. If these options are left blank, the report will be blank.
Use Total By to display a total count of Customers at the bottom of the report. (Optional)
Select an option from the Sort By dropdown to control how results are ordered. (Optional)
At the bottom of the report, select one of the following View Options.
Click Run Report.
β Frequently Asked Questions (FAQs)
Find answers to common questions or additional details that may not be covered in the main instructions.
Click the arrow to view frequently asked questions
Click the arrow to view frequently asked questions
Why donβt I see Appointment data in the Customer Report?
Click the arrow to see the answer
Click the arrow to see the answer
The Customer Report is designed only to display and export Customer-related data. Appointment information must be accessed through the Appointment Report.
Why is my report blank after running it?
Click the arrow to see the answer
Click the arrow to see the answer
If no fields are selected in the Include in Report section, the report will return blank results. Ensure at least one field is selected before running the report.
Can I create mailing labels?
Click the arrow to see the answer
Click the arrow to see the answer
You can't create mailing labels in DaySmart Appointments, but you can export your Customer data to Excel (via the Customer Report). Once the data is in Excel and saved on your hard drive, you can use Microsoft Word's mailing label merge feature to create mailing labels.
π§Ύ Appointment Audit Trail Report
Click here to learn more
Click here to learn more
π Overview
The Appointment Audit Trail report allows Headquarters and Location Administrators to view every change made to an appointment made via Site Administration or Customer View, including who made the change and when it occurred. This report is designed to support auditing and troubleshooting.
βοΈ Please note: In order to have the Appointment Audit Trail feature and Report enabled, please contact our Support team.
π οΈ Running the Appointment Audit Trail Report
Below are the steps to Access the Appointment Audit Report.
Click here to learn more about Running the Appointment Audit Trail Report
Click here to learn more about Running the Appointment Audit Trail Report
Click Reports tab.
Click Appointment Audit Trail Report on the left.
Select the Location(s) to include. (Optional)
Set the Date Range: Appointment scheduled date or Appointment creation date.
Select specific Customers to include. (Optional)
At the bottom of the report, select one of the following Format Options.
HTML
View the report as a web page in your internet browser.
Excel
Opens a spreadsheet alternative where each row represents a record and commas separate data fields.
Click Run Report.
π Captured Appointment Changes
The report captures all changes to an appointment, including:
Click here to learn more about Captured Appointment Changes
Click here to learn more about Captured Appointment Changes
Staff member assigned to the appointment.
User who executed the action (create or update).
Primary service only (add-ons are not included).
Appointment date.
Start time.
End time and duration are not recorded
Appointment status.
Appointment-level field information.
ποΈ Customer Loyalty Report
Click here to learn more
Click here to learn more
π Overview
The Customer Loyalty report allows Headquarters and Location Administrators to view a list of your most frequent and loyal Customers based on their history. However, the Customer Loyalty report is specifically designed to generate a list or group of Customers based on the number of Appointments they have previously scheduled.
π οΈ Running the Customer Loyalty Report
Follow these steps to navigate to and open the Customer Loyalty report within the Reports section.
Click here to learn more about Running the Customer Loyalty Report
Click here to learn more about Running the Customer Loyalty Report
Click on the Reports tab.
Select the Customer Loyalty Reports on the left.
Select the Location(s) to be included in the Report. (Optional)
Enter a date range (up to 1 calendar year) for the Appointments.
You may specify the Service, Staff Member, and Customer Type to be included in the Report. (Optional)
Select specific Appointment Statuses to be included in the Report. (Optional)
Enter a number in the Customers With Appointments or More field.
Select from several fields to be included in Report. From Location, Customer Name, Address, Phone Number, Email, Appointment Status and the Number of Appointments booked. If these options are left blank, the report will be blank.
You have the option to sort the report by Location, Name, City, State and Zip Code. (Optional)
At the bottom of the report, select the View Option.
Click Run Report.
β
π Report on Customers with No Appointments
The Customer Loyalty report supports entering zero (β0β) in the Customers with field.
Click here to learn more about Reporting on Customers with No Appointments
Click here to learn more about Reporting on Customers with No Appointments
When 0 is entered, the report will generate a list of Customers who have no past or future Appointments in the scheduling system.
This can be useful for identifying inactive Customers.
β Frequently Asked Questions (FAQs)
Find answers to common questions or additional details that may not be covered in the main instructions.
Click the arrow to view frequently asked questions
Click the arrow to view frequently asked questions
Who can access the Customer Loyalty report?
Click the arrow to see the answer
Click the arrow to see the answer
Only Headquarters Administrators and Location Administrators have access to this report.
What is the maximum date range I can select?
Click the arrow to see the answer
Click the arrow to see the answer
The date range is limited to one calendar year.
Can I generate a list of Customers with no Appointments?
Click the arrow to see the answer
Click the arrow to see the answer
Yes. Enter 0 in the Customers with field to generate a list of Customers who have no past or future Appointments scheduled.
π³οΈ Open Slots Report
Click here to learn more
Click here to learn more
π Overview
The Open Slots Report creates a list of all time slots for each active schedule and displays both how many slots are available and how many slots have been taken.
Staff Members can print individual schedules or groups of schedules using this report.
β Please note: The Open Slots Report will only appear when using the Multiple Appointments Per Time Slot version. If using the Single Appointment version, we recommend using the Appointment Sheets Report instead.
π Authorizations
Below are the following Access Types for Staff Members this report is available to.
Click here to learn more about Authorizations
Click here to learn more about Authorizations
Headquarters Administrators
Location Administrators
Location Users (if enabled in Settings)
Call Center Users (if enabled in Settings)
π Running the Open Slots Report
Follow the steps to generate this report.
Click here to learn more about Running the Open Slots Report
Click here to learn more about Running the Open Slots Report
Click on the Reports tab.
Select the Open Slots Report on the left.
Select the Location(s) you would like to view appointments for. (Optional)
Select the Appointment Dates you would like to view. The date range defaults to the current date.
Select a specific Staff Member (Schedule). (Optional)
Check the option to Include Staff Members Without Slots if you need to see schedules that do not have time slots created.
Select an Appointment Status to filter the report by a specific status. (Optional)
Choose a View Option.
HTML
Allows you to view the report as a web page within your internet browser.
Excel
Click Run Report.
π¨ Appointment Exception Report
Click here to learn more
Click here to learn more
π Overview
The Appointment Exception Report allows Headquarters and Location Administrators to view all appointments, within a selected date range, that were scheduled at a location other than a customerβs original location (also known as their Home Location). This report is useful for identifying where customer records are being created, gaining visibility into potential scheduling inefficiencies, and reviewing appointment activity across different locations.
βοΈ Please note: The Appointment Exception Report is only available for accounts with multiple locations.
ποΈ Terms
Review key definitions used in this report, Cancelled Appointments and Appointments marked as No Show, are not included in the results.
Click here to learn more about Terms
Click here to learn more about Terms
Home Location
The location a customer is assigned to. In most cases, customer records are automatically assigned to the location where their first appointment was created.
π§ Example: If a customer registers and creates their first appointment at Location A, their Home Location will be Location A.
Serving Location
The location where the appointment was actually scheduled. The report results display the Serving Location for each appointment.
First of Period
This column indicates whether the customer had previously scheduled an appointment at the selected Serving Location before the chosen reporting period.
π οΈ Running the Appointment Exception Report
Below we will learn how to navigate to and open the Appointment Exception Report.
Click here to learn more about Running the Appointment Exception Report
Click here to learn more about Running the Appointment Exception Report
π Appointment Analytics
Click here to learn more
Click here to learn more
π Overview
The Appointment Analytics report allows Headquarter Administrators to compile appointment data created within your scheduling system to review key scheduling metrics for a specific date range for evaluating scheduling performance, service utilization, and booking behavior.
π οΈ Running the Appointment Analytics Report
Below we will review the steps to run and view the Appointment Analytics Report.
Click here to learn more about Running the Appointment Analytics Report
Click here to learn more about Running the Appointment Analytics Report
Click on the Reports tab.
Select the Appointment Analytics Report on the left.
Select the Statistic type you would like to view.
Select a Location from the drop-down list. (Optional)
Choose an option from the Services to Include drop-down. (Optional)
Select a Start Date.
Choose an option from the Start Week On drop-down.
Select a Period (Day, Week, or Month).
Enter the number of Periods to Show.
Select the Statuses to Include.
Use the checkboxes to adjust what options to Include Stats On.
Click Show Statistics.
π Statistic Options
Below we will review each Statistic option provides a different breakdown of appointment data.
Click here to learn more about Statistic Options
Click here to learn more about Statistic Options
If Customer View scheduling is enabled, this report provides statistical insights into the number of appointments scheduled and the percentage of appointments booked through the Customer View (Front End) and Site Administration.
Total Appointments
Lists appointment totals and provides a link to view appointment details for each day.
Customer View VS Site Administration
Lists appointments created through:
Customer View (Front)
Site Administration (Admin)
Each appears on separate rows for comparison.
Appointments by Staff Member
Lists appointment totals for each Staff Member.
Appointments by Service
Lists appointment totals for each Service.
Appointments by Status
Lists appointment totals for each Appointment Status.
π‘ Pro tip: Click the blue underlined number to be linked to the appointment details page
βοΈ Filter & Display Options Explained
Customize how your appointment data is organized and displayed by selecting specific filters, date ranges, statuses, and reporting periods.
Click here to learn more about Statistic Options
Click here to learn more about Statistic Options
Location
Select a specific location to view statistical information for that site.
Services To Include
Determines which types of appointments are included in the report.
Start Date
Choose the date from which the report will begin pulling statistical data.
Start Week On
Modifies which day of the week appears first in the report.
Period
Organize report data by:
Day
Week
Month
Periods To Show
Represents how many days, weeks, or months will be displayed starting from the selected Start Date.
Statuses To Include
Primarily used to remove Cancelled appointments from the report.
Include Stats On
Use the available checkboxes to adjust what data points are included in the statistics.
π Statistics Report
Click here to learn more
Click here to learn more
π Overview
The Statistics Reports allows Headquarters and Location Administrators to compile data created within your account to review basic scheduling metrics for a specific date range. These reports provide insight into appointment activity and customer signups.
π‘ Pro tip: Signups are created when a customer record is added to the system. This applies when a customer record is added through the Customer View or Administrative View.
π οΈ Running the Statistics Report
Below are the steps to access the Statistics Report.
Click here to learn more about Running the Statistics Report
Click here to learn more about Running the Statistics Report
Click on the Reports tab.
Select the Statistics Reports on the left.
Start with the Select Location dropdown to view data for a specific location or all locations. (Optional)
Use the Appointment Dates or Signup Dates section to select a date range. This will default to the current date.
Choose one of the predefined report types from the Include in Report section.
Click the Run Report.
π Statistic Report Types
There are multiple predefined Statistics Report types available. Each report provides a different breakdown of appointment and customer data.
Appointment Statistic Reports
Click here to learn more about Appointment Statistic Reports Types
Click here to learn more about Appointment Statistic Reports Types
Appointments by Staff Member
Shows the number of appointments and the average appointments per day for each Staff Member profile.
Appointments by Service
Shows the number of appointments and the average appointments per day for each Service.
Appointments by Add-on Service
Shows the number of appointments and the average appointments per day for each Add-on Service.
Appointments by Customer Type
Shows the number of appointments and the average appointments per day for each Customer Type.
Appointments by Status
Shows the number of appointments and the average appointments per day for each Appointment Status.
Customer Statistic Reports
Click here to learn more about Appointment Statistic Reports Types
Click here to learn more about Appointment Statistic Reports Types
Signups by Lead Type (Heard Via Type)
Shows the number of customer records by Lead Type.
Signups by Customer Type
Shows the number of customer records by Customer Type.
Signups by Customer Name and Service
Shows the following details for each appointment:
Customer Name
Date
Service
Staff Member
Appointment Status
π Appointment Sheets Report
Click here to learn more
Click here to learn more
π Overview
The Appointment Sheets report allows Headquarters and Location Administrators to view a list of appointments for a specific date range. This report can be used to print individual schedules or groups of schedules for easy reference.
βοΈ Please note: The Appointment Sheets report will not display when using the Multiple Appointments Per Time Slot version. In this case, use the Open Slots Report instead.
π οΈ Running the Appointment Sheets Report
Follow these steps to navigate to and open the Appointment Sheets report from the Reports tab.
π‘ Pro tip: The Appointment Sheets report will not display when Appointments Preference #29 is set to Yes. Appointment Sheets can only show one appointment per time slot.
Click here to learn more about Running the Appointment Sheets Report
Click here to learn more about Running the Appointment Sheets Report
Click the Reports tab.
Select the Appointment Sheets Report on the left.
Select the Location you would like to view appointments for. The Location drop-down will default to the location you were in when you first clicked the Reports tab. (Optional)
Select the Appointment Dates you would like to view. The date range will always default to the current date.
Choose the Additional Information fields you would like to include in the report. You may include:
β’ Company (Employer)
β’ Phone Numbers (Daytime, Evening, & Cell)
β’ Birth Date
β’ Service
β’ Account Number (Account)
β’ Notes from Customer (Special Instructions from/for Customer)
(Optional) Add up to 4 Additional Blank Columns by entering:
A Field Title
A Field Width value
These blank columns can be used by staff to manually fill in additional information when viewing a printed report. For example: Add a column so staff can check off completed appointments.
Choose a Row Height to determine the size of the rows in your report. Selecting Expanded Height will double the size of each row.
Select Yes or No for Display Name in Header. Selecting Yes adds your Company Name (found in: Settings > Location Information) to the header section of the report.
Add a Sheet Title, if applicable. The Sheet Title will appear in the header section of the report.
Add Sheet Header Notes, if applicable. These notes will appear below the Date(s) in the header section.
Check the box next to Page Breaking to list schedules vertically instead of horizontally. (Optional)
Check the Include on Report box for each schedule you would like included.
Select your View Option.
Standard View
Schedules are listed horizontally.
A single header is shown for all schedules.
Page Breaking Enabled
Schedules are listed vertically.
Each schedule includes a separate header section.
Click Run Report.




















































































