...
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 | StringDouble | ||||||
| 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 | StringInteger | ||||||
| 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[ObjectString] | ||||||
| 49 | edata_visits_objid | edata.visits.objid | IMPRESSION event unique id for object visit detailsvisited | Array[ObjectString] | ||||||
| 50 | deviceedata_ | locvisits_ | stateobjtype | ldataedata.visits. | stateState location information for the device | String | 51 | 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 | ldata.state | State location information for the device | String | ||||||
| 54 | device_loc_state_code | ldata.state_code | State ISO code information for the device | String | ||||||
| 5255 | device_loc_city | ldata.city | City location information for the device | String | ||||||
| 5356 | device_loc_country_code | ldata.country_code | Country ISO code information for the device | String | ||||||
| 5457 | device_loc_country | ldata.country | Country location information for the device | String | ||||||
| 5558 | device_os | device.os | Device OS name | String | ||||||
| 5659 | device_make | device.make | Device make and model | String | ||||||
| 5760 | device_id | device.id | Physical device id if available from OS | String | ||||||
| 5861 | device_mem | device.mem | Total memory in mb | IntInteger | ||||||
| 5962 | device_idisk | device.idisk | Total interanl disk | IntInteger | ||||||
| 6063 | device_edisk | device.edisk | Total external disk | IntInteger | ||||||
| 6164 | device_scrn | device.scrn | Screen size in inches | IntInteger | ||||||
| 6265 | device_camera | device.camera | Primary & secondary camera spec | String | ||||||
| 6366 | device_cpu | device.cpu | Processor name | String | ||||||
| 6467 | device_sims | device.sims | Number of sim cards | IntInteger | ||||||
| 6568 | device_ua_spec | ua_spec | User agent spec of the browser | Map | ||||||
| 6669 | device_first_access | first_access | First access of the device | StringDate | ||||||
| 6770 | content_name | name | Name of the content | String | ||||||
| 6871 | content_object_type | objectType | Type of the content | String | ||||||
| 6972 | content_type | contentType | Type of the resource | String | ||||||
| 7073 | content_media_type | mediaType | Type of the media of the resource | String | ||||||
| 7174 | content_language | language | List of languages in the content | Array[String] | ||||||
| 7275 | content_medium | meidum | Language medium of the board | String | ||||||
| 7376 | content_mimetype | mimeType | Mimetype of the resource in the content | String | ||||||
| 7477 | content_framework | framework | String | |||||||
| 7578 | content_board | board | Board of affiliation | String | ||||||
| 7679 | content_status | status | Status of the content - Draft, Published etc. | String | ||||||
| 7780 | content_mimetypes_count | mimeTypesCount | Count grouped by mimetypes | JSON Object | ||||||
| 78 | content_types_count | contentTypesCount | Counts grouped by each content type | JSON Object | ||||||
| 79 | content_version | versionKey | Version of the content | Double | ||||||
| 8081 | content_last_submitted_on | lastSubmittedOn | Last submitted date of the content | StringDate | ||||||
| 8182 | content_last_published_on | lastPublishedOn | Last submitted date of the content | StringDate | ||||||
| 8283 | user_first_name | firstname | First name of the user | String | ||||||
| 8384 | user_last_name | lastname | Lastname of the user | String | ||||||
| 8485 | user_grade_list | grade_list | List of grades taught | Array[String] | ||||||
| 8586 | user_language_list | language_list | List of languages known | Array[String] | ||||||
| 8687 | user_subject_list | subject_list | List of subjects taught | Array[String] | ||||||
| 8788 | user_name | username | Username of the user | String | ||||||
| 8889 | user_type | userType | Type of user | String | ||||||
| 8990 | user_loc_state | user_state | State info of the user | String | ||||||
| 9091 | user_loc_district | user_district | District info of the user | String | ||||||
| 9192 | user_loc_block | user_block | Block info of the user | 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 | StringDate | |||||
| 7 | context_date_range_to | context.date_range.to | End Date for the summary | StringDate | |||||
| 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 | |||||
| 1718 | dimensions_type | dimensions.type | Type of summary | String | |||||
| 1819 | dimensions_mode | dimensions.mode | Mode of action in the session | String | |||||
| 1920 | object_id | object.id | Content Id | String | |||||
| 2021 | object_type | object.type | Content Type | String | |||||
| 2122 | object_type | object.type | Content Type | String | |||||
| 2223 | object_version | object.ver | Content version | String | |||||
| 2324 | object_rollup_l1 | object.rollup.l1 | Object level1 rollup | String | |||||
| 2425 | object_rollup_l2 | object.rollup.l2 | Object level2 rollup | String | |||||
| 2526 | object_rollup_l3 | object.rollup.l3 | Object level3 rollup | String | |||||
| 2627 | object_rollup_l4 | object.rollup.l4 | Object level4 rollup | String | |||||
| 2728 | tags | tags | Tags attached to a summary event | Array[String] | |||||
| 2829 | edata_time_spent | edata.eks.time_spent | Time spent in the session excluding idle time | StringDouble | |||||
| 2930 | edata_time_difference | edata.eks.time_diff | Total time in a session including idle time | StringDouble | |||||
| 3031 | edata_interaction_count | edata.eks.interact_events_count | Total count of interact events in a session | Long | |||||
| 3132 | edata_env_summary_env | edata.eks.env_summary.env | High level env within the app (content, domain, resources, community) | Array[String] | |||||
| 3233 | edata_env_summary_count | edata.eks.env_summary.count | Count of times the environment has been visited | Array[Integer] | |||||
| 3334 | edata_env_summary_time_spent | edata.eks.env_summary.time_spent | Time spent per env | Array[Double] | |||||
| 3435 | edata_page_summary_id | edata.eks.page_summary.id | Page id | Array[String] | |||||
| 3536 | edata_page_summary_type | edata.eks.page_summary.type | Type of page e.g. view/edit | Array[String | 36] | ||||
| 37 | edata_page_summary_env | edata.eks.page_summary.env | Env of page | Array[String] | |||||
| 38 | edata_page_summary_visit_count | edata.eks.page_summary.visit_count | Number of times each page was visited | String | 37Array[Integer] | ||||
| 39 | edata_page_summary_time_spent | edata.eks.page_summary.time_spent | Time taken per page | Array[Double] | |||||
| 3840 | edata_item_responses_item_id | edata.eks.item_responses.itemId | Question Id passed in the ASSESS event | Array[String] | |||||
| 3941 | edata_item_responses_time_spent | edata.eks.item_responses.timeSpent | Time spent in seconds from ASSESS event | String | 40Array[Double] | ||||
| 42 | edata_item_responses_pass | edata.eks.item_responses.pass | Pass response for a question from ASSESS event | Array[String] | |||||
| 4143 | edata_item_responses_score | edata.eks.item_responses.score | Score from ASSESS event | Array[Integer] | |||||
| 4244 | edata_item_responses_max_score | edata.eks.item_responses.maxScore | Max Score from ASSESS event | Array[Integer] | |||||
| 4345 | edata_item_responses_timestamp | edata.eks.item_responses.time_stamp | Timestamp for each response from ASSESS event | String | 44Array[Date] | ||||
| 46 | device_loc_state | ldata.state | State location information for the device | String | |||||
| 4547 | device_loc_state_code | ldata.state_code | State ISO code information for the device | String | |||||
| 4648 | device_loc_city | ldata.city | City location information for the device | String | |||||
| 4749 | device_loc_country_code | ldata.country_code | Country ISO code information for the device | String | |||||
| 4850 | device_loc_country | ldata.country | Country location information for the device | String | |||||
| 4951 | device_os | device.os | Device OS name | String | |||||
| 5052 | device_make | device.make | Device make and model | String | |||||
| 5153 | device_id | device.id | Physical device id if available from OS | String | |||||
| 5254 | device_mem | device.mem | Total memory in mb | IntInteger | |||||
| 5355 | device_idisk | device.idisk | Total interanl disk | IntInteger | |||||
| 5456 | device_edisk | device.edisk | Total external disk | IntInteger | |||||
| 5557 | device_scrn | device.scrn | Screen size in inches | IntInteger | |||||
| 5658 | device_camera | device.camera | Primary & secondary camera spec | String | |||||
| 5759 | device_cpu | device.cpu | Processor name | String | |||||
| 5860 | device_sims | device.sims | Number of sim cards | IntInteger | |||||
| 5961 | device_ua_spec | ua_spec | User agent spec of the browser | Map | |||||
| 6062 | device_first_access | first_access | First access of the device | StringDate | |||||
| 6163 | content_name | name | Name of the content | String | |||||
| 6264 | content_object_type | objectType | Type of the content | String | |||||
| 6365 | content_type | contentType | Type of the resource | String | |||||
| 6466 | content_media_type | mediaType | Type of media of the content | String | |||||
| 6567 | content_language | language | List of languages | Array[String] | |||||
| 6668 | content_medium | medium | Language medium of the board | String | |||||
| 6769 | content_mimetype | mimeType | Mimetype of the content | String | |||||
| 6870 | content_framework | framework | String | ||||||
| 6971 | content_board | board | Board of affiliation | String | |||||
| 7072 | content_status | status | Status of the content - Draft, Published etc. | String | 71content_mimetypes_count | mimeTypesCount | Count grouped by mimetypes | JSON Object | |
| 72 | content_content_types_count | contentTypesCount | Counts grouped by each content type | JSON Object | |||||
| 73 | content_version | versionKey | Version of the content | Double | |||||
| 74 | content_last_submitted_on | lastSubmittedOn | Last submitted date of the content | StringDate | |||||
| 75 | content_last_published_on | lastPublishedOn | Last submitted date of the content | StringDate | |||||
| 76 | user_first_name | firstname | First name of the user | String | |||||
| 77 | user_last_name | lastname | Last name of the user | String | |||||
| 78 | user_grade_list | grade_list | List of grades taught | Array[String] | |||||
| 79 | user_language_list | language_list | List of languages known | Array[String] | |||||
| 80 | user_subject_list | subject_list | List of subjects taught | Array[String] | |||||
| 81 | user_name | username | User name of the user | String | |||||
| 82 | user_type | usertype | Type of the user | String | |||||
| 83 | user_loc_state | user_state | State info of the user | String | |||||
| 84 | user_loc_district | user_district | District info of the user | String | |||||
| 85 | user_loc_block | user_block | Block info of the user | String |
...