Таблицы
Данные разделены на таблицы по дням в соответствии с временной зоной аккаунта AppsFlyer.
Данные за каждый день записываются в отдельную таблицу с названием в формате «ios_events_YYYYMMDD» (например: ios_events_20150609).
Данные о событиях становятся доступны для обработки в течение 2-5 минут после отправки.
Строки
Каждое событие записывается в отдельную строку.
Столбцы
Таблицы содержат следующие столбцы:
| Поле Google BigQuery | Тип данных Google BigQuery | Описание |
|---|---|---|
event_type |
STRING | install/in-app-event |
attribution_type |
STRING | Organic or Regular(non-organic) |
click_time |
STRING | Attributed touch time |
attributed_touch_type |
STRING | The type of the touch we attributed to (could be click / impression / TV / pre-installed) |
attributed_touch_time |
STRING | The time of the touch we attributed to. Format "mm/dd/yyyy hh:mm:ss PM/AM". Example: "11/19/2016 8:32:12 PM" |
download_time |
STRING | Timestamp of the download click on the app store, as appears on the device (UTC timezone) |
install_time |
STRING | Time of the first launch after the installation took place. Format "mm/dd/yyyy hh:mm:ss PM/AM". Example: "11/19/2016 8:32:12 PM" |
media_source |
STRING | Regular networks (excluding FB etc.) will appear on the link |
agency |
STRING | Name of the attributed agency |
event_revenue |
STRING | The revenue created as a result of the event. Supporting up to 4 digits after the decimal point |
event_revenue_currency |
STRING | The amount of the revenue in local currency. Supporting up to 4 digits after the decimal point |
event_revenue_usd |
STRING | The amount of the revenue in US dollars. Supporting up to 4 digits after the decimal point |
event_source |
STRING | The source of the event - either SDK or S2S |
is_receipt_validated |
STRING | true/false/null when implemented in the SDK, empty otherwise |
af_prt |
STRING | Agency or PMD |
af_channel |
STRING | Channel of the media source, such as YouTube for Google, Instagram for Facebook etc |
af_keywords |
STRING | Received from Google Integration |
campaign |
STRING | Note: campaign name for special integrations (e.g. Facebook) returns via API and not via link |
af_c_id |
STRING | Campaign ID |
af_adset |
STRING | Ad set. Facebook info is also included |
af_adset_id |
STRING | Ad set ID. Facebook info is also included |
af_ad |
STRING | Ad. Facebook info is also included |
af_ad_id |
STRING | Ad ID. Facebook info is also included |
fb_campaign_name |
STRING | Facebook campaign name |
fb_campaign_id |
STRING | Facebook campaign ID number |
fb_adset_name |
STRING | Facebook ad set name |
fb_adset_id |
STRING | Facebook ad set ID number |
fb_adgroup_name |
STRING | Facebook ad group name |
fb_adgroup_id |
STRING | Facebook ad group ID |
af_ad_type |
STRING | Type of ad (banner, footer etc.) |
af_siteid |
STRING | Publisher ID |
af_sub1 |
STRING | Custom parameter to be defined by the customer |
af_sub2 |
STRING | Custom parameter to be defined by the customer |
af_sub3 |
STRING | Custom parameter to be defined by the customer |
af_sub4 |
STRING | Custom parameter to be defined by the customer |
af_sub5 |
STRING | Custom parameter to be defined by the customer |
http_referrer |
STRING | Identifies the address of the webpage that linked to the AppsFlyer click URL. By checking the referrer, you can see where the request originated |
original_url |
STRING | Click/Impression URL. For example http://your.url.com |
install_app_store |
STRING | Identifies the Android store where the app is downloaded from (details) |
click_url |
STRING | Click/Impression URL. For example http://your.url.com |
af_cost_model |
STRING | CPC / CPA / CPM / Other. Currently all cost is calculated according to CPA regardless of this value |
af_cost_value |
STRING | Cost in original currency. Supporting up to 4 digits after the decimal point. eg. 320.5095 |
af_cost_currency |
STRING | Currency of the cost (list) |
cost_per_install |
STRING | Cost in the original currency |
contributor1_af_prt |
STRING | Agency or PMD |
contributor1_media_source |
STRING | Media Source of the contributor |
contributor1_campaign |
STRING | Campaign of the contributor |
contributor1_touch_type |
STRING | The type of the touch (could be click / impression / TV) |
contributor1_touch_time |
STRING | The time of the touch |
contributor2_af_prt |
STRING | Agency or PMD |
contributor2_media_source |
STRING | Media Source of the contributor |
contributor2_campaign |
STRING | Campaign of the contributor |
contributor2_touch_type |
STRING | The type of the touch (could be click / impression / TV) |
contributor2_touch_time |
STRING | The time of the touch |
contributor3_af_prt |
STRING | Agency or PMD |
contributor3_media_source |
STRING | Media Source of the contributor |
contributor3_campaign |
STRING | Campaign of the contributor |
contributor3_touch_type |
STRING | The type of the touch (could be click / impression / TV) |
contributor3_touch_time |
STRING | The time of the touch |
region |
STRING | Based on IP from the SDK |
is_retargeting |
BOOLEAN | TRUE / FALSE |
re_targeting_conversion_type |
STRING | Re-engagement / Re-attribution |
af_attribution_lookback |
STRING | Time period for which AppsFlyer attributes events |
af_reengagement_window |
STRING | The re-engagement attribution window is the number of days in which an event can be attributed to a retargeting campaign |
is_primary_attribution |
BOOLEAN | During a re-engagement window, can be attributed either the original media source (prior to the re-engagement) or to the re-engagement media source. While the event is within the re-engagement window, the original media source will not be the primary attribution. Outside of the re-engagement window, it will be the primary attribution |
user_agent |
STRING | The user agent for the URL |
country_code |
STRING | Country Code. For example GB, US |
state |
STRING | State based on IP from the SDK |
city |
STRING | City based on IP from the SDK |
postal_code |
STRING | Postal code based on IP of the SDK |
dma |
STRING | Designated Market Area - regions are the geographic areas in the US where local television viewing is measured by the Nielsen company |
ip |
STRING | IP address |
wifi |
BOOLEAN | TRUE / FALSE |
mac |
STRING | Device mac address |
language |
STRING | Device language |
appsflyer_id |
STRING | Unique Installation identifier |
appsflyer_device_id |
STRING | Unique app installation identifier per device |
idfa |
STRING | For iOS - Device IDFA |
customer_user_id |
STRING | Customer user ID, as set by the developer. This is used as the user identifier in the advertiser's system |
idfv |
STRING | App level identifier for a particular vendor |
platform |
STRING | iOS / Android / Windows Mobile |
device_type |
STRING | Tablet / Phone |
device_name |
STRING | Name of the device as entered by the user - always appears as Null |
os_version |
STRING | Operation System version |
app_version |
STRING | Version of the app |
sdk_version |
STRING | Version of the SDK |
app_id |
STRING | ID of the app. For iOS: id123456789. For Android: com.appsflyer.referrersender |
app_name |
STRING | Name of the app |
bundle_id |
STRING | Identification to match either a single app or a group of apps (for iOS) |
event_time |
STRING | The time of the event happened |
event_name |
STRING | The name of the event that took place |
event_value |
STRING | The value of the event |
currency |
STRING | USD |
selected_currency |
STRING | Currency specified in the event or for the app in the dashboard |
revenue_in_selected_currency |
STRING | Revenue in the currency selected for the app in the dashboard |
cost_in_selected_currency |
STRING | Cost in the currency selected for the app in the dashboard |
download_time_selected_timezone |
STRING | Time of download in the time zone selected for the app |
click_time_selected_timezone |
STRING | Time of the ad click in the time zone selected for the app |
install_time_selected_timezone |
STRING | Time of the first app launch in the time zone selected for the app |
event_time_selected_timezone |
STRING | Time of the event occurrence in the time zone selected for the app |
0 Комментарии