...
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 | @timstamp | @timstamp | Sync Timestamp in String | String | ||||
| 5 | actor_id | actor.id | Actor Id of the event | String | ||||
| 56 | actor_type | actor.type | Type of the actor | String | ||||
| 67 | context_channel | context.channel | Channel Id | String | ||||
| 78 | context_pdata_id | context.pdata.id | Producer Id | String | ||||
| 89 | context_pdata_pid | context.pdata.pid | Producer Process Id | String | ||||
| 910 | context_pdata_ver | context.pdata.ver | Producer version number | String | ||||
| 1011 | context_env | context.env | Context Environment | String | ||||
| 1112 | context_sid | context.sid | Session Id | String | ||||
| 1213 | context_did | context.did | Device Id | String | ||||
| 1314 | context_cdata_type | context.cdata.type | Correlation Data Type | Array[String] | ||||
| 1415 | context_cdata_id | context.cdata.id | Correlation Data Id | Array[String] | 15||||
| 16 | objectcontext_rollup_ | idl1 | objectcontext.rollup. | idContent Idl1 | Context level 1 rollup | String | 16||
| 17 | objectcontext_rollup_ | typel2 | objectcontext.rollup. | typeContent Typel2 | Context level 2 rollup | String | 17||
| 18 | object_version | object.ver | Content Version | String | 18context_rollup_l3 | context.rollup.l3 | Context level 3 rollup | String |
| 19 | context_rollup_l4 | context.rollup.l4 | Context level 4 rollup | String | ||||
| 20 | object_id | object.id | Content Id | String | ||||
| 21 | object_type | object.type | Content Type | String | ||||
| 22 | object_version | object.ver | Content Version | String | ||||
| 23 | object_rollup_l1 | object.rollup.l1 | Content level 1 rollup | String | ||||
| 24 | object_rollup_l2 | object.rollup.l2 | Content level 2 rollup | String | ||||
| 25 | object_rollup_l3 | object.rollup.l3 | Content level 3 rollup | String | ||||
| 26 | object_rollup_l4 | object.rollup.l4 | Content level 4 rollup | String | ||||
| 27 | tags | tags | Tags | Array[String] | ||||
| 1928 | edata_type | edata.type | Event type | String | ||||
| 2029 | edata_subtype | edata.subtype | Event subtype | String | ||||
| 2130 | edata_mode | edata.mode | START event Mode of start | String | ||||
| 2231 | edata_pageid | edata.pageid | Unique pageid | String | ||||
| 2332 | edata_uri | edata.uri | IMPRESSION event Relative URI of the content | String | ||||
| 2433 | edata_id | edata.id | Event data Id | String | ||||
| 2534 | edata_duration | edata.duration | Duration of the event | Double | ||||
| 2635 | edata_index | edata.index | ASSESS event Index of the question within a content | Integer | ||||
| 2736 | edata_pass | edata.pass | ASSESS event Field to identify pass or fail for assessments | String | ||||
| 2837 | edata_score | edata.score | ASSESS event Assessment score | Double | ||||
| 2938 | edata_resvalues | edata.resvalues | ASSESS event Assessment results | Array[Object] | ||||
| 3039 | edata_item_id | edata.item.id | ASSESS event Assessment item id | String | ||||
| 3140 | edata_item_title | edata.item.title | ASSESS event Assessment item title | String | ||||
| 3241 | edata_item_maxscore | edata.item.maxscore | ASSESS event Assessment item max score | Double | ||||
| 3342 | edata_target_id | edata.target.id | ASSESS event Assessment item target id | String | ||||
| 3443 | edata_target_type | edata.target.type | ASSESS event Assessment item target type | String | ||||
| 3544 | edata_rating | edata.rating | FEEDBACK event Ratings | Integer | ||||
| 3645 | edata_comments | edata.comments | FEEDBACK event Comments | String | ||||
| 3746 | edata_dir | edata.dir | SHARE event direction | String | ||||
| 3847 | edata_items_id | edata.items.id | SHARE event shared item ids | Array[String] | ||||
| 3948 | edata_items_type | edata.items.type | SHARE item types | Array[String] | ||||
| 4049 | edata_items_origin_id | edata.items.origin.id | SHARE event source id | Array[String] | ||||
| 4150 | edata_items_origin_type | edata.items.origin.type | SHARE event source type | Array[String] | ||||
| 4251 | edata_items_to_id | edata.items.to.id | SHARE event destination id | Array[String] | ||||
| 4352 | edata_items_to_type | edata.items.to.type | SHARE event destination type | Array[String] | ||||
| 4453 | edata_state | edata.state | AUDIT event current state | String | ||||
| 4554 | edata_prevstate | edata.prevstate | AUDIT event previous state | String | ||||
| 4655 | edata_size | edata.size | SEARCH event result size | Integer | ||||
| 4756 | edata_filters_dialcodes | edata.filters.dialcodes | SEARCH event List of dialcodes | Array[String] | ||||
| 4857 | edata_topn_identifier | edata.topn.identifier | SEARCH event topn results | Array[String] | ||||
| 4958 | edata_visits_objid | edata.visits.objid | IMPRESSION event unique id for object visited | Array[String] | ||||
| 5059 | edata_visits_objtype | edata.visits.objtype | IMPRESSION event type of object visited | Array[String] | ||||
| 5160 | edata_visits_objver | edata.visits.objver | IMPRESSION event version of object visited | Array[String] | ||||
| 5261 | edata_visits_index | edata.visits.index | IMPRESSION event index of object within list | Array[Integer] | 53within list | Array[Integer] | ||
| 62 | device_loc_state | devicedata.state | State location information for the device | String | ||||
| 63 | device_loc_state_code | devicedata.statestatecode | State location ISO code information for the device | String | 54||||
| 64 | device_loc_iso_state_code | devicedata. | statecodeiso3166statecode | State ISO-3166 code information for the device | String | |||
| 5565 | device_loc_city | devicedata.city | City location information for the device | String | ||||
| 5666 | device_loc_country_code | devicedata.countrycode | Country ISO code information for the device | String | ||||
| 5767 | device_loc_country | devicedata.country | Country location information for the device | String | ||||
| 5868 | device_os | devicedata.os | Device OS name | String | ||||
| 5969 | device_make | devicedata.make | Device make and model | String | ||||
| 6070 | device_id | devicedata.id | Physical device id if available from OS | String | ||||
| 6171 | device_mem | devicedata.mem | Total memory in mb | Integer | ||||
| 6272 | device_idisk | devicedata.idisk | Total interanl disk | Integer | ||||
| 6373 | device_edisk | devicedata.edisk | Total external disk | Integer | ||||
| 6474 | device_scrn | devicedata.scrn | Screen size in inches | Integer | ||||
| 6575 | device_camera | devicedata.camera | Primary & secondary camera spec | String | ||||
| 6676 | device_cpu | devicedata.cpu | Processor name | String | ||||
| 6777 | device_sims | devicedata.sims | Number of sim cards | Integer | ||||
| 6878 | device_uaspec_agent | devicedata.uaspec.agent | User agent of the browser | String | ||||
| 6979 | device_uaspec_ver | devicedata.uaspec.ver | User agent version of the browser | String | ||||
| 7080 | device_uaspec_system | devicedata.uaspec.system | User agent system identification of the browser | String | ||||
| 7181 | device_uaspec_platform | devicedata.uaspec.platform | User agent client platform of the browser | String | ||||
| 7282 | device_uaspec_raw | devicedata.uaspec.raw | Raw user agent of the browser | String | ||||
| 7383 | device_first_access | devicedata.firstaccess | First access of the device | Long (Epoch) | ||||
| 7484 | content_name | contentdata.name | Name of the content | String | ||||
| 7585 | content_object_type | contentdata.objecttype | Type of the content | String | ||||
| 7686 | content_type | contentdata.contenttype | Type of the resource | String | ||||
| 7787 | content_media_type | contentdata.mediatype | Type of the media of the resource | String | ||||
| 7888 | content_language | contentdata.language | List of languages in the content | Array[String] | ||||
| 7989 | content_medium | contentdata.medium | Language medium of the board | String | ||||
| 8090 | content_mimetype | contentdata.mimetype | Mimetype of the resource in the content | String | ||||
| 8191 | content_framework | contentdata.framework | String | |||||
| 8292 | content_board | contentdata.board | Board of affiliation | String | ||||
| 8393 | content_status | contentdata.status | Status of the content - Draft, Published etc. | String | ||||
| 8494 | content_version | contentdata.pkgversion | Version of the content | Double | ||||
| 8595 | content_last_submitted_on | contentdata.lastsubmittedon | Last submitted date of the content | Long (Epoch) | ||||
| 8696 | content_last_published_on | contentdata.lastpublishedon | Last submitted date of the content | Long (Epoch) | ||||
| 8797 | content_last_updated_on | contentdata.lastupdatedon | Last updated date of the content | Long (Epoch) | ||||
| 8898 | user_grade_list | userdata.gradelist | List of grades taught | Array[String] | ||||
| 8999 | user_language_list | userdata.languagelist | List of languages known | Array[String] | ||||
| 90100 | user_subject_list | userdata.subjectlist | List of subjects taught | Array[String] | ||||
| 91101 | user_type | userdata.type | Type of user | String | ||||
| 92102 | user_loc_state | userdata.state | State info of the user | String | ||||
| 93103 | user_loc_district | userdata.district | District info of the user | String | ||||
| 94104 | user_loc_block | userdata.block | Block info of the user | String | ||||
| 95105 | dialcode_channel | dialcodedata.channel | Channel for which dialcode is generated | String | ||||
| 96106 | dialcode_batchcode | dialcodedata.batchcode | Batch for which dialcode belongs to | String | ||||
| 97107 | dialcode_publisher | dialcodedata.publisher | Publisher of the dialcode | String | ||||
| 98108 | dialcode_generated_on | dialcodedata.generatedon | Dialcode generated on | Long (Epoch) | ||||
| 99109 | dialcode_published_on | dialcodedata.publishedon | Dialcode published on | Long (Epoch) | ||||
| 100110 | dialcode_status | dialcodedata.status | Status of the dialcode | String | ||||
| 101111 | dialcode_object_type | dialcodedata.objecttype | Object type - DialCode as a value | String |
...
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_version | object.ver | Content version | String |
| 23 | object_rollup_l1 | object.rollup.l1 | Object level1 rollup | String |
| 24 | object_rollup_l2 | object.rollup.l2 | Object level2 rollup | String |
| 25 | object_rollup_l3 | object.rollup.l3 | Object level3 rollup | String |
| 26 | object_rollup_l4 | object.rollup.l4 | Object level4 rollup | String |
| 27 | tags | tags | Tags attached to a summary event | Array[String] |
| 28 | edata_time_spent | edata.eks.time_spent | Time spent in the session excluding idle time | Double |
| 29 | edata_time_difference | edata.eks.time_diff | Total time in a session including idle time | Double |
| 30 | edata_interaction_count | edata.eks.interact_events_count | Total count of interact events in a session | Long |
| 31 | edata_env_summary_env | edata.eks.env_summary.env | High level env within the app (content, domain, resources, community) | Array[String] |
| 32 | edata_env_summary_count | edata.eks.env_summary.count | Count of times the environment has been visited | Array[Integer] |
| 33 | edata_env_summary_time_spent | edata.eks.env_summary.time_spent | Time spent per env | Array[Double] |
| 34 | edata_page_summary_id | edata.eks.page_summary.id | Page id | Array[String] |
| 35 | edata_page_summary_type | edata.eks.page_summary.type | Type of page e.g. view/edit | Array[String] |
| 36 | edata_page_summary_env | edata.eks.page_summary.env | Env of page | Array[String] |
| 37 | edata_page_summary_visit_count | edata.eks.page_summary.visit_count | Number of times each page was visited | Array[Integer] |
| 38 | edata_page_summary_time_spent | edata.eks.page_summary.time_spent | Time taken per page | Array[Double] |
| 39 | edata_item_responses_item_id | edata.eks.item_responses.itemId | Question Id passed in the ASSESS event | Array[String] |
| 40 | edata_item_responses_time_spent | edata.eks.item_responses.timeSpent | Time spent in seconds from ASSESS event | Array[Double] |
| 41 | edata_item_responses_pass | edata.eks.item_responses.pass | Pass response for a question from ASSESS event | Array[String] |
| 42 | edata_item_responses_score | edata.eks.item_responses.score | Score from ASSESS event | Array[Integer] |
| 43 | edata_item_responses_max_score | edata.eks.item_responses.maxScore | Max Score from ASSESS event | Array[Integer] |
| 44 | edata_item_responses_timestamp | edata.eks.item_responses.time_stamp | Timestamp for each response from ASSESS event | Array[Long (Epoch)] |
| 45 | device_loc_state | devicedata.state | State location information for the device | String |
| 46 | device_loc_state_code | devicedata.statecode | State ISO code information for the device | String |
| 47 | device_loc_iso_state_code | devicedata.iso3166statecode | State ISO-3166 code information for the device | String |
| 48 | device_loc_city | devicedata.city | City location information for the device | String |
| 4849 | device_loc_country_code | devicedata.countrycode | Country ISO code information for the device | String |
| 4950 | device_loc_country | devicedata.country | Country location information for the device | String |
| 5051 | device_os | devicedata.os | Device OS name | String |
| 5152 | device_make | devicedata.make | Device make and model | String |
| 5253 | device_id | devicedata.id | Physical device id if available from OS | String |
| 5354 | device_mem | devicedata.mem | Total memory in mb | Integer |
| 5455 | device_idisk | devicedata.idisk | Total interanl disk | Integer |
| 5556 | device_edisk | devicedata.edisk | Total external disk | Integer |
| 5657 | device_scrn | devicedata.scrn | Screen size in inches | Integer |
| 5758 | device_camera | devicedata.camera | Primary & secondary camera spec | String |
| 5859 | device_cpu | devicedata.cpu | Processor name | String |
| 5960 | device_sims | devicedata.sims | Number of sim cards | Integer |
| 6061 | device_uaspec_agent | devicedata.uaspec.agent | User agent of the browser | String |
| 6162 | device_uaspec_ver | devicedata.uaspec.ver | User agent version of the browser | String |
| 6263 | device_uaspec_system | devicedata.uaspec.system | User agent system identification of the browser | String |
| 6364 | device_uaspec_platform | devicedata.uaspec.platform | User agent client platform of the browser | String |
| 6465 | device_uaspec_raw | devicedata.uaspec.raw | Raw user agent of the browser | String |
| 6566 | device_first_access | devicedata.firstaccess | First access of the device | Long (Epoch) |
| 6667 | content_name | contentdata.name | Name of the content | String |
| 6768 | content_object_type | contentdata.objecttype | Type of the content | String |
| 6869 | content_type | contentdata.contenttype | Type of the resource | String |
| 6970 | content_media_type | contentdata.mediatype | Type of media of the content | String |
| 7071 | content_language | contentdata.language | List of languages | Array[String] |
| 7172 | content_medium | contentdata.medium | Language medium of the board | String |
| 7273 | content_mimetype | contentdata.mimetype | Mimetype of the content | String |
| 7374 | content_framework | contentdata.framework | String | |
| 7475 | content_board | contentdata.board | Board of affiliation | String |
| 7576 | content_status | contentdata.status | Status of the content - Draft, Published etc. | String |
| 7677 | content_version | contentdata.pkgversion | Version of the content | Double |
| 7778 | content_last_submitted_on | contentdata.lastsubmittedon | Last submitted date of the content | Long (Epoch) |
| 7879 | content_last_published_on | contentdata.lastpublishedon | Last published date of the content | Long (Epoch) |
| 7980 | content_last_updated_on | contentdata.lastupdatedon | Last updated date of the content | Long (Epoch) |
| 8081 | user_grade_list | userdata.gradelist | List of grades taught | Array[String] |
| 8182 | user_language_list | userdata.languagelist | List of languages known | Array[String] |
| 8283 | user_subject_list | userdata.subjectlist | List of subjects taught | Array[String] |
| 8384 | user_type | userdata.type | Type of the user | String |
| 8485 | user_loc_state | userdata.state | State info of the user | String |
| 8586 | user_loc_district | userdata.district | District info of the user | String |
| 8687 | user_loc_block | userdata.block | Block info of the user | String |
...