The article below provides you with an overview of our Business Intelligence module and how to navigate through the different reports.
All our reports and charts can be exported to PDF by clicking on the pdf icon or to CSV by clicking on the three little dots at the top right of each box and selecting download -> CSV File as seen in the screenshot below.
You can filter the report by clicking on the right hand panel and choosing different criteria.
For a detailed breakdown of each report, see below.
Reports labeled with * signify that they are accessible via the advance analytics module
01- 01 Rounds- Overview
This report entails an overview of your rounds and is broken down by the different product types revenue (green fees + carts) average revenue, channel types (percentage of online vs. offline reservations), channel sources (third party integrators should you have any, the club's widget versus Lightspeed Golf's Marketplace. This report will also show you your reservation breakdown per player type and the state of that reservation, meaning whether they were marked as "arrived" "no show" or "reserved".* It displays the revenue generated for carts and green fees per player type.
01-02 Rounds- Pace Comparison
This report entails your pace year over year. It will display the number of rounds. average revenue and total revenue in comparison to last year.
01-03 Player types/product/State
This report displays rounds played, reserved and no shows per player type. This includes revenue collected from carts and rounds played by each player type.
This report entails the different channels the booking is made from, illustrating the distribution of rounds booked via the website, the booking widget (website) the application as well as how many rounds were booked through the Pro Shop.
01-05 Summary/Channel Player Type
The report records the amount of rounds booked through each channel per player type.
01-06 Player Summary
The player summary report includes a dashboard illustrating an overview of rounds played by customers and guests. This report allows you to find specific customers as well as their number of rounds played through a filtered period of time. The report also includes the amount of identified and unidentified rounds by customers.
This report entails an overview of your tee sheet occupancy broken down into rounds played per time slot by weekday and weekend. The report includes the quantity of products (carts + green fees) booked per hour of the day. Graphs and charts illustrating monthly occupancy and “days in advance booking” can also be found in this section of your Business intelligence module.
02-01 Pace comparison *
The pace comparison report allows you to see the occupancy (rounds played) of your course/courses per month, in comparison to the rounds played in the previous years.
The customer overview report presents an overall visual of all your customers. The report covers all information that is available within the customers profile, such as different player types, customers with and without emails and phone numbers on file, customers by gender, customers with shared addresses, and finally a detailed list with all customers listed in your database alongside the information shared within their profile.
The leaderboards report refers to your leading customers in the separate fields of the software. This reports will show which customers played the most rounds, no shows and cancellations. Also found on the leaderboards report is the amount of revenue collected from your “leading” customers on carts and rounds.
This dashboard gives you an insight into how and when you acquired your customers in the database. The report includes visual representations of customer profile in correlation with the time of day, and the day of week that they were created.
The subscriptions overview report entails charts and graphs illustrating all your active, expired, sold subscriptions. You can also find the payment method used for each subscription purchase. This section further includes the list of all your customers alongside their subscription type, start and end dates, and status.
The Sold subscription report lists all of your sold subscriptions over a selected time period. The report includes YoY sold subscriptions allowing you to compare results from past sales.
The renewed Subscription report lists all of your renewed subscriptions. The report includes YoY renewed subscriptions allowing you to compare how many subscriptions were renewed from year to year.
The cancelled subscription report lists all of your cancelled subscriptions during a period of time. The report includes YoY cancelled subscriptions allowing you to compare how many subscriptions were cancelled in comparison to previous years.
04-05 Active subscriptions*
The active subscription report lists all of your active subscriptions during a period of time. The dashboard gives you an overview of active subscriptions at any given time. The report includes YoY active subscriptions allowing you to compare how many subscriptions were activated in comparison to previous years.
The inactive subscription report lists all of your inactive subscriptions during a period of time. Which means you have subscriptions that will begin in the future. The report includes YoY inactive subscriptions allowing you to compare how many subscriptions were inactive in comparison to previous years.
The Debtors report gives you an overview of who subscribed to memberships and services and has a remaining debt for their dues. The report as well includes a graph illustrating the total amount due to the course over a period of time.
04-08 Failed payments*
The failed payments report gives you an overview of customers with payments that failed on their subscriptions. The report as well includes a graph illustrating the total amount due (in failed payments) to the course over a period of time.
5. House Accounts
This report entails a list of all your customers and house accounts with auto-billing activated. The list includes the next billing date for all house accounts with auto-billing activated.
05-02 Successful payments*
The section of the module illustrates a dashboard with an overview of all customers with successful payments on their house accounts. The report as well includes a graph indicating how much revenue has been collected in successful house accounts payments.
05-03 Failed payments*
The section of the module illustrates a dashboard with an overview of all customers with failed payments on their house accounts. The report as well includes a graph indicating how much revenue is owed in failed house accounts payments.
This report gives you an overview of all your packages, it entails your limited packages, as well as the different product type packages. Also found in the report is a list of all your customers as well as the archived, expired and active packages attached to their accounts.
The redemptions report gives you an overview of when, where and by whom the packages are used. The report contains various graphs and charts illustrating usages on green fees and carts, usages based on the time of the day and the day of the week, and finally YoY usages allowing you to compare package redemptions to previous years. Also found in the report is total usages per package and top packages used by selected customers.
The liabilities report gives you an overview of the total usage left of your sold packages and their monetary value. The report includes your top liabilities per package name as well as top liabilities per package owner. A list of all customers with active packages can be found at the bottom report alongside the amount of revenue owed in the form of active packages.
The Voucher overview report contains a list of all vouchers, graphs illustrating your best-selling vouchers as well as your top redeeming customers can be located in this section of the Business intelligence module. Lastly, the report entails all active and inactive/expired vouchers in your database.
The voucher redemptions report includes an insight into how many vouchers were redeemed, when and by whom. The report also includes a graph of usage over time compared to previous years, allowing you to compare year to year sale usage growth/decline.
The Promo codes overview entails a list of all your promo codes within the system alongside the total amount of discounts given in ($ & %) and the average discount rate offered ( $ & %). In this section of the Business Intelligence module you can find your promo codes which apply to carts and green fees, as well all active and expired promo codes.
The promo codes report includes an insight into how many promo codes were redeemed, when and by whom. The report also includes a graph of usage over time compared to previous years, allowing you to compare year to year usage growth/decline. Finally, the report contains various graphs and charts illustrating usages based on product type, usages based on the time of the day and the day of the week, and finally YoY usages allowing you to compare promo code redemptions to previous years.
The Rainchecks overview gives an overview of all of your recorded issued and redeemed rainchecks. The report as well contains the status of all existing rainchecks (outstanding vs redeemed), the quantity of issued rainchecks per employee and total revenue collected through rainchecks.
The raincheck issued report offers insight into how many rain checks were issued, when and by whom. In addition to the list of all issued raincheck, the report illustrates the date and time, the dollar amount and the employee to which each raincheck was issued.
The raincheck issued report entails an insight into how many rain checks were redeemed, when and by whom. In addition to the list of all redeemed raincheck, the report illustrates the date and time, the dollar amount and the employee to which each raincheck was redeemed.
The employee section of this report gives you an overview of your issued and redeemed rain checks by employees. The report lists the date and time and dollar amount of all issued and redeemed raincheck by each employee.
10. Online deals
The Online deals overview provides a detailed report on when, where and by whom the deals were used. The report illustrates total usages based on product type (green fees and carts), Time of the day and day of the week.
The Online deal redemption report entails an insight into how many online deals were redeemed, when and by whom. In addition to the list of all redeemed online deals, the report illustrates YoY redemptions allowing you to compare usage over time compared to previous years.
11-01 Orca Export*
The ORCA Export allows you to upload all your reservations data (rounds date and time, customer information, round status, etc.) of a given period to the ORCA report system.
11-02 Tee Sheet Export
The Tee Sheet report lists the raw data of your rounds booked (including information such as, date and time, customer booking information, cost, etc.) Useful when exported as .CSV and used in pivot tables in Excel.