Skip to main content

Bloom analytics database views field documentation

Pages Read

column namedescriptionnotes
time_utctime (UTC)
time_localtime (converted to local time)
date_localdate (converted to local time)
context_timezonetimezone as reported by the device
time_local_dayday of the week (converted to local time)
time_local_hourhour (converted to local time)
pages_read_audionumber of audio pages the user viewed
pages_read_nonaudionumber of non-audio pages the user viewed
pages_readnumber of pages the user viewed
anonymous_idunique user ID
device_unique_idunique device IDIn Aug 2022, this value changed due to Android policy changes; so the same device before and after Aug 2022 has two different IDs
device_project_hardware_codecomes from deviceId.json, if found on the device
bloom_reader_versionBR version number, e.g. 2.3
book_titlebook title
book_brandingbook branding code
book_language_codeBCP47 language code
book_languagealways gives "error"join book_language_code to public.languagecodes to get language name
book_pagestotal pages in book
finished_reading_bookuser viewed last content page
countrycountry based on IP lookupIP lookup predated location; it is present even when user disables location on their device; however it is not 100% accurate
regionregion based on IP lookup
citycity based on IP lookup
channelBloom Reader channel, e.g. release, beta, alpha
video_pages_playedhow many pages a user viewed which have video
featurese.g. comic, talkingbook
book_instance_idunique book ID
distribution_sourcebook distribution sourcewe have plans to make this a chain of sources to show shares, etc., but for now it is only original source
latitude_approxrounded latitude based on device location"device location" usually means gps; see location_source
longitude_approxrounded longitude based on device location
country_geocountry based on device location
region_georegion based on device location
city_geocity based on device location
sourcesource of the analytics, currently bloomreader or bloomlibraryrise and western views are filtered to bloomreader only
bookshelvesbookshelves to which the book is assignedusually only one
read_durationtime spent reading the book, in secondsincludes audio_duration and video_duration
audio_durationtime spent listening to audio, in seconds
video_durationtime spent watching video, in seconds
location_sourcesource of the fine location information; or denied or failede.g. gps, network, passive
location_age_dayshow long ago the fine location information was acquired, in days

Comprehension

column namedescriptionnotes
time_utctime (UTC)
time_localtime (converted to local time)
date_localdate (converted to local time)
context_timezonetimezone as reported by the device
time_local_dayday of the week (converted to local time)
time_local_hourhour (converted to local time)
anonymous_idunique user ID
device_unique_idunique device IDIn Aug 2022, this value changed due to Android policy changes; so the same device before and after Aug 2022 has two different IDs
bloom_reader_versionBR version number, e.g. 2.3
book_brandingbook branding code
book_titlebook title
question_countnumber of questions in quiz
percent_rightpercentage of questions the user got correct
countrycountry based on IP lookupIP lookup predated location; it is present even when user disables location on their device; however it is not 100% accurate
regionregion based on IP lookup
citycity based on IP lookup
channelBloom Reader channel, e.g. release, beta, alpha
book_instance_idunique book ID
distribution_sourcebook distribution sourcewe have plans to make this a chain of sources to show shares, etc., but for now it is only original source
latitude_approxrounded latitude based on device location"device location" usually means gps; see location_source
longitude_approxrounded longitude based on device location
country_geocountry based on device location
region_georegion based on device location
city_geocity based on device location
sourcesource of the analytics, currently bloomreader or bloomlibraryrise and western views are filtered to bloomreader only
bookshelvesbookshelves to which the book is assignedusually only one
location_sourcesource of the fine location information; or denied or failede.g. gps, network, passive
location_age_dayshow long ago the fine location information was acquired, in days

Download Book

column namedescriptionnotes
time_utctime (UTC)
book_idbook ID in our internal database, used by the websitee.g. VlzkGKQZXw in https://bloomlibrary.org/book/VlzkGKQZXw
book_instance_idunique book ID
event_typetype of downloade.g. shell, read, epub, bloompub, pdf
book_titlebook title
book_brandingbook branding code
countrycountry based on IP lookupIP lookup is not 100% accurate
regionregion based on IP lookup
citycity based on IP lookup
topicbook topic(s)