CS Events Table

The CS Events table logs ticket lifecycle events like opening, closure, reopening, assignment, and message activity. One row per event.

📋
Table Guide
What You Can Answer With This Table

How many support events are happening by type each day? — filter or group by event_type, group by event_date

Are events triggered by agents or by automations? — use user_id (NULL for automated events)

Before You Query

Required field: event_date

Event type filter: Use event_type to analyze specific lifecycle events. Examples include ticket-opened, ticket-closed, and ticket-reopened.

Automated events: user_id is NULL when the event was triggered by an automation rule rather than a support agent.

Key Relationships

Table Join Key Use This Join To
CS Messages object_id to ticket_id Understand what was said around each ticket lifecycle event

When to Use a Different Table

Use CS Tickets table when you need ticket metadata such as agent, priority, status, tags, or surveys. The CS Events table is for support lifecycle event history.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
CS Messages	`object_id` to `ticket_id`	Understand what was said around each ticket lifecycle event

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-opened`, `ticket-closed`, `ticket-reopened`
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 10 days ago