CS Events Table

cs_events_table

The CS Events table tracks customer support events such as ticket creation, closure, reopening, and message activity. Querying this table lets you analyze support event patterns over time, monitor ticket lifecycle changes, and identify trends in agent and automation activity.

📘
Note
event_date is a required field for queries on this table.

Dimensions

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

Title	ID	Type	Description
Event Date	`event_date`	date	The date the CS event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
Platform	`platform`	string	The customer support platform through which the event was generated. Example value: `gorgias`
Event Created Date	`created_at`	timestamp	The time the event was created, in UTC. Formatted according to the ISO 8601 international standard. Example value: `2026-02-28 22:25:32`
Event ID	`event_id`	string	The unique identifier for the event, assigned by the CS provider. Example value: `15715626681`
Event Type	`event_type`	string	The type of CS event. Example values: `ticket-created`, `ticket-closed`, `ticket-reopened`, `ticket-message-created`, `ticket-updated`, `ticket-assigned`, `ticket-unassigned`
Object ID	`object_id`	string	The ID of the object this event relates to (e.g., a ticket or message). Example value: `380365041`
Object Type	`object_type`	string	The type of object this event relates to. `Ticket` for ticket lifecycle events (e.g., created, closed, reopened); `TicketMessage` for message events (e.g., a new message on a ticket). Example values: `Ticket`, `TicketMessage`
User ID	`user_id`	string	The ID of the user (agent) who triggered this event. NULL when the event was triggered automatically (e.g., by an automation rule). Example value: `416121112`

Updated about 22 hours ago