...
Dimension in Druid | Field in Summary event | Description | Data Type | |
|---|---|---|---|---|
| 1 | eid | eid | Event Id | String |
| 2 | ver | ver | Version | String |
| 3 | syncts | syncts | Sync timestamp | Long |
| 4 | uid | uid | User Id | String |
| 5 | context_date_range_from | context.date_range.from | Start Date for the summary | String |
| 6 | context_date_range_to | context.date_range.to | End Date for the summary | String |
| 7 | context_rollup_l1 | context.rollup.l1 | Context level1 rollup | String |
| 8 | context_rollup_l2 | context.rollup.l2 | Context level2 rollup | String |
| 9 | context_rollup_l3 | context.rollup.l3 | Context level3 rollup | String |
| 10 | context_rollup_l4 | context.rollup.l4 | Context level4 rollup | String |
| 11 | channel_id | dimensions.channel | Channel Id as dimension from raw telemetry | String |
| 12 | device_id | dimensions.did | Device Id as dimension from raw telemetry | String |
| 13 | producer_id | dimensions.pdata.id | Producer Id as dimension from raw telemetry | String |
| 14 | producer_pid | dimensions.pdata.pid | Producer Process Id as dimension from raw telemetry | String |
| 15 | session_id | dimensions.sid | Session Id as dimension | String |
| 16 | session_type | dimension.type | Type of summary | String |
| 17 | session_mode | dimension.mode | Mode of action in the session | String |
| 18 | object_id | object.id | Content Id | String |
| 19 | object_type | object.type | Content Type | String |
| 20 | object_type | object.type | Content Type | String |
| 21 | object_version | object.ver | Content version | String |
| 22 | object_rollup_l1 | object.rollup.l1 | Object level1 rollup | String |
| 23 | object_rollup_l2 | object.rollup.l2 | Object level2 rollup | String |
| 24 | object_rollup_l3 | object.rollup.l3 | Object level3 rollup | String |
| 25 | object_rollup_l4 | object.rollup.l4 | Object level4 rollup | String |
| 26 | tags | tags | Tags attached to a summary event | Array[String] |
| 27 | time_spent | edata.eks.time_spent | Time spent in the session excluding idle time | String |
| 28 | time_difference | edata.eks.time_diff | Total time in a session including idle time | String |
| 29 | interaction_count | edata.eks.interact_events_count | Total count of interact events in a session | Long |
| 30 | summary_env | edata.eks.env_summary.env | High level env within the app (content, domain, resources, community) | String |
| 31 | summary_env_count | edata.eks.env_summary.count | Count of times the environment has been visited | Integer |
| 32 | summary_env_time_spent | edata.eks.env_summary.time_spent | Time spent per env | Double |
| 33 | summary_page_id | edata.eks.page_summary.id | Page id | String |
| 34 | summary_page_type | edata.eks.page_summary.type | Type of page e.g. view/edit | String |
| 35 | summary_page_visit_count | edata.eks.page_summary.visit_count | Number of times each page was visited | String |
| 36 | summary_page_time_spent | edata.eks.page_summary.time_spent | Time taken per page | Double |
| 37 | item_responses_item_id | edata.eks.item_responses.itemId | Question Id passed in the ASSESS event | String |
| 38 | item_responses_time_spent | edata.eks.item_responses.timeSpent | Time spent in seconds from ASSESS event | String |
| 39 | item_responses_pass | edata.eks.item_responses.pass | Pass response for a question from ASSESS event | String |
| 40 | item_responses_score | edata.eks.item_responses.score | Score from ASSESS event | Array[Integer] |
| 41 | item_responses_max_score | edata.eks.item_responses.maxScore | Max Score from ASSESS event | Array[Integer] |
| 42 | item_responses_timestamp | edata.eks.item_responses.time_stamp | Timestamp for each response from ASSESS event | String |
| 43 | dloc_state | ldata.state | State location information for the device | String |
| 44 | dloc_state_code | ldata.state_code | State ISO code information for the device | String |
| 45 | dloc_city | ldata.city | City location information for the device | String |
| 46 | dloc_country_code | ldata.country_code | Country ISO code information for the device | String |
| 47 | dloc_country | ldata.country | Country location information for the device | String |
| 48 | content_name | name | Name of the content | String |
| 49 | object_type | objectType | Type of the content | String |
| 50 | content_type | contentType | Type of the resource | String |
| 51 | media_type | mediaType | Type of media of the content | String |
| 52 | language | language | List of languages | Array[String] |
| 53 | medium | medium | Language medium of the board | String |
| 54 | mimetype | mimeType | Mimetype of the content | String |
| 55 | framework | framework | String | |
| 56 | board | board | Board of affiliation | String |
| 57 | status | status | Status of the content - Draft, Published etc. | String |
| 58 | mimetypes_count | mimeTypesCount | Count grouped by mimetypes | JSON Object |
| 59 | content_types_count | contentTypesCount | Counts grouped by each content type | JSON Object |
| 60 | version | versionKey | Version of the content | Double |
| 61 | last_submitted_on | lastSubmittedOn | Last submitted date of the content | String |
| 62 | last_published_on | lastPublishedOn | Last submitted date of the content | String |
| 63 | device_first_access | first_access | First access of the device | String |
| 64 | device_specification | device_spec | Specification of the device | Map |
| 65 | user_agent_specification | ua_spec | User agent spec of the browser | Map |
| 66 | first_name | firstname | First name of the user | String |
| 67 | last_name | lastname | Last name of the user | String |
| 68 | grade_list | grade_list | List of grades taught | Array[String] |
| 69 | language_list | language_list | List of languages known | Array[String] |
| 70 | subject_list | subject_list | List of subjects taught | Array[String] |
| 71 | user_name | username | User name of the user | String |
| 72 | user_type | usertype | Type of the user | String |
| 73 | user_loc_state | user_state | State info of the user | String |
| 74 | user_district_loc | user_district | District info of the user | String |
| 75 | user_block_loc | user_block | Block info of the user | String |
...