Create a recently Approved Ideas Report


To report on ideas which have been recently approved on your platform, you can setup a scheduled report detailing ideas approved within a certain timeframe, for example, the last seven days.

This allows you to track idea approved over time and ensure that you have a steady stream of ideas which have been approved for implementation.

The steps below detail how to setup a standard ideas approved report which can be run by platform administrators.

Step One: Setting up a report

  1. Click on the Settings cog and select Reports to open the report builder
  2. Click ‘Create new report’ and the wizard will appear
  3. You’ll be building an Idea Data report, so select Idea Data.
  4. To keep things simple for a standard Idea Approved report, we suggest starting with a General Report. Select this from the list and click next

Step Two: Creating a Filter

Filters allow you to further define the parameters of your report, specially:

  • The reporting period i.e. ideas approved in the last 7 days, 14 days, one month…
  • Which Challenge, Idea Space of Co-Creation Community you’d like ideas for

To do this scroll to ‘Data to include’ and under ‘AND filters’

  • Select the ‘Date’ option from the dropdown ‘Select a filter type’
  • Select ‘Approved’ from the dropdown ‘Select what data to filter on’
  • Select a filter value ‘Last 7 Days’

Filter Name and Description

To ensure this filter can be used by other administrators, we suggest naming this filter ‘Ideas Approved’ in the Last 7 Days’. Use the description field to outline what the filter configuration is in more detail.

To save your filter, click ‘Save filter configuration’

Step Three: Data Selection

For a simple view of all ideas submitted, we recommend that the following fields are selected:

  • Idea ID
  • Idea Name
  • Challenge
  • Date Created
  • Date Approved
  • Idea URL
  • Number of unique views
  • Idea Creator Email
  • Creator First Name
  • Creator Last Name
  • Creator Department (if you’ve added this as a profile field)

Step Four: Name and Description

To make it easy to know which report this is, we suggest naming it Ideas Approved. Use the description field to detail what the reporting period is, who’s a recipient and what you use the report for. This

Delivery Settings

By default, the person setting up the report is a recipient. You can also add other recipients, though they need to be a registered on the platform. To do this, start typing the name or email address of the report recipient and select them from the suggestions that appear.

Step Five: Scheduling for future delivery

By default, reports created are not scheduled for future or recurring deliveries. We recommend setting up the report for future delivery on a recurring schedule. To do this, select ‘Yes’, select the ‘Weekly’ schedule, and set report schedule day to ‘Friday’.


Once you have defined your report, recipient(s), and schedule you have the option to ‘Save for Later’ which would save the report and generate as per the schedule set above. We would recommend selecting the option to ‘Save and Run Now’ so you can view what the report output looks like and if required make changes as needed.