База Sina

Обновлено 2026-09-29 16:04 по Москве. Здесь состав базы: таблицы и колонки. Строки клиентов не показываются.

Что нельзя смешивать · Меры Superset · Подробная схема · Дашборд

Витрины

То, что смотрят в отчётах

Клиенты

fct_client · 2 900 строк

Колонки

Поле	Тип	Смысл
contact_id	UInt64
first_created_date	Date
cohort_month	Date
last_created_date	Date
lifetime_days	UInt16
deals	UInt16
paid_deals	UInt16
paid_amount	Float64
paid_line_amount	Float64
line_amount	Float64
utm_source	String
utm_medium	String
utm_campaign	String
is_new_client	UInt8
is_returned	UInt8

Сделки

fct_deal · 4 231 строк

Колонки

Поле	Тип	Смысл
deal_id	UInt64
contact_id	UInt64
company_id	UInt64
lead_id	UInt64
category_id	String
funnel_name	String
created_date	Date
created_at	DateTime
cohort_month	Date
begin_date	Nullable(Date)
close_date	Nullable(Date)
close_month	Nullable(Date)
closed	UInt8
days_to_close	Nullable(UInt16)
stage_id	String
stage_name	String
stage_semantic	LowCardinality(String)
stage_group	String
source_id	String
source_name	String
assigned_by_id	UInt64
amount	Float64
currency	LowCardinality(String)
line_amount	Float64
quantity	Float64
lines	UInt16
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
has_utm	UInt8
yandex_client_id	String
is_vk	UInt8
is_preorder	UInt8
is_in_transit	UInt8
is_refusal	UInt8
is_exchange_return	UInt8
is_confirmed	UInt8
is_paid_full	UInt8
is_paid_partial	UInt8
is_paid	UInt8
is_new_client	UInt8
reached_preorder	UInt8
reached_transit	UInt8
reached_paid	UInt8
reached_refusal	UInt8
reached_confirmed	UInt8
deal_seq	UInt16

Сделка и последний визит

fct_deal_visit · — строк

Колонки

Поле	Тип	Смысл
deal_id	UInt64
created_at	DateTime
created_date	Date
amount	Float64
is_paid	UInt8
yandex_client_id	String
visit_source	String
visit_medium	String
visit_campaign	String
visit_time	DateTime

Расход Директа

fct_direct_day · — строк

Колонки

Поле	Тип	Смысл
day	Date
campaign_id	String
campaign_name	String
impressions	UInt64
clicks	UInt64
cost	Float64

Товары в сделках

fct_sales · 3 636 строк

Колонки

Поле	Тип	Смысл
row_id	UInt64
deal_id	UInt64
product_id	UInt64
created_date	Date
created_at	DateTime
cohort_month	Date
category_id	String
funnel_name	String
stage_id	String
stage_name	String
stage_semantic	LowCardinality(String)
stage_group	String
product_name	String
product_size	String
catalog_name	String
catalog_price	Float64
price	Float64
quantity	Float64
discount_sum	Float64
line_amount	Float64
amount	Float64
currency	LowCardinality(String)
contact_id	UInt64
company_id	UInt64
lead_id	UInt64
source_id	String
source_name	String
assigned_by_id	UInt64
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
has_utm	UInt8
begin_date	Nullable(Date)
close_date	Nullable(Date)
close_month	Nullable(Date)
closed	UInt8
days_to_close	Nullable(UInt16)
yandex_client_id	String
calltouch_first_order	UInt8
is_vk	UInt8
is_preorder	UInt8
is_in_transit	UInt8
is_refusal	UInt8
is_exchange_return	UInt8
is_confirmed	UInt8
is_paid_full	UInt8
is_paid_partial	UInt8
is_paid	UInt8
is_new_client	UInt8

Аудитория

fct_smm_audience · 15 287 строк

Колонки

Поле	Тип	Смысл
day	Date
account_id	String
project	String
network	LowCardinality(String)
account_name	String
gender	LowCardinality(String)
age_band	LowCardinality(String)
people	Float64
is_latest	UInt8

Соцсети по дням

fct_smm_daily · 5 902 строк

Колонки

