Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current ·  View Page History

Introduction

A simple, quick, easy-to-use, fully-clickable report which allows you to drill-down through your organisation. It starts with a summary of incoming, missed and outbound calls for the entity selected and allows you to keep drilling down until you reach individual user level.

The example below shows the first web result for the entire organisation.

Enterprise overview

By clicking on the sites at the left hand side, you can continue to drill-down to any level below as shown below:

Enterprise overview

You can continue to drill-down in this manner until you reach extension level:

Enterprise overview

To see the actual calls for any individual person, simply click on the name or extension number shown. This will show the actual calls as you can see below. Note that the associated recording will only be available when the TIM Talk option is added.

Enterprise overview

Running the report

On the Reports screen, click on Enterprise overview in the reports type list, as shown below:

Enterprise overview

You can tailor the report to your specific requirements by selecting the entity you'd like to apply the report to as well as the output format required. You can also limit the results by adding filters and options as detailed below:

Entity

The Entity allows you to choose which area of the directory you would like to report on. If you want to run a report for your entire organisation, you do not need to choose an entity.

If you want to select a specific area for reporting, click on the Add Entity button button to get a pop-up window showing the areas of the directory you can report on.

Add Entity

To drill up and down simply click on the hyperlinks provided, shown in the screenshot below as Aberdeen, Birmingham, Brighton, Cardiff etc.

Entity panel

Once you have reached the area you would like to report on, click on the green Add Entity button as highlighted in red below.

Entity panel

Alternatively if you are looking for a specific area e.g. person, department, site, name etc, you can just enter the name and press the Search button as shown in the example below:

Entity panel
Selected Entity

Once your entity you would like to report on had been selected, it will appear, as shown below:

Selected entity
Delete an Entity

In order to delete an entity, just select it with your mouse and click on the button above it, as shown below:

Delete entity 

NOTE: If you have restricted access, you may not be able to see the entire directory. You will need to speak to your system administrator to get access rights to other areas.

Period

TIM Enterprise allows complete flexibility in the way you can select your time periods.

Period panel

You have three types of period to select from. These are:

  • Preset period
  • Last period
  • Custom period

NOTE: Running this report over longer periods increases the reliability of its results.

Preset period

The standard Preset periods are shown below and can be selected from this simple drop-down list.

Preset period

The built-in periods are based on a standard Gregorian calendar and are defined as follows:

Period Description
Today The start date and end date is set to the current date. The default start time is set to 00:00:00 and the end time to the current time.
Yesterday The start date and end date is 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 week The start date is set to the Monday of the current week, whilst the end date is set to the current day. The default start time is set to 00:00:00 and the end time to the current time.
Last week This is Monday to Sunday of the previous week. The start time is set to 00:00:00 and the end time to 23:59:59.
This month The start date is set to the 1st day of the current month and the end date to today. The default start time is set to 00:00:00 and the end time to the current time.
Last month The start date for this period is set in three stages. The day is set to 01, the month is set to the current month minus one, or in the case of January, it is set to 12. The year is set to the current year, unless it is a new year, in which case the year is reduced by one. The start and end times are set to 00:00:00 and 23:59:59 respectively.
This year The start date is set to the first day of the first month of the current year. 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 calls The start date is set to the date of the first call in the database, whilst the end date is set to the date of the most recent call in the database. Times are also set to the times of the first and last calls in the database.
Last period

The last period allows complete flexibility, e.g. last 3 hours, last 7 days, last 2 quarters.

Last period

NOTE: We define last week from the pre-set periods as Sun-Sat of the previous week and last 7 days as the preceding 7 days.

Custom period

The user defined custom period allows the user to define the exact date and time that the report is required from and to.

Custom period

Format

This allows you to define the format of the output. Simply click on your preferred output format to determine whether you would like the report output in Web format, to PDF, CSV, as XML or Excel.

Formats panel

To select, simply click on your chosen format from the list as shown above. Note that any report can be run several times with different formats selected for the output if required.

