How to automate a monthly report from Confluence of engagement stats?

[Daniel Vest]

With the sad fact that our Confluence KB space can only look back at Space Analytics for 1 yr from present date (due to limits of Confluence). It would be great to be able to setup an automation to have an automation send an email, extract a CSV, something like that, each month. This way, when someone wants to compare a trend, and say "hey my end users are using the knowledge base more this year to date then then did last year to date." There would be good data to go on...Instead of having to have a calendar reminder each month to go in and export the data and save it, like I have been doing.

I see there is the template in Confluence to send out an email when a page reaches a certain number of views. That is sort of helpful in a small way. It will send me an email list of the pages that passed whatever view count I set in the automation... but then I still have to go into the system and look up the number of views for those pages.

Does anyone know a better, more automated way? 

[Bill Sheboy]

Hi @Daniel Vest 

Although there is a REST API endpoint to get view counts (and watchers) for a specific page, I believe there is no support for generic checks over a set of pages, such as with CQL.

For advanced reporting, I suspect you may need to check the Atlassian Marketplace for reporting / dashboard gadgets to do what you ask.

To do the scheduled rule approach you are trying, perhaps try this:

• trigger: scheduled
• branch rule / related entities:
  • type = page
• action: send email, with the list of pages with more than 10 total views...regardless of when that happened 

{{#pages}}
  {{#if(totalViewsCount.gt(10))}}
    * {{title}}
  {{/}}
{{/}}

Kind regards,
Bill

[Daniel Vest]

thanks for your quick feedback, @Bill Sheboy