What schema/table has Confluence View data in Atlassian Analytics?

[Saikiran Devatha [C]]

I'm looking for some help to gather the page view data of confluence spaces. Atlassian Analytics does not seem to have this data. The only place to get view data from what i could find is Space Analytics. But the data here can be exported for only one space at a time. 

https://support.atlassian.com/confluence-cloud/docs/view-insights-on-spaces/

Also, I'm unable to find the exact query for the insights like Created, Commented, and Updated data from Atlassian Analytics that matches the data from Space Analytics. There seem to be some filters applied in Space Analytics. Is there any documentation on exact queries/filter used here? 

Thanks!

[Humashankar VJ]

Hi @Saikiran Devatha [C] 

It is not practical via Atlassian Analytics to create a dedicated schema or table for Confluence view data that aligns with the insights provided by Space Analytics.

• While Space Analytics in Confluence Cloud offers view data and other insights on a per-space basis, exporting this data for multiple spaces at once is not possible.
• Likewise, the Created, Commented, and Updated data available in Atlassian Analytics may not exactly match the data shown in Space Analytics due to differences in data filtering and aggregation.

To approximate the Space Analytics data, you may need to create custom queries using relevant tables in Atlassian Analytics, such as confluence_page, confluence_comment, and confluence_content_updated_by_mapping.

If you require more comprehensive analytics or need to gather view data across multiple spaces, you can try the Confluence REST API to programmatically fetch Space Analytics data for multiple spaces.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards