Open/closed sessions per interval

Overview

The open_closed_sessions_interval_counts_v2 function provides open and closed session counts grouped by time intervals. Use this endpoint to:

• Track session lifecycle over time
• Monitor open vs closed session ratios
• Analyze workload distribution by period

Quick start

query OpenClosedSessionsInterval(
  $deskIds: _uuid
  $brainIds: _uuid
  $integrationIds: _uuid
  $brainVersions: _int4
  $channels: _text
  $startDate: timestamp
  $endDate: timestamp
  $intervalInDays: interval
  $agentIds: _text
  $isTest: Boolean
) {
  rows: open_closed_sessions_interval_counts_v2(
    args: {
      start_time: $startDate
      end_time: $endDate
      interval_span: $intervalInDays
      brain_parent_ids: $brainIds
      desk_ids: $deskIds
      integration_ids: $integrationIds
      brain_versions: $brainVersions
      channels: $channels
      is_test: $isTest
      agent_ids: $agentIds
    }
  ) {
    closed_sessions
    open_sessions
    date: per_interval
  }
}

Variables:

{
  "deskIds": "{d2be0283-9b53-4d7b-b77d-2650f3a1a99c}",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17",
  "intervalInDays": "1 day"
}

Try it

Loading GraphQL Playground...

Parameters

Parameter	Type	Description
deskIds	_uuid	Filter by desk IDs
brainIds	_uuid	Filter by AI agent IDs
integrationIds	_uuid	Filter by integration IDs
brainVersions	_int4	Filter by AI agent versions
channels	_text	Filter by channels
startDate	timestamp	Start date (format: yyyy-mm-dd)
endDate	timestamp	End date (format: yyyy-mm-dd)
intervalInDays	interval	Time interval (e.g., 1 day, 1 week)
agentIds	_text	Filter by human agent IDs
isTest	Boolean	Exclude test sessions

Response fields

Field	Type	Description
closed_sessions	Int	Number of closed sessions
open_sessions	Int	Number of open sessions
date	timestamp	Start of the interval period

Common use cases

Single desk

Get daily open/closed sessions for a single desk:

{
  "deskIds": "{d2be0283-9b53-4d7b-b77d-2650f3a1a99c}",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17",
  "intervalInDays": "1 day"
}

Multiple desks

Get open/closed sessions across multiple desks:

{
  "deskIds": "{d2be0283-9b53-4d7b-b77d-2650f3a1a99c, 51ff88a7-dfab-44e5-9303-9b2bf13f1c94}",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17",
  "intervalInDays": "1 day"
}

Multiple AI agents

Filter by multiple AI agents:

{
  "brainIds": "{a2wv9283-9b53-4d7b-b77d-2650f3a1a99c, 99xx33p9-dfab-44e5-9303-9b2bf13f1c94}",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17",
  "intervalInDays": "1 day"
}

Specific channels

Filter by specific channels:

{
  "deskIds": "{d2be0283-9b53-4d7b-b77d-2650f3a1a99c}",
  "channels": "{web, facebook, viber}",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17",
  "intervalInDays": "1 day"
}

Production only

Exclude test sessions:

{
  "deskIds": "{d2be0283-9b53-4d7b-b77d-2650f3a1a99c}",
  "isTest": false,
  "startDate": "2024-01-08",
  "endDate": "2024-01-17",
  "intervalInDays": "1 day"
}

Example response

{
  "data": {
    "rows": [
      {
        "closed_sessions": 1000,
        "open_sessions": 13,
        "date": "2024-01-08T00:00:00"
      },
      {
        "closed_sessions": 882,
        "open_sessions": 11,
        "date": "2024-01-09T00:00:00"
      },
      {
        "closed_sessions": 1042,
        "open_sessions": 72,
        "date": "2024-01-10T00:00:00"
      }
    ]
  }
}