Confluence Analytics: Information about viewers

[evgenii.kolomoitsev]

Hello team! 

I'm looking for the solution for the following inquires:

1) I need to find away how directly to export data (via API or SQL) about page viewers including names & roles assigned to them in confluence 

2) To connect Confluence and Jira, i.e. every time the new comment added within the confluence page ->  create a new Jira ticket 

3) To get analytics about Jira ticket: who took a case, how long it took between the ticket_cfeated_time and until the first_response_time, + the AHT of the ticket

Thank you a lor in advance! 

[Mattia _Communardo_ · Accepted solution]

Hello @evgenii.kolomoitsev  and welcome.

I'm not sure if there is a ready-made solution for your use case in the Marketplace.
If there isn't, the only option is to program a custom solution using the Confluence API and Jira API. 

Questions about these APIs and for support are better asked in the developer community. 

Kind regards

Mattia

[Dmitri Bukovski]

Hi, not sure whether you use Server(DC) or Cloud, so here are suggestions for Server(DC)

1. As for page viewers you can use confluence-access logs with entries like "GET /pages/viewpage.action" or "GET /display/", then you can parse them and map  to specific spaces or pages. Regarding the user info you can try "GET 'your_url/rest/mobile/1.0/profile/user_id'

3) As for case with ticket analytics I would  choose search API and expand "changelog" field, there you will find the info you need. I would also first see what custom fields exist, maybe some of the info is already configured as a separate field there.