Format Description
Web When a report is run, its output is displayed in the Report Output window, which is a mini web-browser containing the HTML output generated by the report engine. It is the common interface for all reports. The report body is shown in a window that can be panned around by using the horizontal and vertical scrollbars. If the report is made up of multiple pages, you can navigate it by using the Back and Fwd buttons at the bottom. You can print the report by pressing the Print button, or save the report to an HTML file by pressing the Save button and choosing a filename and location.

Universally-accessible, this format provides clickable column headers for dynamic sorting of table data, with clean graphical charts in the popular Flash format, so you can zoom into them for more detail. Each report is fully customisable - right down to the individual table fields. To view these reports, all that's needed is your favourite web browser - with no need for obscure add-ons!

PDF
(Portable Document Format)
PDF is a file format created by Adobe Systems in 1993 for document exchange. PDF is used for representing two-dimensional documents in a manner independent of the application software, hardware, and operating system.

PDFs will run over several pages depending on the report selected. Because of the nature of PDF reports, headers are fixed and not selectable as in web reports above. You may however pre-sort before running or scheduling using the filters available in the Options section. PDFs are ideal for producing reports like Phone Bills. PDFs are ideal when distributing to colleagues inside and outside of your organisation - while guaranteeing they'll look identical across all operating systems when viewed on the screen or printed out.

XML
(Extensible Markup Language)
XMLs purpose is to aid information systems in sharing structured data, especially via the internet, to encode documents and to serialise data. XML, in combination with other standards, makes it possible to define the content of a document separately from its formatting, making it easy to reuse that content in other applications or for other presentation environments. Most importantly, XML provides a basic syntax that can be used to share information between different kinds of computers, different applications, and different organizations without needing to pass through many layers of conversion.

Since all reports are derived from this native format, we pack each one with all the data you'd ever need, so you'll always be able to extract the report data into your favourite reporting packages, such as Business Objects, Crystal Reports, or even your favourite Office spreadsheet.

CSV
(Comma Separated Values)
A CSV file is used for the digital storage of data structured in a table of lists form, where each associated item (member) in a group is in association with others also separated by the commas of its set. Each line in the CSV file corresponds to a row in the table. Within a line, fields are separated by commas, each field belonging to one table column. CSV files are often used for moving tabular data between two different computer programs, for example between a database program and a spreadsheet program.

This option is ideal for interacting with your own back office systems, all CSV data is fully customisable using XSLT from the report's original XML format.

Excel Select Excel as your preferred report format, if you would like to manipulate the data and possibly integrate with data in other Excel spreadsheets.

Filters

The filters option allows you to add one or more filters to the report to allow you to sift through information in more detail. To add a filter, simply choose the relevant filter and press the button to add to the report.

Add filter

The following window will appear, allowing you to set your report's filters:

Add filter
Account code

If your telephone system provides the ability to add account codes, you may filter by entering the account code here. If more than one account code needs to be entered, simply comma separate.

The default option is to search for calls where there is an exact match for the account code entered i.e. equals, however you do have several other options as shown in the image below:

Account code

You can select one of the following options:

  • equals: To find only exact matches for the account code entered
  • is not equal to: To find all calls to everything except a particular account code
  • begins with: To find calls to an account code beginning with a specific series of digits
  • does not begin with: To exclude calls to account codes beginning with a specific series of digits
  • ends with: When you want to find calls to account codes ending with a specific series of digits
  • does not end with: When you want to find calls to account codes that do not end with a specific series of digits
  • contains: To find a call where you only have a portion of the account code number
  • does not contain: To find a call where you need to exclude certain numbers or portions of numbers

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Carrier

The carrier is the tariff table used to cost the call. You can choose to filter all calls by a particular carrier e.g. if you want to check a recent bill from that carrier. Alternatively, you may want to look at all calls not routed over a particular carrier. The Carrier filter is presented below:

Carrier