Поле	Тип	Смысл
day	Date
account_id	String
project	String
network	LowCardinality(String)
account_name	String
followers	Float64
gained	Float64
lost	Float64
followers_open	Float64
posts	Float64
post_views	Float64
reach	Float64
reach_known	UInt8
reach_followers	Float64
impressions	Float64
visitors	Float64
stories	Float64
story_views	Float64
videos	Float64
video_views	Float64
reels_views	Float64
avg_likes	Float64
avg_comments	Float64
avg_reposts	Float64
avg_views	Float64
avg_reactions	Float64
avg_forwards	Float64
link_clicks	Float64
to_group	Float64
join_group	Float64
hide_clicks	Float64
unsubscribe	Float64
report_clicks	Float64

Сводка периода

fct_smm_period · 13 строк

Колонки

Поле	Тип	Смысл
date_from	Date
date_to	Date
account_id	String
project	String
network	LowCardinality(String)
account_name	String
followers	Float64
followers_diff	Float64
posts	Float64
views	Float64
views_avg	Float64
likes	Float64
comments	Float64
reposts	Float64
er	Float64
er_views	Float64
likes_avg	Float64
comments_avg	Float64
reposts_avg	Float64
votes	Float64
votes_avg	Float64
shares	Float64
shares_avg	Float64
reels_views	Float64
reels_views_avg	Float64

Посты

fct_smm_posts · 3 471 строк

Колонки

Поле	Тип	Смысл
day	Date
created	DateTime
post_id	String
account_id	String
project	String
network	LowCardinality(String)
account_name	String
url	String
text	String
post_type	String
views	Float64
reels_views	Float64
views_best	Float64
likes	Float64
comments	Float64
reposts	Float64
forwards	Float64
votes	Float64
reach	Float64
reach_known	UInt8
reach_subscribers	Float64
reach_viral	Float64
reach_ads	Float64
duration_sec	Float64
action_links	Float64
action_to_group	Float64
action_hide	Float64
action_unsubscribe	Float64
action_report	Float64
is_deleted	UInt8

Сторис

fct_smm_stories · 8 строк

Колонки

Поле	Тип	Смысл
day	Date
created	DateTime
story_id	String
account_id	String
project	String
network	LowCardinality(String)
account_name	String
story_type	String
views	Float64
reach	Float64
replies	Float64
shares	Float64
bans	Float64
subscribers	Float64
open_links	Float64

Видео

fct_smm_videos · 256 строк

Колонки

Поле	Тип	Смысл
day	Date
created	DateTime
video_id	String
account_id	String
project	String
network	LowCardinality(String)
account_name	String
url	String
text	String
views	Float64
likes	Float64
comments	Float64
shares	Float64

Путь по стадиям

fct_stage_path · 19 167 строк

Колонки

Поле	Тип	Смысл
event_id	UInt64
deal_id	UInt64
contact_id	UInt64
category_id	String
funnel_name	String
cohort_month	Date
utm_source	String
utm_medium	String
utm_campaign	String
entered_at	DateTime
entered_date	Date
stage_id	String
stage_name	String
stage_semantic	LowCardinality(String)
stage_group	String
seq	UInt16
is_preorder	UInt8
is_in_transit	UInt8
is_refusal	UInt8
is_paid_full	UInt8
is_paid_partial	UInt8
is_paid	UInt8
is_confirmed	UInt8
is_current	UInt8
hours_in_stage	UInt32

Визиты по меткам

fct_visit_day · — строк

Колонки

Поле	Тип	Смысл
visit_date	Date
utm_source	String
utm_medium	String
utm_campaign	String
visits	UInt64
clients	UInt64

Чистый слой

Без дублей, для расчётов

contact

contact · — строк

Колонки

Поле	Тип	Смысл
contact_id	UInt64
created_at	DateTime
modified_at	DateTime
has_phone	UInt8
has_email	UInt8
source_id	String
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
yandex_client_id	String

deal

deal · — строк

Колонки

Поле	Тип	Смысл
deal_id	UInt64
contact_id	UInt64
company_id	UInt64
lead_id	UInt64
category_id	String
stage_id	String
stage_semantic	LowCardinality(String)
assigned_by_id	UInt64
source_id	String
amount	Float64
currency	LowCardinality(String)
created_at	DateTime
modified_at	DateTime
begin_date	Nullable(Date)
close_date	Nullable(Date)
closed	UInt8
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
yandex_client_id	String
calltouch_first_order	UInt8

deal_product

deal_product · — строк

Колонки

Поле	Тип	Смысл
row_id	UInt64
deal_id	UInt64
product_id	UInt64
product_name	String
price	Float64
quantity	Float64
discount_sum	Float64

deal_stage

