SW Multi-Stats Historical
The SW Multi-Stats Historical dashboard provides the following summarized historical SiteWatch multi-site statistics: total car count, total $ per car, paid single wash car count, unlimited plan redeemed car count, prepaid redeemed car count, unlimited plans reloaded, unlimited plans sold, unlimited capture rate, cars per labor hour, labor cost per car, and labor percentage. It is similar to the Multi-Site Stats dashboard (except the SiteWatch historical dashboard doesn't include rewashes). The dashboard can be generated for each month, up to 2 years from a site's SiteWatch-to-Patheon conversion month (depending on the availability of historical data from its SiteWatch Server). The dashboard provides historical SiteWatch data, so the data is static; it does not include live or current data. Detailed information about the dashboard is provided below.
- Multi-Site Statistics
Insights 2.0 dashboards are accessible from within Patheon Portal, or directly from any mobile device or desktop computer at Insights.DRB.com.
Dashboard Location
Insights 2.0>SW Historical Dashboards>SW Multi-Stats Historical
Dashboard Tools
The SW Multi-Stats Historical dashboard includes the following functions: refresh, sign out, select a site tool, and select a time period tool.
Refresh
The dashboard header provides a refresh function to manually force a data refresh.
Note: SiteWatch data is historical data and does not need to be refreshed.
Sign Out
The dashboard header provides a user icon, which when selected, provides a Sign Out function to sign out of Insights 2.0.
Select a Site
The dashboard provides a site selector to open a list of all sites within the organization, and then select a site to view its data in the dashboards.
Selecting the site selector (it's set to All Sites by default), opens a list with all sites. Users can navigate up and down the list to select a site. In addition, the site list includes the following features: site search, select all sites, deselect all sites, and multi-site selection.
- Search: A search tool is available at the top of the site list for multi-site organizations that have a large number of sites. It can be used to quickly locate a site without navigating through the entire list. Note: The search function is case-sensitive.
- Select all / Deselect all: All sites can be selected or deselected.
- Multi-Site Select: Multiple, select sites can be selected. Select a site to include it; select it again to not include it.
Select a Time Period
A month(s) and year(s) time period selector is provided to choose the month(s) and year(s) to view the dashboard for. By default, the month time period is set to All Months and the year time period is set to All Years.
All Months
The month selector is set to All Months when the dashboard is opened. Select it to open the month selector and choose a specific month, select all months, or select multiple specific months. The month selector.includes a Select all / Deselect all toggle function and each calendar month. A selected month has a red background; a deselected month has a white background. An Apply function is provided to confirm any selection and open the dashboard for the selected month(s).
Note: Use the month selector in conjunction with the year selector (below) to view specific month and year data.
All Years
The year selector is set to All Years when the dashboard is opened. Select it to open the year selector and choose a specific year, all years, or select multiple specific years. The year selector.includes a Select all / Deselect all toggle function and each year of data that is available (in YYYY format). A selected year has a red background; a deselected year has a white background. An Apply function is provided to confirm any selection and open the dashboard for the selected year(s).
Note: Use the year selector in conjunction with the month selector (above) to view specific month and year data.
Multi-Site Statistics
The multi-site statistics table provides a site-by-site comparison for total car count, total $ per car, paid single wash car count, unlimited plan redeemed car count, prepaid redeemed car count, unlimited plans reloaded, unlimited plans sold, unlimited capture rate, cars per labor hour, labor cost per car, and labor percentage:
Site
The Site column provides the site that were selected with the site selector.
The column can be sorted in ascending or descending alphanumerical order by selecting its header.
Total Car Count
The Total Car Count column provides the count of paid single washes, unlimited plan redeemed washes, prepaid redeemed count, and rewash car count.
The column can be sorted in ascending or descending numerical order by selecting its header.
Total $ Per Wash
The Total $ Per Wash column provides the total revenue divided by total cars, for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Paid Single Wash
The Paid Single Wash column provides the count of washes purchased that were not an unlimited plan wash, rewash, or a prepaid wash (it does not include unlimited/unit redemptions or rewash transactions), for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Unlimited Plan Washes ("Unltd Plan Washes")
The Unlimited Plan Washes ("Unltd Plan Washes") column provides the count of washes redeemed by unlimited plan members (automatic reloads only), for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Prepaid Redeemed Washes ("Ppd Rdmd")
The Prepaid Redeemed Washes ("Ppd Rdmd") column provides the count of washes that were a unit plan redemption (includes free wash codes), for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Unlimited Plans Reloaded ("Unltd Plans Reloaded")
The Unlimited Plans Reloaded column provides the number of unlimited plans reloaded (includes both automatic and manual reloads), for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Unlimited Plans Sold ("Unltd Plans Sold")
The Unlimited Plans Sold column provides the number of unlimited plans (automatic reload and manual reload) sold, for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Unlimited Capture Rate ("Unltd Capture Rate")
The Unlimited Capture Rate ("Unltd Capture Rate") column provides the percentage of customers that came to the site and converted to an unlimited plan member (includes both automatic and manual reloads), for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Cars per man hour
The Cars per man hour column provides the total cars divided by total labor hours, for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Labor cost per car
The Labor cost per car column provides the total labor dollars divided by total cars, for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Labor %
The Labor % column provides the total labor cost divided by total sales, for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.
Sales per labor hour
The Sales per labor hour column provides the total sales revenue divided by total labor hours, for the selected time period and site(s).
The column can be sorted in ascending or descending numerical order by selecting its header.