Streamwood. Подключение коннектора

Дата:

Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Добавить источник данных”.

Добавление источника данных

Шаг 2. В появившемся окне найдите "Streamwood" и нажмите кнопку “Добавить”.

Выбор коннектора Streamwood

Шаг 3. Для подключения Вам необходимо ввести логин от аккаунта в Streamwood и API-key проекта.

Ввод ключа API Streamwood

Шаг 4. API-key можно получить в личном кабинете Streamwood в разделе "Интеграции" → "API Streamwood" → Скопировать ключ.

Личный кабинет Интеграции

Личный кабинет Скопировать ключ

Шаг 5. После ввода логина и API-key нажмите кнопку "Проверить подключение".

Коннектор создан!

Описание таблиц в базе данных

Каждый источник данных создает набор таблиц в вашей базе данных

Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице

Название таблицы:
streamwood_(project_id)_leads
Название колонки Описание
lead_id Streamwood Client ID
client_name Client name
message First message to the chat or the specified values in the registrar/generator, depending on which widget the contact was left in
phone Phone number
email E-mail
form_type Type of form contact was left in:chat — contacting to the Online Consultant widget;feedback — feedback, client did not wait for the manager's response in the Online Consultant widget;invitation — auto-invitation to write to the widget of an online consultant;generator — application to the Client Generator widget;recall — ordering a call in the Callback widget;registrator — application to the Registrar widget
url URL of the page from which the contact was left
completed Lead processed
created_at Date and time when client left the contact
host_id ID of the site in the Streamwood system where the contact was left in
host_name Name of the site in the Streamwood system where the contact was left in
manager_id Streamwood manager ID responsible to the contact
manager_name Streamwood manager name
department_id Streamwood department ID responsible to the contact
department_name Streamwood department name
session_id Streamwood client ID
session_expired Contains in the response ONLY if Streamwood Client sessionexpired. All other session parameters are absent with this value
session_client_name Client name
session_last_visit Date and time of client's last visit
session_created_at Date and time of client's first visit
session_ip Client IP-address
session_url URl of the last visited page on the site
utm_campaign Utm Campaign
utm_source Utm Source
utm_medium Utm Medium
utm_term Utm Term
utm_content Utm Content
Название таблицы:
streamwood_(project_id)_calls
Название колонки Описание
call_id Streamwood Call ID
url URL of the page from which the request for a callback was left
created_at Date and time when the client left a request for a call
call_from Phone number of the manager who received the call.May be empty if the call is still in progress.
call_to Client phone number.May be empty if the call is still in progress.
call_state Call status. May change if the call is still in progress.SCHEDULED — call order for a certain time;ERROR — error occurred while processing the call;BUSY — manager's phone is busy;UNANSWERED — client did not answer the call;ANSWERED — call was successful;NONE — call is in progress.
duration Call duration in seconds
record Link to the call record (mp3 file)
host_id ID of the site in the Streamwood system where the callback request was left
host_name Name of the site in the Streamwood system where the callback request was left
client_name Client name
session_id Streamwood Client ID
session_expired Contains in the response ONLY if Streamwood Client sessionexpired. All other session parameters are absent with this value
session_client_name Client name
session_last_visit Date and time of the client's last visit
session_created_at Date and time of the client's first visit
session_ip Client's IP address
session_url URl of the last visited page on the site
utm_campaign Utm Campaign
utm_source Utm Source
utm_medium Utm Medium
utm_term Utm Term
utm_content Utm Content