Salesforce Docs Portal

What Time Zone Is Used for Quip Metric Reporting?

Quip metrics are aggregated for a given day in Coordinated Universal Time (UTC), but Salesforce reports show metrics in your local time zone. At certain times of day, UTC differs by 1 day from your time zone. For this reason, Quip metrics from a single date sometimes appear incorrectly in your Salesforce reports. To see more accurate metric dates, report on the Metric Date Only and Last Updated Date Only fields.

Example
Example Let’s say that you have users in your org who work across different time zones, and a user in London edits a Quip document on November 15. Any edits made over a 2-hour period are aggregated as one edit. Quip aggregates the user’s edits at 10:00 AM GMT and 6:00 PM GMT, for a total of two edits on November 15 in UTC.

If you report on the Metric Date and Last Update Date fields in Salesforce, users across the org see different results based on their local time zone.

  • A user in London sees two edits on November 15 at 12:00 AM GMT.
  • A user in California sees two edits on November 14 at 4:00 PM PST.
  • A user in Singapore sees two edits on November 15 at 8:00 AM SST.

If you report on the Metric Date Only and Last Updated Date Only fields, all users across the org see two edits on November 15.