LiveTex. Подключение коннектора
Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Добавить источник данных”.
Шаг 2. В появившемся окне найдите "” и нажмите кнопку “Добавить”.
Шаг 3. Введите логин и пароль аккаунта LiveTex и нажмите кнопку “Авторизоваться”.
Шаг 4. Скопируйте URL вебхука (необязательно) и нажмите "Сохранить настройки". Коннектор начал загружать данные
Коннектор подключен!
Если требуется сохранение данных с помощью механизма Webhook, то в личном кабинете LiveTex в разделе "Каналы" перейдите к настройке интеграций.
Добавьте новую интеграцию. В поле адреса вставьте скопированный URL вебхука и нажмите галочку. Далее выберете тип сохраняемых событий и необходимые точки контактов и нажмите кнопку "Включить"
Вебхук установлен!
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
| Название колонки | Описание |
|---|---|
chat_id |
Chat ID. Consists of Application ID andthe sequential number of the chat in the application |
created_at |
Date and time of chat creation |
is_closed |
Indicator of closing the whole application |
closed_at |
Date and time of chat closing |
site_id |
ID of the interaction between the company and the client |
site_url |
Name of the interaction between the company and the client |
duration |
Chat duration in seconds |
rating_value |
Score value |
answer_time_avg |
Average employee's response time to visitor's questions in seconds |
conversation_int_referer |
Address of the page where the first chat began |
conversation_result |
Application result |
conversation_visitor_id |
Visitor ID |
conversation_id |
Application ID |
conversation_created_at |
Date of application creation |
prechats_hidden |
List of hidden application fields |
employee_id |
Employee ID |
employee_first_name |
Employee first name |
employee_last_name |
Employee last name |
employee_email |
Employee e-mail, which is also used as the account login |
result |
Chat status |
communication_type |
Communication Channel |
rating_type |
Type of score left by the visitor in the application |
prechats_chat |
List of application fields |
visitor_id |
ID of the visitor who started the chat |
visitor_name |
Visitor name |
employee_remark_id |
Application category ID |
employee_remark_text |
Category name |
message_count |
Number of messages in a chat |
first_answer_time |
Employee response time to the first message of a visitor in seconds |
first_message_id |
Message ID |
first_message_text |
Message text |
first_message_created_at |
Date and time of the first message |
first_message_creator |
Message creator |
messages |
Messages |
| Название колонки | Описание |
|---|---|
lead_id |
Lead ID |
name |
Name |
email |
|
phone |
Phone |
site_id |
ID of the interaction between the company and the client |
site_url |
Name of the interaction between the company and the client |
lead_type |
Lead type |
assigned_to |
ID of the employee to whom the application is assigned |
completed_by |
ID of the employee who processed the application |
text |
Message text |
result |
Time elapsed since visitor's message was sent and marked processed |
created_at |
Date created |
closed_at |
Date and time of chat closing |
employee_remark_id |
Application category ID |
employee_remark_text |
Category name |
is_managed |
Indicator of whether application is managed by the employee calling the method |
conversation_int_referer |
Address of the page where the first chat began |
conversation_result |
Conversation result |
conversation_visitor_id |
Visitor ID |
conversation_id |
Conversation ID |
conversation_created_at |
Conversation creation date |
utm_source |
utm_source |
utm_campaign |
utm_campaign |
utm_content |
utm_content |
utm_medium |
utm_medium |
utm_term |
utm_term |
| Название колонки | Описание |
|---|---|
conversation_id |
Chat ID |
conversation_creation_time |
Date and time of chat creation |
conversation_closed_time |
Date and time of chat closing |
conversation_custom_info |
Additional fields |
discourser_id |
Visitor ID |
discourser_info |
Visitor additional fields |