Page Comparison

...

Druid Data Model

Raw Telemetry

Dimension in Druid

Field in Summary event

Description

Data Type

1

eid

Event Id

String

2

ver

Version

String

3

syncts

Sync timestamp

Long

4

uid

User Id

String

5

context_date_range_from

context.date_range.from

Start Date for the summary

String

6

context_date_range_to

context.date_range.to

End Date for the summary

String

7

context_rollup_l1

context.rollup.l1

Context level1 rollup

String

8

context_rollup_l2

context.rollup.l2

Context level2 rollup

String

9

context_rollup_l3

context.rollup.l3

Context level3 rollup

String

10

context_rollup_l4

context.rollup.l4

Context level4 rollup

String

11

dimension_channel

dimensions.channel

Channel Id as dimension from raw telemetry

String

12

dimensions_did

dimensions.did

Device Id as dimension from raw telemetry

String

13

dimensions_pdata_id

dimensions.pdata.id

Producer Id as dimension from raw telemetry

String

14

dimensions_pdata_pid

dimensions.pdata.pid

Producer Process Id as dimension from raw telemetry

String

15

dimensions_sid

dimensions.sid

Session Id as dimension

String

16

dimensions_type

dimensions.type

Type of summary

String

17

dimensions_mode

dimensions.mode

Mode of action in the session

String

18

object_id

object.id

Content Id

String

19

object_type

object.type

Content Type

String

20

object_type

object.type

Content Type

String

21

object_version

object.ver

Content version

String

22

object_rollup_l1

object.rollup.l1

Object level1 rollup

String

23

object_rollup_l2

object.rollup.l2

Object level2 rollup

String

24

object_rollup_l3

object.rollup.l3

Object level3 rollup

String

25

object_rollup_l4

object.rollup.l4

Object level4 rollup

String

26

tags

Tags attached to a summary event

Array[String]

27

edata_time_spent

edata.eks.time_spent

Time spent in the session excluding idle time

String

28

edata_time_difference

edata.eks.time_diff

Total time in a session including idle time

String

29

edata_interaction_count

edata.eks.interact_events_count

Total count of interact events in a session

Long

30

edata_summary_env

edata.eks.env_summary.env

High level env within the app

(content, domain, resources, community)

String

31

edata_env_summary_count

edata.eks.env_summary.count

Count of times the environment has been visited

Integer

32

edata_env_summary_time_spent

edata.eks.env_summary.time_spent

Time spent per env

Double

33

edata_page_summary_id

edata.eks.page_summary.id

Page id

String

34

edata_page_summary_type

edata.eks.page_summary.type

Type of page e.g. view/edit

String

35

edata_page_summary_visit_count

edata.eks.page_summary.visit_count

Number of times each page was visited

String

36edata_page

	Dimension in Druid	Field in Telemetry	Description	Data Type
