Why Are Timestamp Values Rounded to the Nearest Hour?

Question

Why are all timestamp column values rounded to the nearest hour instead of the nearest minute or second?

Environment

Connector: Pendo

Answer

Pendo's API only provides day-level and hour-level aggregation for timestamp values. As a result, the most granular aggregated value is at the hour level. The minute and second values will always be zero. See Pendo's API documentation for more information.