Adjust

Explore the interactive ERD

Table & Field Reference

erased_user_gdpr

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`currency`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`event`	String
`event_name`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reftag`	String
`region`	String
`reinstalled_at`	Long
`reporting_currency`	String
`reporting_revenue`	BigDecimal
`revenue`	Float
`revenue_float`	BigDecimal
`revenue_usd`	BigDecimal
`revenue_usd_cents`	Int
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`time_spent`	Long
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

sk_qualifier

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adgroup_name`	String
`campaign_name`	String
`country`	String
`created_at`	Long
`created_at_milli`	Long
`creative_name`	String
`device_type`	String
`engagement_time`	Long
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`ip_address`	String
`network_name`	String
`os_name`	String
`os_version`	String
`partner`	String
`reftag`	String
`sk_app_id`	Long
`sk_attribution_signature`	String
`sk_campaign_id`	Long
`sk_conversion_value`	Int
`sk_did_win`	Boolean
`sk_fidelity_type`	Int
`sk_invalid_signature`	Int
`sk_network_id`	String
`sk_payload`	String
`sk_redownload`	Int
`sk_source_app_id`	Long
`sk_transaction_id`	String
`sk_ts`	Instant
`sk_version`	Double
`tracker`	String
`user_agent`	String

update

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`attribution_updated_at`	Long
`city`	String
`click_attribution_window`	Int
`click_referer`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_attribution_window`	Int
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`inactive_user_definition`	Int
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`is_s_2_s_engagement_based`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`outdated_tracker`	String
`postal_code`	String
`proxy_ip_address`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reattribution_attribution_window`	Int
`reftag`	String
`region`	String
`reinstalled_at`	Long
`rejection_reason`	String
`sdk_version`	String
`search_term`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

ad_revenue

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`ad_impressions_count`	Long
`ad_mediation_platform`	String
`ad_revenue_network`	String
`ad_revenue_payload`	String
`ad_revenue_placement`	String
`ad_revenue_unit`	String
`adid`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`conversion_duration`	Long
`country`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`currency`	String
`deeplink`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`is_organic`	Int
`label`	String
`language`	String
`match_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`push_token`	String
`random_user_id`	String
`reftag`	String
`reporting_revenue`	BigDecimal
`revenue`	Float
`revenue_float`	BigDecimal
`revenue_usd`	BigDecimal
`revenue_usd_cents`	Int
`third_party_sharing_disabled`	Int
`timezone`	String
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String
`web_uuid`	String

sk_event

Column	Type	Keys
`_fivetran_id`	String	PK
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adgroup_name`	String
`campaign_name`	String
`count_max`	Long
`count_min`	Long
`country`	String
`created_at`	Long
`created_at_milli`	Long
`creative_name`	String
`device_type`	String
`engagement_time`	Long
`event`	String
`event_name`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`ip_address`	String
`network_name`	String
`os_name`	String
`os_version`	String
`partner`	String
`reftag`	String
`reporting_currency`	String
`reporting_revenue_max`	Double
`reporting_revenue_min`	Double
`sk_app_id`	Long
`sk_attribution_signature`	String
`sk_campaign_id`	Long
`sk_conversion_value`	Int
`sk_did_win`	Boolean
`sk_fidelity_type`	Int
`sk_invalid_signature`	Int
`sk_network_id`	String
`sk_payload`	String
`sk_redownload`	Int
`sk_source_app_id`	Long
`sk_transaction_id`	String
`sk_ts`	Instant
`sk_version`	Double
`tracker`	String
`user_agent`	String

ad_spend

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`city`	String
`click_referer`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`cost_amount`	BigDecimal
`cost_currency`	String
`cost_id_md_5`	String
`cost_type`	String
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`platform`	String
`postal_code`	String
`proxy_ip_address`	String
`push_token`	String
`random_user_id`	String
`referrer`	String
`reftag`	String
`region`	String
`reporting_cost`	BigDecimal
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

