Branch data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: SUMMARY_TOTAL

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
summary_total__ad_id
Display name Ad ID
Description Ad ID of last touch – this is set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_total__ad_name
Display name Ad name
Description Ad name of last touch – this is set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_total__ad_partner_id
Display name Ad partner ID
Description Ad partner ID of last touch – this is set automatically to be the name of the ad partner
Field type dimension
Data type string.text.value
summary_total__ad_partner_name
Display name Ad partner name
Description Ad partner of last touch – this is set automatically to be the name of the ad partner
Field type dimension
Data type string.text.value
summary_total__agency_id
Display name Agency ID
Description ID of the agency
Field type dimension
Data type string.text.value
summary_total__agency_name
Display name Agency name
Description Name of the agency
Field type dimension
Data type string.text.value
summary_total__app_name
Display name App name
Field type dimension
Data type string.text.value
summary_total__attributed
Display name Is attributed
Description Whether the event was attributed to any touch (click or impression) as opposed to unattributed (attributed: false). Unattributed data is the same as organic or direct data
Field type dimension
Data type bool
summary_total__campaign_id
Display name Campaign ID
Description Campaign ID of last touch – this can be set as a custom analytics tag, or set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_total__campaign_name
Display name Campaign name
Description Campaign of last touch – this can be set as a custom analytics tag, or set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_total__channel
Display name Channel
Description Channel of last touch – this can be set as a custom analytics tag
Field type dimension
Data type string.text.value
summary_total__cost
Display name Cost
Description Total cost (spend) for those dimensions (analytics tags, user data, time range), regardless of cost model
Field type metric
Data type float.currency.value
summary_total__custom_event_name
Display name Custom event name
Description Name of the custom event
Field type dimension
Data type string.text.value
summary_total__date
Display name Date
Field type dimension
Data type string.time.date
summary_total__deep_linked
Display name Is deep linked
Description Is the data deep linked? True/False
Field type dimension
Data type bool
summary_total__eo_branch_cta_view
Display name Views
Description The number of Branch CTA views. A banner or Deepview that renders in a user's browser
Field type metric
Data type int.number.value
summary_total__eo_click
Display name Clicks
Description Number of times users tapped on a Branch link, or on an ad where Branch is able to fetch click data from a third party (e.g. Facebook ads). Real-Time user-device level Link clicks are recorded through User Clicks on the Branch Links. SAN Ad Partner's clicks are not included in this bucket
Field type metric
Data type int.number.value
summary_total__eo_dismissal
Display name Journey dismissals
Description The number of journey dismissal
Field type metric
Data type int.number.value
summary_total__eo_impression
Display name Impressions
Description The number of ad impressions. Real-Time user-device level impressions/ad-views triggered via Impression Tracking Ad Links. SAN Ad Partner's impressions are not included in this data source
Field type metric
Data type int.number.value
summary_total__eo_install
Display name Installs
Description Installs attributed to this feature – installs are the first app open after downloading the app
Field type metric
Data type int.number.value
summary_total__eo_open
Display name Opens
Description App opens attributed to your selected filters
Field type metric
Data type int.number.value
summary_total__eo_pageview
Display name Page views
Description The number of attributed pageviews
Field type metric
Data type int.number.value
summary_total__eo_reinstall
Display name Reinstalls
Description Reinstalls attributed to your selected filters
Field type metric
Data type int.number.value
summary_total__eo_sms_sent
Display name SMS sent
Description Number of times users texted themselves an app download link from desktop web
Field type metric
Data type int.number.value
summary_total__eo_web_session_start
Display name Web session starts
Description Web sessions attributed to your selected filters – triggered when a new tab for a website is opened, or when a Branch link is clicked that leads to the website
Field type metric
Data type int.number.value
summary_total__eo_web_to_app_auto_redirect
Display name Web to app redirects
Description Number of times users were auto-redirected to the app without clicking, upon landing on a web page
Field type metric
Data type int.number.value
summary_total__event_data_custom_param_1
Display name Custom parameter 1
Description Custom parameter 1. Available dimension for custom event data
Field type dimension
Data type string.text.value
summary_total__event_data_custom_param_2
Display name Custom parameter 2
Description Custom parameter 2. Available dimension for custom event data
Field type dimension
Data type string.text.value
summary_total__event_data_custom_param_3
Display name Custom parameter 3
Description Custom parameter 3. Available dimension for custom event data
Field type dimension
Data type string.text.value
summary_total__feature
Display name Feature
Description Feature of last touch – this can be set as a custom analytics tag or can be prefilled with the Branch feature, e.g. Journeys
Field type dimension
Data type string.text.value
summary_total__from_desktop
Display name Is from desktop
Description Is data from Desktop? True/False
Field type dimension
Data type bool
summary_total__origin
Display name Origin
Description Whether the event originated with a Branch SDK/API call, or was sent by Segment or mParticle
Field type dimension
Data type string.text.value
summary_total__placement
Display name Placement
Description Placement of the last touch, as set with an analytics tag – actual app or website the ad appears on display campaigns
Field type dimension
Data type string.text.value
summary_total__revenue
Display name Revenue
Description Revenue attributed to your selected filters
Field type metric
Data type float.currency.value
summary_total__tags
Display name Tags
Description Tags of last touch – this can be set as a custom analytics tag
Field type dimension
Data type string.text.value
summary_total__user_data_app_store
Display name App store
Description App store on event
Field type dimension
Data type string.text.value
summary_total__user_data_country
Display name Country
Description Country, derived from IP address
Field type dimension
Data type string.geo.country
summary_total__user_data_environment
Display name Environment
Description Environment where the event occurred, which can distinguish between e.g. full app vs instant app
Field type dimension
Data type string.text.value
summary_total__user_data_geo_country_code
Display name Country code
Description User's Country Code
Field type dimension
Data type string.geo.country.twolettercode
summary_total__user_data_geo_dma_code
Display name Geo DMA code
Description User's GEO Designated Market Area Code, derived from IP address
Field type dimension
Data type string.text.value
summary_total__user_data_geo_region_en
Display name Region
Description User's region
Field type dimension
Data type string.geo.region
summary_total__user_data_language
Display name Language
Description User's Language
Field type dimension
Data type string.text.value
summary_total__user_data_opted_in
Display name Opted in
Description Is User Opted In?
Field type dimension
Data type bool
summary_total__user_data_opted_in_status
Display name Opted in status
Description User Opted In Status
Field type dimension
Data type string.text.value
summary_total__user_data_platform
Display name Platform
Description Platform (web vs app, desktop vs mobile) on which the event took place
Field type dimension
Data type string.text.value

