Page Comparison

...

Druid Data Model

Raw Telemetry

Dimension in Druid

Field in Summary event

Description

Data Type

1etsetsEvent timestampLong2

eid

Event Id

String

3

ver

Version

String

4

syncts

Sync timestamp

Long

5

uid

User Id

String

6

context_date_range_from

context.date_range.from

Start Date for the summary

Date

7

context_date_range_to

context.date_range.to

End Date for the summary

Date

8

context_rollup_l1

context.rollup.l1

Context level1 rollup

String

9

context_rollup_l2

context.rollup.l2

Context level2 rollup

String

10

context_rollup_l3

context.rollup.l3

Context level3 rollup

String

11

context_rollup_l4

context.rollup.l4

Context level4 rollup

String

12

dimension_channel

dimensions.channel

Channel Id as dimension from raw telemetry

String

13

dimensions_did

dimensions.did

Device Id as dimension from raw telemetry

String

14

dimensions_pdata_id

dimensions.pdata.id

Producer Id as dimension from raw telemetry

String

15

dimensions_pdata_pid

dimensions.pdata.pid

Producer Process Id as dimension from raw telemetry

String

16dimensions_pdata_verdimensions.pdata.verProducer Process Ver as dimension from raw telemetryString17

dimensions_sid

dimensions.sid

Session Id as dimension

String

18

dimensions_type

dimensions.type

Type of summary

String

19

dimensions_mode

dimensions.mode

Mode of action in the session

String

20

object_id

object.id

Content Id

String

21

object_type

object.type

Content Type

String

22

object_type

object.type

Content Type

String

23

object_version

object.ver

Content version

String

24

object_rollup_l1

object.rollup.l1

Object level1 rollup

String

25

object_rollup_l2

object.rollup.l2

Object level2 rollup

String

26

object_rollup_l3

object.rollup.l3

Object level3 rollup

String

27

object_rollup_l4

object.rollup.l4

Object level4 rollup

String

28

tags

Tags attached to a summary event

Array[String]

29

edata_time_spent

edata.eks.time_spent

Time spent in the session excluding idle time

Double

30

edata_time_difference

edata.eks.time_diff

Total time in a session including idle time

Double

31

edata_interaction_count

edata.eks.interact_events_count

Total count of interact events in a session

Long

32

edata_env_summary_env

edata.eks.env_summary.env

High level env within the app

(content, domain, resources, community)

Array[String]

33

edata_env_summary_count

edata.eks.env_summary.count

Count of times the environment has been visited

Array[Integer]

34

edata_env_summary_time_spent

edata.eks.env_summary.time_spent

Time spent per env

Array[Double]

35

edata_page_summary_id

edata.eks.page_summary.id

Page id

Array[String]

36

edata_page_summary_type

edata.eks.page_summary.type

Type of page e.g. view/edit

Array[String]

37edata_page

	Dimension in Druid	Field in Telemetry	Description	Data Type
