Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Summary_list
Task1Introduction
Task2Running the report
Task3Creating the report
Task4The report's results

HTML
<a id="Introduction"></a>

Introduction

The Organisation Drill-Down report is an interactive, click-able report, showing call summaries for inbound and outbound calls. The report is useful for comparing call statistics between different parts of your organisation and allows you to drill-down into each value to see the same call information for subsequent groups or users.

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_3.png

HTML
<a id="Running the report"></a>

Running the report

Access the Reports screen, select the Organisation Drill-Down report from the list and click on the Run now button.

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_1.png

...

A new window will open, allowing you to configure the parameters of your report:

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_2.png

...

Note

NOTE: When using TIM Professional on more than one site, you will need to get a site license for each site logged. If you are logging more than one site, you may want to consider TIM Plus or TIM Enterprise, which, although more advanced, often work out more cost effective in a multi-site scenario.

HTML
<h4>Who do you want to bill?</h4>

<p>You can bill people in three ways:-</p>

<table class="confluenceTable">
	<tbody>
		<tr>
			<th class="confluenceTh" width=150>Billing way</th>
			<th class="confluenceTh" width=730>Description</th>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Extension Group</b></td>
			<td class="confluenceTd">Select the group of extensions you would like your bill to cover.  A
			list of groups is automatically constructed from your extensions
			set-up.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Extension</b></td>
			<td class="confluenceTd">Enter a single extension number of the
			person you would like to bill.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Account</b></td>
			<td class="confluenceTd">If you want to produce a bill consisting of all chargeable calls made
			using a particular account code, enter the account code in the box.</td>
		</tr>
	</tbody>
</table>

<h4>Adjust how the bill is calculated</h4>

<p>You have two options available:</p>

<table class="confluenceTable">
	<tbody>
		<tr>
			<th class="confluenceTh" width=150>Bill calculation</th>
			<th class="confluenceTh" width=730>Description</th>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Mark up on each call</b></td>
			<td class="confluenceTd">You can add a percentage mark-up to each call. To do this, enter the
			percentage you would like to mark the call up by here.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Surcharge per call</b></td>
			<td class="confluenceTd">You may want to have a surcharge on each call. A surcharge is a fixed
			amount that is added to the original cost of the call.</td>
		</tr>
	</tbody>
</table>
Note

NOTE: Both a surcharge and a mark-up can be applied together. In this case, the surcharge is added after the mark-up is calculated, on order that the surcharge isn't marked up too.

...

Select a report period

For each report, you must specify a time span that covers the calls you want the report to include.

Screenshotmacro
Borderfalse
URL/download/attachments/7241970/report_period.png

There are several preset reporting periods available for selection, based on the standard Gregorian calendar. The following table describes how the start and end times are defined for each preset period:

PeriodDescription
TodayThe start and end dates are set to the current date. The start time is set to 00:00:00 and the end time to 23:59:59.
YesterdayThe start and end dates are set to the current date minus one day. The start time is set to 00:00:00 and the end time to 23:59:59.
This weekThe start date is set to the first day (normally Monday) of the current week. The end date is set to the current day. The start time is set to 00:00:00 and the end time to the current time.
Last weekThe start date is set to the date of the last Monday, and the end date is set to the start date plus seven days. The start time is set to 00:00:00 and the end time to 23:59:59.
This monthThe start date is set to the first day of the current month. The end date is set to the current day. The start time is set to 00:00:00 and the end time to the current time.
Last monthThe start date for this period is set in three stages: The day is set to the first day of the month. The month is set to the previous month. The year is set to the current year, unless it is currently January, in which case, the previous year is used. The start and end times are set to 00:00:00 and 23:59:59 respectively.
This yearThe start date is set to the first day of the first month of the current year, whilst the end date is set to today's date. The start and end times are set to 00:00:00 and 23:59:59 respectively.
All callsThe start and end dates and times are set to the dates and times of the first and last call in the entire call database, respectively.

In addition to the presets described above, it is possible to specify a custom reporting period by choosing Custom period from the drop-down list and specifying your own  Start and End dates, as shown below:

