AppMetrica. Подключение коннектора
Дата:
Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Добавить источник данных”.
Шаг 2. В появившемся окне найдите “AppMetrica” и нажмите кнопку “Добавить”.
Шаг 3. Для подключения Вам необходимо войти в аккаунт AppMetrica.
Шаг 4. Выберите нужный аккаунт Яндекса и нажмите кнопку "Разрешить".
Шаг 5. Выберите нужный проект в выпадающем списке, затем кликните на "Подключить выбранные".
Коннектор создан!
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
appmetrica_{}_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 |
event_datetime |
Time of the event |
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 |
fraud |
Is fraud? (GOOD.BI checked) |
fraud_str |
Is fraud (verbose)?(GOOD.BI checked) |
Название таблицы:
appmetrica_{}_events
| Название колонки | Описание |
|---|---|
date |
Date and time the server received the event |
event_name |
Name of the event |
event_receive_datetime |
Date and time when the install event was received on the server side |
event_timestamp |
Time of the event |
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 |
event_json |
Event attributes serialized into JSON. |
os_name |
Operating system on the user's device: ios | android | windows. |
application_id |
Unique numeric identifier for the application in AppMetrica. |
device_type |
The device type detected by the AppMetrica service. Possible values: phone | tablet | unknown. |
fraud |
Is fraud? (GOOD.BI checked) |
fraud_str |
Is fraud (verbose)?(GOOD.BI checked) |
Название таблицы:
appmetrica_{}_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 |
install_datetime |
Time of the install |
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 |
installation_id |
Installation ID. |
fraud |
Is fraud? (GOOD.BI checked) |
fraud_str |
Is fraud (verbose)?(GOOD.BI checked) |
Название таблицы:
appmetrica_{}_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 |
fraud |
Is fraud? (GOOD.BI checked) |
fraud_str |
Is fraud (verbose)?(GOOD.BI checked) |
Название таблицы:
appmetrica_{}_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 |
event_datetime |
Date and time of the event |
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 |
fraud |
Is fraud? (GOOD.BI checked) |
fraud_str |
Is fraud (verbose)?(GOOD.BI checked) |
Название таблицы:
appmetrica_{}_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_{}_sessions_report
| Название колонки | Описание |
|---|---|
date |
Date |
users |
Users |
sessions |
Sessions |
Название таблицы:
appmetrica_{}_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 |
fraud |
Is fraud? (GOOD.BI checked) |
fraud_str |
Is fraud (verbose)?(GOOD.BI checked) |
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 |