How can we Help?

Datasets and the Data Dictionary

Follow

Datasets

What’s a dataset in Explore? It’s a set of dimensions and metrics or a single statistical matrix with dimensions and measures, which are organized in such a way for Explore users to easily get the answers to their performance queries and to make it as easy as possible for them to find the answers to their questions. 

 

What’s the difference between Dimensions and Measures?

Dimensions are the contextual fields in your dataset, the independent variables, the x in your distribution.

Metrics or measures are what you want to assess on dimensions behaviour. For instance a specific agent that you’ll identify by name is a dimension, but you want to know how many calls were answered by that agent in the last 30 days, so the number of calls is your measure.

For customizing your own reports and dashboards we have 4 distinct datasets so that you know exactly where to start and what kind of metrics and dimensions you can expect to find.

 

Agents Activity Analysis Dataset

As the name suggests, this dataset is dedicated to agents metrics. It’s here you find statuses, duration related metrics, as well as the speed of answer, calls answered and missed calls.  

The way that the Ring Groups and Team objects are currently stored in the database differ, meaning that you’ll have the information of the Ring Groups returning information based on the logic of “as was” in one hand and in the other, the Team information will be returned “as is”.

For example. Let’s assume I pick Team Support and Agent Ring Group support_en for the past month of May. 

The results returned will show for all the agents that now belong to Support team (as is) but for the Agent Ring Group support_en will show me all the Agents allocated to that Ring Group in May (as was).

 

Calls Analysis Dataset

As for Calls Dataset, this is the more detailed and complete dataset for calls dedicated info. It is similar to a dump of the information from our platform in a dataset format. In this specific dataset, you’ll be able to filter by all dimensions. 

This is an exclusive capability of this dataset, you any dimension can be used as a filter. This particularity of the dataset along with the fact of it being the most thorough and complete compilation of information regarding the record of each call means that is the most flexible and complete dataset, providing consequently a great level and freedom of analysis. 

This can also be challenging and demanding, which is why a clear understanding of the dimensions and what each metric will return is advised, so we stress the importance of using the Data Dictionary.

 

Numbers Analysis Dataset

Numbers analysis Dataset is dedicated to everything phone number related. Here you can find the thresholds set for each of the numbers in your account. Both Service Level threshold and Short-Abandoned threshold details for each number can be derived from this dataset. Besides these configuration details you can also check the Ring Groups associated with Number and performance-wise, the volume of calls and also some time-based metrics.

 

Ring Groups (Queues) Analysis Dataset

The Ring Group Dataset is dedicated to providing metrics and dimensions related only with the Ring Groups’ activity and performance. For instance, to retrieve information regarding Service Level for a specific Ring Group, this is the dataset you’ll use.

You can find detailed information for this dataset by following the link to our Data Dictionary for the article dedicated to Ring Groups (Queues) Dataset

 

Data Dictionary

Overview

For fully detailed information on each dataset available and for information on the default dashboards, reports, and metrics in Explore, we’ve compiled a comprehensive glossary that we’ve called the Data Dictionary.

The Data Dictionary is split into a Glossary of Call Types, Scheduled Reports, Dashboard Historical Metrics and Create Feature Datasets, with each section providing a thorough assessment or definition of all the terminology used in our Reporting product. 

 

Using the Data Dictionary

Use the Search [1] function to enter a metric and the Data Dictionary will return all articles with matching entries.

DD_Search_i.png

 

The results are displayed in order of relevance [2] and you can display them all by clicking View All Results [3].

Alternatively you can use the browser’s search facility [4] (CTRL+F). Any matching entries will be highlighted in both the left navigation menu [5] and in the content of the section your viewing [6].

DD_Search_ii.png

 

You also have the option of simply scrolling to, and selecting a specific entry for the dataset or Metric you’re working on [7].

DD_Search_iii.png

 

The detail is presented for each dataset in the following ways:

 

Datasets

Name Description Type Format Section Filter Field
Name of the field that can be a Metric/Measure or a Dimension Detail on what that Dimension or Metric represents Statistical nature of the outcome - number, sum, average, max, min Formats can be 0.00% -  percentage0 - number at unit level00 - number representing a count[hh]:mm:ss - duration Within each Dataset what is the section (view label) the Metric or Dimensions belongs to If the Metric or Dimension can be used as a filter If the field listed is a Dimension or a Measure/Metric 

 

Reports and Metrics

Metric Name Description Calculation Metric Type Perspective
Name of the Metric or measure Details of that particular Metric or Measure  A breakdown of  how the Report or Metric is calculated How the Metric is shown - as a percentage, a count, or a timestamp. If it’s an agent or a queue (ring group) metric 
Have more questions? Submit a request

Comments

Powered by Zendesk