Updated 7 months ago
Indexed 5 hours ago

Daily Fort Collins OpenBook Analytics

Daily data from the Google Analytics tag for OpenBook at

Analytics shown are presumed to be non-City-employees, as these data come from computers external to the City network. Each day starting at the first day for which there are data is included, and the URL is either a specific page or "all", specifying that every page in the domain is included. Specific-page URLs are filtered to the main Portal page or data assets, so "all" may capture more pages than specified individually.


NameSocrata field nameColumn name in sgr mountData typeDescription
ga:sessionDurationga_sessiondurationga_sessiondurationNumberFrom Google Analytics API: total duration (in seconds) of users sessions
meta_row_idmeta_row_idmeta_row_idTextMetadata field for record hash. This field is a SHA-1 hash of all other fields in the record, used for validation of record uniqueness.
ga:usersga_usersga_usersNumberFrom Google Analytics API: the total number of users for the requested time period
ga:percentNewSessionsga_percentnewsessionsga_percentnewsessionsNumberFrom Google Analytics API: the percentage of sessions by users who had never visited the property before
ga:newUsersga_newusersga_newusersNumberFrom Google Analytics API: the number of sessions marked as a user's first session. This resets each time period
ga:bounceRatega_bounceratega_bouncerateNumberFrom Google Analytics API: the percentage of single-page session (i.e., session in which the person left the property from the first page)
ga:avgSessionDurationga_avgsessiondurationga_avgsessiondurationNumberFrom Google Analytics API: the average duration (in seconds) of users sessions
ga:pageviewsPerSessionga_pageviewspersessionga_pageviewspersessionNumberFrom Google Analytics API: the average number of pages viewed during a session, including repeated views of a single page
ga:hitsga_hitsga_hitsNumberFrom Google Analytics API: total number of hits for the view (profile). This metric sums all hit types, including pageview, custom event, ecommerce, and other types. Because this metric is based on the view (profile), not on the property, it is not the same as the propertys hit volume
meta_row_indexmeta_row_indexmeta_row_indexNumberMetadata field for a suggested sort order. Sort this column in ascending order to order the dataset the way it was intended from the source system.
urlurlurlTextURL of a specific page, or all for all pages in the domain
ga:sessionsga_sessionsga_sessionsNumberFrom Google Analytics API: the total number of sessions
endDateenddateenddateCalendar dateInclusive end date for analytics capture
ga:pageviewsga_pageviewsga_pageviewsNumberFrom Google Analytics API: the total number of pageviews for the property
ga:timeOnPagega_timeonpagega_timeonpageNumberFrom Google Analytics API: time (in seconds) users spent on a particular page, calculated by subtracting the initial view time for a particular page from the initial view time for a subsequent page. This metric does not apply to exit pages of the property
ga:bouncesga_bouncesga_bouncesNumberFrom Google Analytics API: the total number of single page (or single interaction hit) sessions for the property
ga:avgTimeOnPagega_avgtimeonpagega_avgtimeonpageNumberFrom Google Analytics API: the average time users spent viewing this page or a set of pages
startDatestartdatestartdateCalendar dateInclusive start date for analytics capture
Upstream Metadata