You can select one of the following options:

  • equals: Calls equal to the value entered here e.g. all calls via BT
  • is not equal to: Calls not equal to the value here e.g. all calls where BT is not the carrier

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Cost

This is the cost, if any, incurred by the call (shown in local currency). The Cost filter is presented below:

Cost

You can select one of the following options:

  • is greater than: All calls above the value entered here
  • is less than: All calls below the value entered here
  • equals: Calls equal to the value entered here
  • is not equal to: Calls not equal to the value here e.g. calls that were not free i.e. 0.00

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Dialled number

When filtering by dialled number, enter the number you want to filter by here, including any international prefixes. The Dialled number filter is presented below:

Dialled number

You can select one of the following options:

  • equals: To find only exact matches
  • is not equal to: To excluding calls to a particular number or beginning with a particular sequence of numbers
  • begins with: To find calls to a particular location e.g. 00 for International
  • does not begin with: To exclude certain calls e.g. 07 for UK mobile/personal
  • ends with: When you want to find calls to a specific DDI
  • does not end with: Calls to everywhere except a specific number range
  • contains: To find a call where you only have a portion of the number
  • does not contain: To find a call where you need to exclude certain numbers or portions of numbers

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

LCR code

If you use LCR code (Least Cost Routing), you can select the carrier you would like to report on here. Alternatively you can choose to exclude certain carriers. The LCR code filter is presented below:

LCR code

You can select one of the following options:

  • equals: To find only exact matches
  • is not equal to: To find any calls over alternative carriers
  • begins with: To find calls for a partial LCR code
  • does not begin with: To exclude calls over certain carriers
  • ends with: To exclude LCR codes ending with specific digits
  • does not end with: Where the LCR code does not end with specific digits
  • contains: To find a call on an LCR where you only have a portion of the number
  • does not contain: To find a call on an LCR excluding certain numbers or portions of numbers

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Start time

Start time is defined as the exact time of day the call started, as output by your telephone system. The Start time filter is presented below:

Start time

You can select one of the following options:

  • is greater than: Filter for calls that started after this time e.g. after 08:00
  • is less than: Filter for calls that started before this time e.g. before 07:00
  • equals: Filter for calls that started at exactly this time
  • is not equal to: Filter for calls outside a particular time

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Call type

This allows you to define the type of call you would like to report on. The Call type filter is presented below:

Call type

You can select one of the following options:

  • All inbound: The report will produce results based on every inbound call
  • Inbound answered: The report will produce results based on inbound answered calls only
  • Inbound DDI only: The report will produce results based on inbound DDI (direct dial) calls only
  • Inbound transfer only: The report will produce results based on inbound transferred calls only
  • Inbound missed: The report will produce results based on inbound missed calls only
  • All outbound calls: The report will produce results based on every outbound call
  • Outbound connected only: The report will produce results based on outbound connected calls only
  • Outbound not connected only: The report will produce results based on outbound calls that were not actually connected
  • Outbound operator assisted: The report will produce results based on outbound calls that operator assisted
  • Tandem: The report will produce results based on outbound calls that were not actually connected
  • User mobile calls: The report will produce results based on tandem calls i.e. calls coming into a switch through one line and transferred out again through another
  • User SMS: The report will produce results based on "user-dispatched [sent] text messages". These types of "call" only come through if processing mobile billing data
  • All internal: The report will produce results based on internal calls only
  • Internal answered only: The report will produce results based on internal answered calls only
  • Internal not answered only: The report will produce results based on internal calls that were not answered
  • Internal not connected only: The report will produce results based on internal calls that were not actually connected
  • Private wire: The report will produce results based calls that went over a private wire
  • Feature: The report will produce results based on feature calls. A feature call is something which a user dials to obtain a specific PBX feature (such as voicemail enable/disable, group pick up, etc.) They're not really outbound calls or even internal calls, although some may be picked up as such. A feature call can vary depending on the make/model of PBX

