Dimension Tables

Dimensions contain reference information that you can join with fact tables using JOINs. They are updated more frequently (every 10 minutes).

dim_agents

Information about each agent registered on the platform.

Column	Type	Description
`id`	Int32	Agent identifier
`company_id`	Int32	Company identifier
`first_name`	String	First name
`last_name`	String	Last name
`email`	String	Email address
`active`	Bool	Whether the agent is active
`agent_type`	String	Agent type: `admin`, `agent`, etc.

dim_tags

Queues or tags used to route conversations to groups of agents.

Column	Type	Description
`id`	Int32	Tag identifier
`company_id`	Int32	Company identifier
`name`	String	Tag name
`team_id`	Int32	Team it belongs to. `0` if no team

dim_teams

Work teams that group tags.

Column	Type	Description
`id`	Int32	Team identifier
`company_id`	Int32	Company identifier
`name`	String	Team name

dim_hsm

HSM templates (WhatsApp templates) approved by Meta.

Column	Type	Description
`id`	Int32	Template identifier
`company_id`	Int32	Company identifier
`name`	String	Template name
`status`	String	Status: `APPROVED`, `REJECTED`, `PROCESSING`
`category`	String	Template category
`template_type`	String	Template type
`content`	String	Template content
`provider_id`	String	Template ID at Meta

dim_agent_tags

Relation between agents, tags, and teams. An agent can belong to multiple tags.

Column	Type	Description
`agent_id`	Int32	Agent identifier
`company_id`	Int32	Company identifier
`tag_id`	Int32	Tag identifier
`tag_name`	String	Tag name
`team_id`	Int32	Team identifier
`team_name`	String	Team name

Example: agents with their team

SELECT
    a.first_name,
    a.last_name,
    at.tag_name,
    at.team_name
FROM client_analytics.dim_agents a
INNER JOIN client_analytics.dim_agent_tags at ON at.agent_id = a.id
WHERE a.active = true
ORDER BY at.team_name, a.first_name

HSM Responses Optimization

⌘I

Get Started

Meta

Build with Treble

Main Platform

Agent Platform

Integrations

Data Warehouse

Dimension Tables

Dimension Tables

dim_agents

dim_tags

dim_teams

dim_hsm

dim_agent_tags

Example: agents with their team

​Dimension Tables

​dim_agents

​dim_tags

​dim_teams

​dim_hsm

​dim_agent_tags

​Example: agents with their team

Dimension Tables

dim_agents

dim_tags

dim_teams

dim_hsm

dim_agent_tags

Example: agents with their team