Adset.ProAdset.ProKnowledge base
RUEN
To app
Home/Публичное HTTP API/Статистика: справочник полей
This article is currently available in Russian only.View in Russian

Статистика: справочник полей

Справочник ключей, которые принимает POST /api/stats/query: фильтруемые поля (filters[].field), группировки (groups[]) и метрики (metrics[]). Как строить запрос — в статье Статистика: отчёты и экспорт.

Живой источник — справочные эндпойнты GET /api/stats/meta/filters, /meta/groups, /meta/metrics (скоуп api:stats:meta). Таблицы ниже — снимок на 13.10.2026; новые метрики и группировки появляются сначала в API.

Колонка «Таблицы» у группировок означает таблицы ClickHouse, в которых ключ валиден:

  • events — основная воронка: клики, конверсии, финансы, лендинги, PWA;
  • events_push — Push-события (показы и клики по пушам);
  • events_push_attributed — Post-click атрибуция Push (требует attributionWindow);
  • events_ltv — LTV и когорты.

Группировки и метрики одного запроса должны пересекаться хотя бы по одной таблице.

1. Фильтруемые поля (filters[].field)

Поле Имя Группа
user_device Device Traffic
user_platform Platform Traffic
user_os OS Traffic
user_os_ver OS Version Traffic
user_browser Browser Traffic
user_browser_ver Browser Version Traffic
user_lang Language Traffic
user_country Country Traffic
user_region Region Traffic
user_asn ASN Traffic
user_asn_org ASN Org Traffic
user_ip IP Traffic
event_domain Domain Event
event_click_id Click ID Event
event_type Event Type Event
ext_utm_source UTM Source UTM
ext_utm_campaign UTM Campaign UTM
ext_utm_medium UTM Medium UTM
ext_utm_content UTM Content UTM
ext_utm_term UTM Term UTM
ext_sub1 … ext_sub10 Sub1 … Sub10 UTM
cmp_user User Stream
cmp_team Team Stream
cmp_campaign Campaign Stream
cmp_cpa CPA Stream
cmp_offer Offer Stream
cmp_offer_type Offer type Stream
cmp_flow Flow Stream
cmp_creative Creative Stream
cmp_pwa PWA Stream
cmp_landing Landing Stream
cmp_source Source Stream
cmp_set Set Stream
cmp_rotation Rotation Stream
event_push_id Push ID Push
event_slot_key Slot Key Push
event_sub_id Sub ID Push

Значения для cmp_* — ObjectId сущностей. Подобрать их по названию можно через GET /api/stats/meta/distinct?field=cmp_campaign&q=…, который возвращает пары { label, value }. Поля cmp_team и cmp_user переопределяются сервером согласно роли владельца токена.

2. Группировки (groups[])

Каждая группировка добавляет колонку в строки отчёта. Если у ключа есть «name»-вариант (cmp_campaign → cmp_campaign_name), он подмешивается в ответ автоматически.

2.1 Время

Ключ Заголовок Таблицы
tenMin 10 Minute events, events_push, events_push_attributed
hour Hour events, events_push, events_push_attributed
hourTime Hour (DateTime) events, events_push, events_push_attributed
day Day events, events_push, events_push_attributed
week Week events, events_push, events_push_attributed
month Month events, events_push, events_push_attributed

Границы периодов считаются в time.timezone запроса.

2.2 Cohort / LTV

Ключ Заголовок Таблицы
cohort_day Cohort (Day) events_ltv
cohort_week Cohort (Week) events_ltv
cohort_month Cohort (Month) events_ltv
lifetime_days Lifetime Days events_ltv
reg_cohort_day Reg Cohort (Day) events_ltv
reg_cohort_week Reg Cohort (Week) events_ltv
reg_cohort_month Reg Cohort (Month) events_ltv
lifetime_days_from_reg Lifetime Days (Reg) events_ltv

cohort_* и lifetime_days отсчитываются от даты первого депозита (FTD), reg_cohort_* и lifetime_days_from_reg — от даты регистрации.

2.3 Пользователь / Сеть

