AppsFlyer

Explore the interactive ERD

Table & Field Reference

cohort_event

Column	Type	Keys
`_fivetran_id`	String	PK
`ad`	String
`ad_id`	String
`adset`	String
`adset_id`	String
`agency`	String
`app_id`	String
`attributed_touch_type`	String
`campaign`	String
`campaign_id`	String
`channel`	String
`conversion_date`	LocalDate
`conversion_type`	String
`days_post_attribution`	String
`event_count`	Float
`event_date`	LocalDate
`event_name`	String
`geo`	String
`install_app_store`	String
`is_primary_attribution`	Boolean
`keyword_id`	String
`keywords`	String
`media_source`	String
`report_type`	String
`revenue_selected_currency`	Float
`revenue_usd`	Float
`selected_currency`	String
`site_id`	String
`unique_users`	Float

skan_event

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_network_ad_id`	String
`ad_network_ad_name`	String
`ad_network_adset_id`	String
`ad_network_adset_name`	String
`ad_network_campaign_id`	String
`ad_network_campaign_name`	String
`ad_network_channel`	String
`ad_network_creative`	String
`ad_network_name`	String
`ad_network_source_app_id`	String
`ad_network_timestamp`	Instant
`af_attribution_flag`	Boolean
`af_prt`	String
`app_id`	String
`country_code`	String
`did_win`	Boolean
`event_name`	String
`event_revenue`	Double
`event_uuid`	String
`event_value`	String
`fidelity_type`	Int
`install_date`	String
`install_type`	String
`interval`	Int
`ip`	String
`max_event_counter`	Int
`max_revenue`	Double
`max_time_post_install`	Int
`measurement_window`	Int
`media_source`	String
`min_event_counter`	Int
`min_revenue`	Double
`min_time_post_install`	Int
`region`	String
`skad_ad_network_id`	String
`skad_ambiguous_event`	Boolean
`skad_app_id`	String
`skad_attribution_signature`	String
`skad_campaign_id`	Int
`skad_coarse_conversion_value`	String
`skad_conversion_value`	Int
`skad_did_win`	Boolean
`skad_fidelity_type`	Int
`skad_mode`	String
`skad_postback_sequence_index`	Int
`skad_redownload`	Boolean
`skad_revenue`	Double
`skad_source_app_id`	String
`skad_source_domain`	String
`skad_source_identifier`	Int
`skad_transaction_id`	String
`skad_version`	String
`source_app_id`	String
`timestamp`	Instant
`user_agent`	String

creative_report

Column	Type	Keys
`_fivetran_id`	String	PK
`ad`	String
`ad_id`	String
`adset`	String
`adset_id`	String
`app_id`	String
`app_name`	String
`asset_link`	String
`campaign`	String
`campaign_id`	String
`clicks`	Int
`cost`	Double
`cpm`	Double
`creative`	String
`creative_age`	Int
`creative_first_seen`	LocalDate
`creative_type`	String
`ctr`	Double
`cvr`	Double
`date`	LocalDate
`duration`	Double
`ecpi`	Double
`end_card_type`	String
`geo`	String
`impressions`	Int
`installs`	Int
`ipm`	Double
`media_source`	String
`orientation`	String
`partner_clicks`	Int
`partner_cost`	Double
`partner_cpm`	Double
`partner_ctr`	Double
`partner_cvr`	Double
`partner_ecpi`	Double
`partner_impressions`	Int
`partner_installs`	Int
`partner_ipm`	Double
`platform`	String
`reattributions`	Double
`reengagements`	Double
`report_date`	LocalDate
`resolution`	String
`retention_d_1`	Double
`retention_d_14`	Double
`retention_d_30`	Double
`retention_d_60`	Double
`retention_d_7`	Double
`retention_d_90`	Double
`revenue_d_1`	Double
`revenue_d_14`	Double
`revenue_d_30`	Double
`revenue_d_60`	Double
`revenue_d_7`	Double
`revenue_d_90`	Double
`roas_d_1`	Double
`roas_d_14`	Double
`roas_d_30`	Double
`roas_d_60`	Double
`roas_d_7`	Double
`roas_d_90`	Double

event

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_unit`	String
`advertising_id`	String
`af_ad`	String
`af_ad_id`	String
`af_ad_type`	String
`af_adset`	String
`af_adset_id`	String
`af_attribution_lookback`	String
`af_c_id`	String
`af_channel`	String
`af_cost_currency`	String
`af_cost_model`	String
`af_cost_value`	String
`af_keywords`	String
`af_prt`	String
`af_reengagement_window`	String
`af_siteid`	String
`af_sub_1`	String
`af_sub_2`	String
`af_sub_3`	String
`af_sub_4`	String
`af_sub_5`	String
`af_sub_siteid`	String
`af_web_id`	String
`amazon_aid`	String
`android_id`	String
`app_id`	String
`app_name`	String
`app_type`	String
`app_version`	String
`appsflyer_id`	String
`att`	String
`attributed_touch_hour`	String
`attributed_touch_time`	Instant
`attributed_touch_time_selected_timezone`	Instant
`attributed_touch_type`	String
`blocked_reason`	String
`blocked_reason_rule`	String
`blocked_reason_value`	String
`blocked_sub_reason`	String
`bundle_id`	String
`campaign`	String
`campaign_type`	String
`carrier`	String
`city`	String
`contributor_1_af_prt`	String
`contributor_1_campaign`	String
`contributor_1_match_type`	String
`contributor_1_media_source`	String
`contributor_1_touch_time`	Instant
`contributor_1_touch_type`	String
`contributor_2_af_prt`	String
`contributor_2_campaign`	String
`contributor_2_match_type`	String
`contributor_2_media_source`	String
`contributor_2_touch_time`	Instant
`contributor_2_touch_type`	String
`contributor_3_af_prt`	String
`contributor_3_campaign`	String
`contributor_3_match_type`	String
`contributor_3_media_source`	String
`contributor_3_touch_time`	Instant
`contributor_3_touch_type`	String
`conversion_type`	String
`cost_in_selected_currency`	String
`country_code`	String
`custom_data`	String
`custom_dimension`	String
`customer_user_id`	String
`deeplink_url`	String
`detection_date`	String
`device_category`	String
`device_download_time`	Instant
`device_download_time_selected_timezone`	Instant
`device_model`	String
`device_type`	String
`dma`	String
`download_time`	Instant
`download_time_selected_timezone`	Instant
`event_hour`	String
`event_name`	String
`event_revenue`	String
`event_revenue_currency`	String
`event_revenue_preferred`	String
`event_revenue_usd`	String
`event_source`	String
`event_time`	Instant
`event_time_selected_timezone`	Instant
`event_value`	String
`fraud_reason`	String
`fraud_sub_reason`	String
`gp_broadcast_referrer`	String
`gp_click_time`	Instant
`gp_install_begin`	Instant
`gp_referrer`	String
`http_referrer`	String
`idfa`	String
`idfv`	String
`imei`	String
`impressions`	String
`install_app_store`	String
`install_hour`	String
`install_time`	Instant
`install_time_selected_timezone`	Instant
`ip`	String
`is_lat`	Boolean
`is_organic`	Boolean
`is_primary_attribution`	Boolean
`is_receipt_validated`	Boolean
`is_retargeting`	Boolean
`keyword_id`	String
`keyword_match_type`	String
`language`	String
`match_type`	String
`media_source`	String
`media_type`	String
`mediation_network`	String
`monetization_network`	String
`network_account_id`	String
`oaid`	String
`operator`	String
`original_url`	String
`os_version`	String
`pid`	String
`placement`	String
`platform`	String
`postal_code`	String
`postback_error_message`	String
`postback_http_response_code`	String
`postback_method`	String
`postback_retry`	Boolean
`postback_url`	String
`region`	String
`rejected_reason`	String
`rejected_reason_value`	String
`retargeting_conversion_type`	String
`revenue_in_selected_currency`	String
`sdk_version`	String
`segment`	String
`selected_currency`	String
`selected_timezone`	String
`state`	String
`store_product_page`	String
`store_reinstall`	Boolean
`user_agent`	String
`utm_campaign`	String
`utm_content`	String
`utm_medium`	String
`utm_source`	String
`utm_term`	String
`web_event_type`	String
`wifi`	Boolean

geo_daily

Column	Type	Keys
`_fivetran_id`	String	PK
`agency`	String
`app_id`	String
`arpu`	String
`average_ecpi`	String
`campaign`	String
`clicks`	String
`conversion_rate`	String
`conversion_type`	String
`conversions`	String
`country`	String
`ctr`	String
`date`	LocalDate
`impressions`	String
`installs`	String
`loyal_users`	String
`loyal_users_per_installs`	String
`media_source`	String
`roi`	String
`sessions`	String
`total_cost`	String
`total_revenue`	String

partners_report

Column	Type	Keys
`_fivetran_id`	String	PK
`ad`	String
`ad_id`	String
`ad_type`	String
`adset`	String
`adset_id`	String
`agency`	String
`app_id`	String
`arpu`	String
`average_ecpi`	String
`campaign`	String
`campaign_id`	String
`clicks`	String
`conversion_rate`	String
`conversion_type`	String
`conversions`	String
`ctr`	String
`date`	LocalDate
`impressions`	String
`installs`	String
`loyal_users`	String
`loyal_users_per_installs`	String
`media_source`	String
`roi`	String
`sessions`	String
`total_cost`	String
`total_revenue`	String