1	ets	ets	Event timestamp	Long
2	eid	eid	Event Id	String
3	syncts	syncts	Sync Timestamp	Long
4	actor_id	actor.id	Actor Id of the event	String
5	actor_type	actor.type	Type of the actor	String
6	context_channel	context.channel	Channel Id	String
7	context_pdata_id	context.pdata.id	Producer Id	String
8	context_pdata_pid	context.pdata.pid	Producer Process Id	String
9	context_pdata_ver	context.pdata.ver	Producer version number	String
10	context_env	context.env	Context Environment	String
11	context_sid	context.sid	Session Id	String
12	context_did	context.did	Device Id	String
13	context_cdata_type	context.cdata.type	Correlation Data Type	Array[String]
14	context_cdata_id	context.cdata.id	Correlation Data Id	Array[String]
15	object_id	object.id	Content Id	String
16	object_type	object.type	Content Type	String
17	object_version	object.ver	Content Version	String
18	tags	tags	Tags	Array[String]
19	edata_type	edata.type	Event type	String
20	edata_subtype	edata.subtype	Event subtype	String
21	edata_mode	edata.mode	START event Mode of start	String
22	edata_pageid	edata.pageid	Unique pageid	String
23	edata_uri	edata.uri	IMPRESSION event Relative URI of the content	String
24	edata_id	edata.id	Event data Id	String
25	edata_duration	edata.duration	Duration of the event	Double
26	edata_index	edata.index	ASSESS event Index of the question within a content	String
27	edata_pass	edata.pass	ASSESS event Field to identify pass or fail for assessments	String
28	edata_score	edata.score	ASSESS event Assessment score	Double
29	edata_resvalues	edata.resvalues	ASSESS event Assessment results	Array[Object]
30	edata_item_id	edata.item.id	ASSESS event Assessment item id	String
31	edata_item_title	edata.item.title	ASSESS event Assessment item title	String
32	edata_item_maxscore	edata.item.maxscore	ASSESS event Assessment item max score	Double
33	edata_target_id	edata.target.id	ASSESS event Assessment item target id	String
34	edata_target_type	edata.target.type	ASSESS event Assessment item target type	String
35	edata_rating	edata.rating	FEEDBACK event Ratings	Integer
36	edata_comments	edata.comments	FEEDBACK event Comments	String
37	edata_dir	edata.dir	SHARE event direction	String
38	edata_items_id	edata.items.id	SHARE event shared item ids	Array[String]
39	edata_items_type	edata.items.type	SHARE item types	Array[String]
40	edata_items_origin_id	edata.items.origin.id	SHARE event source id	Array[String]
41	edata_items_origin_type	edata.items.origin.type	SHARE event source type	Array[String]
42	edata_items_to_id	edata.items.to.id	SHARE event destination id	Array[String]
43	edata_items_to_type	edata.items.to.type	SHARE event destination type	Array[String]
44	edata_state	edata.state	AUDIT event current state	String
45	edata_prevstate	edata.prevstate	AUDIT event previous state	String
46	edata_size	edata.size	SEARCH event result size	Integer
47	edata_filters_dialcodes	edata.filters.dialcodes	SEARCH event List of dialcodes	Array[String]
48	edata_topn_identifier	edata.topn.identifier	SEARCH event topn results	Array[String]
49	edata_visits_objid	edata.visits.objid	IMPRESSION event unique id for object visited	Array[String]
50	edata_visits_objtype	edata.visits.objtype	IMPRESSION event type of object visited	Array[String]
51	edata_visits_objver	edata.visits.objver	IMPRESSION event version of object visited	Array[String]
52	edata_visits_index	edata.visits.index	IMPRESSION event index of object within list	Array[Integer]
53	device_loc_state	devicedata.state	State location information for the device	String
54	device_loc_state_code	devicedata.statecode	State ISO code information for the device	String
55	device_loc_city	devicedata.city	City location information for the device	String
56	device_loc_country_code	devicedata.countrycode	Country ISO code information for the device	String
57	device_loc_country	devicedata.country	Country location information for the device	String
58	device_os	devicedata.os	Device OS name	String
59	device_make	devicedata.make	Device make and model	String
60	device_id	devicedata.id	Physical device id if available from OS	String
61	device_mem	devicedata.mem	Total memory in mb	Integer
62	device_idisk	devicedata.idisk	Total interanl disk	Integer
63	device_edisk	devicedata.edisk	Total external disk	Integer
64	device_scrn	devicedata.scrn	Screen size in inches	Integer
65	device_camera	devicedata.camera	Primary & secondary camera spec	String
66	device_cpu	devicedata.cpu	Processor name	String
67	device_sims	devicedata.sims	Number of sim cards	Integer
68	device_uaspec_agent	devicedata.uaspec.agent	User agent of the browser	String
69	device_uaspec_ver	devicedata.uaspec.ver	User agent version of the browser	String
70	device_uaspec_system	devicedata.uaspec.system	User agent system identification of the browser	String
71	device_uaspec_platform	devicedata.uaspec.platform	User agent client platform of the browser	String
72	device_uaspec_raw	devicedata.uaspec.raw	Raw user agent of the browser	String
73	device_first_access	devicedata.firstaccess	First access of the device	DateLong (Epoch)
74	content_name	contentdata.name	Name of the content	String
75	content_object_type	contentdata.objecttype	Type of the content	String
76	content_type	contentdata.contenttype	Type of the resource	String
77	content_media_type	contentdata.mediatype	Type of the media of the resource	String
78	content_language	contentdata.language	List of languages in the content	Array[String]
79	content_medium	contentdata.medium	Language medium of the board	String
80	content_mimetype	contentdata.mimetype	Mimetype of the resource in the content	String
81	content_framework	contentdata.framework		String
82	content_board	contentdata.board	Board of affiliation	String
83	content_status	contentdata.status	Status of the content - Draft, Published etc.	String
84	content_version	contentdata.pkgversion	Version of the content	Double
85	content_last_submitted_on	contentdata.lastsubmittedon	Last submitted date of the content	DateLong (Epoch)
86	content_last_published_on	contentdata.lastpublishedon	Last submitted date of the content	DateLong (Epoch)
87	content_last_updated_on	contentdata.lastupdatedon	Last updated date of the content	DateLong (Epoch)
88	user_first_name	userdata.firstname	First name of the user	String
89	user_last_name	userdata.lastname	Lastname of the user	String
90	user_grade_list	userdata.gradelist	List of grades taught	Array[String]
91	user_language_list	userdata.languagelist	List of languages known	Array[String]
92	user_subject_list	userdata.subjectlist	List of subjects taught	Array[String]
93	user_name	userdata.name	Username of the user	String
94	user_type	userdata.type	Type of user	String
95	user_loc_state	userdata.state	State info of the user	String
96	user_loc_district	userdata.district	District info of the user	String
97	user_loc_block	userdata.block	Block info of the user	String

