Ultimate guide to exports

In Award Force, you can export data from the Manage workspace into spreadsheets for reporting, analysis, or record keeping outside the platform. Exports (also known as reports) are available as Excel or CSV files and include data collected from users or generated through your program’s configuration.

Exports are available across many areas of the platform and reflect the data visible in the view you are exporting from.

Take a standard export

To request an export of data, follow these steps:

  1. Choose the location where you want the data from (see Types of standard exports below)
  2. Click Advanced in the search to filter the data as needed; i.e. submitted entries
  3. Open the Export drop-down
  4. Hover over an export option
  5. Select either Excel or CSV

You will receive an email containing a download link once the export is ready. Larger exports may take a few minutes to process.

Types of standard exports (by area)

Entries

Export name Description Includes Excludes Customisable?
Entries Data collected through the entry process All entry and entrant information Judging results, attachments, contributors Yes
Contributors Contributor data captured in contributor tabs and fields Contributor details and basic entrant identifiers Other entry data Yes
Files Metadata for uploaded files File name, size, type, duration, download URL Raw files, entry fields Yes

Review flow

Export name Description Includes Excludes Customisable?
Reviews Data collected through action flow tasks All entry, entrant, and review task information Reviewing results, attachments, collaborators Yes

Judging

Export name Description Includes Excludes Customisable?
Results (Leaderboard) Final outcomes per judging mode Judging results and judge assignment data Entry form data Yes
Decisions / Scores / Picks / Votes + comments Judge outcomes with comments Judging results, judge assignments, comments Entry form data Yes
Comments Comments left during judging or by managers General comments, authors, and timestamps Entry data, criteria-level comments Yes
Progress Judge progress per score set Assignments and completion status Entry form data Yes
Assignments Judge-entry pairings Assigned judges and entries Judging results Yes
Panels Judging panel configuration Panels, judges, modes, filters Judging results Yes
Score sets Judging configuration Score set settings and mode parameters Judging results Yes
Scoring criteria Criteria configuration Criteria, weights, categories, timestamps Judging results Yes

Users and settings

Export name Description Includes Excludes Customisable?
Users User account data User details, registration data, preferences Passwords, entry data Yes
Content blocks Content configuration Content, location, visibility, timestamps User-specific visibility lists Yes
Categories Category configuration Category data, chapters, activity status Entry data Yes
Fields Field configuration Field metadata, slugs, tabs, data protection settings Entry responses Yes
Tabs Tab configuration Tab metadata, timestamps Entry responses Yes

Create a custom export

If a standard export includes more data than you need, you can create a custom export and choose exactly which columns to include.

Custom exports can be created in any area where standard exports are available.

Option 1: create from the Export drop-down

  1. Navigate to the relevant page in the Manage workspace (for example, Judging > Leaderboard)
  2. Open the Export drop-down
  3. Under 'Custom', click New
  4. Enter an export name
  5. Select an Area (this determines where the export is available and which data is included)
  6. Choose Private or Shared availability
  7. Add or remove columns as required
  8. Click Save

Your custom export will now appear in the Export drop-down.

Option 2: create from Settings

  1. In the Manage workspace, go to Settings > General > Custom export layouts
  2. Click New custom export layout
  3. Enter an export name
  4. Select an Area
  5. Choose Private or Shared availability
  6. Configure columns
  7. Click Save

Add and remove export columns

  • To add a column, hover between existing column names and click the + icon, then search for the field.
  • To remove a column, hover over the column name and click the X icon.
  • Use Add all or Clear all to quickly manage columns in bulk.

Good to know

  • Exports with more than 10,000 rows are split into multiple download files.
  • If you don’t receive the 'Export complete' email, check your spam folder or safe-list app.awardforce.com. 
  • Completed exports can also be accessed via your profile by selecting Downloads.
  • Custom exports only show fields associated with the form selected before opening the Export drop-down.

Video overview

Was this article helpful?
7 out of 12 found this helpful

Articles in this section