Then you can define the actual type of call. e.g. to see all abandoned DDI calls, choose equals and select Missed DDI only from drop-down list. This will show how many channels had missed or abandoned calls at any one time.

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

CLI

This is the telephone number of the caller if presented known as CLI (Caller Line Identification). If you want to search for calls from a particular CLI or look for all calls excluding those from a specific CLI, this filter is suitable for you. The CLI filter is presented below:

CLI

You can select one of the following options:

  • equals: To find only exact matches
  • is not equal to: To find every call except those from that CLI
  • begins with: To find calls that begin with similar CLI numbers
  • does not begin with: To exclude calls from specific CLIs
  • ends with: To exclude CLI numbers ending with specific digits
  • does not end with: Where the CLI does not end with specific digits
  • contains: To find call from a CLI where you only have a portion of the number
  • does not contain: To find a call from a CLI excluding certain numbers or portions of numbers

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Destination

The destination can most easily be defined as the B end of the call. It will change depending on the type of report being run. e.g. on an internal call, the destination will be the extension number or name of the person being dialled (if the extension number has been allocated a name). On an outgoing call the destination will be the name of the place being dialled e.g. USA, Leeds, Vodafone etc. If a location or mobile has been customised with an exact name, this will be shown e.g. Joe Bloggs mobile, ABC Corp LA office etc. This allows you to search for all calls except those to a specific destination. The Destination filter is presented below:

Destination

You can select one of the following options:

  • equals: To find only exact matches for this actual destination
  • is not equal to: To exclude calls that don't match this destination
  • begins with: To find calls that begin with a similar spelling
  • does not begin with: To find calls except those that beging with a specific location spelling
  • ends with: To exclude locations ending with specific letters
  • does not end with: To include all calls where the location does not end with specific letters
  • contains: To find calls to destinations where you only have a portion of the name
  • does not contain: To find a call to destinations where you want to exclude a portions of the name

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Duration

You may want to filter calls based on the length of time spent on a call i.e. call duration. The Duration filter is presented below:

Duration

You can select one of the following options:

  • is greater than: Allows you to look for calls longer than the duration entered
  • is less than: Allows you to look for calls shorter than the duration entered
  • equals: Allows you to look for calls equal to the duration shown
  • is not equal to: Allows you to look for any call that does not match the duration entered

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Response time

This filter allows you to search and see how long it took for a call to be answered. The duration for response time is always in seconds. The Response time filter is presented below:

Response time

You can select one of the following options:

  • is greater than: Allows you to search for calls where the response time is longer than the number of seconds entered
  • is less than: Allows you to search for calls where the response time is below the number of seconds entered
  • equals: Allows you to search for calls where the response time equals that entered
  • is not equal to: Allows you to search for calls where the response time differs to that entered
Trunk access code

This filter allows you to search for calls that used a particular trunk access routing code. The Trunk access code filter is presented below:

Trunk access code

You can select one of the following options:

  • equals: To find calls using only this trunk access code
  • is not equal to: To find every call that went out not using this trunk access code
  • begins with: To find calls that went out over a trunk access code that began with these digits
  • does not begin with: To find calls that went out over any trunk access code excluding those that began with the digits entered
  • ends with: To find calls over any trunk access code ending with specific digits
  • does not end with: To find calls over any trunk access code that does not end with specific digits
  • contains: To find calls over any trunk access code where you only have a portion of the number
  • does not contain: To find a call over any trunk access code which does not certain numbers or portions of numbers

To add the filter, simply choose the relevant filter and press the Add button to add to the report.

Added Filters

Once your filters are added, they will appear under the Filters section, as shown below:

Added filters
Delete a Filter

In order to delete a filter, just select it with your mouse and click on the button above it, as shown below:

Delete filter

NOTE: You may add more than one Filter to any report.

Options

Unlike Filters, Options differ depending on the report being run. Some reports do not have any options. Because all options are not available on all reports, only the options that can be used with the report selected will be shown. All other options will be greyed out and can not be selected.