san_impression

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`att_status`	Int
`city`	String
`click_attribution_window`	Int
`connection_type`	String
`cost_amount`	BigDecimal
`cost_currency`	String
`cost_id_md_5`	String
`cost_type`	String
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fingerprint_attribution_window`	Int
`fire_adid`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_attribution_window`	Int
`inactive_user_definition`	Int
`ip_address`	String
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`postal_code`	String
`proxy_ip_address`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattribution_attribution_window`	Int
`referrer`	String
`reftag`	String
`region`	String
`reporting_cost`	BigDecimal
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

reattribution_reinstall

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`inactive_user_definition`	Int
`install_begin_time`	Long
`install_finish_time`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reattribution_attribution_window`	Int
`referral_time`	Long
`referrer`	String
`reftag`	String
`region`	String
`reinstalled_at`	Long
`rejection_reason`	String
`sdk_version`	String
`search_term`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`time_to_reinstall`	Long
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

in_app_event

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`currency`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`event`	String
`event_name`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`is_s_2_s`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`platform`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reftag`	String
`region`	String
`reinstalled_at`	Long
`reporting_currency`	String
`reporting_revenue`	BigDecimal
`revenue`	Float
`revenue_float`	BigDecimal
`revenue_usd`	BigDecimal
`revenue_usd_cents`	Int
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`time_spent`	Long
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

session

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_time_spent`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`platform`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`referrer`	String
`reftag`	String
`region`	String
`reinstalled_at`	Long
`rejection_reason`	String
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

click

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`android_id`	String
`android_id_md_5`	String
`app_id`	String
`city`	String
`click_attribution_window`	Int
`click_referer`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`cost_amount`	BigDecimal
`cost_currency`	String
`cost_id_md_5`	String
`cost_type`	String
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`fingerprint_attribution_window`	Int
`fire_adid`	String
`gclid`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`inactive_user_definition`	Int
`ip_address`	String
`is_reattributed`	Int
`is_s_2_s`	Int
`isp`	String
`label`	String
`language`	String
`mac_md_5`	String
`mac_sha_1`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`postal_code`	String
`proxy_ip_address`	String
`reattribution_attribution_window`	Int
`referrer`	String
`reftag`	String
`region`	String
`reporting_cost`	BigDecimal
`store`	String
`tracker`	String
`user_agent`	String
`web_uuid`	String
`win_adid`	String

san_click

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`att_status`	Int
`city`	String
`click_attribution_window`	Int
`connection_type`	String
`cost_amount`	BigDecimal
`cost_currency`	String
`cost_id_md_5`	String
`cost_type`	String
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fingerprint_attribution_window`	Int
`fire_adid`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_attribution_window`	Int
`inactive_user_definition`	Int
`ip_address`	String
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`postal_code`	String
`proxy_ip_address`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattribution_attribution_window`	Int
`referrer`	String
`reftag`	String
`region`	String
`reporting_cost`	BigDecimal
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

sk_install

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adgroup_name`	String
`campaign_name`	String
`country`	String
`created_at`	Long
`created_at_milli`	Long
`creative_name`	String
`device_type`	String
`engagement_time`	Long
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`ip_address`	String
`network_name`	String
`os_name`	String
`os_version`	String
`partner`	String
`reftag`	String
`sk_app_id`	Long
`sk_attribution_signature`	String
`sk_campaign_id`	Long
`sk_conversion_value`	Int
`sk_did_win`	Boolean
`sk_fidelity_type`	Int
`sk_invalid_signature`	Int
`sk_network_id`	String
`sk_payload`	String
`sk_redownload`	Int
`sk_source_app_id`	Long
`sk_transaction_id`	String
`sk_ts`	Instant
`sk_version`	Double
`tracker`	String
`user_agent`	String

install_update

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adgroup_name`	String
`adid`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_name_dashboard`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`attribution_updated_at`	Long
`campaign_name`	String
`city`	String
`click_attribution_window`	Int
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`first_tracker`	String
`first_tracker_name`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`impression_based`	Int
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`is_s_2_s_engagement_based`	Int
`isp`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`match_type`	String
`mcc`	String
`mnc`	String
`network_name`	String
`os_name`	String
`os_version`	String
`outdated_tracker`	String
`postal_code`	String
`random_user_id`	String
`referrer`	String
`reftag`	String
`region`	String
`sdk_version`	String
`session_count`	Long
`store`	String
`timezone`	String
`tracker`	String
`tracker_name`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`user_agent`	String

