Technical field used as primary key of the model.

The date corresponding to the information in the row.

Number of flow triggers on the given date.

Total number of interactions between flows and visitors on the given date.

Total number of flow executions on the given date.

Number of unique visitors for whom a flow was triggered on the given date.

Number of unique visitors that interacted with a flow on the given date

Number of unique visitors with a flow execution on the given date.

Total number of coupon codes sent by flows on the given date.

Total number of coupon codes used on the given date.

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.

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.

The count of messages from Lyro AI Agent classified as answered.

The count of messages from Lyro AI Agent classified as unanswered.

The total count of messages from Lyro AI Agent (cnt_messages_lyro_answered + cnt_messages_lyro_unanswered).

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.

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.

The total count of threads handled by Lyro AI Agent (cnt_threads_lyro_resolved + cnt_threads_lyro_unresolved).

The count of transfers from Lyro AI Agent to an agent.

Total number of tickets created on the given date.

Total number of tickets with a message from operator created on the given date.

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.

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.

The total number of agent threads on a given date.

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.

Total number of agent threads on the given date where an agent did not reply within 3 hours of the visitor’s first message.

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.

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.

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.

Total number of leads created from agent threads on a given date.

Total number of leads acquired through lead generation flows on the given date.

Total number of leads created from pre-chat survey on a given date.

Total number of leads created from whatsapp threads on a given date.

Total number of leads created from instagram threads on a given date.

Total number of contacts leads from messenger threads on a given date.

Total number of leads created from tickets on a given date.

Total number of leads created from an imported csv file on a given date.

Total number of leads created from person details on a given date.

Total number of leads created from Open API integration on a given date.

Total number of leads imported from Shopify on a given date.

Total number of leads created from emails on a given date.

Total number of leads created from review on a given date.

Technical timestamp (UTC, NTZ)

Filtering Columns

Ordering

Limiting and Pagination

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.

Limiting and Pagination

Limiting and Pagination

Preference