deal_stage · — строк

Колонки

Поле	Тип	Смысл
deal_id	UInt64
contact_id	UInt64
company_id	UInt64
lead_id	UInt64
d.category_id	String
d.stage_id	String
stage_semantic	LowCardinality(String)
assigned_by_id	UInt64
d.source_id	String
amount	Float64
currency	LowCardinality(String)
created_at	DateTime
modified_at	DateTime
begin_date	Nullable(Date)
close_date	Nullable(Date)
closed	UInt8
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
yandex_client_id	String
calltouch_first_order	UInt8
funnel_name	String
stage_name	String
stage_group	String
source_name	String
is_vk	UInt8
is_preorder	UInt8
is_in_transit	UInt8
is_refusal	UInt8
is_exchange_return	UInt8
is_confirmed	UInt8
is_paid_full	UInt8
is_paid_partial	UInt8
is_paid	UInt8
is_new_client	UInt8
has_utm	UInt8

direct_cost

direct_cost · — строк

Колонки

Поле	Тип	Смысл
report_date	Date
client_login	LowCardinality(String)
campaign_id	String
campaign_name	String
impressions	UInt64
clicks	UInt64
cost	Float64

funnel

funnel · — строк

Колонки

Поле	Тип	Смысл
category_id	String
name	String

ld_account

ld_account · — строк

Колонки

Поле	Тип	Смысл
account_id	String
project	String
network	LowCardinality(String)
type	LowCardinality(String)
name	String
url	String
is_linked	UInt8
followers_now	Float64
payload	String

ld_analytics

ld_analytics · — строк

Колонки

Поле	Тип	Смысл
account_id	String
date_from	Date
date_to	Date
followers	Float64
followers_diff	Float64
posts	Float64
views	Float64
views_avg	Float64
likes	Float64
comments	Float64
reposts	Float64
er	Float64
er_views	Float64
likes_avg	Float64
comments_avg	Float64
reposts_avg	Float64
votes	Float64
votes_avg	Float64
shares	Float64
shares_avg	Float64
reels_views	Float64
reels_views_avg	Float64

ld_audience

ld_audience · — строк

Колонки

Поле	Тип	Смысл
account_id	String
day	Date
payload	String

ld_history

ld_history · — строк

Колонки

Поле	Тип	Смысл
account_id	String
day	Date
followers	Float64
gained	Float64
lost	Float64
followers_open	Float64
posts	Float64
post_views	Float64
reach	Float64
reach_known	UInt8
impressions	Float64
visitors	Float64
stories	Float64
story_views	Float64
avg_likes	Float64
avg_comments	Float64
avg_reposts	Float64
avg_views	Float64
avg_reactions	Float64
avg_forwards	Float64
videos	Float64
video_views	Float64
reels_views	Float64
reach_followers	Float64
link_clicks	Float64
to_group	Float64
join_group	Float64
hide_clicks	Float64
unsubscribe	Float64
report_clicks	Float64

ld_post

ld_post · — строк

Колонки

Поле	Тип	Смысл
account_id	String
post_id	String
day	Date
created	DateTime
url	String
text	String
post_type	String
views	Float64
likes	Float64
comments	Float64
reposts	Float64
reach	Float64
reach_known	UInt8
votes	Float64
forwards	Float64
reels_views	Float64
views_best	Float64
duration_sec	Float64
reach_subscribers	Float64
reach_viral	Float64
reach_ads	Float64
action_links	Float64
action_to_group	Float64
action_hide	Float64
action_unsubscribe	Float64
action_report	Float64
is_deleted	UInt8

ld_story

ld_story · — строк

Колонки

Поле	Тип	Смысл
account_id	String
story_id	String
day	Date
created	DateTime
story_type	String
views	Float64
reach	Float64
replies	Float64
shares	Float64
bans	Float64
subscribers	Float64
open_links	Float64

ld_video

ld_video · — строк

Колонки

Поле	Тип	Смысл
account_id	String
video_id	String
day	Date
created	DateTime
url	String
text	String
views	Float64
likes	Float64
comments	Float64
shares	Float64

lead

lead · — строк

Колонки

Поле	Тип	Смысл
lead_id	UInt64
contact_id	UInt64
company_id	UInt64
status_id	String
status_semantic	LowCardinality(String)
source_id	String
amount	Float64
currency	LowCardinality(String)
created_at	DateTime
modified_at	DateTime
closed_at	Nullable(DateTime)
has_phone	UInt8
has_email	UInt8
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String

