# Can we get analytics data based on Session ID

**URL:** https://community.yellow.ai/t/can-we-get-analytics-data-based-on-session-id/3039
**Category:** Insights
**Tags:** bot-analytics
**Created:** [December 7, 2022, 8:11am UTC](https://community.yellow.ai/t/can-we-get-analytics-data-based-on-session-id/3039 "2022-12-07T08:11:41Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Sai\_Sandeep](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.yellow.ai/sai_sandeep/32/1899_2.png) [@Sai\_Sandeep](https://community.yellow.ai/u/Sai_Sandeep)
#### Post date: [December 7, 2022, 8:11am UTC](https://community.yellow.ai/t/can-we-get-analytics-data-based-on-session-id/3039/1 "2022-12-07T08:11:41Z")

</div>

Is it possible to get analytics data for each Session, Client needs data with the below fields

Session ID, User ID, Chat closed at what level? (Bot/Agent), Session Duration, Bot Message count, User Message Count, Journey Completion %

---

<div class="post-metadata">

### Author: ![Sanskrity](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.yellow.ai/sanskrity/32/1082_2.png) [@Sanskrity](https://community.yellow.ai/u/Sanskrity)
#### Post date: [December 7, 2022, 8:17am UTC](https://community.yellow.ai/t/can-we-get-analytics-data-based-on-session-id/3039/2 "2022-12-07T08:17:02Z")

</div>

@Sai_Sandeep You can derive this report from the Bot events and User engagement events tables in Data Explorer. You might need to export and analyse externally on excel.

---

<div class="post-metadata">

### Author: ![Sai\_Sandeep](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.yellow.ai/sai_sandeep/32/1899_2.png) [@Sai\_Sandeep](https://community.yellow.ai/u/Sai_Sandeep)
#### Post date: [December 7, 2022, 8:34am UTC](https://community.yellow.ai/t/can-we-get-analytics-data-based-on-session-id/3039/3 "2022-12-07T08:34:10Z")

</div>

@Sanskrity Currently we are flowing this process only. But the manual task is involved her client needs to put more effort to analyse both tables, is it possible to get a report directly with the combination of Bot events and User engagement events table with unique sessionId and userId

---

<div class="post-metadata">

### Author: ![Sanskrity](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.yellow.ai/sanskrity/32/1082_2.png) [@Sanskrity](https://community.yellow.ai/u/Sanskrity)
#### Post date: [December 7, 2022, 8:40am UTC](https://community.yellow.ai/t/can-we-get-analytics-data-based-on-session-id/3039/4 "2022-12-07T08:40:27Z")

</div>

@Sai_Sandeep Currently joining of tables is not possible. We’re exploring a solution for this though.