Screenshotmacro
Borderfalse
URL/download/attachments/7241970/custom_period.png

Select a site

If your system is set up to log multiple sites, you can select a particular site from the drop-down list. To report on all sites, select the blank line.

Screenshotmacro
Borderfalse
URL/download/attachments/7241980/select_site.png

Select an extension group

To further limit your report's results, you can select a particular group to report on from the drop-down list, or select the blank line to report on all groups.

Screenshotmacro
Borderfalse
URL/download/attachments/7241973/select_extension_group.png

Specify a partial dialled number

To report on calls to a particular area or number enter a partial or full number in the field provided. For example, to monitor how much you spend on calls to mobile numbers, enter 

Keywordmacro
Label07
in the field provided or, for international calls, enter
Keywordmacro
Label00
.

Screenshotmacro
Borderfalse
URL/download/attachments/7241966/specify_partial_number.png

Specify call duration

If you want to exclude calls below a certain duration, enter the minimum duration in the field provided.

Screenshotmacro
Borderfalse
URL/download/attachments/7241966/duration.png

Select a field to order the results by

By default, the report's results are ordered by cost. To sort the results by a different column, select it from the drop-down list.

Screenshotmacro
Borderfalse
URL/download/attachments/7241966/order.png

Sort order

By default the report's results are displayed in ascending order. To display the results in descending order, tick the appropriate option.

Screenshotmacro
Borderfalse
URL/download/attachments/7241966/sort_order.png

Options

Selecting the

Keywordmacro
LabelEnable hyperlinks
option, allows you to drill-down into the report's results to see call information for an extension group or individual user. However, as the hyperlinks are usually underlined, for printing purposes you may prefer to deselect this option and produce a static report.

To show a summary of all calls, rather a breakdown of all answered, unanswered and outgoing calls, select the Combine call totals option.

Screenshotmacro
Borderfalse
URL/download/attachments/7241966/options.png

HTML
<a id="Creating the report"></a>

Creating the report

When you have selected a reporting period and have chosen the report's criteria, click on the Run now button, as shown below:

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_6.png

HTML
<a id="The report's results"></a>

The report's results

The results of this report show a summary of call volumes - organised by call type - for the entity you selected. Totals and averages of all extension groups are displayed at the foot of each column.

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_3.png

The header of the report will display its title, any friendly name you assigned to it, the period of the report and any options you have selected in the report's selection criteria window.

The body of the report will display call summary information for each extension group. A description of each column header is presented in the table below:

Column headerDescription
Extension GroupThe name of each extension group the system has logged calls for. If an extension group is missing from this list, no calls were registered for the user group within the time period the report was run for
#ExtsThe number of extensions contained within the respective group
UnansThe number of unanswered (abandoned) calls
Ans CallsThe number of incoming calls, including transferred calls
Total DurThe total duration of all incoming calls
Avg DurThe average duration of all incoming calls
Out CallsThe total number of outbound calls
Out N/CThe total number of outgoing non-connected calls
Total DurThe total aggregate duration of all outgoing calls
Avg DurThe average duration for all outgoing calls
CostThe total aggregate cost of all outbound calls

Drilling down

Having seen the summary information for each extension group, you may wish to see the same call information for each individual extension within a particular group. To drill down into the report, click on an extension group hyperlink, as shown below:

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_4.png

To drill-down even further into the report, click on an extension hyperlink and a new report will be produced, showing - in chronological order - an itemised list of calls made or received by the selected extension:

Screenshotmacro
Borderfalse
Shadowfalse
URL/download/attachments/7241966/organisation_drill_down_5.png

The headers of the itemised call table are described below:

Column headerDescription
Date & TimeThe date and time the call started
ExtensionThe name or number of the extension that made or received the call
DestinationThe name of the destination where the call terminated, or a brief description of the type of call, for incoming ones
CLIThe telephone number of the remote caller for inbound calls
Dialled NumberThe number dialled, in the case of an outbound call
TrunkThe number of the trunk carrying the call
ResponseThe length of time it took for the call to be answered, e.g. the response time
DurationThe duration of the call in hours, minutes and seconds
CostThe cost of the call, if applicable