Skip to main content

Data Alert Remediation Guide

In this article, we’ll go through how to investigate and resolve different data alerts in Cambio.

Updated over 2 months ago

Overview

The Data Management Page helps you monitor and maintain high-quality utility data across all properties. Within the Alerts tab, Cambio flags issues like missing data, gaps, duplicates, or anomalies in energy use and carbon calculations.

This guide explains how to address each alert type and ensure accurate reporting across your portfolio.


  • New Data Missing

    1. To fix this alert, go to Data Management → Alerts → filter Alert Type = New Data Missing (Status: Active).

    2. Click an alert → in the side panel, note Last Data Received and the meter.

    3. Verify data exists:

      • If you have the bill: open the meter → Add Data → drag-and-drop the PDF (recommended) and review/confirm OCR values, or paste values manually.

      • If the meter is Cambio Sync: go to Cambio Sync → check the utility credential. If failed/expired → Update credential and re-authenticate.

      • If the meter is ESPM/Energy Star/third-party: request missing data from the provider or trigger a Resync if available.

    4. Back in the alert, set Status:

      • In Progress with a dated note if you’re waiting on a bill/tenant/utility (e.g., “Waiting on August bill—ETA Nov 15”).

      • Ignored only if there’s a valid reason (e.g., “Changed to net lease—landlord doesn’t pay the utility bills anymore”), and document it.

    5. Let Cambio auto-resolve the anomalies after your upload/sync; recheck later.


  • Meter Data Gap

    1. To fix this alert, go to Data Management → Alerts → filter Alert Type = Meter Data Gap.

    2. Open the alert → review the missing date range; click through to the meter → use the chart/table to see the gap.

    3. Fix the gap:

      • Do you have the bills? Add Data → upload PDFs and verify, or paste values for the exact missing months.

      • Cambio Sync: confirm the connection is healthy; Update credential if needed, then allow sync to fill the gap.

      • ESPM/third-party: request missing data from the provider or trigger a Resync if available.

    4. Set Status:

      • In Progress with a dated note if you’re still gathering files.

      • Ignored with a reason if data is irretrievable (e.g., “Utility cannot provide 2024-03 to 2024-05”).

    5. Gaps auto-resolve after the data posts (typically overnight; some alerts may take up to a week).


  • Duplicate Meter Data

    1. To fix this alert, go to Data Management → Alerts → filter Alert Type = Duplicate Meter Data.

    2. Open the alert → compare the duplicate reading/bill lines for the same meter + period.

    3. Decide which to keep:

      • Prioritize the record with a primary source (has a utility bill attached or is from ESPM).

      • If you see a duplicated manual/Direct Upload record → delete the manual duplicate row in the meter’s data table.

      • If duplicates originate from Cambio Sync/ESPM → run a Refresh/Resync rather than manual deletion.

    4. Add a short note on the alert (what you removed/kept).

    5. Allow the alert to auto-resolve after the correction (typically overnight; some alerts may take up to a week).


  • EUI Variance (Energy Use Intensity)

    1. To fix this alert, go to Data Management → Alerts → filter Alert Type = EUI Variance.

    2. Before changing anything, fix any Active “Missing Data,” “Data Gaps,” and “Duplicates” first (these often cause the variance).

    3. If still flagged, investigate further:

      • Check meter assignments (Property → Meter Assignments) to ensure each meter maps to the correct areas/units.

      • Review units/areas (Property → Areas/Units) for obvious errors (e.g., missing common area).

      • Scan the last 2 years in the monthly charts for spikes or dips in the data.

      • Confirm units & meter types/units (kWh vs MWh, therms vs kBtu) and that no copy-paste or OCR error inflated a value.

    4. If it’s a data error → correct values and/or assignments;

      • Ignored with a clear, dated explanation (e.g., “Cooling tower replacement increased runtime in 2025-Q2; verified by FM”).

      • Otherwise In Progress while you confirm with facilities.

    5. Variance will auto-resolve after upstream fixes; keep the justification in comments for audit.


  • Carbon Variance

    1. To fix this alert, go to Data Management → Alerts → filter Alert Type = Carbon Variance.

    2. Before changing anything, fix any Active “Missing Data,” “Data Gaps,” and “Duplicates” first (these often cause the variance).

    3. Validate the emissions:

      • Confirm the contributing meters or associated meter data(energy/fuels) are correct and not duplicated.

      • Check emission factors are correct for region/fuel (grid vs onsite fuel) and that the right scope/source mapping is used.

    4. If incorrect data/factors caused the swing → fix readings, update meter mapping, or re-ingest with correct units; trigger Resync if needed.

    5. If the change is legitimate (e.g., retrofit reduced usage, fuel switch, tenant turnover):

      • Change the status to Ignored with a short rationale (and dates).

      • Change the status to In Progress while awaiting documentation.

    6. Let the alert auto-resolve after updates propagate.


Common Reasons for an EUI or Carbon Variance

If after remediating all other data alert for a building, you still have an EUI or Carbon variance remaining, then there are a few key reasons this might be the case:

  1. Occupancy change

    • This happens if units went from vacant to leased or vice versa, causing the energy to spike or dip in a way that is anticipated

    • If so, add a comment to let us know why energy spiked or dipped due to an occupancy shift and change the status to “Ignore”

      • E.g. "Tenants moved in July 2025, causing energy to increase"

  2. Areas are incorrect

    • This happens if the total area recorded for your property is incorrect — for example, a missing common area or an outdated floor plan.

    • Check your areas in the Units tab, make sure the total area is accurate, and update if needed.

  3. System update

    • This happens if you recently electrified the building, replaced major equipment, or decommissioned certain types of meters.

    • Add a comment to note the change and set the status to “Ignore.”

  4. System maintenance or use change

    • This happens if one of your meters experienced an operational issue, like a leak or excessive use (for example, someone left all the windows open).

    • Add a comment to describe the event and set the status to “Ignore.”


Good Habits That Make All Five Go Faster

  • Work the Active queue first; move items to In Progress with dated notes so your team (and auditors) have context.

  • Prioritize PDF uploads (with the quick OCR verification step) so bills are attached and traceable.

  • For Cambio Sync issues, go straight to the Cambio Sync Dashboard and Update credential.

  • Use Ignore sparingly and always explain why.

  • After fixing, give the system time to auto-resolve (nightly checks; some alerts may take up to a week).


Please reach out to [email protected] if you have any questions!


Did this answer your question?