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

Дата:

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

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

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

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

Шаг 3. Далее Вам необходимо заполнить token V1.0, token V2.0 и нажать кнопку "Проверить ключи".

Ключи

Шаг 4. Для получения токенов Вам необходимо зайти в личный кабинет AppsFlyer. Выберите в меню API tokens (1). Скопируйте ключи token V1.0 (2) и token V2.0 (3).

Кабинет

Замечание по статистике из Master API

Для источников Вконтакте и Mytarget в поле adset_id приходит значение равное полю ad_id.

По нашему мнению, оно должно быть пустое, так как у этих источников нет групп объявлений.

Но из Master API мы получаем это поле заполненным.

Будьте внимательны при склеивании статистики с объявлениями.

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

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

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

Название таблицы:
appsflyer_{}_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_fraud_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_fraud_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_fraud_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_fraud_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_fraud_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_fraud_events
Название колонки Описание
date Event date
attributed_touch_type Attributed Touch Type
attributed_touch_time Attributed Touch Time
install_time Install time
event_time Event time
event_name Event Name
event_value Event value
event_revenue Event revenue
event_revenue_currency Event revenue currency
event_revenue_usd Event revenue USD
event_source Event source
event_type Event type
media_source Media source
channel Channel
campaign Campaign
campaign_id Campaign ID
adset Adset
adset_id Adset ID
ad_id Ad ID
ad_type Ad type
site_id Site ID
region Region
country_code Country code
state State
city City
postal_code Postal code
dma DMA
ip IP
wifi Wi-Fi
operator Operator
language Language
appsflyer_id AppsFlyer ID
af_order_id Event value 'af_order_id', if is available
advertising_id Advertising ID (GAID)
platform Platform
device_type Device type
os_version OS version
app_version App version
sdk_version SDK version
attribution_lookback Period of time after installation in which reinstalls are not counted as new
is_primary_attribution Is primary attribution
user_agent Technical information for user devices, e.g, browser type, OS or software version
is_retargeting Is retargeting
partner Partner
fraud Is fraud? (GOOD.BI checked)
client_check Is fraud? (user checked)
Название таблицы:
appsflyer_{}_daily_report
Название колонки Описание
date Date
media_source Media source
campaign Campaign
impressions Impressions
clicks Clicks
ctr Click-through rate
installs Installs
conversion_rate Conversion rate
sessions Sessions
loyal_users Loyal users
loyal_users_to_installs Conversion of loyal users to installs
total_cost Total cost
average_ecpi Average eCPI
Название таблицы:
appsflyer_{}_partners_report
Название колонки Описание
date Date
media_source Media source
campaign Campaign
impressions Impressions
clicks Clicks
ctr Click-through rate
installs Installs
conversion_rate Conversion rate
sessions Sessions
loyal_users Loyal users
loyal_users_to_installs Conversion of loyal users to installs
total_revenue Total revenue
total_cost Total cost
average_ecpi Average eCPI
is_retargeting Is retargeting
purchase_unique_users Unique users
purchase_event_counter Purchases
purchase_sales Purchase amount
purchase_currency Purchase currency
Название таблицы:
appsflyer_{}_partners_event_report
Название колонки Описание
date Date
media_source Media source
campaign Campaign
is_retargeting Is retargeting
event_name Event name
purchase_currency Purchase currency
event_revenue Event revenue
unique_users Unique users
event_count Events count
Название таблицы:
appsflyer_{}_master_report
Название колонки Описание
date Date
media_source Media source
campaign_id Campaign ID
campaign Campaign name
adset_id Adset ID
ad_id Ad ID
channel Channel
impressions Impressions
clicks Clicks
installs Installs
purchase_unique_users Unique users
purchase_event_counter Purchases
Название таблицы:
appsflyer_{}_user_fraud_marks
Название колонки Описание
event_time Event time
event_name Event Name
appsflyer_id AppsFlyer ID
af_order_id af_order_id from event value
client_check Is fraud? (user checked)