This article describes the Data Completeness Check, how to interpret it, and how to address identified data issues. The Data Completeness Check is an excel file sent from your Customer Success Manager which summarizes which of your buildings have incomplete data and shows meter-level detail on when your meter data is late, includes gaps or overlaps, requires Utility Sync resolution, or has not been assigned to a space. Improving Data Completeness is an important step to take before you dive into further Data Quality review, as incomplete data will not lend itself to an accurate assessment of performance.
Summary Tab
This tab summarizes all of your incomplete data by building and by subgroup (if applicable). The remaining tabs will provide you with the meter-level detail to fully action these issues.
Definitions
- Yellow 0 in “Number of Active Meters” column - There are no active meters for this meter type for this building. Meters may need to be set up, or this may mean you do not have meter data available to you to track (which is most common with Fuel and Waste).
- Red # in “Meters without data until…” column - Some or all of the meters for this meter type do not have data up to the end date indicated in the header. Depending on the source of data for that meter, data may need to be entered by hand, bill scans uploaded, or Utility Sync issues resolved.
- Yes in “Gap” column - At least one meter for the meter type for the building has a gap between two or more of its readings. Depending on the source of data for that meter, data may need to be entered by hand, bill scans uploaded, or Utility Sync issues resolved.
- Yes in “Overlap” column - At least one meter for the meter type for the building has readings that overlap with each other (fall in the same time period). If the meter is manual, readings can be edited in the system to remove the overlap, otherwise Measurabl will work to resolve.
- Yes in “Utility Sync issue(s)” column - At least one Utility Sync account for the building has an issue that requires action.
- Yes in “Unassigned Meter(s)” column - At least one meter for the building has not been assigned to a space. It’s important for every meter to be assigned to a space so that they will be included in metrics.
Last Reading Detail
This tab shows all of your active meters in the portfolio and how many days have passed since their last reading, so that you can confirm each meter has data through the end of the quarter.
Definitions
- From Date - Start date of the last reading for the meter.
- To Date - End date of the most recent reading for the meter.
- Days Since - Number of days since the “To Date” based on the day the report has been put together or the lateness of the meter
- Data Collection Method - Which method is used to collect the utility data for the reading– either manual, offline Utility Sync, or Online Utility Sync
- Data until end of … - Formula that confirms whether or not the meter has readings through the end of the quarter.
- Action required - Instructions on how to bring the meter up-to-date or deactivate it, depending on the data collection method. “Measurabl working to resolve” means no action is needed on your part.
Gaps & Overlaps Detail
This tab shows all of your active meters in the portfolio that have gaps or overlaps and how to fix them.
Definitions
- Issue type is “GAP” - The meter has a gap between two or more of its readings.
- Issue type is “END_GAP” - The meter’s last meter reading end date is over 90 days before the date when the report is created.
- Issue type if “OVERLAP” - The meter has more than one reading that falls within the same range of dates.
Customer Issues Detail
This tab shows all of the utility sync accounts that have an issue requiring action. All definitions and solutions can be found here.
Unassigned Meter Detail
This tab shows all of the meters that are not assigned to a space. These are important to review and resolve because meters that are not assigned to a space are not included in any metrics.
More detail on how to resolve them can be found here.
FAQ
-
What should I prioritize when working through the list?
- While prioritization of issues may vary by organization, here are a few things to consider:
- Size of the building: The larger the building, the more it will influence your overall data coverage and performance metrics.
- Subgroups/funds: You may wish to prioritize subgroups or funds that have mandatory reporting or disclosure guidelines.
- Ease of solving: Addressing Utility Sync issues will often be simpler to solve than meter issues that require manual entry.
-
Are my property managers aware of these same issues?
- Yes, your property managers have three ways of reviewing these issues:
- Bi-weekly Utility Sync issue emails: These go out automatically when a site has any Utility Sync issues.
- In-app: Navigating to the “Utilities” page will highlight issues for a property. Here are further details.
- Data Completeness: Navigating to Analytics > Data Completeness and clicking “View all issues” will show a list view of any issues.
-
What is Measurabl doing to address my data issues?
- Before Measurabl shares the Data Completeness file, our Data Ops team will review the list of issues to address anything that’s possible to resolve on our end for utility sync meters (gaps, overlaps, late meters). In some cases, you’ll see notes like “Measurabl working to resolve” which means the issue is in our team’s queue but is not yet resolved as of the time when the file was prepared.