In the Analytics > Filter Logs screen, the time zone of the data can be ambiguous:
We show an explicit time zone in the chart data (when viewing by minute or hour), which is always east coast. However, the data in the table underneath is always displayed in your browser local time, but it doesn't clarify what time zone the data is in. If you download the CSV data from this same page, the CSV data is returned in UTC, but again, without clarifying what time zone the data is in.
I'd propose making the following changes:
- Add a time zone specifier to the dates shown in the table so it's clear what time zone this is in.
- Optional: Should we consider hard-coding the table data so it's always shown in ET to match the charts above? Or alternatively, should we change the chart so it shows data in the local time instead? Updating the chart gets perhaps a bit wonky, since if you're viewing the daily, weekly, or monthly charts, those will always be hard-coded to end the days in ET. So this would then make the hourly/minutely charts inconsistent with when the daily charts end. But maybe having the mixed time zones between the chart and table are fine as long as we're explicitly showing them, so maybe doing nothing here is simplest. But I could go either way on this.
- Update the CSV time output format to include time zone. This original format was picked so Excel would pick it up as a time field, but I'm maybe more inclined to just format all of our CSVs in ISO8601 UTC format so it's more explicit and easier to parse programatically. This could be a backwards incompatible change for anyone with automated processes on the CSV downloads, but I suspect most of the automated things are built using the JSON endpoints instead, so I think we could get away with changing this.
In the Analytics > Filter Logs screen, the time zone of the data can be ambiguous:
We show an explicit time zone in the chart data (when viewing by minute or hour), which is always east coast. However, the data in the table underneath is always displayed in your browser local time, but it doesn't clarify what time zone the data is in. If you download the CSV data from this same page, the CSV data is returned in UTC, but again, without clarifying what time zone the data is in.
I'd propose making the following changes: