Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
EVENT ⇱
_fivetran_id 🔑
app_info_*
bundle_sequence_id
date
device_*
device_web_*
ecommerce_*
event_diemsions_hostname
geo_*�is_active_user
is_intraday
name
params/param_*
platform
previous_timestamp
privacy_info_*
server_timestamp_offset
stream_id
timestamp
traffic_source*
collected_traffic_source
user_first_touch_timestamp
user_id
user_ltv_*
user_properties/user_property_*
user_pseudo_id
value_in _usd
param_* and user_property_* columns are populated if sync mode is Columns.
params and user_properties columns are populated if the sync mode is JSON.
EVENT ⇱
_fivetran_id 🔑
app_info_*
bundle_sequence_id
date
device_*
device_web_*
ecommerce_*
event_diemsions_hostname
geo_*�is_active_user
is_intraday
name
params/param_*
platform
previous_timestamp
privacy_info_*
server_timestamp_offset
stream_id
timestamp
traffic_source*
collected_traffic_source
user_first_touch_timestamp
user_id
user_ltv_*
user_properties/user_property_*
user_pseudo_id
value_in _usd
ITEM ⇱
_fivetran_id 🔑 ➤ EVENT
index 🔑
event_timestamp ➤ EVENT.timestamp
affiliation
brand
coupon
creative_name
creative_slot
id
list_id
list_index
list_name
location_id
name
price
price_in_usd
promotion_id
promotion_name
quantity
refund
refund_in_usd
revenue
revenue_in_usd
variant
category_*
params/param_*
EVENT ⇱
_fivetran_id 🔑
app_info_*
bundle_sequence_id
date
device_*
device_web_*
ecommerce_*
event_diemsions_hostname
geo_*�is_active_user
is_intraday
name
params/param_*
platform
previous_timestamp
privacy_info_*
server_timestamp_offset
stream_id
timestamp
traffic_source*
collected_traffic_source
user_first_touch_timestamp
user_id
user_ltv_*
user_properties/user_property_*
user_pseudo_id
value_in _usd
EVENT ⇱
_fivetran_id 🔑
batch_event_index
batch_ordering_id
batch_page_id
bundle_sequence_id
date
event_diemsions_hostname�is_active_user
is_intraday
name
platform
previous_timestamp
server_timestamp_offset
stream_id
timestamp
user_first_touch_timestamp
user_id
user_pseudo_id
value_in _usd
app_info_*
collected_traffic_source_*
device_*
device_web_*
ecommerce_*
geo_*
params/param_*
privacy_info_*
session_traffic_source_last_click_cm360_campaign_*
session_traffic_source_last_click_cross_channel_campaign_*
session_traffic_source_last_click_dv360_campaign_*
session_traffic_source_last_click_google_ads_campaign_*
session_traffic_source_last_click_manual_campagin_*
session_traffic_source_last_click_sa360_campaign_*
traffic_source*
user_ltv_*
user_properties/user_property_*