1	eid	eid	Event Id	String
2	syncts	syncts	Sync Timestamp	Long
3	actor_id	actor.id	Actor Id of the event	String
4	actor_type	actor.type	Type of the actor	String
5	context_channel	context.channel	Channel Id	String
6	context_pdata_id	context.pdata.id	Producer Id	String
7	context_pdata_pid	context.pdata.pid	Producer Process Id	String
8	context_pdata_ver	context.pdata.ver	Producer version number	String
9	context_env	context.env	Context Environment	String
10	context_sid	context.sid	Session Id	String
11	context_did	context.did	Device Id	String
12	context_cdata_type	context.cdata.type	Correlation Data Type	String
13	context_cdata_id	context.cdata.id	Correlation Data Id	Array[String]
14	object_id	object.id	Content Id	String
15	object_type	object.type	Content Type	String
16	object_version	object.ver	Content Version	String
17	tags	tags	Tags	Array[String]
18	edata_type	edata.type	Event type	String
19	edata_subtype	edata.subtype	Event subtype	String
20	edata_mode	edata.mode	START event Mode of start	String
21	edata_pageid	edata.pageid	Unique pageid	String
22	edata_uri	edata.uri	IMPRESSION event Relative URI of the content	String
23	edata_id	edata.id	Event data Id	String
24	edata_duration	edata.duration	Duration of the event	String
25	edata_index	edata.index	ASSESS event Index of the question within a content	String
26	edata_pass	edata.pass	ASSESS event Field to identify pass or fail for assessments	String
27	edata_score	edata.score	ASSESS event Assessment score	Double
28	edata_resvalues	edata.resvalues	ASSESS event Assessment results	Array[Object]
29	edata_item_id	edata.item.id	ASSESS event Assessment item id	String
30	edata_item_title	edata.item.title	ASSESS event Assessment item title	String
31	edata_item_maxscore	edata.item.maxscore	ASSESS event Assessment item max score	Double
32	edata_target_id	edata.target.id	ASSESS event Assessment item target id	String
33	edata_target_type	edata.target.type	ASSESS event Assessment item target type	String
34	edata_rating	edata.rating	FEEDBACK event Ratings	String
35	edata_comments	edata.comments	FEEDBACK event Comments	String
36	edata_dir	edata.dir	SHARE event direction	String
37	edata_items_id	edata.items.id	SHARE event shared item ids	String
38	edata_items_type	edata.items.type	SHARE item types	String
39	edata_items_origin_id	edata.items.origin.id	SHARE event source id	String
40	edata_items_origin_type	edata.items.origin.type	SHARE event source type	String
41	edata_items_to_id	edata.items.to.id	SHARE event destination id	String
42	edata_items_to_type	edata.items.to.type	SHARE event destination type	String
43	edata_state	edata.state	AUDIT event current state	String
44	edata_prevstate	edata.prevstate	AUDIT event previous state	String
45	edata_size	edata.size	SEARCH event result size	Integer
46	edata_filters_dialcodes	edata.filters.dialcodes	SEARCH event List of dialcodes	Array[String]
47	edata_topn	edata.topn	SEARCH event topn results	Array[Object]
48	edata_visits	edata.visits	IMPRESSION event object visit details	Array[Object]
49	device_loc_state	ldata.state	State location information for the device	String
50	device_loc_state_code	ldata.state_code	State ISO code information for the device	String
51	device_loc_city	ldata.city	City location information for the device	String
52	device_loc_country_code	ldata.country_code	Country ISO code information for the device	String
53	device_loc_country	ldata.country	Country location information for the device	String
54	content_name	name	Name of the content	device_os	device.os	Device OS name	String
55	contentdevice_object_type	objectType	Type of the contentmake	device.make	Device make and model	String
56	contentdevice_typeid	contentType	Type of the resourcedevice.id	Physical device id if available from OS	String
57	contentdevice_media_type	mediaType	Type of the media of the resource	Stringmem	device.mem	Total memory in mb	Int
58	contentdevice_languageidisk	language	List of languages in the content	Array[String]device.idisk	Total interanl disk	Int
59	contentdevice_mediumedisk	meidum	Language medium of the board	Stringdevice.edisk	Total external disk	Int
60	contentdevice_mimetypescrn	mimeType	Mimetype of the resource in the content	Stringdevice.scrn	Screen size in inches	Int
61	contentdevice_frameworkcamera	framework	device.camera	Primary & secondary camera spec	String
62	contentdevice_boardcpu	board	Board of affiliationdevice.cpu	Processor name	String
63	contentdevice_statussimsstatus	device.sims	Status of the content - Draft, Published etc.	StringNumber of sim cards	Int
64	contentdevice_mimetypesua_countspec	mimeTypesCount	Count grouped by mimetypes	JSON Objectua_spec	User agent spec of the browser	Map
65	contentdevice_typesfirst_countaccess	contentTypesCount	Counts grouped by each content type	JSON Objectfirst_access	First access of the device	String
66	content_versionname	versionKeyname	Version Name of the content	DoubleString
67	content_lastobject_submitted_ontype	lastSubmittedOnobjectType	Last submitted date Type of the content	String
68	content_last_published_on	lastPublishedOn	Last submitted date of the contenttype	contentType	Type of the resource	String
69	devicecontent_firstmedia_accesstype	first_access	First access mediaType	Type of the devicemedia of the resource	String
70	devicecontent_speclanguagedevice_spec	language	Specification List of languages in the deviceMapcontent	Array[String]
71	devicecontent_ua_spec	ua_spec	User agent spec of the browser	Mapmedium	meidum	Language medium of the board	String
72	usercontent_first_namemimetype	firstnamemimeType	First name Mimetype of the userresource in the content	String
73	usercontent_last_name	lastname	Lastname of the userframework	framework		String
74	usercontent_grade_list	grade_list	List of grades taught	Array[String]board	board	Board of affiliation	String
75	usercontent_language_list	language_list	List of languages known	Array[String]status	status	Status of the content - Draft, Published etc.	String
76	usercontent_subjectmimetypes_listcount	subject_list	List of subjects taught	Array[String]mimeTypesCount	Count grouped by mimetypes	JSON Object
77	usercontent_nametypes_count	username	Username of the user	StringcontentTypesCount	Counts grouped by each content type	JSON Object
78	usercontent_typeversion	userTypeversionKey	Type Version of userthe content	StringDouble
79	usercontent_last_locsubmitted_stateon	user_state	State info lastSubmittedOn	Last submitted date of the usercontent	String
80	usercontent_last_locpublished_districton	user_district	District info lastPublishedOn	Last submitted date of the usercontent	String
81	user_locfirst_blockname	user_block	Block info firstname	First name of the user	String

