How to get Report for Confluence Page Title and Page Status ?

[Yatin Shingala]

For the confluence page, we can set the status value as Draft, In Progress, Ready for Review etc.   I want to generate a  report showing the list of page with title and status information.

How can I do that ?

[Levente Szabo _Midori_]

@Yatin Shingala 

On top of what the others mentioned, a core feature in Better Content Archiving and Analytics for Confluence Cloud is the Content Status Overview which is a content status report table based on your custom page statuses:

2024 March UPDATE

Better Content Archiving and Analytics is now enriched with advanced Confluence analytics dashboards, including content lifecycle aspects, like page count by status, distribution by status, and more. Confluence report gadgets and more features are gradually shipped, so keep an eye on this screen:

                Notice the stacked area chart to display historical changes in page status

Some suggested reading, a blog on Confluence page status, its limitations for large teams, and alternatives for flexible content status management.

Better Content Archiving and Analytics has been a market-leading app for Confluence content lifecycle management on Data Center (Server), and it's now available on Confluence Cloud.

(Note that Better Content Archiving and Analytics is a paid and supported app and I'm part of the team developing it.)

[Max Foerster - K15t]

Hi @Yatin Shingala

Unfortunately, the new content status feature still misses one or two essential things. You cannot quickly get an overview of statuses as they are not supported by the Confluence search and the page property report (which would have been the first suggestion to solve the reporting need). A community user already created two product suggestions you should consider voting for and watching them.

• CONFCLOUD-74397 - Add option to show page status in various macros
• CONFCLOUD-74398 - Include page status in the Confluence search

But I can provide you with a workaround. 😄 Since there is currently no way to solve your use cases natively in Confluence, you might also want to check out our app Orderly Databases for Confluence, which we like to describe as "Page Properties on Steroids". 😄

After setting it up and adding the fields and data that are important to you, it might look something like this:

- You have all pages listed with additional data of your choice in a table (user mentions, select lists, dates...)

- You see all page statuses of each linked page and can edit them inline as well from anywhere without information being out of sync.

If you have any questions, please let me know, and have a great day!

Best, Max

[chris.grom]

Hi @Yatin Shingala.   

I had to tackle a similar issue with regards to obtaining a list of page statuses.

I shared my step by step method of using Confluence's new Automation feature (as a temporary workaround for reporting) in this thread:

Searching by Status in Confluence

In summary, I created rules that automatically add a specific page label to each page that has a new status assigned to it.

It allows users to search for and produce a list of pages with the same status, I'll include a screenshot of the customized rule I designed for this below, along with a screenshot of my rule for 'updating' page statuses. Please refer to the thread linked to above for detailed steps. Thank you.

[chris.grom]

[Adrian Hülsmann - B1NARY]

Hi @Yatin Shingala

Content status reports can be provided by Breeze, available via the Atlassian Marketplace.

In fact, Breeze is a time-saving solution for content lifecycle management and includes

• automated content analyses,
• page review and archiving workflows,
• page and space ownership,
• reports (global and space-level),
• notifications for reviewing / archiving pages,
• bulk archiving and deletion,
• analytics,
• data export
• and more to update outdated pages quickly and enhance collaboration.

👉 Feel free to give it a try or schedule an appointment with me for a personal demo, in which I can show you all details and provide tips for establishing proper review/archiving workflows.

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

[Alex Koxaras _Relational_]

Hi @Yatin Shingala 

Out of the box, there isn't a way to do this simple. Two solutions I can think of:

• Search the marketplace for an app which can produce such report (haven't search my self to be honest)
• Create (or add) on every page a page property macro including two columns, the title and its status

Hope that helps. 

[Yatin Shingala]

Hi @Alex Koxaras _Relational_ 

For the second option, I have created a page property macro.  I have a title.

How do I get the page status there ?

[Alex Koxaras _Relational_]

@Yatin Shingala out of the box you can't get it. If you use an http request you can get the name of the page status e.g:

/wiki/api/v2/pages/PAGEIDGOESHERE/properties

I honestly don't know if there is an app which would let you send http requests.

Manually would be the way to go unfortunately.