# AppsFlyer schema ERD

Table and field reference for the Fivetran AppsFlyer connector.

## Table & Field Reference

### ssot_retargeting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| af_ad | String |  |
| af_ad_id | String |  |
| af_adset | String |  |
| af_adset_id | String |  |
| af_c_id | String |  |
| app_id | String |  |
| attributed_touch_type | String |  |
| attribution_method | String |  |
| campaign | String |  |
| conversion_type | String |  |
| days_post_attribution | Int |  |
| event_name | String |  |
| geo | String |  |
| install_date | LocalDate |  |
| is_primary_attribution | Boolean |  |
| media_source | String |  |
| revenue_selected_currency | Double |  |
| revenue_usd | Double |  |
| selected_currency | String |  |
| skan_duplicates | Long |  |
| uninstalls_count | Long |  |
| unique_users | Int |  |

### ssot_user_acquisition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| af_ad | String |  |
| af_ad_id | String |  |
| af_adset | String |  |
| af_adset_id | String |  |
| af_c_id | String |  |
| app_id | String |  |
| attributed_touch_type | String |  |
| attribution_method | String |  |
| campaign | String |  |
| conversion_type | String |  |
| days_post_attribution | Int |  |
| event_name | String |  |
| geo | String |  |
| install_date | LocalDate |  |
| is_primary_attribution | Boolean |  |
| media_source | String |  |
| revenue_selected_currency | Double |  |
| revenue_usd | Double |  |
| selected_currency | String |  |
| skan_duplicates | Long |  |
| uninstalls_count | Long |  |
| unique_users | Int |  |

### 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 |  |

### 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 |  |

### partners_daily

| 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 |  |

### 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 |  |

### 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 |  |

### ssot_unified

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| af_ad | String |  |
| af_ad_id | String |  |
| af_adset | String |  |
| af_adset_id | String |  |
| af_c_id | String |  |
| app_id | String |  |
| attributed_touch_type | String |  |
| attribution_method | String |  |
| campaign | String |  |
| conversion_type | String |  |
| days_post_attribution | Int |  |
| event_name | String |  |
| geo | String |  |
| install_date | LocalDate |  |
| is_primary_attribution | Boolean |  |
| media_source | String |  |
| revenue_selected_currency | Double |  |
| revenue_usd | Double |  |
| selected_currency | String |  |
| skan_duplicates | Long |  |
| uninstalls_count | Long |  |
| unique_users | Int |  |

### 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 |  |