Table: SUMMARY_UNIQUE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
summary_unique__ad_id
Display name Ad ID
Description Ad ID of last touch – this is set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_unique__ad_name
Display name Ad name
Description Ad name of last touch – this is set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_unique__ad_partner_id
Display name Ad partner ID
Description Ad partner ID of last touch – this is set automatically to be the name of the ad partner
Field type dimension
Data type string.text.value
summary_unique__ad_partner_name
Display name Ad partner name
Description Ad partner of last touch – this is set automatically to be the name of the ad partner
Field type dimension
Data type string.text.value
summary_unique__agency_id
Display name Agency ID
Description ID of the agency
Field type dimension
Data type string.text.value
summary_unique__agency_name
Display name Agency name
Description Name of the agency
Field type dimension
Data type string.text.value
summary_unique__app_name
Display name App name
Field type dimension
Data type string.text.value
summary_unique__attributed
Display name Is attributed
Description Whether the event was attributed to any touch (click or impression) as opposed to unattributed (attributed: false). Unattributed data is the same as organic or direct data
Field type dimension
Data type bool
summary_unique__campaign_id
Display name Campaign ID
Description Campaign ID of last touch – this can be set as a custom analytics tag, or set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_unique__campaign_name
Display name Campaign name
Description Campaign of last touch – this can be set as a custom analytics tag, or set automatically by ad networks like Facebook
Field type dimension
Data type string.text.value
summary_unique__channel
Display name Channel
Description Channel of last touch – this can be set as a custom analytics tag
Field type dimension
Data type string.text.value
summary_unique__cost
Display name Cost
Description Total cost (spend) for those dimensions (analytics tags, user data, time range), regardless of cost model
Field type metric
Data type float.currency.value
summary_unique__custom_event_name
Display name Custom event name
Description Name of the custom event
Field type dimension
Data type string.text.value
summary_unique__date
Display name Date
Field type dimension
Data type string.time.date
summary_unique__deep_linked
Display name Is deep linked
Description Is the data deep linked? True/False
Field type dimension
Data type bool
summary_unique__eo_branch_cta_view
Display name Views
Description The number of Branch CTA views. A banner or Deepview that renders in a user's browser
Field type metric
Data type int.number.value
summary_unique__eo_click
Display name Clicks
Description Number of times users tapped on a Branch link, or on an ad where Branch is able to fetch click data from a third party (e.g. Facebook ads). Real-Time user-device level Link clicks are recorded through User Clicks on the Branch Links. SAN Ad Partner's clicks are not included in this bucket
Field type metric
Data type int.number.value
summary_unique__eo_dismissal
Display name Journey dismissals
Description The number of journey dismissal
Field type metric
Data type int.number.value
summary_unique__eo_impression
Display name Impressions
Description The number of ad impressions. Real-Time user-device level impressions/ad-views triggered via Impression Tracking Ad Links. SAN Ad Partner's impressions are not included in this data source
Field type metric
Data type int.number.value
summary_unique__eo_install
Display name Installs
Description Installs attributed to this feature – installs are the first app open after downloading the app
Field type metric
Data type int.number.value
summary_unique__eo_open
Display name Opens
Description App opens attributed to your selected filters
Field type metric
Data type int.number.value
summary_unique__eo_pageview
Display name Page views
Description The number of attributed pageviews
Field type metric
Data type int.number.value
summary_unique__eo_reinstall
Display name Reinstalls
Description Reinstalls attributed to your selected filters
Field type metric
Data type int.number.value
summary_unique__eo_sms_sent
Display name SMS sent
Description Number of times users texted themselves an app download link from desktop web
Field type metric
Data type int.number.value
summary_unique__eo_web_session_start
Display name Web session starts
Description Web sessions attributed to your selected filters – triggered when a new tab for a website is opened, or when a Branch link is clicked that leads to the website
Field type metric
Data type int.number.value
summary_unique__eo_web_to_app_auto_redirect
Display name Web to app redirects
Description Number of times users were auto-redirected to the app without clicking, upon landing on a web page
Field type metric
Data type int.number.value
summary_unique__event_data_custom_param_1
Display name Custom parameter 1
Description Custom parameter 1. Available dimension for custom event data
Field type dimension
Data type string.text.value
summary_unique__event_data_custom_param_2
Display name Custom parameter 2
Description Custom parameter 2. Available dimension for custom event data
Field type dimension
Data type string.text.value
summary_unique__event_data_custom_param_3
Display name Custom parameter 3
Description Custom parameter 3. Available dimension for custom event data
Field type dimension
Data type string.text.value
summary_unique__feature
Display name Feature
Description Feature of last touch – this can be set as a custom analytics tag or can be prefilled with the Branch feature, e.g. Journeys
Field type dimension
Data type string.text.value
summary_unique__from_desktop
Display name Is from desktop
Description Is data from Desktop? True/False
Field type dimension
Data type bool
summary_unique__origin
Display name Origin
Description Whether the event originated with a Branch SDK/API call, or was sent by Segment or mParticle
Field type dimension
Data type string.text.value
summary_unique__placement
Display name Placement
Description Placement of the last touch, as set with an analytics tag – actual app or website the ad appears on display campaigns
Field type dimension
Data type string.text.value
summary_unique__revenue
Display name Revenue
Description Revenue attributed to your selected filters
Field type metric
Data type float.currency.value
summary_unique__tags
Display name Tags
Description Tags of last touch – this can be set as a custom analytics tag
Field type dimension
Data type string.text.value
summary_unique__user_data_app_store
Display name App store
Description App store on event
Field type dimension
Data type string.text.value
summary_unique__user_data_country
Display name Country
Description Country, derived from IP address
Field type dimension
Data type string.geo.country
summary_unique__user_data_environment
Display name Environment
Description Environment where the event occurred, which can distinguish between e.g. full app vs instant app
Field type dimension
Data type string.text.value
summary_unique__user_data_geo_country_code
Display name Country code
Description User's Country Code
Field type dimension
Data type string.geo.country.twolettercode
summary_unique__user_data_geo_dma_code
Display name Geo DMA code
Description User's GEO Designated Market Area Code, derived from IP address
Field type dimension
Data type string.text.value
summary_unique__user_data_geo_region_en
Display name Region
Description User's region
Field type dimension
Data type string.geo.region
summary_unique__user_data_language
Display name Language
Description User's Language
Field type dimension
Data type string.text.value
summary_unique__user_data_opted_in
Display name Opted in
Description Is User Opted In?
Field type dimension
Data type bool
summary_unique__user_data_opted_in_status
Display name Opted in status
Description User Opted In Status
Field type dimension
Data type string.text.value
summary_unique__user_data_platform
Display name Platform
Description Platform (web vs app, desktop vs mobile) on which the event took place
Field type dimension
Data type string.text.value