install

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_attribution_window`	Int
`click_referer`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`cost_amount`	BigDecimal
`cost_currency`	String
`cost_id_md_5`	String
`cost_type`	String
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fingerprint_attribution_window`	Int
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_attribution_window`	Int
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`install_begin_time`	Long
`install_finish_time`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`is_s_2_s_engagement_based`	Int
`isp`	String
`label`	String
`language`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`platform`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random_user_id`	String
`referral_time`	Long
`referrer`	String
`reftag`	String
`region`	String
`rejection_reason`	String
`reporting_cost`	BigDecimal
`sdk_version`	String
`search_term`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

reattribution

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`inactive_user_definition`	Int
`install_begin_time`	Long
`install_finish_time`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`is_s_2_s_engagement_based`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`platform`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reattribution_attribution_window`	Int
`referral_time`	Long
`referrer`	String
`reftag`	String
`region`	String
`reinstalled_at`	Long
`rejection_reason`	String
`sdk_version`	String
`search_term`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

reinstall

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`fire_adid`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`install_begin_time`	Long
`install_finish_time`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_time_spent`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`referral_time`	Long
`referrer`	String
`reftag`	String
`region`	String
`reinstalled_at`	Long
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`time_to_reinstall`	Long
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String
`win_adid`	String
`win_hwid`	String
`win_naid`	String
`win_udid`	String

subscription

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`android_id`	String
`android_id_md_5`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`click_time`	Long
`click_time_hour`	Long
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`currency`	String
`deeplink`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`first_tracker`	String
`first_tracker_name`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`language`	String
`lifetime_session_count`	Long
`match_type`	String
`os_name`	String
`os_version`	String
`publisher_parameters`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reftag`	String
`reporting_currency`	String
`reporting_revenue`	BigDecimal
`revenue`	Float
`revenue_float`	BigDecimal
`revenue_usd`	BigDecimal
`revenue_usd_cents`	Int
`sdk_version`	String
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String

uninstall

Column	Type	Keys
`nonce`	String	PK
`tracker_id`	String	FK
`adid`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`click_time`	Long
`click_time_hour`	Long
`conversion_duration`	Long
`country`	String
`created_at`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`gps_adid`	String
`gps_adid_md_5`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`is_organic`	Int
`is_reattributed`	Int
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`match_type`	String
`mcc`	String
`mnc`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`push_token`	String
`random`	Long
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reftag`	String
`reinstalled_at`	Long
`store`	String
`third_party_sharing_disabled`	Int
`time_to_uninstall`	Long
`tracker`	String
`tweet_id`	String
`twitter_line_item_id`	String
`uninstalled_at`	Long
`user_agent`	String
`web_uuid`	String

tracker

Column	Type	Keys
`_fivetran_id`	String	PK
`adgroup_name`	String
`app_name_dashboard`	String
`campaign_name`	String
`creative_name`	String
`network_name`	String
`tracker_name`	String

impression

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`android_id`	String
`android_id_md_5`	String
`app_id`	String
`city`	String
`connection_type`	String
`cost_amount`	BigDecimal
`cost_currency`	String
`cost_id_md_5`	String
`cost_type`	String
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`fire_adid`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`impression_attribution_window`	Int
`impression_time`	Long
`impression_time_hour`	Long
`ip_address`	String
`is_reattributed`	Int
`is_s_2_s`	Int
`isp`	String
`label`	String
`language`	String
`mac_md_5`	String
`mac_sha_1`	String
`oaid`	String
`oaid_md_5`	String
`os_name`	String
`os_version`	String
`postal_code`	String
`proxy_ip_address`	String
`referrer`	String
`reftag`	String
`region`	String
`reporting_cost`	BigDecimal
`store`	String
`tracker`	String
`user_agent`	String
`web_uuid`	String
`win_adid`	String

