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

Дата:

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

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

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

Выбор коннектора AppMetrica

Шаг 3. Для подключения Вам необходимо войти в аккаунт AppMetrica.

Авторизация в AppMetrica

Шаг 4. Выберите нужный аккаунт Яндекса и нажмите кнопку "Разрешить".

Предоставление прав доступа

Шаг 5. Выберите нужный проект в выпадающем списке, затем кликните на "Подключить выбранные".

Выбор проекта

Коннектор создан!

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

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

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

Название таблицы:
appmetrica_(project_id)_revenue_events
Название колонки Описание
date Date and time the server received the event
revenue_order_id Order ID
revenue_quantity Number of purchases (item quantity)
revenue_price Cost. It can be negative (like for refunds)
revenue_currency Currency code of the purchase
revenue_product_id Product ID
revenue_order_id_source Source of the order ID. Possible values: (autogenerated | user_defined)
is_revenue_verified Indicator of whether the purchase verification is in the store. Possible values: (true | false | undefined)
event_name Name of the event
event_receive_datetime Date and time when the install event was received on the server side
session_id Session ID. Installation ID, Session ID and device platform ID set of values(google_aid / ios_ifa) allows to identify a user session
installation_id Installation ID
profile_id User profile ID
appmetrica_device_id Unique device ID detected by the AppMetrica service
Название таблицы:
appmetrica_(project_id)_installations
Название колонки Описание
date Date and time of installation
click_id Click ID
install_receive_datetime Date and time when the install event was received on the server side
click_url_parameters Parameters as they are shown in the URL
profile_id User profile ID
publisher_id ID of the AppMetrica partner
publisher_name Name of the AppMetrica partner
tracking_id Tracker ID in AppMetrica
tracker_name Name of the tracker added in the AppMetrica interface
is_reattribution Indicator of whether the installation is reattributed to the new source
is_reinstallation Indicator of whether the app has been reinstalled
match_type Attribution method. Possible values: (fingerprint | referrer | identifier | '')
appmetrica_device_id Unique device ID detected by the AppMetrica service
Название таблицы:
appmetrica_(project_id)_postbacks
Название колонки Описание
date Date and time of sending
click_id Click ID
click_url_parameters Parameters as they are shown in the URL
publisher_id ID of the AppMetrica partner
publisher_name Name of the AppMetrica partner
tracking_id Tracker ID in AppMetrica
tracker_name Name of the tracker
attempt_datetime Date and time of sending
event_name Name of the event
cost_model Postback type. Possible values: cpi (installation) | cpa (event)| cpr (re-engagement)
notifying_status Status of the postback sending (failed | sent)
postback_url_parameters Postback URL parameters as shown in the URL
match_type Attribution method. Possible values: (fingerprint | referrer | identifier | '')
appmetrica_device_id Unique device ID detected by the AppMetrica service
Название таблицы:
appmetrica_(project_id)_deeplinks
Название колонки Описание
date Date and time pf event
deeplink_url_host Domain name deeplink
deeplink_url_parameters Parameters that are passed in the deeplink
event_receive_datetime Date and time when the install event was received on the server side
is_reengagement Indicates that the tracker was created for a remarketing campaign
profile_id User profile ID
publisher_id ID of the AppMetrica partner
publisher_name Name of the AppMetrica partner
tracking_id Tracker ID in AppMetrica
tracker_name Name of the tracker
session_id Session ID
appmetrica_device_id Unique device ID detected by the AppMetrica service
Название таблицы:
appmetrica_(project_id)_installs_report
Название колонки Описание
date Date
installDevices Number of devices that completed installations
campaignId Campaign ID
campaignName Campaign name
publisherId ID of the AppMetrica partner
publisherName Name of the AppMetrica partner
Название таблицы:
appmetrica_(project_id)_sessions_report
Название колонки Описание
date Date
users Users
sessions Sessions
Название таблицы:
appmetrica_(project_id)_sessions
Название колонки Описание
date Date and time of the session
session_start_datetime Date and time of the session start
appmetrica_device_id Unique device ID detected by the AppMetrica service
city Name of the city where click took place
country_iso_code ISO country code
device_locale Device language
device_manufacturer Device manufacturer as detected by the AppMetrica service
device_type Device type detected by the AppMetrica service