Schema
Data Broker Pipeline Efforts
>
Banno Usage Data - Vendor
>
Schema
Banno Usage Data Schema
master_fct_cdd
| Column | Type | Description |
|---|---|---|
| utm_term | STRING | |
| utm_source | STRING | Not used |
| utm_medium | STRING | Not used |
| utm_content | STRING | Not used |
| utm_campaign | STRING | Not used |
| useragent | STRING | Browser user agent (Online |
| time | TIMESTAMP | Time of the event |
| status | STRING | Not used |
| sampling_factor | FLOAT64 | Not used |
| pageurl | STRING | Page URL (Online only) |
| pageid | STRING | ID of the page/screen |
| msclkid | STRING | Not used |
| mp_wifi | BOOL | Is the device using Wifi |
| mp_user_id | STRING | GUID for the user |
| mp_sent_by_lib_version | STRING | Native library version used (Mobile only) |
| mp_search_engine | STRING | Not used |
| mp_screen_width | FLOAT64 | Screen width |
| mp_screen_height | FLOAT64 | Screen height |
| mp_screen_dpi | FLOAT64 | Screen DPI |
| mp_region | STRING | State or other region (Defined by IP) |
| mp_referring_domain | STRING | Referring domain if linked into platform (Online only) |
| mp_referrer | STRING | Referring page if linked into platform (Online only) |
| mp_radio | STRING | Cellular radio type (Mobile only) |
| mp_processing_time_ms | FLOAT64 | Event processing time |
| mp_os_version | STRING | Operating system version |
| mp_os | STRING | Operating |
| mp_mp_api_timestamp_ms | FLOAT64 | API timestamp |
| mp_mp_api_endpoint | STRING | API called |
| mp_model | STRING | Device model (Mobile only) |
| mp_manufacturer | STRING | Device manufacturer (Mobile only) |
| mp_lib_version | STRING | Library version |
| mp_lib | STRING | Not used |
| mp_keyword | STRING | Not used |
| mp_insert_id | STRING | Not used |
| mp_initial_referring_domain | STRING | First domain in referring list (Online only) |
| mp_initial_referrer | STRING | First URL in referring list (Online only) |
| mp_identified_id | STRING | Identified device (Mobile only) |
| mp_has_telephone | BOOL | Device has telephone (Mobile only) |
| mp_has_nfc | BOOL | Device has NFC (Mobile only) |
| mp_had_persisted_distinct_id | BOOL | Is there a persisted ID for the user |
| mp_failure_reason | STRING | Error message on collection |
| mp_failure_description | STRING | Error message on collection |
| mp_event_name | STRING | Name of the event |
| mp_distinct_id_before_identity | STRING | ID of anonymous user |
| mp_device_id | STRING | Unique device ID |
| mp_device | STRING | Device info |
| mp_current_url | STRING | Current page URL (Online only) |
| mp_country_code | STRING | Country (Defined by IP) |
| mp_city | STRING | City (Defined by IP) |
| mp_carrier | STRING | Mobile carrier (Mobile only) |
| mp_browser_version | FLOAT64 | Browser version (Online only) |
| mp_browser | STRING | Browser name (Online only) |
| mp_brand | STRING | Device brand (Mobile only) |
| mp_bluetooth_version | STRING | Device bluetooth version (Mobile only) |
| mp_bluetooth_enabled | BOOL | Is bluetooth enabled (Mobile only) |
| mp_app_version_string | STRING | Mobile app version (Mobile only) |
| mp_app_version | STRING | Not used |
| mp_app_release | STRING | Not used |
| mp_app_build_number | STRING | Mobile app build number (Mobile only) |
| mp_anon_id | STRING | Not used |
| languagecode | STRING | Device/browser language |
| institutionname | STRING | Institution name |
| institutionid | STRING | Institution ID (GUID) |
| gclid | STRING | Not used |
| fbclid | STRING | Not used |
| distinct_id | STRING | Distinct user id (GUID) |
| mp_ae_session_length | FLOAT64 | Not used |
| mp_screen_width_string | STRING | Not used |
| mp_screen_height_string | STRING | Not used |
| ttckud | STRING | |
| jhdeviceid_blob | STRING | |
| jhdeviceid | STRING |
people_fct_cdd
| Column | Type | Description |
|---|---|---|
| usertype | STRING | |
| userid | STRING | |
| mp_where | STRING | |
| mp_timezone | STRING | |
| mp_swift_lib_version | STRING | |
| mp_region | STRING | |
| mp_os | STRING | |
| mp_last_seen | STRING | |
| mp_ios_version | STRING | |
| mp_ios_lib_version | STRING | |
| mp_ios_device_model | STRING | |
| mp_ios_app_version | STRING | |
| mp_ios_app_release | STRING | |
| mp_initial_referring_domain | STRING | |
| mp_initial_referrer | STRING | |
| mp_geo_source | STRING | |
| mp_distinct_id | STRING | |
| mp_country_code | STRING | |
| mp_city | STRING | |
| mp_browser_version | FLOAT64 | |
| mp_browser | STRING | |
| mp_android_os_version | STRING | |
| mp_android_os | STRING | |
| mp_android_model | STRING | |
| mp_android_manufacturer | STRING | |
| mp_android_lib_version | STRING | |
| mp_android_brand | STRING | |
| mp_android_app_version_code | STRING | |
| mp_android_app_version | STRING | |
| mp_ae_total_app_sessions | FLOAT64 | |
| mp_ae_total_app_session_length | FLOAT64 | |
| institutionname | STRING | |
| institutionid | STRING | |
| initial_utm_term | STRING | |
| initial_utm_source | STRING | |
| initial_utm_medium | STRING | |
| initial_utm_content | STRING | |
| initial_utm_campaign | STRING | |
| darkmode | BOOL |
Last updated Tue Nov 5 2024