metrika_visit

metrika_visit · — строк

Колонки

Поле	Тип	Смысл
event_id	UInt64
event_time	DateTime
visit_date	Date
client_id	String
utm_source	String
utm_medium	String
utm_campaign	String
goals	Array(String)

product

product · — строк

Колонки

Поле	Тип	Смысл
product_id	UInt64
name	String
price	Float64
currency	LowCardinality(String)
active	UInt8

source

source · — строк

Колонки

Поле	Тип	Смысл
source_id	String
name	String

stage

stage · — строк

Колонки

Поле	Тип	Смысл
stage_id	String
category_id	String
name	String
semantics	LowCardinality(String)

stage_flag

stage_flag · — строк

Колонки

Поле	Тип	Смысл
stage_id	String
category_id	String
stage_name	String
semantics	LowCardinality(String)
stage_group	String
is_preorder	UInt8
is_in_transit	UInt8
is_refusal	UInt8
is_exchange_return	UInt8
is_confirmed	UInt8
is_paid_full	UInt8
is_paid_partial	UInt8
is_paid	UInt8

stage_history

stage_history · — строк

Колонки

Поле	Тип	Смысл
event_id	UInt64
entity_type	LowCardinality(String)
owner_id	UInt64
category_id	String
stage_id	String
stage_semantic	LowCardinality(String)
created_at	DateTime

stage_map

stage_map · — строк

Колонки

Поле	Тип	Смысл
stage_id	String
category_id	String
stage_name	String
semantics	LowCardinality(String)
stage_group	String

Сырьё

Как пришло из кабинетов

btx_activity

btx_activity · 21 230 строк

Колонки

Поле	Тип	Смысл
activity_id	UInt64
type_id	UInt16	Стандарт Битрикса: 1 встреча, 2 звонок, 3 задача, 4 письмо
direction	UInt8	1 входящее, 2 исходящее
owner_type_id	UInt16	1 лид, 2 сделка, 3 контакт, 4 компания
owner_id	UInt64
completed	UInt8
created_at	DateTime

btx_company

btx_company · 337 строк

Колонки

Поле	Тип	Смысл
company_id	UInt64
title	String	Название компании
created_at	DateTime
modified_at	DateTime

btx_contact

btx_contact · 3 337 строк

Колонки

Поле	Тип	Смысл
contact_id	UInt64	Клиент в CRM
created_at	DateTime
modified_at	DateTime
has_phone	UInt8	Телефон в Битриксе есть
has_email	UInt8	Почта в Битриксе есть
source_id	String
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
yandex_client_id	String	clientID Метрики

Сделки Битрикса

btx_deal · 4 231 строк

Колонки

Поле	Тип	Смысл
deal_id	UInt64
contact_id	UInt64	Клиент
company_id	UInt64
lead_id	UInt64
category_id	String	Воронка
stage_id	String
stage_semantic	LowCardinality(String)	S успех, F провал, P в работе
assigned_by_id	UInt64	Числовой id менеджера
source_id	String
amount	Float64	Сумма поля сделки
currency	LowCardinality(String)
created_at	DateTime
modified_at	DateTime
begin_date	Nullable(Date)
close_date	Nullable(Date)
closed	UInt8
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String
yandex_client_id	String	clientID Метрики
calltouch_first_order	UInt8	Галочка Calltouch «первый заказ»

btx_deal_product

btx_deal_product · 3 636 строк

Колонки

Поле	Тип	Смысл
row_id	UInt64	ID строки товара в сделке
deal_id	UInt64
product_id	UInt64	ID каталога. 0 — строка без карточки товара
product_name	String	Название на момент сделки
price	Float64
quantity	Float64
discount_sum	Float64

btx_funnel

btx_funnel · 4 строк

Колонки

Поле	Тип	Смысл
category_id	String	ID воронки
name	String	Название воронки

btx_lead

btx_lead · 939 строк

Колонки

Поле	Тип	Смысл
lead_id	UInt64
contact_id	UInt64
company_id	UInt64
status_id	String
status_semantic	LowCardinality(String)
source_id	String
amount	Float64
currency	LowCardinality(String)
created_at	DateTime
modified_at	DateTime
closed_at	Nullable(DateTime)
has_phone	UInt8
has_email	UInt8
utm_source	String
utm_medium	String
utm_campaign	String
utm_content	String
utm_term	String