Summary Events

98	dialcode_channel	dialcode.channel	Channel for which dialcode is generated	String
99	dialcode_batchcode	dialcode.batchcode	Batch for which dialcode belongs to	String
100	dialcode_publisher	dialcode.publisher	Publisher of the dialcode	String
101	dialcode_generated_on	dialcode.generatedon	Dialcode generated on	Long (Epoch)
102	dialcode_published_on	dialcode.publishedon	Dialcode published on	Long (Epoch)
103	dialcode_status	dialcode.status	Status of the dialcode	String
104	dialcode_object_type	dialcode.objecttype	Object type - DialCode as a value	String

Summary Events

pageEnv of page42itemresponsespassitemresponsespassPass response for a question from ASSESS eventString

	Dimension in Druid	Field in Summary event	Description	Data Type
1	ets	ets	Event timestamp	Long
2	eid	eid	Event Id	String
3	ver	ver	Version	String
4	syncts	syncts	Sync timestamp	Long
5	uid	uid	User Id	String
6	context_date_range_from	context.date_range.from	Start Date for the summary	Long (Epoch)
7	context_date_range_to	context.date_range.to	End Date for the summary	Long (Epoch)
8	context_rollup_l1	context.rollup.l1	Context level1 rollup	String
9	context_rollup_l2	context.rollup.l2	Context level2 rollup	String
10	context_rollup_l3	context.rollup.l3	Context level3 rollup	String
11	context_rollup_l4	context.rollup.l4	Context level4 rollup	String
12	dimension_channel	dimensions.channel	Channel Id as dimension from raw telemetry	String
13	dimensions_did	dimensions.did	Device Id as dimension from raw telemetry	String
14	dimensions_pdata_id	dimensions.pdata.id	Producer Id as dimension from raw telemetry	String
15	dimensions_pdata_pid	dimensions.pdata.pid	Producer Process Id as dimension from raw telemetry	String
16	dimensions_pdata_ver	dimensions.pdata.ver	Producer Process Ver as dimension from raw telemetry	String
17	dimensions_sid	dimensions.sid	Session Id as dimension	String
18	dimensions_type	dimensions.type	Type of summary	String
19	dimensions_mode	dimensions.mode	Mode of action in the session	String
20	object_id	object.id	Content Id	String
21	object_type	object.type	Content Type	String
22	object_type	object.type	Content Type	String
23	object_version	object.ver	Content version	String
24	object_rollup_l1	object.rollup.l1	Object level1 rollup	String
25	object_rollup_l2	object.rollup.l2	Object level2 rollup	String
26	object_rollup_l3	object.rollup.l3	Object level3 rollup	String
27	object_rollup_l4	object.rollup.l4	Object level4 rollup	String
28	tags	tags	Tags attached to a summary event	Array[String]
29	edata_time_spent	edata.eks.time_spent	Time spent in the session excluding idle time	Double
30	edata_time_difference	edata.eks.time_diff	Total time in a session including idle time	Double
31	edata_interaction_count	edata.eks.interact_events_count	Total count of interact events in a session	Long
32	edata_env_summary_env	edata.eks.	env_summary.env	High level env within the app (content, domain, resources, community)	Array[String]
3833	edata_pageenv_summary_visit_count	edata.eks.pageenv_summary.visit_count	Number Count of times each page was the environment has been visited	Array[Integer]
3934	edata_pageenv_summary_time_spent	edata.eks.pageenv_summary.time_spent	Time taken spent per pageenv	Array[Double]
4035	edata_itempage_responsessummary_item_id	edata.eks.itempage_responsessummary.itemIdQuestion Id passed in the ASSESS eventid	Page id	Array[String]
4136	edata_itempage_responsessummary_time_spenttype	edata.eks.itempage_responsessummary.timeSpentTime spent in seconds from ASSESS eventtype	Type of page e.g. view/edit	Array[DoubleString]
37	edata_	page_	summary_	env	edata.eks.	page_	summary.	env	Env of page	Array[String]
4338	edata_itempage_summary_responsesvisit_scorecount	edata.eks.itempage_responsessummary.scoreScore from ASSESS eventvisit_count	Number of times each page was visited	Array[Integer]
4439	edata_itempage_responsessummary_maxtime_scorespent	edata.eks.page_summary.time_spent	Time taken per page	Array[Double]
40	edata_item_responses.maxScoreMax Score from _item_id	edata.eks.item_responses.itemId	Question Id passed in the ASSESS event	Array[IntegerString]
4541	edata_item_responses_timestamptime_spent	edata.eks.item_responses.time_stampTimestamp for each response timeSpent	Time spent in seconds from ASSESS event	Array[Date]
46	device_loc_state	devicedata.state	State location information for the device	String
47	device_loc_state_code	devicedata.statecode	State ISO code information for the device	String
48	device_loc_city	devicedata.city	City location information for the device	String
49	device_loc_country_code	devicedata.countrycode	Country ISO code information for the device	String
50	device_loc_country	devicedata.country	Country location information for the device	String
51	device_os	devicedata.os	Device OS name	String
52	device_make	devicedata.make	Device make and model	String
53	device_id	devicedata.id	Physical device id if available from OS	String
54	device_mem	devicedata.mem	Total memory in mb	Integer
55	device_idisk	devicedata.idisk	Total interanl disk	Integer
56	device_edisk	devicedata.edisk	Total external disk	Integer
57	device_scrn	devicedata.scrn	Screen size in inches	Integer
58	device_camera	devicedata.camera	Primary & secondary camera spec	String
59	device_cpu	devicedata.cpu	Processor name	String
60	device_sims	devicedata.sims	Number of sim cards	Integer
61	device_uaspec_agent	devicedata.uaspec.agent	User agent of the browser	String
62	device_uaspec_ver	devicedata.uaspec.ver	User agent version of the browser	String
63	device_uaspec_system	devicedata.uaspec.system	User agent system identification of the browser	String
64	device_uaspec_platform	devicedata.uaspec.platform	User agent client platform of the browser	String
65	device_uaspec_raw	devicedata.uaspec.raw	Raw user agent of the browser	String
66	device_first_access	devicedata.firstaccess	First access of the device	Date
67	content_name	contentdata.name	Name of the content	String
68	content_object_type	contentdata.objecttype	Type of the content	String
69	content_type	contentdata.contenttype	Type of the resource	String
70	content_media_type	contentdata.mediatype	Type of media of the content	String
71	content_language	contentdata.language	List of languages	Array[String]
72	content_medium	contentdata.medium	Language medium of the board	String
73	content_mimetype	contentdata.mimetype	Mimetype of the content	String
74	content_framework	contentdata.framework	String
75	content_board	contentdata.board	Board of affiliation	String
76	content_status	contentdata.status	Status of the content - Draft, Published etc.	String
77	content_version	contentdata.pkgversion	Version of the content	Double
78	content_last_submitted_on	contentdata.lastsubmittedon	Last submitted date of the content	Date
79	content_last_published_on	contentdata.lastpublishedon	Last published date of the content	Date
80	content_last_updated_on	contentdata.lastupdatedon	Last updated date of the content	Date
81	user_first_name	userdata.firstname	First name of the user	String
82	user_last_name	userdata.lastname	Last name of the user	String
83	user_grade_list	userdata.gradelist	List of grades taught	Array[String]
84	user_language_list	userdata.languagelist	List of languages known	Array[String]
85	user_subject_list	userdata.subjectlist	List of subjects taught	Array[String]
86	user_name	userdata.name	User name of the user	String
87	user_type	userdata.type	Type of the user	String
88	user_loc_state	userdata.state	State info of the user	String
89	user_loc_district	userdata.district	District info of the user	String
90	user_loc_block	userdata.block	Block info of the user	Double]
42	edata_item_responses_pass	edata.eks.item_responses.pass	Pass response for a question from ASSESS event	Array[String]
43	edata_item_responses_score	edata.eks.item_responses.score	Score from ASSESS event	Array[Integer]
44	edata_item_responses_max_score	edata.eks.item_responses.maxScore	Max Score from ASSESS event	Array[Integer]
45	edata_item_responses_timestamp	edata.eks.item_responses.time_stamp	Timestamp for each response from ASSESS event	Array[Date]
46	device_loc_state	devicedata.state	State location information for the device	String
47	device_loc_state_code	devicedata.statecode	State ISO code information for the device	String
48	device_loc_city	devicedata.city	City location information for the device	String
49	device_loc_country_code	devicedata.countrycode	Country ISO code information for the device	String
50	device_loc_country	devicedata.country	Country location information for the device	String
51	device_os	devicedata.os	Device OS name	String
52	device_make	devicedata.make	Device make and model	String
53	device_id	devicedata.id	Physical device id if available from OS	String
54	device_mem	devicedata.mem	Total memory in mb	Integer
55	device_idisk	devicedata.idisk	Total interanl disk	Integer
56	device_edisk	devicedata.edisk	Total external disk	Integer
57	device_scrn	devicedata.scrn	Screen size in inches	Integer
58	device_camera	devicedata.camera	Primary & secondary camera spec	String
59	device_cpu	devicedata.cpu	Processor name	String
60	device_sims	devicedata.sims	Number of sim cards	Integer
61	device_uaspec_agent	devicedata.uaspec.agent	User agent of the browser	String
62	device_uaspec_ver	devicedata.uaspec.ver	User agent version of the browser	String
63	device_uaspec_system	devicedata.uaspec.system	User agent system identification of the browser	String
64	device_uaspec_platform	devicedata.uaspec.platform	User agent client platform of the browser	String
65	device_uaspec_raw	devicedata.uaspec.raw	Raw user agent of the browser	String
66	device_first_access	devicedata.firstaccess	First access of the device	Long (Epoch)
67	content_name	contentdata.name	Name of the content	String
68	content_object_type	contentdata.objecttype	Type of the content	String
69	content_type	contentdata.contenttype	Type of the resource	String
70	content_media_type	contentdata.mediatype	Type of media of the content	String
71	content_language	contentdata.language	List of languages	Array[String]
72	content_medium	contentdata.medium	Language medium of the board	String
73	content_mimetype	contentdata.mimetype	Mimetype of the content	String
74	content_framework	contentdata.framework		String
75	content_board	contentdata.board	Board of affiliation	String
76	content_status	contentdata.status	Status of the content - Draft, Published etc.	String
77	content_version	contentdata.pkgversion	Version of the content	Double
78	content_last_submitted_on	contentdata.lastsubmittedon	Last submitted date of the content	Long (Epoch)
79	content_last_published_on	contentdata.lastpublishedon	Last published date of the content	Long (Epoch)
80	content_last_updated_on	contentdata.lastupdatedon	Last updated date of the content	Long (Epoch)
81	user_first_name	userdata.firstname	First name of the user	String
82	user_last_name	userdata.lastname	Last name of the user	String
83	user_grade_list	userdata.gradelist	List of grades taught	Array[String]
84	user_language_list	userdata.languagelist	List of languages known	Array[String]
85	user_subject_list	userdata.subjectlist	List of subjects taught	Array[String]
86	user_name	userdata.name	User name of the user	String
87	user_type	userdata.type	Type of the user	String
88	user_loc_state	userdata.state	State info of the user	String
89	user_loc_district	userdata.district	District info of the user	String
90	user_loc_block	userdata.block	Block info of the user	String
91	dialcode_channel	dialcode.channel	Channel for which dialcode is generated	String
92	dialcode_batchcode	dialcode.batchcode	Batch for which dialcode belongs to	String
93	dialcode_publisher	dialcode.publisher	Publisher of the dialcode	String
94	dialcode_generated_on	dialcode.generatedon	Dialcode generated on	Long (Epoch)
95	dialcode_published_on	dialcode.publishedon	Dialcode published on	Long (Epoch)
96	dialcode_status	dialcode.status	Status of the dialcode	String
97	dialcode_object_type	dialcode.objecttype	Object type - DialCode as a value	String
98

Aggregates

Granularity → DAY

...

Versions Compared

Old Version 25

New Version 26

Key

Druid Data Model

Raw Telemetry

Summary Events

Summary Events

Aggregates