DAP Universal Analytics Historical Data Schema

DAP Universal Analytics Historical Data Structure

Granularity	Start Date	End Date
Weekly and Monthly	01/01/2021	06/24/2024
Monthly	01/01/2012	06/24/2024

Events	Metrics
Dimensions	Users	Sessions	Event Count
month	TRUE	TRUE	TRUE
year	TRUE	TRUE	TRUE
Event Type	TRUE	TRUE	FALSE

Acquisition	Metrics
Dimensions	Sessions	Users	New Users	Avg. Session Duration	Bounce Rate
month	TRUE	TRUE	TRUE	TRUE	TRUE
year	TRUE	TRUE	TRUE	TRUE	TRUE
Source	TRUE	TRUE	TRUE	TRUE	TRUE
Medium	TRUE	TRUE	TRUE	TRUE	TRUE
Campaign	TRUE	TRUE	TRUE	TRUE	TRUE

Pages	Metrics
Dimensions	Pageviews	Unique Pageviews	Avg. Time on Page	Entrances	% Exit
month	TRUE	TRUE	TRUE	TRUE	TRUE
year	TRUE	TRUE	TRUE	TRUE	TRUE
Page Path	TRUE	TRUE	TRUE	TRUE	TRUE
Page Title	TRUE	TRUE	TRUE	TRUE	TRUE
Page (URL)	TRUE	TRUE	TRUE	TRUE	TRUE

Demographics	Metrics
Dimensions	Sessions	Users	New Users	Avg. Session Duration	Bounce Rate
month	TRUE	TRUE	TRUE	TRUE	TRUE
year	TRUE	TRUE	TRUE	TRUE	TRUE
Metro	TRUE	TRUE	TRUE	TRUE	TRUE
Region	TRUE	TRUE	TRUE	TRUE	TRUE
Language	TRUE	TRUE	TRUE	TRUE	TRUE
City	TRUE	TRUE	TRUE	TRUE	TRUE

SEARCH	Metrics
Dimensions	Sessions	Users
month	TRUE	TRUE
year
Visits Without Site Search	TRUE	TRUE
Visits With Site Search	TRUE	TRUE

Attribution 2	Metrics
Dimensions	bounces	newUsers	pageviews	sessionDuration	sessions	users
month	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
year	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
deviceCategory	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
medium	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
referralPath	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
source	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
campaign	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
fullReferrer	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
landingPagePath	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE

Engagement	Metrics
Dimensions	pageviews	sessions
month	TRUE	TRUE
year	TRUE	TRUE
medium	TRUE	TRUE
source	TRUE	TRUE
sessionDurationBucket	TRUE	TRUE

Device	Metrics
year	Sessions	Users
month	TRUE	TRUE
deviceCategory	TRUE	TRUE
webBrowser	TRUE	TRUE
OS	TRUE	TRUE