--- title: "Get project_statistics_daily" method: GET path: "/project_statistics_daily" tags: ["Project statistics daily"] --- # Get project_statistics_daily `GET /project_statistics_daily` ## Request - Base URL: `https://taa.data.tidio.com` - URL: `https://taa.data.tidio.com/project_statistics_daily` - Auth: API key in header `X-Tidio-Openapi-Client-Id` and API key in header `X-Tidio-Openapi-Client-Secret` Statistics for the whole project in daily resolution. ## Query parameters - `_unique_id` string - `period_date` string - `cnt_flow_triggers` string - `cnt_flow_interactions_with_visitor` string - `cnt_flow_executed_action` string - `cnt_unique_visitor_flow_triggers` string - `cnt_unique_visitor_flow_interactions_with_visitor` string - `cnt_unique_visitor_flow_executed_action` string - `cnt_codes_sent` string - `cnt_codes_used` string - `cnt_orders_with_flows` string - `sum_sales_with_flow_coupon_codes` string - `cnt_messages_lyro_answered` string - `cnt_messages_lyro_unanswered` string - `cnt_messages_lyro` string - `cnt_threads_lyro_resolved` string - `cnt_threads_lyro_unresolved` string - `cnt_threads_lyro` string - `cnt_transfers_to_agent_from_lyro` string - `cnt_all_tickets` string - `cnt_handled_tickets` string - `sum_sales_with_agent_threads_usd` string - `cnt_orders_with_agent_threads` string - `cnt_new_agent_threads` string - `cnt_replied_agent_threads` string - `cnt_missed_agent_threads` string - `cnt_agent_threads_taken_over_by_flow` string - `avg_first_response_time_sec` string - `avg_agent_thread_duration_sec` string - `cnt_leads_from_agent_threads` string - `cnt_leads_from_flows` string - `cnt_leads_from_prechat_survey` string - `cnt_leads_from_whatsapp` string - `cnt_leads_from_instagram` string - `cnt_leads_from_messenger` string - `cnt_leads_from_tickets` string - `cnt_leads_from_import_csv` string - `cnt_leads_from_person_details` string - `cnt_leads_from_open_api` string - `cnt_leads_from_import_shopify` string - `cnt_leads_from_emails` string - `cnt_leads_from_review` string - `cnt_leads_from_shopify_abandoned_cart` string - `_updated_at` string - `select` string - `order` string - `offset` string - `limit` string, required ## Headers - `Range` string - `Range-Unit` string - `Prefer` 'count=none' ## Response `200` OK - object[] - `_unique_id` number: Technical field used as primary key of the model. - `project_id` number: Unique project identifier. - `project_public_key` string: Project public key. - `period_date` string, date: The date corresponding to the information in the row. - `cnt_flow_triggers` number: Number of flow triggers on the given date. - `cnt_flow_interactions_with_visitor` number: Total number of interactions between flows and visitors on the given date. - `cnt_flow_executed_action` number: Total number of flow executions on the given date. - `cnt_unique_visitor_flow_triggers` number: Number of unique visitors for whom a flow was triggered on the given date. - `cnt_unique_visitor_flow_interactions_with_visitor` number: Number of unique visitors that interacted with a flow on the given date - `cnt_unique_visitor_flow_executed_action` number: Number of unique visitors with a flow execution on the given date. - `cnt_codes_sent` number: Total number of coupon codes sent by flows on the given date. - `cnt_codes_used` number: Total number of coupon codes used on the given date. - `cnt_orders_with_flows` number: Total number of orders attributed to interactions with flows after a visitor makes a purchase using a discount code received flow a flow within a 7-day window. - `sum_sales_with_flow_coupon_codes` number: Sales value attributed to interactions with flows after a visitor makes a purchase using a discount code received flow a flow within a 7-day window. - `cnt_messages_lyro_answered` number: The count of messages from Lyro AI Agent classified as answered. - `cnt_messages_lyro_unanswered` number: The count of messages from Lyro AI Agent classified as unanswered. - `cnt_messages_lyro` number: The total count of messages from Lyro AI Agent (cnt_messages_lyro_answered + cnt_messages_lyro_unanswered). - `cnt_threads_lyro_resolved` number: The count of threads resolved by Lyro AI Agent. A thread is considered resolved when it was closed within 15 minutes since the last message, the last message was classified as answered, and there was no transfer to a human agent. - `cnt_threads_lyro_unresolved` number: The count of threads unresolved by Lyro AI Agent. A thread is considered unresolved when it was closed within 15 minutes since the last message and either the last message was not classified as answered or there was a transfer to a human agent. - `cnt_threads_lyro` number: The total count of threads handled by Lyro AI Agent (cnt_threads_lyro_resolved + cnt_threads_lyro_unresolved). - `cnt_transfers_to_agent_from_lyro` number: The count of transfers from Lyro AI Agent to an agent. - `cnt_all_tickets` number: Total number of tickets created on the given date. - `cnt_handled_tickets` number: Total number of tickets with a message from operator created on the given date. - `sum_sales_with_agent_threads_usd` number: Sales value attributed to interactions with Tidio live chat within a 7-day window. Doesn't include sales generated by coupon codes. Available only for projects integrated with Shopify. - `cnt_orders_with_agent_threads` number: Number of orders attributed to interactions with Tidio live chat within a 7-day window. Doesn't include sales generated by coupon codes. Available only for projects integrated with Shopify. - `cnt_new_agent_threads` number: The total number of agent threads on a given date. - `cnt_replied_agent_threads` number: Total number of agent threads on the given date where the visitor received a reply from a human agent or the conversation was started by an agent. - `cnt_missed_agent_threads` number: Total number of agent threads on the given date where an agent did not reply within 3 hours of the visitor’s first message. - `cnt_agent_threads_taken_over_by_flow` number: The number of agent threads on the given date that were initially available to be picked up by agents but didn't receive any response and were eventually taken over by a Flow. As such, they disappeared from the Unassigned section. - `avg_first_response_time_sec` number: Average time (expressed in seconds) needed from agent to respond to the first message in a new thread on a given date. Is calculated only when a thread contains both agent and visitor message. - `avg_agent_thread_duration_sec` number: Average time (expressed in seconds) from first to last message in the threads started on a given date. Is calculated only when a thread contains both agent and visitor messages. - `cnt_leads_from_agent_threads` number: Total number of leads created from agent threads on a given date. - `cnt_leads_from_flows` number: Total number of leads acquired through lead generation flows on the given date. - `cnt_leads_from_prechat_survey` number: Total number of leads created from pre-chat survey on a given date. - `cnt_leads_from_whatsapp` number: Total number of leads created from whatsapp threads on a given date. - `cnt_leads_from_instagram` number: Total number of leads created from instagram threads on a given date. - `cnt_leads_from_messenger` number: Total number of contacts leads from messenger threads on a given date. - `cnt_leads_from_tickets` number: Total number of leads created from tickets on a given date. - `cnt_leads_from_import_csv` number: Total number of leads created from an imported csv file on a given date. - `cnt_leads_from_person_details` number: Total number of leads created from person details on a given date. - `cnt_leads_from_open_api` number: Total number of leads created from Open API integration on a given date. - `cnt_leads_from_import_shopify` number: Total number of leads imported from Shopify on a given date. - `cnt_leads_from_emails` number: Total number of leads created from emails on a given date. - `cnt_leads_from_review` number: Total number of leads created from review on a given date. - `cnt_leads_from_shopify_abandoned_cart` number - `_updated_at` string, date-time: Technical timestamp (UTC, NTZ) ## Other responses - `206`: Partial Content - `408`: 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. --- [API](https://skmtc.dev/tidio/apis/tidio-analytics-api.md) - [All operations](https://skmtc.dev/tidio/apis/tidio-analytics-api/llms.txt) - [OpenAPI document](https://skmtc.dev/tidio/apis/tidio-analytics-api/revisions/960021ed741c?raw)