Rovo or Chat GPT prompts to help automate qualitative status reporting

[Sheila Connolly]

I'm a program manager who is responsible for updating a google slide deck weekly for executive team members. This slide deck primarily is used to show whether an initiative is on track or at risk, while showcasing any progress made towards that initiative during the week.

Not all the recipients have Atlassian licenses, so we have to manually update a presentation to be emailed out. Has anyone had any success leveraging Rovo or other AI tools to help pull relevant updates out of Jira and make them 'human readable' to an executive audience? Looking to get more comfortable with my use of AI in general, so any advice is greatly appreciated!

Our current Jira structure is as follows:

1. Initiatives exist for cross functional work

2. Epics are under those initiatives, and the epics are scheduled within a quarter

3. Epics are broken down into Stories and Tasks that are scheduled in Sprints to be executed by development teams 

[Gunjan Kumar · Accepted solution]

Hi Sheila,

Yes, Rovo can help summarize Jira work and produce qualitative status updates.

• Use Jira filters to capture Initiatives → Epics → Stories.
• Export results (CSV/Excel/Google Sheets) and provide them to Rovo or ChatGPT with a prompt like:
  “Summarize progress, risks, and overall status (On-Track / At-Risk).”
  

References:

• https://support.atlassian.com/jira-software-cloud/docs/export-search-results
• https://support.atlassian.com/organization-administration/docs/best-practices-for-atlassian-intelligence