Options

Upon selecting the Option, then click on the Add button to add this option or just select the Close button if you no longer want to include this Option.

A list with the available options for the Enterprise overview report can be seen below:

Exclude transfers

Select this option if you would like to exclude transferred calls when running this report.

Exclude transfers

As shown above, you have the following two options:

  • Yes: When this option is selected, all transferred calls are excluded in the results
  • No: When this option is selected, transferred calls are included as standard

Once your option is selected, press the Add button to add it to the report.

Exclude weekends

This gives you the option of excluding weekend calls from any results shown. To exclude weekend calls, simply select Yes as your option.

Exclude weekends

As shown above, you have the following two options:

  • Yes: When this option is selected, weekends calls are normally excluded from the report
  • No: Select this option to include weekend calls in reports

Once your option is selected, press the Add button to add it to the report.

Hide unused

This gives you the option of excluding unused extensions from the results shown.

Exclude transfers

As shown above, you have the following two options:

  • Yes: Select this option to exclude unused extension from the results
  • No: Unused extensions are included in the results

Once your option is selected, press the Add button to add it to the report.

Sort results by

When running this report, you may want to order the results to suit. You can select the criteria by which you want to order the results from the list as shown below:

Sort results by
  • Name: ...............................
  • Number of missed calls: ..................
  • Average missed duration: .................
  • Number of answered calls: ................
  • Total answered duration: ...............................
  • Average answered duration: ..................
  • Average answered response: ..................
  • Number of outbound calls: ..................
  • Total outbound duration: .....................
  • Average outbound duration: .................
  • Total outbound cost: ..................
  • Number of tandem calls: ..................
  • Average tandem response: .....................
  • Total tandem duration: .....................
  • Average tandem duration: .................
  • Total tandem cost: ..................

Once your option is selected, press the Add button to add it to the report.

Sort order

Decide if you would like the results displayed in ascending or descending order.

Sort order

You may choose to order the results in either ascending or descending order. Note that all web reports have clickable headers so you can reorder on-the-fly. However for other report formats e.g. PDF, it's best to decide on the Sort order before running.

  • Ascending: :Results are ordered lowest first
  • Descending: Results are ordered highest first

Once your option is selected, press the Add button to add it to the report.

Ignore missed

You may choose to ignore missed calls below a defined time e.g. 2 seconds. Because the ring time is so short, these calls are difficult to actually answer and therefore you may want to exclude from the Enterprise overview report.

Ignore missed

As shown above, you have the option to insert the number of seconds above which your missed calls will be ignored.

Once your option is selected, press the Add button to add it to the report.

Audio only

This option allows you to display only calls that have an associated voice recording in the results.

Audio only

As shown above, you have the following two options:

  • Yes: The report results will only show calls with an audio file attached
  • No: The report excludes all calls with audio attached

Once your option is selected, press the Add button to add it to the report.

Notes only

This option allows you to display only calls that have an associated note in the results.

Notes only

As shown above, you have the following two options:

  • Yes: The report results will only show calls with a note attached
  • No: The report excludes all calls with a note attached

Once your option is selected, press the Add button to add it to the report.

Scored only

This option allows you to limit the search to scored calls only.

Scored only

As shown above, you have the following two options:

  • Yes: The report results will only show calls with a score attached i.e. calls that have been scored
  • No: The report excludes all calls with a score attached. i.e. all calls that have not been scored

Once your option is selected, press the Add button to add it to the report.

Added Options

Once your options are added, they will appear under the Options section, as shown below:

Added Options
Delete an Option

In order to delete an option, just select it with your mouse and click on the button above it, as shown below:

Delete Options

NOTE: You may add more than one Option to any report.

Creating the report

When you have chosen a reporting period, and are happy with your selections, you have two options:

  • Run the report now
  • Schedule for future delivery

To choose your preferred option, select the appropriate button.

If you choose to run the report now, click the Run now button, as shown below. The results will appear immediately in your chosen format.

