How to Get a Customer's Interval Usage Data Without Their Password

Why this matters

A monthly bill tells you how much. A smart meter's interval record tells you when, and "when" is usually the diagnosis: a floor that never drops at 3 AM, a spike every cold morning at 6, a four-hour block every night that started the week the customer bought something. Most homes on a smart meter already have this record sitting in the utility's online usage portal, and most customers have never opened it.

The fast way to get it is also the wrong way: "just give me your login and I'll pull it." The customer's utility account can change the mailing address, enroll them in programs, see payment methods and, at some utilities, request a disconnect. Holding that password makes your shop part of their account security, and if anything goes wrong on that account in the next year, you were the last outsider in it. The steps below get the same file with the customer's hands on the keyboard.

Step 1: Ask whether the data exists before asking for it

Not every meter records intervals, and not every utility shows them. Ask the customer three things on the phone or at the door:

• Does your bill or the utility website mention a smart meter, hourly usage or a usage chart? If the portal shows a daily bar chart, intervals almost certainly sit underneath it.
• Do you log in to pay the bill? A customer who already has an account is ten minutes from the file. One who does not will need to create an account with the utility, which only they can do.
• Is there solar on the house? A net-metered house usually has two channels, energy delivered to the house and energy received from it, and you need both.

Why first: if the meter is an older one read monthly, there is no interval record to get, and you switch to a whole-house baseline test or a temporary energy monitor instead of spending a week waiting for a file that does not exist.

Step 2: Have the customer log in and download, on their own device

Walk them through it while they drive. Many US utilities support a data export under the industry name Green Button, usually labeled "Download My Data", which produces a spreadsheet (CSV) or an XML file. Others have their own "export usage" or "download" button beside the usage chart. The menu wording varies; the steps rarely do:

1. Customer logs in to the utility account themselves.
2. Customer opens the usage or energy-use page.
3. Customer picks the finest interval offered (15-minute, 30-minute or hourly) and the longest range offered, ideally the last 12 months, and at minimum the billing periods the complaint covers plus one normal period before them.
4. Customer downloads the CSV, which is the easiest format to open in a spreadsheet.
5. Customer emails or texts the file to the shop, or uploads it to the job.

If they get stuck, a screen share is fine where they control the device and type the password. You never take remote control of the session, and you never ask them to read you a verification code. A verification code read aloud is a password by another name.

What breaks if skipped: someone in the office "helps" by typing the customer's credentials, the customer later disputes a program enrollment or a changed setting, and the shop cannot show it touched nothing.

Step 3: Use an authorized share when the customer cannot download

Some customers cannot or will not handle a download. Two routes keep the password out of your hands:

• A data-sharing authorization from inside their account. Some utilities offer a "Connect My Data" style authorization that grants a named third party access to usage for a set period. The customer starts it and can revoke it.
• A signed customer authorization form (often called a customer information release or letter of authorization) submitted to the utility, naming your shop, the data requested and the period. Rules for who may receive customer usage data and how are set by state utility commissions and each utility's tariff, so the form and turnaround vary widely; call the utility's customer service and ask what it accepts.

Why this matters: both routes leave a record that the customer chose to share, with what, and for how long. That record protects you if the data is ever questioned.

Step 4: Open the file and get its clock right before reading anything

Before looking for patterns, settle four things about the file itself:

• Interval length. Count rows per day: 24 means hourly, 96 means 15-minute.
• Units. Each row is kWh used in that interval. An hourly kWh value is numerically the average kW over that hour. A 15-minute kWh value times 4 is the average kW over those 15 minutes.
• Hour beginning or hour ending. A row stamped 02:00 may cover 1 to 2 AM or 2 to 3 AM. The header or the utility's help page says which. Get it wrong and every pattern shifts an hour, which matters when you try to match a spike to a thermostat schedule.
• Daylight saving days. Expect one 23-hour day in spring and one 25-hour day in fall. A row that seems missing or doubled on those dates is the clock, not a meter fault.

Then add up a full billing period from the file and compare it to the kWh on the bill. They should agree closely. If they do not, you may have one channel of a two-channel file, a partial download, or the wrong account.

Step 5: Read it for three patterns, in this order

