brunomertins/app_web_bigquery_export.csv

## app_web_bigquery_export.csv

          
            Field name
            Data type
            Description

            
              App

            
              app_info
              RECORD
              A record of information on the app.

            
              app_info.id
              STRING
              The package name or bundle ID of the app.

            
              app_info.firebase_app_id
              STRING
              The Firebase App ID associated with the app

            
              app_info.install_source
              STRING
              The store that installed the app.

            
              app_info.version
              STRING
              The app's versionName (Android) or short bundle version.

            
              Device

            
              device
              RECORD
              A record of device information.

            
              device.category
              STRING
              The device category (mobile, tablet, desktop).

            
              device.mobile_brand_name
              STRING
              The device brand name.

            
              device.mobile_model_name
              STRING
              The device model name.

            
              device.mobile_marketing_name
              STRING
              The device marketing name.

            
              device.mobile_os_hardware_model
              STRING
              The device model information retrieved directly from the operating system.

            
              device.operating_system
              STRING
              The operating system of the device.

            
              device.operating_system_version
              STRING
              The OS version.

            
              device.vendor_id
              STRING
              IDFV (present only if IDFA is not collected).

            
              device.advertising_id
              STRING
              Advertising ID/IDFA.

            
              device.language
              STRING
              The OS language.

            
              device.time_zone_offset_seconds
              INTEGER
              The offset from GMT in seconds.

            
              device.is_limited_ad_tracking
              BOOLEAN
              The device's Limit Ad Tracking setting.

            
              Stream and platform

            
              stream_id
              STRING
              The numeric ID of the stream.

            
              platform
              STRING
              The platform on which the app was built.

            
              User

            
              user_first_touch_timestamp
              INTEGER
              The time (in microseconds) at which the user first opened the app.

            
              user_id
              STRING
              The user ID set via the setUserId API.

            
              user_pseudo_id
              STRING
              The pseudonymous id (e.g., app instance ID) for the user.

            
              user_properties
              RECORD
              A repeated record of user properties set with the setUserProperty API.

            
              user_properties.key
              STRING
              The name of the user property.

            
              user_properties.value
              RECORD
              A record for the user property value.

            
              user_properties.value.string_value
              STRING
              The string value of the user property.

            
              user_properties.value.int_value
              INTEGER
              The integer value of the user property.

            
              user_properties.value.double_value
              FLOAT
              The double value of the user property.

            
              user_properties.value.float_value
              FLOAT
              This field is currently unused.

            
              user_properties.value.set_timestamp_micros
              INTEGER
              The time (in microseconds) at which the user property was last set.

            
              user_ltv
              RECORD
              A record of Lifetime Value information about the user. This field is not populated in intraday tables.

            
              user_ltv.revenue
              FLOAT
              The Lifetime Value (revenue) of the user. This field is not populated in intraday tables.

            
              user_ltv.currency
              STRING
              The Lifetime Value (currency) of the user. This field is not populated in intraday tables.

            
              Campaign
              
              Note: traffic_source attribution is based on cross-channel last click. traffic_source values do not change if the user interacts with subsequent campaigns after installation.

            
              traffic_source
              RECORD
              Name of the traffic source that first acquired the user. This field is not populated in intraday tables.

            
              traffic_source.name
              STRING
              Name of the marketing campaign that first acquired the user. This field is not populated in intraday tables.

            
              traffic_source.medium
              STRING
              Name of the medium (paid search, organic search, email, etc.) that first acquired the user. This field is not populated in intraday tables.

            
              traffic_source.source
              STRING
              Name of the network that first acquired the user. This field is not populated in intraday tables.

            
              Geo

            
              geo
              RECORD
              A record of the user's geographic information.

            
              geo.continent
              STRING
              The continent from which events were reported, based on IP address.

            
              geo.sub_continent
              STRING
              The subcontinent from which events were reported, based on IP address.

            
              geo.country
              STRING
              The country from which events were reported, based on IP address.

            
              geo.region
              STRING
              The region from which events were reported, based on IP address.

            
              geo.metro
              STRING
              The metro from which events were reported, based on IP address.

            
              geo.city
              STRING
              The city from which events were reported, based on IP address.

            
              Event

            
              event_date
              STRING
              The date on which the event was logged (YYYYMMDD format in the registered timezone of your app).

            
              event_timestamp
              INTEGER
              The time (in microseconds, UTC) at which the event was logged on the client.

            
              event_previous_timestamp
              INTEGER
              The time (in microseconds, UTC) at which the event was previously logged on the client.

            
              event_name
              STRING
              The name of the event.

            
              event_params
              RECORD
              A repeated record of the parameters associated with this event.

            
              event_params.key
              STRING
              The event parameter's key.

            
              event_params.value
              RECORD
              A record of the event parameter's value.

            
              event_params.value.string_value
              STRING
              The string value of the event parameter.

            
              event_params.value.int_value
              INTEGER
              The integer value of the event parameter.

            
              event_params.value.double_value
              FLOAT
              The double value of the event parameter.

            
              event_params.value.float_value
              FLOAT
              The float value of the event parameter. This field is currently unused.

            
              event_value_in_usd
              FLOAT
              The currency-converted value (in USD) of the event's "value" parameter.

            
              event_bundle_sequence_id
              INTEGER
              The sequential ID of the bundle in which these events were uploaded.

            
              event_server_timestamp_offset
              INTEGER
              Timestamp offset between collection time and upload time in micros.

            
              Web

            
              web_info
              RECORD
              A record of information for web data.

            
              web_info.hostname
              STRING
              The hostname associated with the logged event.

            
              web_info.browser
              STRING
              The browser in which the user viewed content.

            
              web_info.browser_version
              STRING
              The version of the browser in which the user viewed content.