att_status_update_ios

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adid`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`att_status`	Int
`city`	String
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`cpu_type`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`deeplink`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`fb_platform_position`	String
`first_tracker`	String
`first_tracker_name`	String
`gclid`	String
`google_ads_adgroup_id`	String
`google_ads_campaign_id`	String
`google_ads_campaign_name`	String
`google_ads_campaign_type`	String
`google_ads_creative_id`	String
`google_ads_keyword`	String
`google_ads_matchtype`	String
`google_ads_network_subtype`	String
`google_ads_network_type`	String
`google_ads_placement`	String
`google_ads_video_id`	String
`hardware_name`	String
`iad_conversion_type`	String
`iad_creative_set_id`	String
`iad_creative_set_name`	String
`iad_keyword_matchtype`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`idfv`	String
`impression_based`	Int
`impression_time`	Long
`impression_time_hour`	Long
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	Int
`is_reattributed`	Int
`isp`	String
`label`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`mac_md_5`	String
`mac_sha_1`	String
`match_type`	String
`mcc`	String
`mnc`	String
`network_type`	String
`os_name`	String
`os_version`	String
`partner_parameters`	String
`platform`	String
`postal_code`	String
`proxy_ip_address`	String
`publisher_parameters`	String
`push_token`	String
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`referrer`	String
`reftag`	String
`region`	String
`sdk_version`	String
`session_count`	Long
`store`	String
`third_party_sharing_disabled`	Int
`timezone`	String
`tracker`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`tweet_id`	String
`twitter_line_item_id`	String
`user_agent`	String

reattribution_update

Column	Type	Keys
`nonce`	String	PK
`random`	String	PK
`tracker_id`	String	FK
`adgroup_name`	String
`adid`	String
`adwords_campaign_id`	String
`adwords_campaign_name`	String
`adwords_campaign_type`	String
`adwords_network_subtype`	String
`adwords_network_type`	String
`api_level`	String
`app_id`	String
`app_name`	String
`app_name_dashboard`	String
`app_version`	String
`app_version_raw`	String
`app_version_short`	String
`attribution_updated_at`	Long
`campaign_name`	String
`city`	String
`click_attribution_window`	Int
`click_time`	Long
`click_time_hour`	Long
`connection_type`	String
`conversion_duration`	Long
`country`	String
`country_subdivision`	String
`created_at`	Long
`created_at_hour`	Long
`created_at_milli`	Long
`creative_name`	String
`device_manufacturer`	String
`device_name`	String
`device_type`	String
`engagement_time`	Long
`engagement_time_hour`	Long
`environment`	String
`fb_account_id`	String
`fb_ad_objective_name`	String
`fb_adgroup_id`	String
`fb_adgroup_name`	String
`fb_campaign_group_id`	String
`fb_campaign_group_name`	String
`fb_campaign_id`	String
`fb_campaign_name`	String
`first_tracker`	String
`first_tracker_name`	String
`gps_adid`	String
`gps_adid_md_5`	String
`idfa`	String
`idfa_md_5`	String
`idfa_md_5_hex`	String
`idfa_or_android_id`	String
`idfa_or_gps_adid`	String
`idfa_or_gps_adid_or_fire_adid`	String
`idfa_upper`	String
`impression_based`	Int
`installed_at`	Long
`installed_at_hour`	Long
`ip_address`	String
`is_organic`	String
`is_reattributed`	Int
`is_s_2_s_engagement_based`	Int
`isp`	String
`language`	String
`last_session_time`	Long
`last_tracker`	String
`last_tracker_name`	String
`lifetime_session_count`	Long
`match_type`	String
`mcc`	String
`mnc`	String
`network_name`	String
`os_name`	String
`os_version`	String
`outdated_tracker`	String
`partner_parameters`	String
`postal_code`	String
`publisher_parameters`	String
`random_user_id`	String
`reattributed_at`	Long
`reattributed_at_hour`	Long
`reftag`	String
`region`	String
`sdk_version`	String
`session_count`	Long
`store`	String
`timezone`	String
`tracker`	String
`tracker_name`	String
`tracking_enabled`	Int
`tracking_limited`	Int
`user_agent`	String