Summary Events

82	user_last_name	lastname	Lastname of the user	String
83	user_grade_list	grade_list	List of grades taught	Array[String]
84	user_language_list	language_list	List of languages known	Array[String]
85	user_subject_list	subject_list	List of subjects taught	Array[String]
86	user_name	username	Username of the user	String
87	user_type	userType	Type of user	String
88	user_loc_state	user_state	State info of the user	String
89	user_loc_district	user_district	District info of the user	String
90	user_loc_block	user_block	Block info of the user	String

Summary Events

41424866

	Dimension in Druid	Field in Summary event	Description	Data Type
1	eid	eid	Event Id	String
2	ver	ver	Version	String
3	syncts	syncts	Sync timestamp	Long
4	uid	uid	User Id	String
5	context_date_range_from	context.date_range.from	Start Date for the summary	String
6	context_date_range_to	context.date_range.to	End Date for the summary	String
7	context_rollup_l1	context.rollup.l1	Context level1 rollup	String
8	context_rollup_l2	context.rollup.l2	Context level2 rollup	String
9	context_rollup_l3	context.rollup.l3	Context level3 rollup	String
10	context_rollup_l4	context.rollup.l4	Context level4 rollup	String
11	dimension_channel	dimensions.channel	Channel Id as dimension from raw telemetry	String
12	dimensions_did	dimensions.did	Device Id as dimension from raw telemetry	String
13	dimensions_pdata_id	dimensions.pdata.id	Producer Id as dimension from raw telemetry	String
14	dimensions_pdata_pid	dimensions.pdata.pid	Producer Process Id as dimension from raw telemetry	String
15	dimensions_sid	dimensions.sid	Session Id as dimension	String
16	dimensions_type	dimensions.type	Type of summary	String
17	dimensions_mode	dimensions.mode	Mode of action in the session	String
18	object_id	object.id	Content Id	String
19	object_type	object.type	Content Type	String
20	object_type	object.type	Content Type	String
21	object_version	object.ver	Content version	String
22	object_rollup_l1	object.rollup.l1	Object level1 rollup	String
23	object_rollup_l2	object.rollup.l2	Object level2 rollup	String
24	object_rollup_l3	object.rollup.l3	Object level3 rollup	String
25	object_rollup_l4	object.rollup.l4	Object level4 rollup	String
26	tags	tags	Tags attached to a summary event	Array[String]
27	edata_time_spent	edata.eks.time_spent	Time spent in the session excluding idle time	String
28	edata_time_difference	edata.eks.time_diff	Total time in a session including idle time	String
29	edata_interaction_count	edata.eks.interact_events_count	Total count of interact events in a session	Long
30	edata_summary_env	edata.eks.env_summary.env	High level env within the app (content, domain, resources, community)	String
31	edata_env_summary_count	edata.eks.env_summary.count	Count of times the environment has been visited	Integer
32	edata_env_summary_time_spent	edata.eks.pageenv_summary.time_spent	Time taken spent per pageenv	Double
3733	edata_itempage_responses_itemsummary_id	edata.eks.itempage_responsessummary.itemIdQuestion Id passed in the ASSESS eventid	Page id	String
3834	edata_itempage_responsessummary_time_spenttype	edata.eks.itempage_responsessummary.timeSpentTime spent in seconds from ASSESS eventtype	Type of page e.g. view/edit	String
3935	edata_itempage_summary_responsesvisit_passcount	edata.eks.itempage_responsessummary.passPass response for a question from ASSESS eventvisit_count	Number of times each page was visited	String
4036	edata_itempage_summary_responsestime_scorespent	edata.eks.itempage_responsessummary.score	Score from ASSESS event	Array[Integer]	time_spent	Time taken per page	Double
37	edata_item_responses_maxitem_scoreid	edata.eks.item_responses.maxScoreMax Score from itemId	Question Id passed in the ASSESS event	Array[Integer]	String
38	edata_item_responses_timestamptime_spent	edata.eks.item_responses.time_stamp	Timestamp for each response from ASSESS event	String
43	device_loc_state	ldata.state	State location information for the device	String
44	device_loc_state_code	ldata.state_code	State ISO code information for the device	String
45	device_loc_city	ldata.city	City location information for the device	String
46	device_loc_country_code	ldata.country_code	Country ISO code information for the device	String
47	device_loc_country	ldata.country	Country location information for the device	String
timeSpent	Time spent in seconds from ASSESS event	String
39	edata_item_responses_pass	edata.eks.item_responses.pass	Pass response for a question from ASSESS event	String
40	edata_item_responses_score	edata.eks.item_responses.score	Score from ASSESS event	Array[Integer]
41	edata_item_responses_max_score	edata.eks.item_responses.maxScore	Max Score from ASSESS event	Array[Integer]
42	edata_item_responses_timestamp	edata.eks.item_responses.time_stamp	Timestamp for each response from ASSESS event	String
43	device_loc_state	ldata.state	State location information for the device	String
44	device_loc_state_code	ldata.state_code	State ISO code information for the device	String
45	device_loc_city	ldata.city	City location information for the device	String
46	device_loc_country_code	ldata.country_code	Country ISO code information for the device	String
47	device_loc_country	ldata.country	Country location information for the device	String
48	device_os	device.os	Device OS name	String
49	device_make	device.make	Device make and model	String
50	device_id	device.id	Physical device id if available from OS	String
51	device_mem	device.mem	Total memory in mb	Int
52	device_idisk	device.idisk	Total interanl disk	Int
53	device_edisk	device.edisk	Total external disk	Int
54	device_scrn	device.scrn	Screen size in inches	Int
55	device_camera	device.camera	Primary & secondary camera spec	String
56	device_cpu	device.cpu	Processor name	String
57	device_sims	device.sims	Number of sim cards	Int
58	device_ua_spec	ua_spec	User agent spec of the browser	Map
59	device_first_access	first_access	First access of the device	String
60	content_name	name	Name of the content	String
4961	content_object_type	objectType	Type of the content	String
5062	content_type	contentType	Type of the resource	String
5163	content_media_type	mediaType	Type of media of the content	String
5264	content_language	language	List of languages	Array[String]
5365	content_medium	medium	Language medium of the board	String
5466	content_mimetype	mimeType	Mimetype of the content	String
5567	content_framework	framework		String
5668	content_board	board	Board of affiliation	String
5769	content_status	status	Status of the content - Draft, Published etc.	String
5870	content_mimetypes_count	mimeTypesCount	Count grouped by mimetypes	JSON Object
5971	content_content_types_count	contentTypesCount	Counts grouped by each content type	JSON Object
6072	content_version	versionKey	Version of the content	Double
61	content_last_submitted_on	lastSubmittedOn	Last submitted date of the content	String
62	content_last_published_on	lastPublishedOn	Last submitted date of the content	String
63	device_device_first_access	first_access	First access of the device	String
64	device_spec	device_spec	Specification of the device	Map
65	device_ua_spec	ua_spec	User agent spec of the browser	Map
of the content	Double
73	content_last_submitted_on	lastSubmittedOn	Last submitted date of the content	String
74	content_last_published_on	lastPublishedOn	Last submitted date of the content	String
75	user_first_name	firstname	First name of the user	String
6776	user_last_name	lastname	Last name of the user	String
6877	user_grade_list	grade_list	List of grades taught	Array[String]
6978	user_language_list	language_list	List of languages known	Array[String]
7079	user_subject_list	subject_list	List of subjects taught	Array[String]
7180	user_name	username	User name of the user	String
7281	user_type	usertype	Type of the user	String
7382	user_loc_state	user_state	State info of the user	String
7483	user_loc_district	user_district	District info of the user	String
7584	user_loc_block	user_block	Block info of the user	String

...

Versions Compared

Old Version 17

New Version 18

Key

Druid Data Model

Raw Telemetry

Summary Events

Summary Events