Field name	Data type	Description
App
app_info	RECORD	A record of information on the app.
app_info.id	STRING	The package name or bundle ID of the app.
app_info.firebase_app_id	STRING	The Firebase App ID associated with the app
app_info.install_source	STRING	The store that installed the app.
app_info.version	STRING	The app's versionName (Android) or short bundle version.
Device
device	RECORD	A record of device information.
device.category	STRING	The device category (mobile, tablet, desktop).
device.mobile_brand_name	STRING	The device brand name.
device.mobile_model_name	STRING	The device model name.
device.mobile_marketing_name	STRING	The device marketing name.
device.mobile_os_hardware_model	STRING	The device model information retrieved directly from the operating system.
device.operating_system	STRING	The operating system of the device.
device.operating_system_version	STRING	The OS version.
device.vendor_id	STRING	IDFV (present only if IDFA is not collected).
device.advertising_id	STRING	Advertising ID/IDFA.
device.language	STRING	The OS language.
device.time_zone_offset_seconds	INTEGER	The offset from GMT in seconds.
device.is_limited_ad_tracking	BOOLEAN	The device's Limit Ad Tracking setting.
Stream and platform
stream_id	STRING	The numeric ID of the stream.
platform	STRING	The platform on which the app was built.
User
user_first_touch_timestamp	INTEGER	The time (in microseconds) at which the user first opened the app.
user_id	STRING	The user ID set via the setUserId API.
user_pseudo_id	STRING	The pseudonymous id (e.g., app instance ID) for the user.
user_properties	RECORD	A repeated record of user properties set with the setUserProperty API.
user_properties.key	STRING	The name of the user property.
user_properties.value	RECORD	A record for the user property value.
user_properties.value.string_value	STRING	The string value of the user property.
user_properties.value.int_value	INTEGER	The integer value of the user property.
user_properties.value.double_value	FLOAT	The double value of the user property.
user_properties.value.float_value	FLOAT	This field is currently unused.
user_properties.value.set_timestamp_micros	INTEGER	The time (in microseconds) at which the user property was last set.
user_ltv	RECORD	A record of Lifetime Value information about the user. This field is not populated in intraday tables.
user_ltv.revenue	FLOAT	The Lifetime Value (revenue) of the user. This field is not populated in intraday tables.
user_ltv.currency	STRING	The Lifetime Value (currency) of the user. This field is not populated in intraday tables.
Campaign		Note: traffic_source attribution is based on cross-channel last click. traffic_source values do not change if the user interacts with subsequent campaigns after installation.
traffic_source	RECORD	Name of the traffic source that first acquired the user. This field is not populated in intraday tables.
traffic_source.name	STRING	Name of the marketing campaign that first acquired the user. This field is not populated in intraday tables.
traffic_source.medium	STRING	Name of the medium (paid search, organic search, email, etc.) that first acquired the user. This field is not populated in intraday tables.
traffic_source.source	STRING	Name of the network that first acquired the user. This field is not populated in intraday tables.
Geo
geo	RECORD	A record of the user's geographic information.
geo.continent	STRING	The continent from which events were reported, based on IP address.
geo.sub_continent	STRING	The subcontinent from which events were reported, based on IP address.
geo.country	STRING	The country from which events were reported, based on IP address.
geo.region	STRING	The region from which events were reported, based on IP address.
geo.metro	STRING	The metro from which events were reported, based on IP address.
geo.city	STRING	The city from which events were reported, based on IP address.
Event
event_date	STRING	The date on which the event was logged (YYYYMMDD format in the registered timezone of your app).
event_timestamp	INTEGER	The time (in microseconds, UTC) at which the event was logged on the client.
event_previous_timestamp	INTEGER	The time (in microseconds, UTC) at which the event was previously logged on the client.
event_name	STRING	The name of the event.
event_params	RECORD	A repeated record of the parameters associated with this event.
event_params.key	STRING	The event parameter's key.
event_params.value	RECORD	A record of the event parameter's value.
event_params.value.string_value	STRING	The string value of the event parameter.
event_params.value.int_value	INTEGER	The integer value of the event parameter.
event_params.value.double_value	FLOAT	The double value of the event parameter.
event_params.value.float_value	FLOAT	The float value of the event parameter. This field is currently unused.
event_value_in_usd	FLOAT	The currency-converted value (in USD) of the event's "value" parameter.
event_bundle_sequence_id	INTEGER	The sequential ID of the bundle in which these events were uploaded.
event_server_timestamp_offset	INTEGER	Timestamp offset between collection time and upload time in micros.
Web
web_info	RECORD	A record of information for web data.
web_info.hostname	STRING	The hostname associated with the logged event.
web_info.browser	STRING	The browser in which the user viewed content.
web_info.browser_version	STRING	The version of the browser in which the user viewed content.