Run report

To schedule the report for delivery at a later date, follow the instruction given on the Schedule a report section.

Enterprise overview - The results

When selecting Web as the output format, this report will appear as below.

The Web format allows for complete flexibility when viewing any report. To view details of any filters or selection parameters used in creating this report, simply click on About this report at the top right of the page.

As with all reports, the header of the report includes the report title, any name you may have given to it, and the date and time it was run.

Enterprise overview

All headers are clickable allowing you re-arrange the report layout in seconds, to sort the calls in ascending or decending order based on the header clicked.

You can click on any site to drill-down to the extension group information. The example below shows extension group information for the London site.

Enterprise overview

The body of the report consists of detailed summary information about each extension group (or individual extension if you already selected an extension group during the criteria selection process). A description of each column header is described here, in order from left to right:

Header Description
Site/Extension Group If reporting on more than one site, the first screen will by default show site information. If reporting on a single site only, the report will display the extension group by default. You can drill-down to the extension group level, by clicking on the individual site name. If an extension group is missing from this list, then the system did not find any calls made or received by any extension in that group.
Missed The missed calls column is always displayed as red. It allows you to re-order your call analysis detail based on whichever of the following criteria is most important:
  • Squiggle: Shows how many unanswered (or abandoned) calls lost by all active extensions in the particular group displayed.
  • Avg duration: Shows the average duration of missed calls for the group displayed alongside.
Answered The answered calls columm is always displayed in green. It allows you to re-order the Call analysis report based on incoming call information. You can re-arrange based on any of the following selection criteria:
  • Squiggle: Shows the number of incoming calls that were successfully answered by extensions in the group. Transferred calls are included in this total.
  • Total duration: This column shows the total duration of all incoming calls by all extensions in the group.
  • Avg duration: The average duration of all incoming calls for the group.
  • Avg response: The average time taken to respond to calls for the group/extension displayed.
Outbound The outbound calls column is always displayed in blue. It shows the total number of calls for each half hour, the maximum, average and total duration for calls in that half hour and average and total cost of calls made in that half hour. It also allows you to re-order the Call analysis report based on this outbound call information. You can re-arrange based on any of the following selection criteria:
  • Squiggle: The number of outbound calls made by the extension group.
  • Total duration: The total aggregate duration of all outgoing calls by all active extensions in the group.
  • Avg duration: Average duration of an outgoing calls by all extensions in the group.
  • Total cost: Total aggregate cost of all outbound calls made by all active extensions in the extension group.

In addition to the summary information, totals and averages of all call types are shown in footer for each column.

Drilling-down

Having seen the summary information for each extension group, you may wish to see the same information for each individual extension in a particular group.

Click on the extension group you're interested in, and a new report will be produced showing the same summary information, but this time for each individual extension in the selected group, as shown below:

Enterprise overview

Finally, by clicking on the hyperlink of a particular extension, a new report is produced showing, in chronological order, the actual calls that were made and received by that particular extension.

Enterprise overview

The output for this, the lowest level in the Enterprise overview report, is slightly different than the previous summary screens. Because this is an itemised list of all calls made and received, there is no summary information, and so there is a different structure, as defined below:

Header Description
Date & Time Shows the date and time the calls was started.
Source Details of where the call originated.
CLI Shows the caller line identity of the incoming call.
Route Shows the number that was dialled, in the case of an outgoing or internal call.
Destination For outgoing calls, shows the destination of the call; for other calls, shows the type of call, e.g. unanswered, abandoned, internal, feature call.
Response The response field shows the length of time it took before the call was answered i.e. the response time.
Duration Shows the duration of the call in hours, minutes and seconds.
Cost Shows the cost of the call.
Listen to the recording button Shows only if there is a recording associated with the call. To play, simply click on this icon.

If you would like to go back and view any report for a larger section of the organisation, simply click on the appropriate link in the breadcrumb as shown below:

Breadcrumbs
Labels: