Marketing requires managing a lot of content and assets. A content backlog allows you to manage this content and keep track of statuses and deadlines. Read the following guide to find out how Orderly Databases for Confluence Cloud helps you to keep a structured and clean overview of your pages and their current status.

What's in for you?

  • Separate board for articles depending on the status

  • Access to all articles from one place in Confluence through the database
  • No manual editing of labels or page properties on every page

  • Quick overview of the most important data for every article 

Requirements for Partner Management

In this guide, you'll learn how to manage articles using the fictitious company Good Consulting as an example. Good Consulting want to display the following information for each article with their database:

  • Link to the Confluence page of the article

  • Quick summary of the article's topic
  • Author
  • Creation date
  • Current status
  • Due date
  • Publishing date

In a next step, we will use filters within the Orderly Database macro to create three boards for our content backlog:

  • Idea board – where everyone can insert an idea for a piece of content
  • Backlog – where content is stored which should be picked up next or is currently being worked on
  • Publishing board – where all the published articles are stored

How to Create the Database

To get started, you'll first need to create a database for the articles in your Confluence space. Learn more about databases and how to create one here.
Then you have to insert and filter the Orderly Database macro to create the three different boards. Finally,
you can create an overview at the top of each partner page by adding an Orderly Entry macro. 

Content Library Database

Go to "Orderly Databases" and create a new database "Content Library". 

Set up the necessary field types you need for managing your content backlog and enter your articles as entries.

Here are some examples for field types you could add and which settings to choose in the set up to create a database like above.

Title

Field Type

Settings

Articles (Title field)Page Link
  • Enable page creation
  • Select the parent page for creating new pages
  • Initial content is set to Entry macro
  • Disable multi select
SummaryText
  • Allow line breaks
AuthorUser
  • Set current user as default user is enabled
  • Enable multi select is disabled
Created onDate
  • Set current date as default value is selected
StatusSelect
  • Selectable items
    • todo
    • in progress
    • published
    • under review
    • outline
  • Disable the creation option
  • Enable multi select for this field
  • Default value is "to do"
Due dateDate
  • default settings
Published OnDate
  • default settings

Creating Separate Boards With the Help of Filters

Next up we will create the three boards - an idea board, an backlog and a publishing board. First you need to create three separate Confluence pages for each board, depending where you want the boards be displayed later.

Idea Board

To create the idea board, go the respective page and insert the Orderly Database Macro here with "Content Library" as input. Then navigate to the filters in the "Default view" section. Here, you need to enter the following filters:

  • Status is not "in progress" 
  • Status is not "published"
  • Status is not "in progress" + "under review"

When new content ideas are coming in, people can submit it by entering a new entry on the idea board, that creates a new entry with status "to do", since this is the default.

Backlog Board

For creating the content backlog board, you have to repeat the steps above on the page you want the backlog to be displayed. Here you need to set different filters:

  • Status is not "to do" 
  • Status is not "to do" + "outline"
  • Status is not "published"

Publishing Board

Lastly, for the publishing board, you have to insert the database macro again on the desired page with the following filter settings:

  • Status is not "to do" 
  • Status is not "to do" + "outline"
  • Status is not "in progress"
  • Status is not "in progress" + "under review"


By inserting those database macros with the recommended filters, we we get three boards, filtered by the status labels. If it’s a "to do" then it’s in the idea board; if it’s "in progress" it’s in the content backlog; if it’s in "published" then it’s in the published board.

Display Key Data on Each Page

By adding an Orderly entry macro to the very top of each page, key data for each position will be visible right away when you land on a page. You can set this as a default, if you set the Orderly Entry macro as initial content for every newly created page in the settings for the "Articles" field, as described in the table above.

Curious to read about more ways to use Orderly Databases?

If we have raised your interest in using Orderly for your content management, you should definitely check out our other use case articles as well.
Click here to visit our use case library. Or have a look at our guides and tutorial for getting started with Orderly here.