How do I create a custom report?

Custom call report. Selecting columns and grouping.

When creating custom reports, they can either be call reports or order reports. This article discusses creating a call report, if you want more information on order reports, see this article on the support pages.

In your Admin account:

Reports_-_Custom_reports.png

  1. Click to select the Reports page from the top menu.
  2. Click to view Custom reports.
  3. To create a new report, click the Reports_-_New_custom_report_button.png button in the top right.

Custom_reports_new_full_span.png

Report basics

  1. In the Name field, type a name for your report. Try to make it meaningful, particularly if you have a lot of custom reports, or will only use this report occasionally.
  2. To create a call report, click the Report group drop-down list and select Call report

Reports_-_custom_call_selected.png

You can then use the Report options section to define what sort of calls should appear in the report:

  1. Click the Type of displayed calls drop-down list to select to see answered or unanswered calls, or only finalized calls. This defaults to All calls.
  2. Click the Call direction drop-down list to choose outbound calls, inbound calls, or both. This defaults to Inbound and outbound calls.
  3. By default, Use custom field names from selected campaign is ticked. If you have renamed any of the “Other info” fields for a project, having this ticked will show your field names in the report. For example, if you have renamed the field name “Other info 1” to “Membership level”, the report would reflect that.

Reports_-_report_options_-_calls.png

Note that any changes to the standard fields, like First name, Email and City will not show in the report.

  1. You can use the Sorting column and Sorting order drop-down lists to choose the ordering of your data.

Building the report you want

Once you have defined the basics of your report, you can now configure precisely what information should show in it. This can be done with or without Grouping.

Grouping

By default, the report will show an individual line for each call within its parameters, for example the duration of each call for each agent. Often, it is more useful to see a total or an average. For example, you might want to see the total duration of all calls for an agent, or the average duration of all their calls. To create the second type of report, use Grouping.

  1. Click the Reports_-_grouping_toggle.png toggle to enable grouping.
  2. Click Add grouping to choose which groups to use.
  3. Click to tick the checkbox for one or more groups from the list.
  4. Click outside the list to finish.

Reports_-_grouping_selected.png

  1. If you have added a group by mistake, click Reports_-_trash_icon.png to remove it.
  2. You can change the order of the groups by clicking and dragging Reports_-_reorder_handle.png by the group’s name.

Add columns

You cannot save a report until you have added at least one column to it. If you have not used grouping, you will have many more options.

  1. Click Add columns.
  2. Click to tick the checkbox for the columns you wish to use.
  3. Click outside the list to finish.

Reports_-_Report_columns_-_call_-_grouped.png

  1. If you have added a column by mistake, click Reports_-_trash_icon.png to remove it.
  2. You can change the order of the columns by clicking and dragging Reports_-_reorder_handle.png by the column’s name.
  3. Once all columns have been selected and arranged, click Reports_-_Custom_reports_Save.png in the top right.

Saving and running the report

Once the report has been saved, you will be taken to the screen to run the report. Before you do, there are several further options.

  1. Filter the report, by clicking the available drop-down lists. For example, you may only want to run this report for a particular office or contact list.
  2. Click the Time period drop-down list. You can select a specific date range by choosing Numeric date and typing the dates. It is usually better to choose a “literal date”, for example Previous week or This month.

Reports_-_Custom_filter_and_run.png

  1. If you choose a literal date for Time period, you can click Save to shortcuts. This will make it easier to find and run the report in the future.
  2. You can then either click Reports_-_Run_report_button.png, or Reports_-_Export_report_button.png, to output the report to, for example, a CSV file.