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]
91user_language_listuserdata.languagelistList of languages knownArray[String]
92user_subject_listuserdata.subjectlistList of subjects taughtArray[String]
93user_nameuserdata.nameUsername of the userString
94user_typeuserdata.typeType of userString
95user_loc_stateuserdata.stateState info of the userString
96user_loc_districtuserdata.districtDistrict info of the userString
97user_loc_blockuserdata.blockBlock info of the userString
98dialcode_channeldialcodedialcodedata.channelChannel for which dialcode is generatedString
99dialcode_batchcodedialcodedialcodedata.batchcodeBatch for which dialcode belongs toString
100dialcode_publisherdialcodedialcodedata.publisherPublisher of the dialcodeString
101dialcode_generated_ondialcodedialcodedata.generatedonDialcode generated onLong (Epoch)
102dialcode_published_ondialcodedialcodedata.publishedonDialcode published onLong (Epoch)
103dialcode_statusdialcodedialcodedata.statusStatus of the dialcodeString
104dialcode_object_typedialcodedialcodedata.objecttypeObject type - DialCode as a valueString

...

98


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

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]

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_summary_envedata.eks.page_summary.envEnv of pageArray[String]
38

edata_page_summary_visit_count

edata.eks.page_summary.visit_count

Number of times each page was visited

Array[Integer]

39

edata_page_summary_time_spent

edata.eks.page_summary.time_spent

Time taken per page

Array[Double]

40

edata_item_responses_item_id

edata.eks.item_responses.itemId

Question Id passed in the ASSESS event

Array[String]

41

edata_item_responses_time_spent

edata.eks.item_responses.timeSpent

Time spent in seconds from ASSESS event

Array[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[DateLong (Epoch)]

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

51device_osdevicedata.osDevice OS nameString
52device_makedevicedata.makeDevice make and modelString
53device_iddevicedata.idPhysical device id if available from OSString
54device_memdevicedata.memTotal memory in mbInteger
55device_idiskdevicedata.idiskTotal interanl diskInteger
56device_ediskdevicedata.ediskTotal external diskInteger
57device_scrndevicedata.scrnScreen size in inchesInteger
58device_cameradevicedata.cameraPrimary & secondary camera specString
59device_cpudevicedata.cpuProcessor nameString
60device_simsdevicedata.simsNumber of sim cardsInteger
61device_uaspec_agentdevicedata.uaspec.agentUser agent of the browserString
62device_uaspec_verdevicedata.uaspec.verUser agent version of the browserString
63device_uaspec_systemdevicedata.uaspec.systemUser agent system identification of the browserString
64device_uaspec_platformdevicedata.uaspec.platformUser agent client platform of the browserString
65device_uaspec_rawdevicedata.uaspec.rawRaw user agent of the browserString
66device_first_accessdevicedata.firstaccessFirst access of the deviceLong (Epoch)
67content_namecontentdata.nameName of the contentString
68content_object_typecontentdata.objecttypeType of the contentString
69content_typecontentdata.contenttypeType of the resourceString
70content_media_typecontentdata.mediatypeType of media of the contentString
71content_languagecontentdata.languageList of languagesArray[String]
72content_mediumcontentdata.mediumLanguage medium of the boardString
73content_mimetypecontentdata.mimetypeMimetype of the contentString
74content_frameworkcontentdata.framework
String
75content_boardcontentdata.boardBoard of affiliationString
76content_statuscontentdata.statusStatus of the content - Draft, Published etc.String
77content_versioncontentdata.pkgversionVersion of the contentDouble
78content_last_submitted_oncontentdata.lastsubmittedonLast submitted date of the contentLong (Epoch)
79content_last_published_oncontentdata.lastpublishedonLast published date of the contentLong (Epoch)
80content_last_updated_oncontentdata.lastupdatedonLast updated date of the contentLong (Epoch)
81user_first_nameuserdata.firstnameFirst name of the userString
82user_last_nameuserdata.lastnameLast name of the userString
83user_grade_listuserdata.gradelistList of grades taughtArray[String]
84user_language_listuserdata.languagelistList of languages knownArray[String]
85user_subject_listuserdata.subjectlistList of subjects taughtArray[String]
86user_nameuserdata.nameUser name of the userString
87user_typeuserdata.typeType of the userString
88user_loc_stateuserdata.stateState info of the userString
89user_loc_districtuserdata.districtDistrict info of the userString
90user_loc_blockuserdata.blockBlock info of the userString
91dialcode_channeldialcode.channelChannel for which dialcode is generatedString
92dialcode_batchcodedialcode.batchcodeBatch for which dialcode belongs toString
93dialcode_publisherdialcode.publisherPublisher of the dialcodeString
94dialcode_generated_ondialcode.generatedonDialcode generated onLong (Epoch)
95dialcode_published_ondialcode.publishedonDialcode published onLong (Epoch)
96dialcode_statusdialcode.statusStatus of the dialcodeString
97dialcode_object_typedialcode.objecttypeObject type - DialCode as a valueString
Aggregates

Granularity → DAY

...