Core Analytics is a flexible reporting tool that allows you to explore your Mero data and create customized views to answer specific questions about your operations. You can analyze metrics related to cleaning performance, footfall, consumable usage, and more.
How to Build a Report
Step 1: Access Core Analytics
Select Core Analytics from the main navigation menu on the left side of your screen.
Step 2: Configure Your Report
Use the controls at the top of the page to build your custom report by following these steps:
1. Select Your Metric
Choose the primary data point you want to measure from the dropdown list. Available metrics include:
Average Visit Time
Number of Visits
Scope of Work Completed
SOW Completion Percentage — Shows the percentage of assigned tasks that were completed. This metric can be grouped by Building, Floor, Location, or Cleaner, helping you identify exactly where and who may need additional support.
And many more...
Consumable Metrics
If your site uses consumable sensors (paper towel and toilet paper dispensers), you'll have access to these additional metrics:
Number of Refills — The total count of times a dispenser was refilled during the selected time period. A refill is counted when the sensor detects the paper level returning to full after being low or empty.
Time to Refill — Measures how quickly your team responds to low/empty alerts. This is the median time from when a dispenser triggers a low/empty alert until it gets refilled. Lower values indicate faster response times. Example: If a dispenser goes empty at 10:00 AM and is refilled at 10:45 AM, the time to refill for that event is 45 minutes.
Consumption Interval — Shows how long your consumables last before needing attention. This is the median time from when a dispenser is refilled until it next triggers a low/empty alert. Use this to understand usage patterns and optimize supply quantities. Example: If a dispenser is refilled at 8:00 AM and reaches "low" status at 2:00 PM, the consumption interval is 6 hours.
Why median? We use median (the middle value) rather than average because it gives you a more accurate picture of typical performance. A single unusually long or short event won't skew your results.
Note: Some metrics may not be available depending on your site configuration. If you hover over an unavailable metric, you'll see one of these messages:
For consumables metrics: "This metric isn't available because your site doesn't use consumable sensing."
For traffic metrics: "This metric isn't available because your site doesn't track traffic."
2. Group and Split Your Data
Group By: This determines how your data is organized. It creates the rows in your data table or the individual lines/bars in your chart. You can group by:
Building
Floor
Location
Cleaner
For consumable metrics, additional grouping options are available:
Dispenser — Individual dispenser units (sensors)
Dispenser Type — Paper towel vs toilet paper
Zone — Restroom or area containing dispensers
Example: Group by Dispenser Type and Split by Building to compare paper towel vs toilet paper consumption patterns across your portfolio.
Split By: This adds another dimension to your analysis, creating the columns in your data table or the X-axis in your chart. Options include:
Cleaner
Building
Floor
Location
Time of Day
Day of Week
Previous Time Period
Example: Group by Building and Split by Cleaner to see each cleaner's performance within each building.
3. Choose a Comparison Period
Select how you want to view your data over time:
Single Period: Compare your selected time frame to a previous period
This week vs. last week
This month vs. last month
This month vs. same month last year
Time Series: View trends over time with these grouping options:
Daily
Weekly
Monthly
Quarterly
Yearly
When using Time Series with Daily comparison, a date range filter will appear for more precise control.
4. Select a Chart Type
Choose how to visualize your data:
Bar Graph - Best for comparing discrete values
Line Chart - Ideal for showing trends over time
Heat Map - Great for visualizing patterns across two dimensions
None - View only the data table without visualization
Step 3: Understanding Your Results
Core Analytics generates two outputs:
Chart: A visual representation based on your selected chart type
Data Table: Detailed numbers with "Group By" categories as rows and "Split By" categories as columns
Exporting Your Reports
Quick Export
Configure your report with the desired filters and settings
Click the Export button in the top toolbar
Your report will download immediately in your browser's default format
⚠️ Export Column Limits:
Day of Week split: You can export up to 7 columns (one for each day of the week). If you select more, you'll see: "Please select 7 columns or less to export."
All other splits: You can export up to 5 columns. If you select more, you'll see: "Please select 5 columns or less to export."
Export Formats
Reports can be exported as:
PDF - For sharing and presentation purposes
Scheduling Email Reports
Setting Up Scheduled Reports
Click the Schedule Email button
A dialog will open where you can customize your scheduled report:
Email Recipients: Enter one or more email addresses
Report Frequency: Choose between Daily or Weekly delivery
Send Time: Select when the report should be sent
Additional Filters: Refine your report further if needed
Time Period Options: Customize the date range for your scheduled reports
Review your settings and click Schedule to activate
Note: Scheduled email reports follow the same column limits as quick exports—7 columns for Day of Week, 5 columns for all other splits.
Managing Scheduled Reports
Within the Schedule Email dialog, you can:
View all your existing scheduled reports
Modify schedule settings
Cancel scheduled reports that are no longer needed
Saving and Managing Reports
Saving a Report
After configuring your report settings, click the Save Report button
Enter a descriptive name for your report
Click Save
Your saved report will retain all current settings including:
Selected metric
Group By and Split By options
Comparison period
Chart type
Any active filters
Managing Saved Reports
Click the Manage Reports button to access your saved reports. Here you can:
Set a Default Report
Click Make Default next to any saved report
The default report will load automatically when you open Core Analytics
Only one report can be set as default at a time
Other reports will show a disabled option with the tooltip: "The Default option is disabled because there is already a default report"
Edit Reports
Rename: Change the report name to better reflect its purpose
Remove Default: If a report is set as default, you can remove this status
Delete Reports
Remove reports you no longer need
This action cannot be undone
Based on the existing Core Analytics article tone and format, here's the new section:
Using Conditional Formatting
Conditional formatting lets you visually highlight metric values based on your performance targets. Instead of scanning through numbers, you can instantly see which values are on track (green), need attention (yellow), or are missing the mark (red).
Accessing Conditional Formatting
In Core Analytics, click Report Options in the top toolbar
Select Conditional Formatting from the dropdown menu
Setting Up Your Thresholds
The Conditional Formatting panel has several options:
Apply formatting toggle
Turn this on to enable color-coding in your data table. When off, your table displays without highlighting.
Metric type selector
Choose how your metric should be evaluated:
Lower is better — Use for metrics like cleaning time, time to refill, or response time. Lower values appear green, higher values appear red.
Higher is better — Use for metrics like completion rate, number of visits, or SOW compliance. Higher values appear green, lower values appear red.
Threshold configuration
Set three threshold values to define your performance ranges:
Target (green) — Values meeting your goal
Warning (yellow) — Values in the caution range
Red — Values that need immediate attention
Example: For a "Time to Refill" metric where lower is better, you might set:
Target: ≤10 (refills under 10 minutes show green)
Warning: 11-35 (refills taking 11-35 minutes show yellow)
Red: >35 (refills over 35 minutes show red)
Display goal line
Toggle this on to show a horizontal reference line on your chart at your target value. This makes it easy to see at a glance which data points are above or below your goal.
When enabled, enter the goal value you want displayed on the chart.
How It Looks
Once configured, your data table cells will display with colored backgrounds based on where each value falls within your thresholds. The color-coding applies to all numeric values in the table, making it easy to spot patterns and outliers.
Saving Your Settings
Your conditional formatting settings are saved along with your report. When you click Save Report, your threshold configuration, metric type selection, and goal line settings are all preserved. The next time you load that saved report, your formatting will be applied automatically.
Tip: Create separate saved reports with different conditional formatting settings for different audiences—stricter thresholds for internal reviews, more lenient ones for client-facing reports.
Tips for Effective Analysis
Start Broad, Then Narrow: Begin with a wider view (e.g., all buildings) then filter down to specific areas of interest
Use Time Series for Trends: When looking for patterns over time, Time Series comparison is more effective than Single Period
Combine Filters: Use multiple filters together to answer specific questions about your operations
Save Common Views: If you frequently check the same metrics, save them as reports for quick access
Check Data Availability: If certain metrics appear grayed out, hover over them to understand why they're unavailable for your site
Schedule Regular Updates: For reports you need to monitor consistently, use the Schedule Email feature to receive them automatically in your inbox
Use SOW Completion Percentage: This new metric is especially helpful for identifying underperforming locations or cleaners who may need additional training or support