CoMagic. Подключение коннектора
Дата:
Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Плюс”.
Шаг 2. В появившемся окне, найдите “Calltouch” и нажмите кнопку “Добавить”.
Теперь Comagic появился в источниках данных.
Шаг 3. Нажмите кнопку “Настройки” и скопируйте ip-адрес. Перед вводом логина и пароля, Вам необходимо зайти в кабинет Comagic. В боковом меню выберете вкладку “Мои клиенты”.
Шаг 4. Выберете клиента, данные по которому хотите выгружать.
Важно!!! При переходе необходимо выбрать аккаунт с административными доступами.
Шаг 5. Заходим в аккаунт .
В боковом меню выберете “Правила настройки безопасности”. Далее перейдите во вкладку API. Нажмите кнопку добавить и вставьте ip-адреса:
- 78.46.105.226
- 88.99.148.90
- 23.88.75.147
- 94.130.13.34
После нажмите иконку “Сохранить”.
Шаг 6. Вернитесь в приложение Калидка. Введите логин и пароль от кабинета CoMagic и нажмите кнопку “Проверить ключ”.
Шаг 7. Выберите пользователя, сайт и нажмите “Сохранить настройки”.
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
comagic_{}_calls
| Название колонки | Описание |
|---|---|
id_system |
Call session ID |
date |
Date and time of call session start |
channel |
Channel |
contact_phone_number |
Phone number of the contact who made the call in case of an incoming call or the number of the contact to whom the call was made in case of an outgoing call |
contact_full_name |
Contact fullname |
virtual_phone_number |
Virtual phone number |
link_download |
Link to call record |
referrer |
Referrer |
referrer_domain |
Referrer domain |
entrance_page |
Landing page |
campaign_id |
Campaign ID |
campaign_name |
Campaign Name |
visit_other_campaign |
Indicator of whether person visited other campaigns |
utm_source |
utm_source |
utm_campaign |
utm_campaign |
utm_content |
utm_content |
utm_medium |
utm_medium |
utm_term |
utm_term |
ym_client_id |
Yandex.Metrica ID |
ua_client_id |
Universal Analytics ID |
finish_time |
End time of the call session |
is_transfer |
Indicator of whether there was a transfer in the call session |
finish_reason |
Reason for ending the call session |
direction |
Direction of the call session |
source |
Call source |
communication_number |
Is always empty for Hosted PBX sessions |
communication_page_url |
URL of the page where the visitor was at the time of the application |
communication_id |
Application ID |
communication_type |
Application type |
is_lost |
Indication of whether the call is lost or successful |
cpn_region_id |
ID of the subscriber number region |
cpn_region_name |
Subscriber number region name |
wait_duration |
Duration of subscriber's waiting time before the first conversationwith an employee, seconds |
total_wait_duration |
Total duration of subscriber's waiting time on the line. Counts all intervals when the subscriber did not speak to an employee |
talk_duration |
Call duration. Counts from the moment of the first conversation between the subscriber and the employee to the beginning of postprocessing |
clean_talk_duration |
Net duration of the call. Counts only the intervals when the subscriber was talking to an employee |
total_duration |
Call duration, seconds |
postprocess_duration |
Postprocessing duration, seconds |
sale_date |
Deal date |
sale_cost |
Deal sum |
search_query |
Search query |
search_engine |
Search engine |
gclid |
Google Click ID |
yclid |
Yandex Click ID |
ymclid |
Yandex Market Click ID |
ef_id |
Is used to mark up links in AdLense |
site_id |
Website ID |
site_domain_name |
Website domain. Without specifying the protocol |
visitor_id |
Visitor ID |
person_id |
Person ID |
visitor_type |
Visitor type |
visitor_session_id |
Visitor session ID |
visits_count |
Sessions count |
visitor_first_campaign_id |
First campaign ID |
visitor_first_campaign_name |
First campaign name |
visitor_city |
Visitor city |
visitor_region |
Visitor region |
visitor_country |
Visitor country |
visitor_device |
Visitor device |
last_answered_employee_id |
ID of the last employee who answered the call |
last_answered_employee_full_name |
Fullname of the last employee who answered the call |
last_answered_employee_rating |
Rating that subscriber gave the employee who answered the call last |
first_answered_employee_id |
ID of the first employee who answered the call |
first_answered_employee_full_name |
Fullname of the first employee who answered the call |
scenario_id |
ID of the script that started call processing |
scenario_name |
Name of the script that started the call processing |
call_api_external_id |
Call API External ID |
call_api_request_id |
Call API Request ID |
contact_id |
Contact ID |
openstat_ad |
Ad ID |
openstat_campaign |
Campaign ID |
openstat_service |
Vendor ID |
openstat_source |
ID of the site, section, page, place on the page where the ad was shown |
eq_utm_source |
Extended utm_source |
eq_utm_medium |
Extended utm_medium |
eq_utm_term |
Extended utm_term |
eq_utm_content |
Extended utm_content |
eq_utm_campaign |
Extended utm_campaign |
eq_utm_referrer |
Extended utm_referrer |
eq_utm_expid |
Extended utm_expid |
attributes |
Attributes |
call_records |
Call record link ID |
voice_mail_records |
Voice mail record ID |
tags |
Tags |
visitor_custom_properties |
Visitor custom properties |
segments |
Segments |
employees |
Employees who participated in the call |
scenario_operations |
List of all operations for all scenarios involved in call processing |
Название таблицы:
comagic_{}_offline_messages
| Название колонки | Описание |
|---|---|
id_system |
Offline application ID |
date |
Date and time of receipt of application |
text |
Application text |
communication_number |
Application number. Calculated within the persona |
communication_page_url |
URL of the page where the visitor was at the time of the application |
communication_type |
Application type |
communication_id |
Application ID |
ua_client_id |
Universal Analytics ID |
ym_client_id |
Yandex Metrica ID |
sale_date |
Deal date |
sale_cost |
Deal sum |
status |
Deal status |
process_time |
Date and time when the application was transferred to the status "Processed" |
form_type |
Type of form from which the offline application was sent |
search_query |
Search query |
search_engine |
Search engine |
referrer_domain |
Referrer domain |
referrer |
Referrer |
entrance_page |
Landing page |
gclid |
Google Click ID |
yclid |
Yandex Click ID |
ymclid |
Yandex Market Click ID |
ef_id |
Is used to mark up links in the contextual advertising management system AdLense |
channel |
Channel |
employee_id |
ID of the employee who processed the application |
employee_full_name |
ID of the employee who processed the application |
employee_answer_message |
Employee's response, which was sent to the visitor's email address |
employee_comment |
Employee's comment when moving the application to the 'Processed' status |
tags |
Tags |
site_id |
Website ID |
site_domain_name |
Website domain. Without specifying the protocol |
group_id |
Group ID chosen by visitor |
group_name |
Group name chosen by visitor |
campaign_id |
Campaign ID |
campaign_name |
Campaign name |
visit_other_campaign |
Indicator of whether person visited other campaigns |
visitor_id |
Visitor ID |
visitor_name |
Visitor name |
visitor_phone_number |
Visitor phone number |
visitor_email |
Visitor e-mail |
person_id |
Person ID |
visitor_type |
Visitor type |
visitor_session_id |
Visitor session ID |
visits_count |
Sessions count |
visitor_first_campaign_id |
First campaign ID |
visitor_first_campaign_name |
First campaign name |
visitor_city |
Visitor city |
visitor_region |
Visitor region |
visitor_country |
Visitor country |
visitor_device |
Visitor device |
visitor_custom_properties |
Visitor custom properties |
segments |
Segments |
utm_source |
Utm source |
utm_medium |
Utm medium |
utm_term |
Utm term |
utm_content |
Utm content |
utm_campaign |
Utm campaign |
openstat_ad |
Ad ID |
openstat_campaign |
Campaign ID |
openstat_service |
Vendor ID |
openstat_source |
ID of the site, section, page, place on the page where the ad was shown |
eq_utm_source |
Extended utm_source |
eq_utm_medium |
Extended utm_medium |
eq_utm_term |
Extended utm_term |
eq_utm_content |
Extended utm_content |
eq_utm_campaign |
Extended utm_campaign |
eq_utm_referrer |
Extended utm_referrer |
eq_utm_expid |
Extended utm_expid |
attributes |
Attributes |
Название таблицы:
comagic_{}_visitor_params
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
name |
Name |
emails |
Emails list |
properties |
Properties |
phone_numbers |
Phone numbers |
Название таблицы:
comagic_{}_chats
| Название колонки | Описание |
|---|---|
id_system |
Chat ID |
date |
Chat start date and time |
status |
Status |
initiator |
Chat initiator |
duration |
Chat duration in seconds |
answer_time |
Operator response time in seconds |
communication_number |
Application number. Calculated within the person |
communication_page_url |
URL of the page where the visitor was at the time of the application |
communication_id |
Application ID |
communication_type |
Application type |
chat_channel_type |
Channel type |
chat_channel_name |
Channel name |
messages_count |
Number of chat messages |
ua_client_id |
Universal Analytics ID |
ym_client_id |
Yandex.Metrica ID |
sale_date |
Deal date |
sale_cost |
Deal sum |
is_transfer |
Indicator of whether chat was passed on to another employee |
release_cause |
Reason for ending the chat |
search_query |
Search query |
search_engine |
Search engine |
referrer_domain |
Referrer domain |
referrer |
Referrer |
entrance_page |
Landing page |
gclid |
Google Click ID |
yclid |
Yandex Click ID |
ymclid |
Yandex Market Click ID |
ef_id |
Is used to mark up links in the contextual advertising management system AdLense |
channel |
Channel |
employee_id |
Employee ID |
employee_full_name |
Employee fullname |
employee_messages_count |
Number of employee messages in chat |
employee_raiting |
Employee rating given by a visitor |
site_id |
Website ID |
site_domain_name |
Website domain. Without specifying the protocol |
campaign_id |
Campaign ID |
campaign_name |
Campaign name |
visit_other_campaign |
Indicator of whether person visited other campaigns |
visitor_id |
Visitor ID |
person_id |
Person ID |
visitor_type |
Visitor type |
visitor_session_id |
Visitor session ID |
visits_count |
Sessions count |
visitor_first_campaign_id |
First campaign ID |
visitor_first_campaign_name |
First campaign name |
visitor_city |
Visitor city |
visitor_region |
Visitor region |
visitor_country |
Visitor country |
visitor_device |
Visitor device |
utm_source |
Utm source |
utm_medium |
Utm medium |
utm_term |
Utm source term |
utm_content |
Utm content |
utm_campaign |
Utm campaign |
openstat_ad |
Ad ID |
openstat_campaign |
Campaign ID |
openstat_service |
Vendor ID |
openstat_source |
ID of the site, section, page, place on the page where the ad was shown |
eq_utm_source |
Extended utm_source |
eq_utm_medium |
Extended utm_medium |
eq_utm_term |
Extended utm_term |
eq_utm_content |
Extended utm_content |
eq_utm_campaign |
Extended utm_campaign |
eq_utm_referrer |
Extended utm_referrer |
eq_utm_expid |
Extended utm_expid |
attributes |
Attributes |
visitor_custom_properties |
Visitor custom properties |
segments |
Segments |
tags |
Tags |
Название таблицы:
comagic_{}_goals
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
date |
Дата и время достижения цели |
name |
Название цели |
type |
Тип цели (click, scroll, track_event и др.) |
ext_id |
Внешний идентификатор цели |
source |
Система, где создана цель (yandex.metrika, google.analytics, comagic) |
communication_number |
Номер обращения в рамках персоны |
communication_page_url |
URL страницы, где произошло обращение |
communication_id |
Уникальный идентификатор обращения |
communication_type |
Тип обращения (goal, primary, secondary) |
ua_client_id |
Universal Analytics ID |
ym_client_id |
Yandex.Metrica ID |
sale_date |
Дата сделки |
sale_cost |
Сумма сделки |
search_query |
Поисковый запрос |
search_engine |
Поисковая система |
referrer_domain |
Домен реферера |
referrer |
Реферер (полный URL) |
entrance_page |
Страница входа (landing page) |
gclid |
Google Click ID |
yclid |
Yandex Click ID |
ymclid |
Yandex Market Click ID |
ef_id |
Click ID для AdLense |
channel |
Канал привлечения |
tags |
Теги (массив объектов) |
site_id |
ID сайта |
site_domain_name |
Домен сайта без протокола |
campaign_id |
ID рекламной кампании |
campaign_name |
Название рекламной кампании |
visit_other_campaign |
Посещал ли посетитель другие кампании |
visitor_id |
ID посетителя |
person_id |
ID персоны |
visitor_type |
Тип посетителя (новый/вернувшийся) |
visitor_session_id |
ID сессии посетителя |
visits_count |
Количество сессий |
visitor_first_campaign_id |
ID первой кампании посетителя |
visitor_first_campaign_name |
Название первой кампании посетителя |
visitor_city |
Город посетителя |
visitor_region |
Регион посетителя |
visitor_country |
Страна посетителя |
visitor_device |
Устройство посетителя (desktop, mobile, tablet) |
visitor_custom_properties |
Пользовательские свойства посетителя |
segments |
Сегменты |
utm_source |
UTM-метка: источник кампании |
utm_medium |
UTM-метка: канал кампании |
utm_term |
UTM-метка: ключевое слово |
utm_content |
UTM-метка: содержимое объявления |
utm_campaign |
UTM-метка: название кампании |
openstat_ad |
OpenStat: идентификатор объявления |
openstat_campaign |
OpenStat: идентификатор кампании |
openstat_service |
OpenStat: идентификатор сервиса |
openstat_source |
OpenStat: источник (сайт, раздел, страница) |
eq_utm_source |
Расширенная UTM-метка: источник |
eq_utm_medium |
Расширенная UTM-метка: канал |
eq_utm_term |
Расширенная UTM-метка: ключевое слово |
eq_utm_content |
Расширенная UTM-метка: содержимое |
eq_utm_campaign |
Расширенная UTM-метка: кампания |
eq_utm_referrer |
Расширенная UTM-метка: реферер |
eq_utm_expid |
Расширенная UTM-метка: ID эксперимента |
attributes |
Атрибуты (массив строк) |
Название таблицы:
comagic_{}_goals_list
| Название колонки | Описание |
|---|---|
goal_id |
Goal ID |
name |
Goal Name |
email |
Is Goal Email |
Название таблицы:
comagic_{}_communications
| Название колонки | Описание |
|---|---|
id_system |
Application ID |
communication_type |
Application type |
communication_number |
Application number. Calculated within the person |
date |
Date and time of application |
ua_client_id |
Universal Analytics ID |
ym_client_id |
Yandex Metrica ID |
sale_date |
Deal date |
sale_cost |
Deal sum |
search_query |
Search query |
search_engine |
Search engine |
referrer_domain |
Referrer |
entrance_page |
Landing page |
gclid |
Google Click ID |
yclid |
Yandex Click ID |
ymclid |
YandexMarket Click ID |
ef_id |
Is used to mark up links in the contextual advertising management system AdLense |
channel |
Channel |
visitor_id |
Visitor ID |
person_id |
Person ID |
visitor_type |
Visitor type |
visitor_session_id |
Visitor session ID |
visits_count |
Sessions count |
visitor_first_campaign_id |
First campaign ID |
visitor_first_campaign_name |
First campaign name |
visitor_city |
Visitor city |
visitor_region |
Visitor region |
visitor_country |
Visitor country |
visitor_device |
Visitor device |
site_id |
Website ID |
site_domain_name |
Website domain. Without specifying the protocol |
campaign_id |
Campaign ID |
campaign_name |
Campaign name |
visit_other_campaign |
Indicator of whether person visited other campaigns |
utm_source |
Utm source |
utm_medium |
Utm medium |
utm_term |
Utm term |
utm_content |
Utm content |
utm_campaign |
Utm campaign |
attributes |
Attributes |
Название таблицы:
comagic_{}_campaign_daily_stat
| Название колонки | Описание |
|---|---|
date |
Day for which the statistics are given |
site_id |
CoMagic website ID |
site_domain_name |
Website domain name |
campaign_id |
CoMagic Campaign ID |
campaign_name |
Campaign name |
campaign_ext_id |
Campaign external ID |
campaign_ext_name |
Campaign external name |
engine |
Campaign engine |
keyword_id |
Keyword ID |
keyword |
Keyword |
current_banner_id |
Current banner ID |
current_banner_name |
Current banner name |
old_banner_ids |
Previous banner IDs |
banner_group_id |
Banner group ID |
banner_group_name |
Banner group name |
cost_sum |
Channel costs on a given day |
shows_count |
Channel impressions on a given day |
clicks_count |
Campaign clicks on a given day |
calls_count |
Campaign calls on a given day |
chats_count |
Campaign chats on a given day |
goals_count |
Campaign goals on a given day |
visits_count |
Campaign visits on a given day |
offline_messages_count |
Campaign applications on a given day |
daily_budget |
Daily budget |
weekly_budget |
Weekly budget |
currency |
Currency |
session_ids |
Campaign Session IDs on a given day |
communications |
Campaign applications on a given day |
communication_ids |
Campaign applications IDs РК on a given day |
Название таблицы:
comagic_{}_campaigns
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
status |
Campaign status |
creation_time |
Campaign creation time |
description |
Description |
engine |
Campaign engine |
type |
Campaign type |
name |
Campaign name |
Название таблицы:
comagic_{}_employee
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
email |
|
status |
status: - available - Доступен - break - Перерыв - do_not_disturb - Не беспокоить - not_at_workplace - Нет на месте - not_at_work - Нет на работе - auto_out_call - Исходящий обзвон - unknown - Неизвестно |
first_name |
first_name |
last_name |
last_name |
patronymic |
patronymic |
full_name |
full_name |
status_id |
status_id |
call_recording |
call_recording: all, in, out, off |
calls_available |
calls_available |
login |
login |
phone_numbers |
phone_numbers |
operator_sites |
operator_sites |
extension |
extension |
coach |
coach |
operator_workplace_access |
operator_workplace_access |
Название таблицы:
comagic_{}_emp_group
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
name |
name |
group_phone_number |
group_phone_number |
channels_count |
channels_count |
Название таблицы:
comagic_{}_emp_group_phones
| Название колонки | Описание |
|---|---|
group_id |
id |
available |
available |
employee_id |
employee_id |
phone_in_employee_id |
phone_in_employee_id |
employee_phone_number |
employee_phone_number |
employee_phone_number_id |
employee_phone_number_id |
Название таблицы:
comagic_{}_communication_params
| Название колонки | Описание |
|---|---|
site_domain_name |
Website domain |
site_name |
Website name |
communication_type |
Communication type |
communication_id |
Communication ID |
communication_date_time |
Communication date and time |
communication_kinds |
Types/kinds of communication |
communication_page_url |
Page URL at the moment of communication |
contact_phone_number |
Contact phone number |
communication_number |
Communication number within the person |
virtual_phone_number |
Virtual phone number |
contact_full_name |
Contact full name |
is_communication_with_visit |
Is communication associated with a visit |
total_duration |
Total duration (seconds) |
tags |
Tags |
employees |
Employees involved |
channel_new |
New channel |
channel_code |
Channel code |
campaign_name |
Campaign name |
source_new |
New source |
source_name |
Source name |
channel |
Channel |
source |
Source |
referrer |
Referrer |
referrer_domain |
Referrer domain |
eq_utm_source |
Extended utm_source |
eq_utm_medium |
Extended utm_medium |
eq_utm_term |
Extended utm_term |
eq_utm_content |
Extended utm_content |
eq_utm_campaign |
Extended utm_campaign |
eq_utm_referrer |
Extended utm_referrer |
eq_utm_expid |
Extended utm_expid |
utm_source |
utm_source |
utm_medium |
utm_medium |
utm_term |
utm_term |
utm_content |
utm_content |
utm_campaign |
utm_campaign |
utm_referrer |
utm_referrer |
utm_expid |
utm_expid |
entrance_page |
Landing page |
visitor_type |
Visitor type |
visitor_id |
Visitor ID |
person_id |
Person ID |
email_from |
Email from address |
email_message |
Email message text |
email_cc |
Email CC |
email_bcc |
Email BCC |
email_message_html |
Email HTML message |
email_to |
Email to address |
email_subject |
Email subject |
site_analytics |
Site analytics data |
pc |
PC parameter |
gr |
GR parameter |
ad |
Ad parameter |
kw |
Keyword parameter |
chat_initiator |
Chat initiator |
offline_message_type |
Offline message type |
offline_message_email |
Offline message email |
offline_message_text |
Offline message text |
call_region_name |
Call region name |
phone_tracking_type |
Phone tracking type |
call_direction |
Call direction |
call_status |
Call status |
call_type |
Call type |
visit_date |
Visit date |
segments |
Segments |
tag_from |
Tag from |
cm_id |
CM ID |
ef_id |
EF ID (AdLense) |
ymclid |
Yandex Market Click ID |