Generate Analytics report for confluence based on last activity

[Testing]

Hello All,

Can anyone suggest how we can create report based on last activity date performed on  confluence space. so that we can identify if space are active or not.

Please suggest any free plugins or if possible using eazybi tools then how we can report such report on eazybi as not able to find out last activity performed on space related field.

Data required:

SpaceName , Last activity name and date

Thanks,

Sahiba 

[Levente Szabo _Midori_]

It's also not free, but another relevant option to identify if a Confluence space is active or not is Better Content Archiving for Confluence Cloud. There are several ways to check the status of a space or pages:

• Site and space scope content status overview (to identify stale content across all your spaces or within one space)
• Usage metrics on an individual piece of content (page or blog)
• Search by Confluence page status

Site scope content status overview: 

Page usage metrics:

(Please note that Better Content Archiving for Confluence is a paid and supported app and I'm part of the team developing it.)

[Adrian Hülsmann - B1NARY]

Hi,

not free, but a perfect fit for your use case is Breeze, available via the Atlassian Marketplace.

It is a full content lifecycle management solution and also features reports and visual analytics.

👉 Feel free to give it a try, or to schedule an appointment with me for a personal demo.

Cheers and all the best, Adrian from B1NARY (we are the developers of Breeze)

[eazyBI Support]

Hi @Testing 
You can check eazyBI for the Confluence app demo account to see available reports on Content Health: https://docs.eazybi.com/plugins/servlet/eazybi/accounts/6/dashboards/38-content-health
There is information about the last page's updated date and how many times the page has been viewed. Also, you can see information related to attachment size and versions created.

If you have some specific requirements, don't hesitate to write to us directly!

Gerda // support@eazyBI.com

[Testing]

@eazyBI Support Thankyou for sharing this link.

But I need all spaces data along with last modified details.

Suppose i need to perform any cleanup activity on confluence and need to delete spaces which are not active from couple of month so is there any way to fetch these details?

[Gerda Grantiņa]

Hi @Testing 
Yes, you can create your reports using different metrics when importing data into eazyBI. Those were just examples to illustrate better what is possible in eazyBI. 
You can see what dimensions and measures are available when you import data into eazyBI on this documentation page: https://docs.eazybi.com/eazybi/data-import/data-from-confluence/confluence-measures-and-dimensions

If you want to see all pages you can remove from this sample report "Bottom 10" values and select different Time periods.



best,
Gerda

[Testing]

@Gerda Grantiņa  Is it possible to get page updated details space wise not page?

Example: last modified page date with space name

[Gerda Grantiņa]

Hi @Testing , 
You can create a new measure in the Measure dimension to get the date with the oldest updated page:

TimestampToDate(
  Min(
   Filter(
    Descendants([Page].CurrentMember, [Page].[Page]),
    [Measures].[Pages updated]>0
   ),
  DateToTimestamp([Measures].[Page updated date])
 )
)

Or you can get what is the latest date by changing the formula min() to max():

TimestampToDate(
  Max(
    Filter(
     Descendants([Page].CurrentMember, [Page].[Page]),
     [Measures].[Pages updated]>0
    ),
  DateToTimestamp([Measures].[Page updated date])
 )
)

Don't forget to set measure formatting to date. 

Use the measure together with the Space dimension to get a view of Space. In the report it looks like this:


Kind regards,
Gerda

[Mattia _bitvoodoo ag_]

Hello @Testing 

It's not a free app but Viewtracker's Content & Usage Report will give you the information you need. For example, you can have all spaces listed including last viewed and last modified date and time.

It should be noted, however, that this app only tracks and lists the desired information from the time of installation. Unfortunately, I do not know of a solution for historical data.

Kind regards

Mattia

[Testing]

@Mattia _bitvoodoo ag_   I know about this apps, do you know how we can fetch this data from eazybi.

[Mattia _bitvoodoo ag_]

@Testing currently the app offers a CSV file export of these reports.

A REST API is still being worked on and will be available in the coming weeks.

[Fabian Lim]

Hi @Testing

Welcome to the community!

I don't think there are any free apps unfortunately. 

For eazybi, I would reach out to them directly and check if they have a way to capture what you want.

Cheers 

[Testing]

Thanks @Fabian Lim please let me know if you received any solution.