The Customer Support Agg Metrics table tracks key customer support actions, including ticket creation, responses, and resolutions. Querying this table helps users analyze support team performance over time and identify patterns in response and resolution efficiency.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

ID	Type	Description
`event_date`	date	The date of the customer support event. Based on the time zone of the shop at the moment of the customer support event.
`event_date.day`	date	The day the customer support event occurred. Derived from `event_date`.
`event_date.week`	date	The Sunday of the week during which the customer support event occurred. Derived from `event_date`.
`event_date.month`	date	The month during which the customer support event occurred. Derived from `event_date`.
`event_date.quarter`	date	The first month of the quarter during which the customer support event occurred. Derived from `event_date`.
`event_date.year`	date	The year during which the customer support event occurred. Derived from `event_date`.

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

ID	Type	Description
`median_first_response_time`	numeric	The median time taken for the first response to a customer support ticket during the period selected.
`median_resolution_time`	numeric	The median time taken to resolve a customer support ticket during the period selected.
`tickets_closed`	numeric	The total number of tickets closed during the period selected.
`tickets_created`	numeric	The total number of new tickets created during the period selected.
`tickets_replied`	numeric	The total number of tickets with at least one reply during the period selected.