Таблицы

Данные разделены на таблицы по дням в соответствии с временной зоной аккаунта AppsFlyer.

Данные за каждый день записываются в отдельную таблицу с названием в формате «android_events_YYYYMMDD» (например:android_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
operator STRING Operator name
carrier STRING Carrier name
language STRING Device language
appsflyer_id STRING Unique Installation identifier
appsflyer_device_id STRING Unique app installation identifier per device
advertising_id STRING The advertising ID is a user-resettable, unique, anonymous ID for advertising provided by Google Play services
idfa STRING For iOS - Device IDFA
android_id STRING Android device ID
customer_user_id STRING Customer user ID, as set by the developer. This is used as the user identifier in the advertiser's system
IMEI STRING Device IMEI for Android and iOS
idfv STRING App level identifier for a particular vendor
platform STRING iOS / Android / Windows Mobile
device_type STRING Tablet / Phone
device_brand STRING Device brand
device_model STRING Device model
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
validated STRING  
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 из 0
Еще есть вопросы? Отправить запрос

0 Комментарии

Войдите в службу, чтобы оставить комментарий.