Таблицы

Данные разделены на таблицы по дням в соответствии с временной зоной аккаунта 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 из 0
Еще есть вопросы? Отправить запрос

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

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