Jira Reports for Marketing Teams Working in Confluence

Although there are growing numbers of marketing teams using Jira for managing campaigns and content in a more agile way, platforms like Asana, Trello, and Monday.com are still very popular.

Of course, even if the marketing team isn’t working in Jira, other teams will be. And the marketing team have to have eyes on what those teams are up to. For example, they’ll need to know progress on new features and releases from the product team because they’ll need to start marketing them. And the best way of seeing that progress is by looking at Jira reports.

How can a marketing team look at Jira reports if they don’t work in Jira? Enter Confluence.

No Jira? Yes Confluence

All the teams in your organization are likely to be using Confluence; it acts as an intranet as well as a digital substitute for the office for remote workers. And your marketing team is probably using it day to day to plan and produce content. I know ours is. I wrote this blog in Confluence.

What’s great is that Jira and Confluence are both Atlassian products, meaning they’re easily integrated so you can see Jira data on Confluence pages.

That said, the native capabilities are limited (and that’s being kind). There is a Jira charts macro that lets you build pie charts, a two-dimensional statistics table, and a created vs resolved issues line graph on a Confluence page. But there are two big problems with it. One: the customization options are basically non-existent. Two: if your marketing team doesn’t have access to Jira (which they probably won’t if they don’t work in it), all the charts will be blank. Useful, eh?

As is so often the case, it’s the Atlassian Marketplace to the rescue. Custom Jira Charts for Confluence is a Marketplace macro that lets you make whatever kind of chart you want – funnel charts, tile charts, 2D stacked bar charts – and customize colors, labels, descriptions, and how the data is ordered.

Most importantly, Custom Charts’ User Impersonation feature lets you load reports onto a Confluence page using a Jira user’s account permissions. Therefore, if the marketing team doesn’t have access to a Jira project, they’ll still be able to see data about the project in Confluence.

Here are 2 examples of Jira reports that you could make that your marketing team would find useful.

1. Project Status of Issues

The Custom Charts Issue List below is displaying issues and their status in a development project, showing what’s coming up for one of our apps, Live Input Macros. All you do to make this list is search for your desired project in the Source field and click on it. Then the Issue List macro will load all issues associated with the project onto your Confluence page. You can then sort the issues by preference and monitor their overall status and progress. This enables the marketing team to get a heads up as to what features may need to be marketed and when.

Issue List Progress Chart in Custom Charts

2. Upcoming Releases

This Custom Charts 2D grouped bar chart offers a visual insight into the development team’s progress on their Jira epics, i.e. product releases. The Chart By dropdown is set to the Epic Link field and the Group By dropdown is set to the Status Category. You can see that the “Code Block Macro” release is mostly complete, with only 2 items in progress, nothing in “to do”, and 8 items completed. This means the marketing team should start thinking about a marketing campaign for this release.

You can show or hide epics you are/not interested in using additional customization settings.

Upcoming Releases Grouped Bar Chart in Custom Charts

To help your marketing team get better insights on what your Jira teams are up to with Custom Jira Charts for Confluence, book a training session with our team. You can also try Custom Charts in our interactive reporting playground.

Christopher is a self-confessed nerd who’d probably take the cake on Mastermind if Star Trek: Voyager was his specialist subject. He writes fiction about time travel, conspiracies and aliens; loves roller coasters, hiking and Christmas; and hates carpet, rom-coms and anything with chilli in it. He’s written extensively for technology companies and Atlassian partners and specializes in translating complicated technical concepts, specs and jargon into readable, benefits-driven copy that casual readers will understand.