Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


Dimension in Druid

Field in Telemetry

Description

Data Type

1etsetsEvent timestampLong
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

9context_pdata_vercontext.pdata.verProducer version numberString
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]

48edata_topn_identifieredata.topn.identifierSEARCH event topn resultsArray[String]
49edata_visits_objidedata.visits.objidIMPRESSION event unique id for object visitedArray[String]
50edata_visits_objtypeedata.visits.objtypeIMPRESSION event type of object visitedArray[String]
51edata_visits_objveredata.visits.objverIMPRESSION event version of object visitedArray[String]
52edata_visits_indexedata.visits.indexIMPRESSION event index of object within listArray[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

58device_osdevicedata.osDevice OS nameString
59device_makedevicedata.makeDevice make and modelString
60device_iddevicedata.idPhysical device id if available from OSString
61device_memdevicedata.memTotal memory in mbInteger
62device_idiskdevicedata.idiskTotal interanl diskInteger
63device_ediskdevicedata.ediskTotal external diskInteger
64device_scrndevicedata.scrnScreen size in inchesInteger
65device_cameradevicedata.cameraPrimary & secondary camera specString
66device_cpudevicedata.cpuProcessor nameString
67device_simsdevicedata.simsNumber of sim cardsInteger
68device_uaspec_agentdevicedata.uaspec.agentUser agent of the browserString
69device_uaspec_verdevicedata.uaspec.verUser agent version of the browserString
70device_uaspec_systemdevicedata.uaspec.systemUser agent system identification of the browserString
71device_uaspec_platformdevicedata.uaspec.platformUser agent client platform of the browserString
72device_uaspec_rawdevicedata.uaspec.rawRaw user agent of the browserString
73device_first_accessdevicedata.firstaccessFirst access of the deviceLong (Epoch)
74content_namecontentdata.nameName of the contentString
75content_object_typecontentdata.objecttypeType of the contentString
76content_typecontentdata.contenttypeType of the resourceString
77content_media_typecontentdata.mediatypeType of the media of the resourceString
78content_languagecontentdata.languageList of languages in the contentArray[String]
79content_mediumcontentdata.mediumLanguage medium of the boardString
80content_mimetypecontentdata.mimetypeMimetype of the resource in the contentString
81content_frameworkcontentdata.framework
String
82content_boardcontentdata.boardBoard of affiliationString
83content_statuscontentdata.statusStatus of the content - Draft, Published etc.String
84content_versioncontentdata.pkgversionVersion of the contentDouble
85content_last_submitted_oncontentdata.lastsubmittedonLast submitted date of the contentLong (Epoch)
86content_last_published_oncontentdata.lastpublishedonLast submitted date of the contentLong (Epoch)
87content_last_updated_oncontentdata.lastupdatedonLast updated date of the contentLong (Epoch)
88user_first_nameuserdata.firstnameFirst name of the userString
89user_last_nameuserdata.lastnameLastname of the userString
90user_grade_listuserdata.gradelistList of grades taughtArray[String]
9189user_language_listuserdata.languagelistList of languages knownArray[String]
9290user_subject_listuserdata.subjectlistList of subjects taughtArray[String]
9391user_nameuserdata.nameUsername of the userString94user_typeuserdata.typeType of userString
9592user_loc_stateuserdata.stateState info of the userString
9693user_loc_districtuserdata.districtDistrict info of the userString
9794user_loc_blockuserdata.blockBlock info of the userString
9895dialcode_channeldialcodedata.channelChannel for which dialcode is generatedString
9996dialcode_batchcodedialcodedata.batchcodeBatch for which dialcode belongs toString
10097dialcode_publisherdialcodedata.publisherPublisher of the dialcodeString
10198dialcode_generated_ondialcodedata.generatedonDialcode generated onLong (Epoch)
10299dialcode_published_ondialcodedata.publishedonDialcode published onLong (Epoch)
103100dialcode_statusdialcodedata.statusStatus of the dialcodeString
104101dialcode_object_typedialcodedata.objecttypeObject type - DialCode as a valueString

...


Dimension in Druid

Field in Summary event

Description

Data Type

1etsetsEvent timestampLong
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

16dimensions_pdata_verdimensions.pdata.verProducer Process Ver as dimension from raw telemetryString
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

2423

object_rollup_l1

object.rollup.l1

Object level1 rollup

String

2524

object_rollup_l2

object.rollup.l2

Object level2 rollup

String

2625

object_rollup_l3

object.rollup.l3

Object level3 rollup

String

2726

object_rollup_l4

object.rollup.l4

Object level4 rollup

String

2827

tags

tags

Tags attached to a summary event

Array[String]

2928

edata_time_spent

edata.eks.time_spent

Time spent in the session excluding idle time

Double

3029

edata_time_difference

edata.eks.time_diff

Total time in a session including idle time

Double

3130

edata_interaction_count

edata.eks.interact_events_count

Total count of interact events in a session

Long

3231

edata_env_summary_env

edata.eks.env_summary.env

High level env within the app

(content, domain, resources, community)

Array[String]

3332

edata_env_summary_count

edata.eks.env_summary.count

Count of times the environment has been visited

Array[Integer]

3433

edata_env_summary_time_spent

edata.eks.env_summary.time_spent

Time spent per env

Array[Double]

3534

edata_page_summary_id

edata.eks.page_summary.id

Page id

Array[String]

3635

edata_page_summary_type

edata.eks.page_summary.type

Type of page e.g. view/edit

Array[String]

3736edata_page_summary_envedata.eks.page_summary.envEnv of pageArray[String]
3837

edata_page_summary_visit_count

edata.eks.page_summary.visit_count

Number of times each page was visited

Array[Integer]

3938

edata_page_summary_time_spent

edata.eks.page_summary.time_spent

Time taken per page

Array[Double]

4039

edata_item_responses_item_id

edata.eks.item_responses.itemId

Question Id passed in the ASSESS event

Array[String]

4140

edata_item_responses_time_spent

edata.eks.item_responses.timeSpent

Time spent in seconds from ASSESS event

Array[Double]

4241

edata_item_responses_pass

edata.eks.item_responses.pass

Pass response for a question from ASSESS event

Array[String]

4342

edata_item_responses_score

edata.eks.item_responses.score

Score from ASSESS event

Array[Integer]

4443

edata_item_responses_max_score

edata.eks.item_responses.maxScore

Max Score from ASSESS event

Array[Integer]

4544

edata_item_responses_timestamp

edata.eks.item_responses.time_stamp

Timestamp for each response from ASSESS event

Array[Long (Epoch)]

4645

device_loc_state

devicedata.state

State location information for the device

String

4746

device_loc_state_code

devicedata.statecode

State ISO code information for the device

String

4847

device_loc_city

devicedata.city

City location information for the device

String

4948

device_loc_country_code

devicedata.countrycode

Country ISO code information for the device

String

5049

device_loc_country

devicedata.country

Country location information for the device

String

5150device_osdevicedata.osDevice OS nameString
5251device_makedevicedata.makeDevice make and modelString
5352device_iddevicedata.idPhysical device id if available from OSString
5453device_memdevicedata.memTotal memory in mbInteger
5554device_idiskdevicedata.idiskTotal interanl diskInteger
5655device_ediskdevicedata.ediskTotal external diskInteger
5756device_scrndevicedata.scrnScreen size in inchesInteger
5857device_cameradevicedata.cameraPrimary & secondary camera specString
5958device_cpudevicedata.cpuProcessor nameString
6059device_simsdevicedata.simsNumber of sim cardsInteger
6160device_uaspec_agentdevicedata.uaspec.agentUser agent of the browserString
6261device_uaspec_verdevicedata.uaspec.verUser agent version of the browserString
6362device_uaspec_systemdevicedata.uaspec.systemUser agent system identification of the browserString
6463device_uaspec_platformdevicedata.uaspec.platformUser agent client platform of the browserString
6564device_uaspec_rawdevicedata.uaspec.rawRaw user agent of the browserString
6665device_first_accessdevicedata.firstaccessFirst access of the deviceLong (Epoch)
6766content_namecontentdata.nameName of the contentString
6867content_object_typecontentdata.objecttypeType of the contentString
6968content_typecontentdata.contenttypeType of the resourceString
7069content_media_typecontentdata.mediatypeType of media of the contentString
7170content_languagecontentdata.languageList of languagesArray[String]
7271content_mediumcontentdata.mediumLanguage medium of the boardString
7372content_mimetypecontentdata.mimetypeMimetype of the contentString
7473content_frameworkcontentdata.framework
String
7574content_boardcontentdata.boardBoard of affiliationString
7675content_statuscontentdata.statusStatus of the content - Draft, Published etc.String
7776content_versioncontentdata.pkgversionVersion of the contentDouble
7877content_last_submitted_oncontentdata.lastsubmittedonLast submitted date of the contentLong (Epoch)
7978content_last_published_oncontentdata.lastpublishedonLast published date of the contentLong (Epoch)
8079content_last_updated_oncontentdata.lastupdatedonLast updated date of the contentLong (Epoch)
8180user_first_nameuserdata.firstnameFirst name of the userString
82user_last_nameuserdata.lastnameLast name of the userString
83user_grade_listuserdata.gradelistList of grades taughtArray[String]
8481user_language_listuserdata.languagelistList of languages knownArray[String]
8582user_subject_listuserdata.subjectlistList of subjects taughtArray[String]
8683user_nameuserdata.nameUser name of the userString87user_typeuserdata.typeType of the userString
8884user_loc_stateuserdata.stateState info of the userString
8985user_loc_districtuserdata.districtDistrict info of the userString
9086user_loc_blockuserdata.blockBlock info of the userString

...