Ключ Заголовок Группа Таблицы
user_device Device User events, events_push, events_push_attributed
user_platform Platform User events, events_push, events_push_attributed
user_os OS User events, events_push, events_push_attributed
user_os_ver OS Version User events, events_push, events_push_attributed
user_browser Browser User events, events_push, events_push_attributed
user_browser_ver Browser Version User events, events_push, events_push_attributed
user_lang Language User events, events_push, events_push_attributed
user_lang_name Language Name User events, events_push, events_push_attributed
user_country Country User events, events_push, events_push_attributed
user_country_name Country Name User events, events_push, events_push_attributed
user_region Region User events, events_push, events_push_attributed
user_proxy Proxy User events, events_push, events_push_attributed
user_proxy_type Proxy Type User events, events_push, events_push_attributed
user_proxy_usage Proxy Usage User events, events_push, events_push_attributed
user_bot Is Bot User events, events_push, events_push_attributed
user_ua User Agent User events, events_push, events_push_attributed
user_ip IP User events, events_push, events_push_attributed
user_asn ASN Network events, events_push, events_push_attributed
user_asn_org ASN Org Network events, events_push, events_push_attributed
event_click_id ClickID User events, events_push, events_push_attributed
event_domain Domain User events

2.4 Маркетинг (UTM / External / Campaign)

Ключ Заголовок Группа Таблицы
ext_utm_source UTM Source UTM events
ext_utm_campaign UTM Campaign UTM events
ext_utm_medium UTM Medium UTM events
ext_utm_content UTM Content UTM events
ext_utm_term UTM Term UTM events
ext_sub1 … ext_sub10 Sub 1 … Sub 10 External events
cmp_user User Campaign events, events_push, events_push_attributed
cmp_user_name User Name Campaign events, events_push, events_push_attributed
cmp_user_email User Email Campaign events, events_push, events_push_attributed
cmp_team Team Campaign events, events_push, events_push_attributed
cmp_team_name Team Name Campaign events, events_push, events_push_attributed
cmp_campaign Campaign Campaign events, events_push, events_push_attributed
cmp_campaign_name Campaign Name Campaign events, events_push, events_push_attributed
cmp_cpa CPA Campaign events, events_push, events_push_attributed
cmp_cpa_name CPA Name Campaign events, events_push, events_push_attributed
cmp_offer Offer Campaign events, events_push, events_push_attributed
cmp_offer_name Offer Name Campaign events, events_push, events_push_attributed
cmp_offer_type Offer Type Campaign events, events_push, events_push_attributed
cmp_flow Flow Campaign events, events_push, events_push_attributed
cmp_flow_name Flow Name Campaign events, events_push, events_push_attributed
cmp_creative Creative Campaign events, events_push, events_push_attributed
cmp_pwa PWA Campaign events, events_push, events_push_attributed
cmp_pwa_name PWA Name Campaign events, events_push, events_push_attributed
cmp_landing Landing Campaign events, events_push, events_push_attributed
cmp_landing_name Landing Name Campaign events, events_push, events_push_attributed
cmp_source Traffic Source Campaign events, events_push, events_push_attributed
cmp_source_name Traffic Source Name Campaign events, events_push, events_push_attributed
cmp_set Set Campaign events, events_push, events_push_attributed
cmp_rotation Rotation Campaign events, events_push, events_push_attributed

2.5 Push / Event

Ключ Заголовок Группа Таблицы
event_push_id Push ID Push events_push, events_push_attributed
event_push_id_name Push Name Push events_push, events_push_attributed
event_slot_key Slot Key Push events_push, events_push_attributed
event_sub_id Sub ID Push events_push, events_push_attributed
event_type Event Type Event events

Группировки event_time, event_revenue, event_currency доступны только для лог-выгрузок и в агрегированном отчёте не используются.

3. Метрики (metrics[])

type различает прямые агрегаты (direct) и вычисляемые из других метрик (calculated) — у последних в dependencies перечислены метрики, которые автоматически добавляются в запрос. format — подсказка для форматирования: ceil (целое), finance (деньги, USD), percent (доля 0..1), number.

3.1 Трафик и финансы