btx_lead_status

btx_lead_status · 5 строк

Колонки

Поле	Тип	Смысл
status_id	String
name	String
semantics	LowCardinality(String)

btx_product

btx_product · 678 строк

Колонки

Поле	Тип	Смысл
product_id	UInt64	ID товара каталога
name	String	Название в каталоге
price	Float64	Цена каталога
currency	LowCardinality(String)
active	UInt8	1 — активен

btx_source

btx_source · 62 строк

Колонки

Поле	Тип	Смысл
source_id	String	Код источника
name	String	Название источника

btx_stage

btx_stage · 79 строк

Колонки

Поле	Тип	Смысл
stage_id	String	Код стадии
category_id	String	Воронка
name	String	Название стадии
semantics	LowCardinality(String)	Пометка Битрикса: process, success, failure, apology

btx_stage_history

btx_stage_history · 21 046 строк

Колонки

Поле	Тип	Смысл
event_id	UInt64
entity_type	LowCardinality(String)	deal или lead
owner_id	UInt64	ID сделки или лида
category_id	String
stage_id	String
stage_semantic	LowCardinality(String)
created_at	DateTime	Когда стадия стала текущей

ld_account

ld_account · 13 строк

Колонки

Поле	Тип	Смысл
account_id	String
project	String
network	LowCardinality(String)
type	LowCardinality(String)
name	String
url	String
is_linked	UInt8
followers_now	Float64
payload	String

ld_analytics

ld_analytics · 13 строк

Колонки

Поле	Тип	Смысл
account_id	String
date_from	Date
date_to	Date
followers	Float64
followers_diff	Float64
posts	Float64
views	Float64
views_avg	Float64
likes	Float64
comments	Float64
reposts	Float64
er	Float64
payload	String

ld_audience

ld_audience · 797 строк

Колонки

Поле	Тип	Смысл
account_id	String
day	Date
payload	String

ld_history

ld_history · 5 902 строк

Колонки

Поле	Тип	Смысл
account_id	String
day	Date
followers	Float64
gained	Float64
lost	Float64
posts	Float64
post_views	Float64
reach	Float64
reach_known	UInt8
impressions	Float64
visitors	Float64
stories	Float64
story_views	Float64
avg_likes	Float64
avg_comments	Float64
avg_reposts	Float64
avg_views	Float64
avg_reactions	Float64
avg_forwards	Float64
payload	String

ld_post

ld_post · 3 471 строк

Колонки

Поле	Тип	Смысл
account_id	String
post_id	String
day	Date
created	DateTime
url	String
text	String
post_type	String
views	Float64
likes	Float64
comments	Float64
reposts	Float64
reach	Float64
reach_known	UInt8
payload	String

ld_story

ld_story · 8 строк

Колонки

Поле	Тип	Смысл
account_id	String
story_id	String
day	Date
created	DateTime
story_type	String
views	Float64
reach	Float64
payload	String

ld_video

ld_video · 256 строк

Колонки

Поле	Тип	Смысл
account_id	String
video_id	String
day	Date
created	DateTime
url	String
text	String
views	Float64
payload	String

Расход Директа, сырьё

ya_direct_costs · 828 строк

Колонки

Поле	Тип	Смысл
loaded_at	DateTime64(3, \'Europe/Moscow\')
report_date	Date	День отчёта
client_login	LowCardinality(String)
campaign_id	String
campaign_name	String	Название кампании на момент отчёта
impressions	UInt64
clicks	UInt64
cost	Float64	Расход с НДС, рубли

ya_metrika_logs_hits

ya_metrika_logs_hits · 0 строк

Колонки

Поле	Тип	Смысл
loaded_at	DateTime64(3, \'Europe/Moscow\')
event_id	UInt64	ym:pv:watchID
event_time	DateTime	Дата и время просмотра
client_id	String	ClientID, связь с yandex_client_id Битрикса
utm_source	String
utm_medium	String
utm_campaign	String
goals	Array(String)	Достигнутые цели

Визиты Метрики

ya_metrika_logs_visits · 234 962 строк

Колонки

Поле	Тип	Смысл
loaded_at	DateTime64(3, \'Europe/Moscow\')
event_id	UInt64	ym:s:visitID
event_time	DateTime	Дата и время визита
client_id	String	ClientID, связь с yandex_client_id Битрикса
utm_source	String
utm_medium	String
utm_campaign	String
goals	Array(String)	Достигнутые цели