--- updatedAt: 2026-08-27T13:50:24.000Z agentTools: projectIndex: https://developers.tidio.com/llms.txt --- # Get agent_statistics_daily Statistics on human agent level in daily resolution. # OpenAPI definition ```json { "openapi": "3.0.3", "info": { "description": "This is a dynamic API generated by PostgREST", "title": "TIDIO Analytics API", "version": "14.4" }, "externalDocs": { "description": "PostgREST Documentation", "url": "https://postgrest.org/en/v14/references/api.html" }, "servers": [ { "url": "https://taa.data.tidio.com" } ], "tags": [ { "name": "Agent statistics daily" } ], "security": [ { "ClientId": [], "ClientSecret": [] } ], "paths": { "/agent_statistics_daily": { "get": { "tags": [ "Agent statistics daily" ], "summary": "Get agent_statistics_daily", "description": "Statistics on human agent level in daily resolution.", "parameters": [ { "name": "_unique_id", "description": "Technical field used as primary key of the model.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "agent_id", "description": "Unique agent identifier.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "period_date", "description": "The date corresponding to the information in the row.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "cnt_replied_live_conversations", "description": "Total number of customer conversations the agent replied to on the given date.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "avg_first_response_time_sec", "description": "The average time (in seconds) needed for the agent to respond to the first customer's message in a new conversation.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "avg_conversation_duration_sec", "description": "The average duration (in seconds) of all conversations replied to by the agent on the given date.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "avg_satisfaction_rate", "description": "Average customer satisfaction score given to the conversations replied to by the operator in the given date.", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "_updated_at", "description": "Technical timestamp (UTC, NTZ)", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "select", "description": "Filtering Columns", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "order", "description": "Ordering", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "Range", "description": "Limiting and Pagination", "required": false, "in": "header", "schema": { "type": "string" } }, { "name": "Range-Unit", "description": "Limiting and Pagination", "required": false, "in": "header", "schema": { "default": "items", "type": "string" } }, { "name": "offset", "description": "Limiting and Pagination", "required": false, "in": "query", "schema": { "type": "string" } }, { "name": "limit", "description": "Maximum rows to return. Pre-filled with 100 to keep the request fast. The API applies no implicit limit -- an unbounded query against a large table exceeds the 25s statement timeout and returns 408, so raise this in steps and page rather than clearing it.", "required": true, "in": "query", "schema": { "type": "string", "default": "100", "example": "100" }, "example": "100" }, { "name": "Prefer", "description": "Preference", "required": false, "in": "header", "schema": { "enum": [ "count=none" ], "type": "string" } } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "items": { "description": "Statistics on human agent level in daily resolution.", "properties": { "_unique_id": { "description": "Technical field used as primary key of the model.", "type": "number", "x-postgres-format": "numeric" }, "project_id": { "description": "Unique project identifier.", "type": "number", "x-postgres-format": "numeric" }, "agent_id": { "description": "Unique agent identifier.", "type": "number", "x-postgres-format": "numeric" }, "period_date": { "description": "The date corresponding to the information in the row.", "format": "date", "type": "string" }, "cnt_replied_live_conversations": { "description": "Total number of customer conversations the agent replied to on the given date.", "type": "number", "x-postgres-format": "numeric" }, "avg_first_response_time_sec": { "description": "The average time (in seconds) needed for the agent to respond to the first customer's message in a new conversation.", "type": "number", "x-postgres-format": "numeric" }, "avg_conversation_duration_sec": { "description": "The average duration (in seconds) of all conversations replied to by the agent on the given date.", "type": "number", "x-postgres-format": "numeric" }, "avg_satisfaction_rate": { "description": "Average customer satisfaction score given to the conversations replied to by the operator in the given date.", "type": "number", "x-postgres-format": "numeric" }, "_updated_at": { "description": "Technical timestamp (UTC, NTZ)", "format": "date-time", "type": "string" } }, "type": "object" }, "type": "array" } } } }, "206": { "description": "Partial Content" }, "408": { "description": "Request Timeout. The query took longer than the database's 25s statement limit -- almost always an unbounded read of a large table. Add a `limit`, narrow the date filter, or page with `Range`/keyset instead of scanning the whole table. `Prefer: count=exact` also forces a full scan; use `count=planned` on the large tables.", "content": { "application/json": { "schema": { "type": "object", "properties": { "detail": { "type": "string", "example": "Request to database timed out after 25s. Please adjust your query." } } } } } } }, "x-readme": { "code-samples": [ { "language": "curl", "name": "Fetch rows (keyset paging)", "code": "# Next page: append &_unique_id=gt.\ncurl \"https://taa.data.tidio.com/agent_statistics_daily?select=_unique_id,period_date,agent_id,cnt_replied_live_conversations,avg_first_response_time_sec,avg_satisfaction_rate&order=_unique_id.asc&limit=500\" \\\n -H \"X-Tidio-Openapi-Client-Id: $TIDIO_CLIENT_ID\" \\\n -H \"X-Tidio-Openapi-Client-Secret: $TIDIO_CLIENT_SECRET\"" } ] } } } }, "components": { "securitySchemes": { "ClientId": { "type": "apiKey", "in": "header", "name": "X-Tidio-Openapi-Client-Id" }, "ClientSecret": { "type": "apiKey", "in": "header", "name": "X-Tidio-Openapi-Client-Secret" } } }, "x-readme": { "samples-languages": [ "curl" ] } } ```