Ключ Заголовок Группа Тип Формат Описание
clicks Clicks Traffic direct ceil Уникальные клики (по паре user_ip + user_ua) с event_type = SOURCE_CLICK
click_all Clicks All Traffic direct ceil Все клики без дедупликации
filter Filtered Traffic direct ceil События SOURCE_FILTER — отфильтрованный трафик
cpc CPC Traffic calculated finance cost / clicks
rpm RPM Traffic calculated finance cost / clicks * 1000
cost Costs Finance direct finance Сумма event_cost по SOURCE_CLICK — закупка трафика
revenue Revenue Finance direct finance Сумма event_revenue с конвертацией в USD
profit Profit Finance calculated finance revenue - cost
roi ROI Finance calculated percent (revenue - cost) / cost
epl EPL Finance calculated finance revenue / cpa_accept — Earning per Lead
epc EPC Finance calculated finance revenue / clicks — Earning per Click (FTD + ReDep)
epc_cpa EPC (CPA only) Finance calculated finance cpa_accept_revenue / clicks — только FTD
cpl CPL Finance calculated finance cost / cpa_accept
epl_total EPL Total Finance calculated finance revenue / total_deposits
cpl_total CPL Total Finance calculated finance cost / total_deposits

3.2 Лендинг

Ключ Заголовок Группа Тип Формат Описание
land_views Impression Landing direct ceil События LAND_VIEW
land_clicks Clicks Landing direct ceil События LAND_CLICK
land_view_to_click_rate CTR Landing calculated percent land_clicks / land_views

3.3 PWA

Ключ Заголовок Группа Тип Формат Описание
pwa_views Impression PWA direct ceil PWA_VIEW
pwa_installs Install PWA direct ceil PWA_INSTALL
pwa_opens Open PWA direct ceil PWA_OPEN
ios_installs iOS Install PWA direct ceil IOS_INSTALL
click_to_instal_rate Click 2 Install PWA calculated percent pwa_installs / clicks
click_to_ios_install_rate Click 2 iOS Install PWA calculated percent ios_installs / clicks
pwa_view_to_instal_rate Imp 2 Install PWA calculated percent pwa_installs / pwa_views

3.4 Postlanding

Ключ Заголовок Группа Тип Формат Описание
postlanding_views Impression Postlanding direct ceil POSTLANDING_VIEW
postlanding_clicks Clicks Postlanding direct ceil POSTLANDING_CLICK
postlanding_ctr CTR Postlanding calculated percent postlanding_clicks / postlanding_views

3.5 Notify

Ключ Заголовок Группа Тип Формат Описание
notify_requests Notify requests Notify direct ceil NOTIFICATION_REQUEST
notify_subscribes Notify subscribes Notify direct ceil NOTIFICATION_SUBSCRIBE
notify_declines Notify declines Notify direct ceil NOTIFICATION_DECLINE
notify_click Clicks Notify direct ceil NOTIFICATION_CLICK

3.6 Конверсии

Ключ Заголовок Группа Тип Формат Описание
cpa_hold Registration Conversion direct ceil CPA_HOLD — регистрации
cpa_accept FTDs Conversion direct ceil CPA_ACCEPT — первые депозиты
cpa_decline DECLINE Conversion direct ceil CPA_DECLINE
cpa_trash TRASH Conversion direct ceil CPA_TRASH
cpa_redep Re-Deposits Conversion direct ceil CPA_REDEP
cpa_accept_revenue FTD Revenue Conversion direct finance Доход с FTD
cpa_redep_revenue ReDep Revenue Conversion direct finance Доход с повторных депозитов
total_deposits Total Deposits Conversion calculated ceil cpa_accept + cpa_redep
total_deposit_revenue Total Dep Revenue Conversion calculated finance cpa_accept_revenue + cpa_redep_revenue
dep_to_redep Dep 2 ReDep Conversion calculated percent cpa_redep / cpa_accept
cpa_accept_unique_clicks Unique FTD Users Conversion direct ceil Уникальные event_click_id с ≥1 FTD. Только для конструктора отчётов
cpa_redep_unique_clicks Unique ReDep Users Conversion direct ceil Уникальные event_click_id с ≥1 ReDep. Только для конструктора отчётов
click_to_reg Click 2 Reg Conversion calculated percent cpa_hold / clicks
click_to_dep Click 2 Dep Conversion calculated percent cpa_accept / clicks
click_to_dep_total Click 2 Dep Total Conversion calculated percent total_deposits / clicks
pwa_install_to_hold_rate Install 2 Reg Conversion calculated percent cpa_hold / pwa_installs
pwa_install_to_accept_rate Install to FTDs Conversion calculated percent cpa_accept / pwa_installs
cpa_hold_to_accept_rate Reg 2 Dep Conversion calculated percent cpa_accept / cpa_hold

