CallKeeper. Подключение коннектора
Дата:
Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Плюс”.
Шаг 2. В появившемся окне найдите “CallKeeper” и нажмите кнопку “Добавить”.
Шаг 3. Теперь CallKeeper появился в разделе “Источники данных”. Перейдите в раздел “Настройки”.
Шаг 4. Для подключения Вам необходимо ввести API ключ . Чтобы получить API ключ, зайдите в свой личный кабинет CallKeeper. Перейдите в "Профиль -> Настройки -> Добавление нового API ключа".
Шаг 5. Добавьте новый API ключ (Срок действия: Без срока, Уровень доступа: Только получение данных, Название: <можно указать любое>).
Шаг 6.Скопируйте код созданного API ключа из личного кабинета.
Шаг 7. Введите скопированный API ключ и нажмите кнопку "Проверить ключ".
Шаг 8. После успешной проверки ключа нажмите кнопку “Сохранить настройки”.
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
callkeeper_{}_calls
| Название колонки | Описание |
|---|---|
id_system |
CallKeeper Call ID |
status_code |
SIP manager call status code |
status_reason |
Message about the status of the call to the manager |
status2_code |
SIP client call status code |
status2_reason |
Message about the status of the call to the client |
ip |
Client IP address |
country |
Country code |
city |
City |
region |
Region |
district |
District |
site |
Site |
roistat_visit |
Roistat visit ID |
ga_clientid |
Google Analytics ID |
ya_clientid |
Yandex.Metrica ID |
phone1 |
Manager phone number [additional] |
phone2 |
Client phone number |
widget_hash |
Callkeeper widget's hash |
date |
Date of call in UTC |
order_date |
Date of the call order in UTC |
duration_sec |
Call duration in seconds |
duration_min |
Rounded (billed) duration in minutes |
record_url |
link to the call record |
tags |
Tags |
attempt |
Attempt number |
a_type |
Connection type: 0 - unknown, 1 - connection without SmartCall, 2 - Analog DTMF Smart Call, 3 - Digital DTMF Smart Call, 4 - Voice SmartCall, 5 - Automatically, after completion of the set value of the IVR pronouncing |
playback_tick |
Number of pronouncements of the IVR text beforethe response from the operator |
asr_attempts |
Number of recognition attempts |
event_source |
Type of call source |
source |
Ad traffic source |
source_type |
Traffic type |
duration2_sec |
Duration after answering by the client in seconds |
duration2_min |
Duration after answering by the client in minutes (with rounding up) |
text_to_manager |
Text for manager |
office_name |
Name of the office from which the call was received |
call_type_description |
Call type |
visit_info_current_typ |
Traffic type |
visit_info_current_src |
utm source |
visit_info_current_mdm |
utm medium |
visit_info_current_cmp |
utm campaign |
visit_info_current_cnt |
utm content |
visit_info_current_trm |
utm term |
visit_info_current_src_full |
Full transition source |
visit_info_first_typ |
Traffic type of the first visit |
visit_info_first_src |
utm_source of the first visit |
visit_info_first_mdm |
utm medium of the first visit |
visit_info_first_cmp |
utm campaign of the first visit |
visit_info_first_cnt |
utm content of the first visit |
visit_info_first_trm |
utm term of the first visit |
visit_info_first_src_full |
Full source of the transition of the first visit |
visit_info_session_pgs |
Number of pages viewed (before making the call) |
visit_info_session_cpg |
Page from where the call was made |
visit_info_session_cpg_full |
Page from where the call was made |
visit_info_udata_vst |
Sequential number of the visit |
visit_info_udata_uip |
Client IP address |
visit_info_udata_uag |
User Agent data |
visit_info_ga_clid_gaClientId |
Google Analytics ID |
visit_info_sending_page |
Transition page |
Название таблицы:
callkeeper_{}_tap2calls
| Название колонки | Описание |
|---|---|
id_system |
CallKeeper Call ID |
date |
Date of call in UTC |
widget_hash |
Callkeeper widget's hash |
t2c_phone |
Phone number |
cookieees |
Cookies |
visit_info_current_typ |
Traffic type |
visit_info_current_src |
utm source |
visit_info_current_mdm |
utm medium |
visit_info_current_cmp |
utm campaign |
visit_info_current_cnt |
utm content |
visit_info_current_trm |
utm term |
visit_info_current_add_fd |
Transition date |
visit_info_current_add_ep |
First page that the user visited |
visit_info_current_add_rf |
Page from which the user logged in |
visit_info_first_typ |
Traffic type of the first visit |
visit_info_first_src |
utm_source |
visit_info_first_mdm |
utm medium |
visit_info_first_cmp |
utm campaign |
visit_info_first_cnt |
utm content |
visit_info_first_trm |
utm term |
visit_info_first_add_fd |
Transition date |
visit_info_first_add_ep |
First page that the user visited |
visit_info_first_add_rf |
Page from which the user logged in |
visit_info_session_pgs |
Number of pages viewed (before making the call) |
visit_info_session_cpg |
Page from where the call was made |
visit_info_udata_vst |
Sequential number of the visit |
visit_info_udata_uip |
Client IP address |
visit_info_udata_uag |
User Agent data |
visit_info_ga_clid_gaClientId |
Google Analytics ID |
visit_info_sending_page |
Transition page |
ip |
Client IP address |
t2c_calltouch_id |
Calltouch session ID |
office |
Name of the office from which the call was received |