Baseload first. For each night, find the lowest hour between about midnight and 5 AM. That minimum is the house when everyone is asleep: refrigeration, electronics in standby, controls. Plot or list it across the weeks. A floor that holds steady is normal. A floor that stepped up on a particular date and stayed up is a new constant load, and the date is the clue.

Cold-morning spikes second. Put the daily outdoor low beside the file (the customer's thermostat history or a public weather record for the nearest station). In a heat pump house, the hour the thermostat recovers from a night setback is where auxiliary strip heat shows itself, and it shows on cold mornings, not mild ones. See related: Smart Meter Interval Data: What the Hourly Record Shows.

Nightly blocks third. Look for a rectangle: several consecutive hours at nearly the same elevated level, starting at the same time each night. Timers and chargers draw like that. Pool pumps, EV chargers, water heaters on a timer and irrigation pumps all leave rectangles.

Worked example: one file, three findings

A customer on a heat pump with 10 kW of backup strips says January's bill was the worst ever. She downloads 14 days of hourly data and sends the CSV. The file stamps hour ending, 24 rows per day, and the 14 days total 1,262 kWh against her daily usage chart, which agrees.

Baseload. The lowest overnight hour is 0.9 kWh nearly every night, usually the 4 AM row (hour ending, so 3 to 4 AM, after the charger block below has ended). That is 0.9 kWh in one hour, an average of 0.9 kW, or 900 W. It held at 0.9 for the whole fortnight, so nothing new appeared in the baseload during these two weeks. Whether 900 W is high for this house is a question for the baseline test; the file only says it is constant.

Cold mornings. On the ten days with lows in the 30s F, the 7 AM row (hour ending, so 6 to 7 AM) reads 3.1 to 3.4 kWh. On the four days with lows of 18 to 21 F, the same row reads 7.6 to 7.9 kWh. An average of 7.8 kW for a full hour, against roughly 3.2 kW on mild mornings, is about 4.6 kW of extra draw sustained for an hour. A compressor alone does not add that much in that hour; strips staging on during morning recovery do. This is evidence for a conversation, not a repair verdict: the next step is the thermostat's aux runtime and a clamp on the strip circuit. See related: How to Confirm Backup Heat Runtime From the Thermostat and a Clamp.

The nightly rectangle. On 12 of the 14 nights, the rows for hour ending midnight through hour ending 3 AM, four rows covering 11 PM to 3 AM, each read 8.1 kWh, then drop straight back to the 0.9 floor. Subtract the floor: 8.1 minus 0.9 is 7.2 kWh per hour above baseload, for four hours, which is 28.8 kWh a night. The customer bought an electric car in December and charges it on a timer at 11 PM. On 12 nights that is 12 x 28.8 = 345.6 kWh, which is 27.4 percent of the fortnight's 1,262 kWh.

Put together for the customer: the charger is the largest single new item in the period, the morning strip heat is a real second contributor that needs a tech to confirm, and the overnight floor has not changed. Nothing here is a promise about the next bill; it is what the meter recorded.

What would change the reading

• The file is daily, not hourly. Daily totals still show weather sensitivity and a date when use stepped up, but they cannot show a 3 AM floor or a four-hour block. Pair a daily file with a whole-house baseline test at the meter.
• The house has solar. Daytime rows on the delivered channel can read near zero while the panels cover the house, so the baseload must come from night rows only, and you read the received channel separately. See related: Net Metering and Net Billing: What a Solar House Bill Is Saying.
• The interval is 15 minutes and the load cycles faster than that. A well pump short-cycling every two minutes averages into a raised floor; the file shows that something runs constantly, not how it cycles. Watch the meter's instantaneous reading or use an energy monitor to see the cycle itself.

How to confirm you read it right

Three checks before the findings go to the customer. The billing-period total from the file matches the bill. Every pattern you name is stated in the file's own units with its time convention (hour ending 7 AM, not "the morning"). And each finding has a physical explanation you can go and verify: a charger with a timer, strips with a runtime log, a floor that a breaker test can split. A pattern with no candidate load behind it goes in the note as unexplained rather than as a guess.

References

• See related: Smart Meter Interval Data: What the Hourly Record Shows
• See related: How to Run a Whole-House Baseline Test at the Electric Meter
• See related: Reading Energy Data Without Misleading the Customer
• Green Button data-access initiative documentation and the serving utility's data-sharing terms
• State utility commission rules on customer energy-usage data privacy