3.7 Telegram

Ключ Заголовок Группа Тип Формат Описание
tg_starts TG Starts Telegram direct ceil TG_START
tg_joins TG Joins Telegram direct ceil TG_JOIN
click_to_tg_start_rate Click 2 Start Telegram calculated percent tg_starts / clicks
click_to_tg_join_rate Click 2 Join Telegram calculated percent tg_joins / clicks

3.8 Push (таблица events_push)

Ключ Заголовок Группа Тип Формат Описание
push_views Push Views Push direct ceil Показы push
push_clicks Push Clicks Push direct ceil Клики по push
push_ctr Push CTR Push calculated percent push_clicks / push_views

3.9 Push Attribution (таблица events_push_attributed)

Требуют параметра attributionWindow в запросе.

Ключ Заголовок Группа Тип Формат Описание
push_postclick_holds Post-Click Registrations Push Attribution direct ceil Регистрации в окне атрибуции после клика по пушу
push_postclick_accepts Post-Click FTDs Push Attribution direct ceil FTD после клика по пушу
push_postclick_redeps Post-Click ReDeps Push Attribution direct ceil ReDep после клика по пушу
push_click_to_hold_rate Click to Reg Push Attribution calculated percent push_postclick_holds / push_clicks
push_click_to_accept_rate Click to FTD Push Attribution calculated percent push_postclick_accepts / push_clicks
push_hold_to_accept_rate Reg to Dep Push Attribution calculated percent push_postclick_accepts / push_postclick_holds

3.10 LTV / Cohort (таблица events_ltv)

Используются вместе с группировками cohort_*, reg_cohort_*, lifetime_days* (раздел 2.2). LTV считается от даты FTD, Reg-LTV — от даты регистрации.

Ключ Заголовок Группа Тип Формат Описание
avg_redep_revenue Avg ReDep Revenue LTV calculated finance cpa_redep_revenue / cpa_redep
redep_per_ftd ReDeps per FTD LTV calculated number cpa_redep / cpa_accept
redep_unique_clicks ReDep Users LTV direct ceil Уникальные event_click_id с ≥1 ReDep
ftd_to_redep_rate FTD to ReDep Rate LTV calculated percent redep_unique_clicks / cpa_accept
ltv_d0 LTV Day 0 LTV direct finance Доход за день FTD
ltv_d1_7 LTV Day 1-7 LTV direct finance Доход в 1–7 день после FTD
ltv_d8_30 LTV Day 8-30 LTV direct finance Доход в 8–30 день после FTD
ltv_d31_90 LTV Day 31-90 LTV direct finance Доход в 31–90 день после FTD
ltv_total LTV Total LTV calculated finance Сумма LTV-окон от FTD
ltv_per_ftd LTV per FTD LTV calculated finance ltv_total / cpa_accept
ltv_reg_d0 LTV Reg Day 0 LTV direct finance Доход за день регистрации
ltv_reg_d1_7 LTV Reg Day 1-7 LTV direct finance Доход в 1–7 день после регистрации
ltv_reg_d8_30 LTV Reg Day 8-30 LTV direct finance Доход в 8–30 день после регистрации
ltv_reg_d31_90 LTV Reg Day 31-90 LTV direct finance Доход в 31–90 день после регистрации
ltv_reg_total LTV Reg Total LTV calculated finance Сумма LTV-окон от регистрации
ltv_per_reg LTV per Reg LTV calculated finance ltv_reg_total / registrations
registrations Registrations Cohort direct ceil CPA_HOLD в когорте
ftds FTDs Cohort direct ceil CPA_ACCEPT в когорте
reg_to_ftd_rate Reg to FTD Cohort calculated percent cpa_accept / cpa_hold

Связанные статьи