Report API¶
The report API allows you to access information in a similar way to reports, through HTTP POST requests. The intent of this document is to show how to use this API.
POST Request¶
On the post request should be sent a JSON raw that contains information for get data of the report that you want. The return of the post request is a CSV format with each column of the specific report.
URL Definition¶
The URL of the post request should be formatted as below:
https://<instantvoice host address>/reports/<accountcode>
Example: If the InstantVoice’s host address is 192.168.1.123 and if accountcode in your InstantVoice server is acc1, then:
https://192.168.1.123/reports/acc1
JSON Definition¶
It is necessary to send a JSON raw in the body of the post request. The main fields of the JSON are:
- login = User of the administrative interface. This user must have access to the reports interface. This field is required.
- pass = Password of the login. This field is required.
- id = The integer of the report ID. The list of the ids report is defined in this document in List of reports descriptions. This field is required.
- interval = Indicates the interval of time (in seconds) the report will display each row. Valid values are: 120, 60 or 30. It is required in some reports.
- percentage = Indicates whether the values of some fields will be displayed in percent format. ‘0’=NO or ‘1’=YES. It is required in some reports.
- timeformat = Is the format how the time will be displayed. If ‘0’ the format is ‘99:99:99’, if ‘1’ the format is ‘000’ (seconds). It is required in some reports.
- params = List of fields to filter data of report. This field is required.
- columns = List of fields that will be returned on the CSV. This field is optional. If not informed, the system returns all fields of the report using the name of column without alias.
JSON example:
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":32,
"interval":120,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"survey_id","alias":"Survey ID"},{"name":"queue_name"
,"alias":"Grupo"},{"name":"answered","alias":"Atendidas"},{"name":"surveys","alias":"Pesquisas"},{"name"
:"total_answer_1","alias":"Número de Respostas 1"},{"name":"total_answer_2","alias":"Número de Respostas 2"}
,{"name":"total_answer_3","alias":"Número de Respostas 3"},{"name":"total_answer_4","alias":"Número de Respostas 4"}
,{"name":"total_answer_5","alias":"Número de Respostas 5"},{"name":"total_answer_6"
,"alias":"Número de Respostas 6"},{"name":"total_answer_7","alias":"Número de Respostas 7"},{"name":"total_answer_8"
,"alias":"Número de Respostas 8"},{"name":"total_answer_9","alias":"Número de Respostas 9"},{"name":"total_answer_10"
,"alias":"Número de Respostas 10"},{"name":"sum_answer_1","alias":"Média Resposta 1"},{"name":"sum_answer_2"
,"alias":"Média Resposta 2"},{"name":"sum_answer_3","alias":"Média Resposta 3"},{"name":"sum_answer_4"
,"alias":"Média Resposta 4"},{"name":"sum_answer_5","alias":"Média Resposta 5"},{"name":"sum_answer_6"
,"alias":"Média Resposta 6"},{"name":"sum_answer_7","alias":"Média Resposta 7"},{"name":"sum_answer_8"
,"alias":"Média Resposta 8"},{"name":"sum_answer_9","alias":"Média Resposta 9"},{"name":"sum_answer_10"
,"alias":"Média Resposta 10"}]
}
The params field¶
The params field is defined with all report fields that you want to filter data.
Structure of params field:
"params":{
<report field>:{
"type":<match operator type>,
"values":[<values to filter>]
}
}
<report field> - String with the name of the report field that do you want to filter data. All report fields contain a ‘Column Type’ that indicates whether the field can be used as a parameter or filter. Parameters are required fields.
<match operator type> - String with the operator that is used to compare values. The operators types are:
| Operator | Description |
|---|---|
| == | Equal operator |
| !== | Different operator |
| >< | Between operator |
| > | Greater than operator |
| < | Less than operator |
| - | Contains operator for text fields |
<values to filter> - List of strings with the values that is used to compare with the operator.
The columns field¶
The columns field is a list of dictionary with the names of fields that you want to show on CSV return.
Structure of columns field:
"columns":[
{"name":<report column name>, "alias":<column name alias>}
,...
]
<report column name> - String with the column name of the report. The column names of each report are listed below in List of reports descriptions.
<column name alias> - String with the friendly name of the report column name to be returned on CSV.
Code sample¶
#! /usr/bin/env python2.6
# coding=utf-8
import requests
url = 'https://192.168.1.123/reports/acc1'
data = """{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":22,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-16",
"2016-11-16"
]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"extension","alias":"Ramal"},{"name":"agent","alias"
:"Operador"},{"name":"name","alias":"Nome"},{"name":"login","alias":"Login"},{"name":"logoff","alias"
:"Logout"}]
}"""
response = requests.post(url, data=data)
print response.content
Expected result¶
Data,Ramal,Operador,Nome,Login,Logout
2016-11-16,0001,1001,1001,2016-11-16 11:51:35,2016-11-16 18:05:55
2016-11-16,0002,1002,1002,2016-11-16 11:52:20,2016-11-16 18:03:11
List of reports descriptions¶
In the list below are all reports and their descriptions.
Chamadas - Agrupamento por descritores¶
Report ID: 1.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| tag | Descritor | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":1,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-14",
"2016-11-14"
]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"tag","alias":"Descritor"},{"name":"calls","alias"
:"Chamadas"}]
}
Chamadas - Metricas por data¶
Report ID: 2.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | == |
| interval | Intervalo | parameter | YES | == |
| made | Realizadas | info | ||
| received | Recebidas | info | ||
| time | Hora | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":2,
"interval":120,
"percentage":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-14"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"calls","alias"
:"Chamadas"},{"name":"made","alias":"Realizadas"},{"name":"received","alias":"Recebidas"},{"name":"answered"
,"alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"}]
}
Chamadas - Metricas por periodo¶
Report ID: 3.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| made | Realizadas | info | ||
| received | Recebidas | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":3,
"percentage":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-14", "2016-11-14"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"calls","alias":"Chamadas"},{"name":"made","alias"
:"Realizadas"},{"name":"received","alias":"Recebidas"},{"name":"answered","alias":"Atendidas"},{"name"
:"unanswered","alias":"Não Atendidas"}]
}
Chamadas - Entrantes, Metricas por data¶
Report ID: 4.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | == |
| did | DDR | info | ||
| interval | Intervalo | parameter | YES | == |
| ivr | URA | info | ||
| queue | Grupo | info | ||
| time | Hora | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":4,
"interval":120,
"percentage":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-14"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"calls","alias"
:"Chamadas"},{"name":"ivr","alias":"URA"},{"name":"did","alias":"DDR"},{"name":"queue","alias":"Grupo"
},{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"}]
}
Chamadas - Entrantes, Metricas por periodo¶
Report ID: 5.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| did | DDR | info | ||
| ivr | URA | info | ||
| queue | Grupo | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":5,
"percentage":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-14", "2016-11-14"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"calls","alias":"Chamadas"},{"name":"ivr","alias"
:"URA"},{"name":"did","alias":"DDR"},{"name":"queue","alias":"Grupo"},{"name":"answered","alias":"Atendidas"
},{"name":"unanswered","alias":"Não Atendidas"}]
}
Chamadas - Saintes, Metricas por data¶
Report ID: 7.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | == |
| interval | Intervalo | parameter | YES | == |
| time | Hora | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":7,
"interval":120,
"percentage":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-14"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"calls","alias"
:"Chamadas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"},{"name"
:"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2"
,"alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">
=120s"}]
}
Chamadas - Saintes, Metricas por periodo¶
Report ID: 8.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":8,
"percentage":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-14", "2016-11-14"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"calls","alias":"Chamadas"},{"name":"answered"
,"alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"},{"name":"answered_before_0","alias"
:"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2","alias":"<90s"},{"name"
:"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">=120s"}]
}
Chamadas - Registro detalhado¶
Report ID: 26.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| billsec | Duração Atendimento | info | ||
| customer | Cliente | filter | NO | == / - |
| date | Data | parameter | YES | == / >< |
| destination | Destino | filter | NO | == / - |
| duration | Duração Parcial | filter | NO | > / < |
| duration_total | Duracao Total | filter | NO | > / < / >< |
| extension | Ramal | filter | NO | == |
| hangupby | Finalizador | filter | NO | == |
| hold | Em espera | info | ||
| leg | Transferencia | info | ||
| note | Observação | filter | NO | - |
| origin | Origem | filter | NO | == / - |
| queue_name | Grupo | filter | NO | == |
| reasons | Motivos | filter | NO | - |
| rec_filter | Filtro | info | ||
| rec_filter_action | Ação | info | ||
| record | Gravação | info | ||
| recordxfer | Gravação Transf. | info | ||
| route | Rota | filter | NO | - |
| status | Status | filter | NO | == / !== |
| tags | Descritores | filter | NO | - |
| time | Hora | filter | NO | >< |
| type | Tipo | filter | NO | == |
| uniqueid | Uniqueid | filter | NO | == |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":26,
"params":{
"date":{
"type":"==",
"values":["2016-11-14"]
},
"uniqueid":{
"type":"==",
"values":["1479132934.1.36"]
}
},
"columns":[{"name":"leg","alias":"Transferencia"},{"name":"uniqueid","alias":"Uniqueid"
},{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"type","alias":"Tipo"
},{"name":"origin","alias":"Origem"},{"name":"destination","alias":"Destino"},{"name":"extension",
"alias":"Ramal"},{"name":"agent","alias":"Operador"},{"name":"queue_name","alias":"Grupo"},
{"name":"billsec","alias":"DuraçãoAtendimento"},{"name":"duration","alias":"DuraçãoParcial"},
{"name":"duration_total","alias":"DuracaoTotal"},{"name":"hold","alias":"Emespera"},{"name":"status"
,"alias":"Status"},{"name":"record","alias":"Gravação"},{"name":"recordxfer","alias":"GravaçãoTransf."}
,{"name":"tags","alias":"Descritores"},{"name":"customer","alias":"Cliente"},{"name":"route"
,"alias":"Rota"},{"name":"rec_filter","alias":"Filtro"},{"name":"rec_filter_action","alias":
"Ação"},{"name":"hangupby","alias":"Finalizador"},{"name":"reasons","alias":"Motivos"}
,{"name":"note","alias":"Obs"}]
}
Chamadas - Chamadas Saintes, Tarifação¶
Report ID: 30.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| cost | Custo | info | ||
| date | Data | parameter | YES | >< |
| duration | Duração | info | ||
| entity | Entidade | info | ||
| extension | Destino | filter | NO | == |
| origin | Origem | filter | NO | == |
| permission_entity | Nome Entidade | info | ||
| permission_group | Grupo de Per. | info | ||
| route | Rota | info | ||
| server | Servidor | info | ||
| time | Hora | info | ||
| trunk | Tronco | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":30,
"params":{
"date":{
"type":"><",
"values":["2016-11-16","2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"origin","alias"
:"Origem"},{"name":"extension","alias":"Destino"},{"name":"agent","alias":"Operador"},{"name":"route"
,"alias":"Rota"},{"name":"server","alias":"Servidor"},{"name":"trunk","alias":"Tronco"},{"name":"entity"
,"alias":"Entidade"},{"name":"permission_entity","alias":"Nome Entidade"},{"name":"duration","alias"
:"Duração"},{"name":"cost","alias":"Custo"},{"name":"permission_group","alias":"Grupo de Per."}]
}
Chamadas - Chamadas, Registro de Descritores¶
Report ID: 31.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Agente | info | ||
| date | Data | parameter | YES | == |
| duration | Duração | info | ||
| extension | Destino | info | ||
| origin | Origem | info | ||
| status | Status | info | ||
| tag | Descritores | info | ||
| time | Hora | filter | NO | == |
| type | Tipo | filter | NO | == |
| uniqueid | Uniqueid | info | / |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":31,
"params":{
"date":{
"type":"==",
"values":["2016-11-16"]
}
},
"columns":[{"name":"uniqueid","alias":"Uniqueid"},{"name":"tag","alias":"Descritores"},{"name":"date","alias":"Data"
},{"name":"time","alias":"Hora"},{"name":"type","alias":"Tipo"},{"name":"agent","alias"
:"Agente"},{"name":"origin","alias":"Origem"},{"name":"extension","alias":"Destino"},{"name":"duration"
,"alias":"Duração"},{"name":"status","alias":"Status"}]
}
Chamadas - Registro detalhado de URA¶
Report ID: 37.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| callerid | CallerID | filter | NO | - |
| date | Data | parameter | YES | == / >< |
| datetime | Data e Hora | info | ||
| day | Dia | info | ||
| depth | Nível | info | ||
| disposition | Disposition | info | ||
| disposition_data | Disposition Data | info | ||
| disposition_queue | Disposition Queue | info | ||
| duration | Duração | info | ||
| duration_ivr | Duração URA | info | ||
| duration_queue | Duração Fila | info | ||
| duration_talk | Duração Atendimento | info | ||
| interval120 | Intervalo 120min | info | ||
| interval30 | Intervalo 30min | info | ||
| interval60 | Intervalo 60min | info | ||
| ivr_module | Nome Módulo | info | ||
| ivr_name | Nome URA | info | ||
| last | Última | info | ||
| month_full | Mês (completo) | info | ||
| month_num | Mês (número) | info | ||
| parent_tag | Descritor Superior | info | ||
| parent_tag_description | Notas Descritor Superior | info | ||
| parent_tag_id | ID Descritor Superior | info | ||
| parent_tag_table_description | Descrição Descritor Superior | info | ||
| route | Rota | info | ||
| status | Status | info | ||
| status_description | Descrição Status | info | ||
| status_error | Status Erro | info | ||
| status_success | Status Sucesso | info | ||
| tag | Descritor | info | ||
| tag_description | Notas Descritor | info | ||
| tag_id | ID Descritor | info | ||
| tag_table_description | Descrição Descritor | info | ||
| time | Hora | filter | NO | >< |
| timestamp | Timestamp | info | ||
| uniqueid | Uniqueid | filter | NO | == |
| year | Ano | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":37,
"params":{
"date":{
"type":"==",
"values":["2016-10-06"]
}
},
"columns":[{"name":"uniqueid","alias":"Uniqueid"},{"name":"timestamp","alias":"Timestamp"},{"name":"date","alias"
:"Data"},{"name":"time","alias":"Hora"},{"name":"datetime","alias":"Data e Hora"},{"name"
:"year","alias":"Ano"},{"name":"month_num","alias":"Mês (número)"},{"name":"month_full","alias":"Mês (completo)"}
,{"name":"day","alias":"Dia"},{"name":"interval30","alias":"Intervalo 30min"},{"name":"interval60"
,"alias":"Intervalo 60min"},{"name":"interval120","alias":"Intervalo 120min"},{"name":"callerid","alias"
:"CallerID"},{"name":"route","alias":"Rota"},{"name":"tag_id","alias":"ID Descritor"},{"name":"tag","alias"
:"Descritor"},{"name":"tag_description","alias":"Notas Descritor"},{"name":"tag_table_description","alias"
:"Descrição Descritor"},{"name":"parent_tag_id","alias":"ID Descritor Superior"},{"name":"parent_tag"
,"alias":"Descritor Superior"},{"name":"parent_tag_description","alias":"Notas Descritor Superior"},
{"name":"parent_tag_table_description","alias":"Descrição Descritor Superior"},{"name":"duration","alias"
:"Duração"},{"name":"depth","alias":"Nível"},{"name":"disposition","alias":"Disposition"},{"name":"disposition_data"
,"alias":"Disposition Data"},{"name":"disposition_queue","alias":"Disposition Queue"},{"name":"ivr_name"
,"alias":"Nome URA"},{"name":"ivr_module","alias":"Nome Módulo"},{"name":"last","alias":"Última"},{"name"
:"status","alias":"Status"},{"name":"status_description","alias":"Descrição Status"},{"name":"status_success"
,"alias":"Status Sucesso"},{"name":"status_error","alias":"Status Erro"},{"name":"duration_ivr","alias"
:"Duração URA"},{"name":"duration_queue","alias":"Duração Fila"},{"name":"duration_talk",
"alias":"Duração Atendimento"}]
}
Grupos - (Entrantes), Metricas por data¶
Report ID: 11.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| CALLBACK | Callback | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | == |
| DIALER | Discador | info | ||
| giveup | Desistências | info | ||
| giveup_before_0 | Des. <30s | info | ||
| giveup_before_1 | Des. <60s | info | ||
| giveup_before_2 | Des. <90s | info | ||
| giveup_before_3 | Des. <120s | info | ||
| giveup_before_4 | Des. >120s | info | ||
| interval | Intervalo | parameter | YES | == |
| longest_hold | Maior Espera | info | ||
| queue_name | Grupo | filter | NO | == |
| refused | Recusadas | info | ||
| time | Hora | info | ||
| total_call | TMO | info | ||
| total_hold | TME | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":11,
"interval":120,
"timeformat":0,
"percentage":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"queue_name","alias"
:"Grupo"},{"name":"calls","alias":"Chamadas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered"
,"alias":"Não Atendidas"},{"name":"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias"
:"<60s"},{"name":"answered_before_2","alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name"
:"answered_before_4","alias":">=120s"},{"name":"giveup","alias":"Desistências"},{"name":"refused","alias"
:"Recusadas"},{"name":"total_talk","alias":"TMA"},{"name":"total_hold","alias":"TME"},{"name":"total_call"
,"alias":"TMO"},{"name":"longest_hold","alias":"Maior Espera"},{"name":"giveup_before_0","alias":"Des. <30s"}
,{"name":"giveup_before_1","alias":"Des. <60s"},{"name":"giveup_before_2","alias":"Des. <90s"
},{"name":"giveup_before_3","alias":"Des. <120s"},{"name":"giveup_before_4","alias":"Des. >120s"}]
}
Grupos - (Entrantes), Metricas por período¶
Report ID: 12.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| CALLBACK | Callback | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| DIALER | Discador | info | ||
| giveup | Desistências | info | ||
| giveup_before_0 | Des. <30s | info | ||
| giveup_before_1 | Des. <60s | info | ||
| giveup_before_2 | Des. <90s | info | ||
| giveup_before_3 | Des. <120s | info | ||
| giveup_before_4 | Des. >120s | info | ||
| longest_hold | Maior Espera | info | ||
| queue_name | Grupo | filter | NO | == |
| refused | Recusadas | info | ||
| total_call | TMO | info | ||
| total_hold | TME | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":12,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-16","2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"queue_name","alias":"Grupo"},{"name":"calls","alias"
:"Chamadas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"},{"name"
:"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2"
,"alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">=120s"}
,{"name":"giveup","alias":"Desistências"},{"name":"refused","alias":"Recusadas"},{"name":"total_talk"
,"alias":"TMA"},{"name":"total_hold","alias":"TME"},{"name":"total_call","alias":"TMO"},{"name":"longest_hold"
,"alias":"Maior Espera"},{"name":"giveup_before_0","alias":"Des. <30s"},{"name":"giveup_before_1","alias"
:"Des. <60s"},{"name":"giveup_before_2","alias":"Des. <90s"},{"name":"giveup_before_3","alias":"Des. <120s"}
,{"name":"giveup_before_4","alias":"Des. >120s"}]
}
Grupos - (Saintes), Metricas por data¶
Report ID: 14.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | == |
| interval | Intervalo | parameter | YES | == |
| queue_name | Grupo | filter | NO | == |
| time | Hora | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":14,
"interval":120,
"timeformat":0,
"percentage":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"queue_name","alias"
:"Grupo"},{"name":"calls","alias":"Chamadas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered"
,"alias":"Não Atendidas"},{"name":"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias"
:"<60s"},{"name":"answered_before_2","alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name"
:"answered_before_4","alias":">=120s"},{"name":"total_talk","alias":"TMA"}]
}
Grupos - (Saintes), Metricas por periodo¶
Report ID: 15.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| queue_name | Grupo | filter | NO | == |
| total_talk | TMA | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":15,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-16","2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"queue_name","alias":"Grupo"},{"name":"calls","alias"
:"Chamadas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"},{"name"
:"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2"
,"alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">=120s"}
,{"name":"total_talk","alias":"TMA"}]
}
Grupos - (Saintes), Registro detalhado¶
Report ID: 16.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| accountcode | accountcode | info | ||
| agent | Operador | filter | NO | == |
| date | Data | parameter | YES | == |
| duration | Duração | info | ||
| extension | Destino | filter | NO | == |
| origin | Ramal | filter | NO | == |
| queue_name | Fila | parameter | YES | == |
| report_date | ReportJoinDate | info | ||
| report_time | ReportJoinTime | info | ||
| status | Status | filter | NO | == |
| time | Hora | info | ||
| uniqueid | Identificador | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":16,
"timeformat":0,
"params":{
"queue_name":{
"type":"==",
"values":["2001"]
},
"date":{
"type":"==",
"values":["2016-11-16"]
}
},
"columns":[{"name":"queue_name","alias":"Fila"},{"name":"date","alias":"Data"},{"name"
:"time","alias":"Hora"},{"name":"origin","alias":"Ramal"},{"name":"extension","alias":"Destino"},{"name"
:"agent","alias":"Operador"},{"name":"status","alias":"Status"},{"name":"duration","alias":"Duração"
},{"name":"uniqueid","alias":"Identificador"}]
}
Grupos - Metricas por data¶
Report ID: 17.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| CALLBACK | Callback | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | == |
| DIALER | Discador | info | ||
| interval | Intervalo | parameter | YES | == |
| made | Realizadas | info | ||
| queue_name | Grupo | filter | NO | == |
| received | Recebidas | info | ||
| time | Hora | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":17,
"interval":120,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"queue_name","alias"
:"Grupo"},{"name":"calls","alias":"Chamadas"},{"name":"made","alias":"Realizadas"},{"name":"received"
,"alias":"Recebidas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"
},{"name":"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2"
,"alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">=120s"}
,{"name":"total_talk","alias":"TMA"}]
}
Grupos - Metricas por periodo¶
Report ID: 18.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| CALLBACK | Callback | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| DIALER | Discador | info | ||
| made | Realizadas | info | ||
| queue_name | Grupo | filter | NO | == |
| received | Recebidas | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":18,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-16","2016-11-16"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"queue_name","alias":"Grupo"},{"name":"calls","alias"
:"Chamadas"},{"name":"made","alias":"Realizadas"},{"name":"received","alias":"Recebidas"},{"name":"answered"
,"alias":"Atendidas"},{"name":"unanswered","alias":"Não Atendidas"},{"name":"answered_before_0","alias"
:"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2","alias":"<90s"},{"name"
:"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">=120s"},{"name":"total_talk"
,"alias":"TMA"}]
}
Operadores - Métricas por período¶
Report ID: 19.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| active_pause_time | Tempo Pausa Ativa | info | ||
| agent | Operador | filter | NO | == |
| answered | Atendidas | info | ||
| answered_ads | Atendidas (discador) | info | ||
| answered_callback | Atendidas (callback) | info | ||
| answered_inbound | Atendidas (entrantes) | info | ||
| answered_outbound | Atendidas (saintes) | info | ||
| date | Data | parameter | YES | >< |
| login_time | Tempo Login | info | ||
| logins | Logins | info | ||
| logints | Hora Login | info | ||
| logouts | Logouts | info | ||
| logoutts | Hora Logout | info | ||
| made | Realizadas | info | ||
| name | Nome | info | ||
| pause_time | Tempo Pausa | info | ||
| pauses | Pausas | info | ||
| queue_name | Grupo | filter | NO | == |
| received | Recebidas | info | ||
| talk_time | Tempo Atendimento | info | ||
| talk_time_ads | Tempo Atendimento (discador) | info | ||
| talk_time_callback | Tempo Atendimento (callback) | info | ||
| talk_time_inbound | Tempo Atendimento (entrantes) | info | ||
| talk_time_outbound | Tempo Atendimento (saintes) | info | ||
| total_talk | TMA | info | ||
| total_talk_ads | TMA (discador) | info | ||
| total_talk_callback | TMA (callback) | info | ||
| total_talk_inbound | TMA (entrantes) | info | ||
| total_talk_outbound | TMA (saintes) | info | ||
| unanswered | Não Atendidas | info | ||
| unanswered_ads | Não Atendidas (discador) | info | ||
| unanswered_callback | Não Atendidas (callback) | info | ||
| unanswered_inbound | Não Atendidas (entrantes) | info | ||
| unanswered_outbound | Não Atendidas (saintes) | info | ||
| unpauses | Despausas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":19,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"agent","alias":"Operador"},{"name":"name","alias":"Nome"},{"name":"made","alias":"Realizadas"
},{"name":"received","alias":"Recebidas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered"
,"alias":"Não Atendidas"},{"name":"logints","alias":"Hora Login"},{"name":"logoutts","alias":"Hora Logout"
},{"name":"logins","alias":"Logins"},{"name":"logouts","alias":"Logouts"},{"name":"pauses","alias":"Pausas"
},{"name":"unpauses","alias":"Despausas"},{"name":"talk_time","alias":"Tempo Atendimento"},{"name":"login_time"
,"alias":"Tempo Login"},{"name":"pause_time","alias":"Tempo Pausa"},{"name":"active_pause_time","alias"
:"Tempo Pausa Ativa"},{"name":"total_talk","alias":"TMA"},{"name":"queue_name","alias":"Grupo"},{"name"
:"answered_inbound","alias":"Atendidas (entrantes)"},{"name":"unanswered_inbound","alias":"Não Atendidas (entrantes)"}
,{"name":"talk_time_inbound","alias":"Tempo Atendimento (entrantes)"},{"name":"total_talk_inbound"
,"alias":"TMA (entrantes)"},{"name":"answered_outbound","alias":"Atendidas (saintes)"},{"name"
:"unanswered_outbound","alias":"Não Atendidas (saintes)"},{"name":"talk_time_outbound","alias":"Tempo Atendimento (saintes)"}
,{"name":"total_talk_outbound","alias":"TMA (saintes)"}]
}
Operadores - Registro de ramais¶
Report ID: 22.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| date | Data | parameter | YES | >< |
| extension | Ramal | info | ||
| login | Login | info | ||
| logoff | Logout | info | ||
| name | Nome | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":22,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-16",
"2016-11-16"
]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"extension","alias":"Ramal"},{"name":"agent","alias"
:"Operador"},{"name":"name","alias":"Nome"},{"name":"login","alias":"Login"},{"name":"logoff","alias"
:"Logout"}]
}
Operadores - Registro detalhado¶
Report ID: 23.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| date | Data | parameter | YES | >< |
| duration | Duração | info | ||
| event | Evento | info | ||
| extension | Ramal | info | ||
| name | Nome | info | ||
| origin_or_destination | Origem | info | ||
| pause | Pausa | info | ||
| time | Hora | filter | NO | >< |
| uniqueid | Identificador | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":23,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-17",
"2016-11-17"
]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"agent","alias"
:"Operador"},{"name":"name","alias":"Nome"},{"name":"event","alias":"Evento"},{"name":"pause","alias"
:"Pausa"},{"name":"extension","alias":"Ramal"},{"name":"origin_or_destination","alias":"Origem"},{"name"
:"duration","alias":"Duração"},{"name":"uniqueid","alias":"Identificador"}]
}
Operadores - Metricas por periodo - Totais¶
Report ID: 51.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| active_pause_time | Tempo Pausa Ativa | info | ||
| agent | Operador | filter | NO | == |
| answered | Atendidas | info | ||
| answered_ads | Atendidas (discador) | info | ||
| answered_callback | Atendidas (callback) | info | ||
| answered_inbound | Atendidas (entrantes) | info | ||
| answered_outbound | Atendidas (saintes) | info | ||
| date | Data | parameter | YES | >< |
| login_time | Tempo Login | info | ||
| logins | Logins | info | ||
| logints | Hora Login | info | ||
| logouts | Logouts | info | ||
| logoutts | Hora Logout | info | ||
| made | Realizadas | info | ||
| name | Nome | info | ||
| pause_time | Tempo Pausa | info | ||
| pauses | Pausas | info | ||
| queue_name | Grupo | info | ||
| received | Recebidas | info | ||
| talk_time | Tempo Atendimento | info | ||
| talk_time_ads | Tempo Atendimento (discador) | info | ||
| talk_time_callback | Tempo Atendimento (callback) | info | ||
| talk_time_inbound | Tempo Atendimento (entrantes) | info | ||
| talk_time_outbound | Tempo Atendimento (saintes) | info | ||
| total_talk | TMA | info | ||
| total_talk_ads | TMA (discador) | info | ||
| total_talk_callback | TMA (callback) | info | ||
| total_talk_inbound | TMA (entrantes) | info | ||
| total_talk_outbound | TMA (saintes) | info | ||
| unanswered | Não Atendidas | info | ||
| unanswered_ads | Não Atendidas (discador) | info | ||
| unanswered_callback | Não Atendidas (callback) | info | ||
| unanswered_inbound | Não Atendidas (entrantes) | info | ||
| unanswered_outbound | Não Atendidas (saintes) | info | ||
| unpauses | Despausas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":51,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-17",
"2016-11-17"
]
}
},
"columns":[{"name":"agent","alias":"Operador"},{"name":"name","alias":"Nome"},{"name":"made","alias":"Realizadas"
},{"name":"received","alias":"Recebidas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered"
,"alias":"Não Atendidas"},{"name":"logints","alias":"Hora Login"},{"name":"logoutts","alias":"Hora Logout"
},{"name":"logins","alias":"Logins"},{"name":"logouts","alias":"Logouts"},{"name":"pauses","alias":"Pausas"
},{"name":"unpauses","alias":"Despausas"},{"name":"talk_time","alias":"Tempo Atendimento"},{"name":"login_time"
,"alias":"Tempo Login"},{"name":"pause_time","alias":"Tempo Pausa"},{"name":"active_pause_time","alias"
:"Tempo Pausa Ativa"},{"name":"total_talk","alias":"TMA"},{"name":"queue_name","alias":"Grupo"},{"name"
:"answered_inbound","alias":"Atendidas (entrantes)"},{"name":"unanswered_inbound","alias":"Não Atendidas (entrantes)"}
,{"name":"talk_time_inbound","alias":"Tempo Atendimento (entrantes)"},{"name":"total_talk_inbound"
,"alias":"TMA (entrantes)"},{"name":"talk_time_outbound","alias":"Tempo Atendimento (saintes)"},{"name"
:"unanswered_outbound","alias":"Não Atendidas (saintes)"},{"name":"answered_outbound","alias":"Atendidas (saintes)"}
,{"name":"total_talk_outbound","alias":"TMA (saintes)"}]
}
Ramais - Metricas por periodo¶
Report ID: 24.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| calls | Chamadas | info | ||
| date | Data | parameter | YES | >< |
| extension | Ramal | filter | NO | == |
| made | Realizadas | info | ||
| received | Recebidas | info | ||
| talk_time | Tempo Atendimento | info | ||
| unanswered | Não Atendidas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":24,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-17",
"2016-11-17"
]
}
},
"columns":[{"name":"extension","alias":"Ramal"},{"name":"calls","alias":"Chamadas"},{"name":"made","alias":"Realizadas"
},{"name":"received","alias":"Recebidas"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered"
,"alias":"Não Atendidas"},{"name":"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias"
:"<60s"},{"name":"answered_before_2","alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name"
:"answered_before_4","alias":">=120s"},{"name":"talk_time","alias":"Tempo Atendimento"}]
}
Ramais - Registro de operadores¶
Report ID: 29.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | info | ||
| date | Data | parameter | YES | >< |
| extension | Ramal | filter | NO | == |
| login | Login | info | ||
| logoff | Logout | info | ||
| name | Nome | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":29,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-16",
"2016-11-16"
]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"extension","alias":"Ramal"},{"name":"agent","alias"
:"Operador"},{"name":"name","alias":"Nome"},{"name":"login","alias":"Login"},{"name":"logoff","alias"
:"Logout"}]
}
Pesquisa de satisfação - Survey analitico¶
Report ID: 27.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| agent_name | Nome Operador | info | ||
| client_code | Codigo Cliente | info | ||
| date | Data | parameter | YES | >< |
| duration | Duração | info | ||
| origin | Origem | filter | NO | == |
| queue_name | Grupo | filter | NO | == |
| Resposta_1 | Resposta 1 | info | ||
| Resposta_2 | Resposta 2 | info | ||
| Resposta_3 | Resposta 3 | info | ||
| Resposta_4 | Resposta 4 | info | ||
| Resposta_5 | Resposta 5 | info | ||
| Resposta_6 | Resposta 6 | info | ||
| Resposta_7 | Resposta 7 | info | ||
| Resposta_8 | Resposta 8 | info | ||
| Resposta_9 | Resposta 9 | info | ||
| Resposta_10 | Resposta 10 | info | ||
| survey_id | Survey ID | filter | NO | == |
| survey_info | Survey Info | filter | NO | == |
| time | Hora | info | ||
| uniqueid | Uniqueid | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":27,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-17",
"2016-11-17"
]
}
},
"columns":[{"name":"uniqueid","alias":"Uniqueid"},{"name":"date","alias":"Data"},{"name":"time","alias"
:"Hora"},{"name":"origin","alias":"Origem"},{"name":"queue_name","alias":"Grupo"},{"name":"agent","alias"
:"Operador"},{"name":"agent_name","alias":"Nome Operador"},{"name":"survey_info","alias":"Survey Info"
},{"name":"survey_id","alias":"Survey ID"},{"name":"client_code","alias":"Codigo Cliente"},{"name":"duration"
,"alias":"Duração"},{"name":"Resposta_1","alias":"Resposta 1"},{"name":"Resposta_2","alias":"Resposta 2"}
,{"name":"Resposta_3","alias":"Resposta 3"},{"name":"Resposta_4","alias":"Resposta 4"},{"name":"Resposta_5"
,"alias":"Resposta 5"},{"name":"Resposta_6","alias":"Resposta 6"},{"name":"Resposta_7","alias":"Resposta 7"}
,{"name":"Resposta_8","alias":"Resposta 8"},{"name":"Resposta_9","alias":"Resposta 9"},{"name":"Resposta_10"
,"alias":"Resposta 10"}]
}
Pesquisa de satisfação - Survey sintetico¶
Report ID: 28.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| date | Data | parameter | YES | >< |
| queue_name | Grupo | filter | NO | == |
| sum_answer_1 | Média Resposta 1 | info | ||
| sum_answer_2 | Média Resposta 2 | info | ||
| sum_answer_3 | Média Resposta 3 | info | ||
| sum_answer_4 | Média Resposta 4 | info | ||
| sum_answer_5 | Média Resposta 5 | info | ||
| sum_answer_6 | Média Resposta 6 | info | ||
| sum_answer_7 | Média Resposta 7 | info | ||
| sum_answer_8 | Média Resposta 8 | info | ||
| sum_answer_9 | Média Resposta 9 | info | ||
| sum_answer_10 | Média Resposta 10 | info | ||
| survey_id | Survey ID | info | ||
| surveys | Pesquisas | info | ||
| total_answer_1 | Número de Respostas 1 | info | ||
| total_answer_2 | Número de Respostas 2 | info | ||
| total_answer_3 | Número de Respostas 3 | info | ||
| total_answer_4 | Número de Respostas 4 | info | ||
| total_answer_5 | Número de Respostas 5 | info | ||
| total_answer_6 | Número de Respostas 6 | info | ||
| total_answer_7 | Número de Respostas 7 | info | ||
| total_answer_8 | Número de Respostas 8 | info | ||
| total_answer_9 | Número de Respostas 9 | info | ||
| total_answer_10 | Número de Respostas 10 | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":28,
"params":{
"date":{
"type":"><",
"values":[
"2016-11-17",
"2016-11-17"
]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"survey_id","alias":"Survey ID"},{"name":"queue_name"
,"alias":"Grupo"},{"name":"answered","alias":"Atendidas"},{"name":"surveys","alias":"Pesquisas"},{"name"
:"total_answer_1","alias":"Número de Respostas 1"},{"name":"total_answer_2","alias":"Número de Respostas 2"}
,{"name":"total_answer_3","alias":"Número de Respostas 3"},{"name":"total_answer_4","alias":"Número de Respostas 4"}
,{"name":"total_answer_5","alias":"Número de Respostas 5"},{"name":"total_answer_6"
,"alias":"Número de Respostas 6"},{"name":"total_answer_7","alias":"Número de Respostas 7"},{"name":"total_answer_8"
,"alias":"Número de Respostas 8"},{"name":"total_answer_9","alias":"Número de Respostas 9"},{"name":"total_answer_10"
,"alias":"Número de Respostas 10"},{"name":"sum_answer_1","alias":"Média Resposta 1"},{"name":"sum_answer_2"
,"alias":"Média Resposta 2"},{"name":"sum_answer_3","alias":"Média Resposta 3"},{"name":"sum_answer_4"
,"alias":"Média Resposta 4"},{"name":"sum_answer_5","alias":"Média Resposta 5"},{"name":"sum_answer_6"
,"alias":"Média Resposta 6"},{"name":"sum_answer_7","alias":"Média Resposta 7"},{"name":"sum_answer_8"
,"alias":"Média Resposta 8"},{"name":"sum_answer_9","alias":"Média Resposta 9"},{"name":"sum_answer_10"
,"alias":"Média Resposta 10"}]
}
Chats - Grupos, Métricas por Data¶
Report ID: 32.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| chats | Chats | info | ||
| date | Data | parameter | YES | == |
| giveup | Desistencias | info | ||
| giveup_before_0 | Des. <30s | info | ||
| giveup_before_1 | Des. <60s | info | ||
| giveup_before_2 | Des. <90s | info | ||
| giveup_before_3 | Des. <120s | info | ||
| giveup_before_4 | Des. >120s | info | ||
| interval | Intervalo | parameter | YES | == |
| longest_hold | Maior Espera | info | ||
| queue_name | Grupo | filter | NO | == |
| refused | Recusados | info | ||
| time | Hora | info | ||
| total_call | TMO | info | ||
| total_hold | TME | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atentidos | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":32,
"interval":120,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"==",
"values":["2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"survey_id","alias":"Survey ID"},{"name":"queue_name"
,"alias":"Grupo"},{"name":"answered","alias":"Atendidas"},{"name":"surveys","alias":"Pesquisas"},{"name"
:"total_answer_1","alias":"Número de Respostas 1"},{"name":"total_answer_2","alias":"Número de Respostas 2"}
,{"name":"total_answer_3","alias":"Número de Respostas 3"},{"name":"total_answer_4","alias":"Número de Respostas 4"}
,{"name":"total_answer_5","alias":"Número de Respostas 5"},{"name":"total_answer_6"
,"alias":"Número de Respostas 6"},{"name":"total_answer_7","alias":"Número de Respostas 7"},{"name":"total_answer_8"
,"alias":"Número de Respostas 8"},{"name":"total_answer_9","alias":"Número de Respostas 9"},{"name":"total_answer_10"
,"alias":"Número de Respostas 10"},{"name":"sum_answer_1","alias":"Média Resposta 1"},{"name":"sum_answer_2"
,"alias":"Média Resposta 2"},{"name":"sum_answer_3","alias":"Média Resposta 3"},{"name":"sum_answer_4"
,"alias":"Média Resposta 4"},{"name":"sum_answer_5","alias":"Média Resposta 5"},{"name":"sum_answer_6"
,"alias":"Média Resposta 6"},{"name":"sum_answer_7","alias":"Média Resposta 7"},{"name":"sum_answer_8"
,"alias":"Média Resposta 8"},{"name":"sum_answer_9","alias":"Média Resposta 9"},{"name":"sum_answer_10"
,"alias":"Média Resposta 10"}]
}
Chats - Grupos, Metricas por Periodo¶
Report ID: 33.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| answered | Atendidas | info | ||
| answered_before_0 | <30s | info | ||
| answered_before_1 | <60s | info | ||
| answered_before_2 | <90s | info | ||
| answered_before_3 | <120s | info | ||
| answered_before_4 | >=120s | info | ||
| chats | Chats | info | ||
| date | Data | parameter | YES | >< |
| giveup | Desistencias | info | ||
| giveup_before_0 | Des. <30s | info | ||
| giveup_before_1 | Des. <60s | info | ||
| giveup_before_2 | Des. <90s | info | ||
| giveup_before_3 | Des. <120s | info | ||
| giveup_before_4 | Des. >120s | info | ||
| longest_hold | Maior Espera | info | ||
| queue_name | Grupo | filter | NO | == |
| refused | Recusados | info | ||
| total_call | TMO | info | ||
| total_hold | TME | info | ||
| total_talk | TMA | info | ||
| unanswered | Não Atentidos | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":33,
"percentage":0,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":
[{"name":"date","alias":"Data"},{"name":"queue_name","alias":"Grupo"},{"name":"chats","alias"
:"Chats"},{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atentidos"},{"name"
:"answered_before_0","alias":"<30s"},{"name":"answered_before_1","alias":"<60s"},{"name":"answered_before_2"
,"alias":"<90s"},{"name":"answered_before_3","alias":"<120s"},{"name":"answered_before_4","alias":">=120s"}
,{"name":"giveup","alias":"Desistencias"},{"name":"refused","alias":"Recusados"},{"name":"total_talk"
,"alias":"TMA"},{"name":"total_hold","alias":"TME"},{"name":"total_call","alias":"TMO"},{"name":"longest_hold"
,"alias":"Maior Espera"},{"name":"giveup_before_0","alias":"Des. <30s"},{"name":"giveup_before_1","alias"
:"Des. <60s"},{"name":"giveup_before_2","alias":"Des. <90s"},{"name":"giveup_before_3","alias":"Des. <120s"}
,{"name":"giveup_before_4","alias":"Des. >120s"}]
}
Chats - Grupos, Registro Detalhado¶
Report ID: 34.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| date | Data | parameter | YES | >< |
| duration | Duração | info | ||
| extension | Ramal | filter | NO | == |
| messages | Mensagens | info | ||
| origin | Origem | filter | NO | == |
| queue_name | Grupo | filter | NO | == |
| status | Status | filter | NO | == |
| time | Hora | filter | NO | >< |
| uniqueid | Identificador | info |
Note
In the messages field you can see the [LF] and [CR] markings, which respectively mean “Line Feed” and “Carriege Return” of the message.
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":34,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"origin","alias"
:"Origem"},{"name":"extension","alias":"Ramal"},{"name":"agent","alias":"Operador"},{"name":"queue_name"
,"alias":"Grupo"},{"name":"status","alias":"Status"},{"name":"duration","alias":"Duração"},{"name":"messages"
,"alias":"Mensagens"},{"name":"uniqueid","alias":"Identificador"}]
}
Chats - Operadores, Registro Detalhado¶
Report ID: 35.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| date | Data | parameter | YES | >< |
| duration | Duração | info | ||
| event | Evento | info | ||
| extension | Ramal | filter | NO | == |
| name | Nome | info | ||
| origin | Origem | filter | NO | == |
| pause | Pausa | info | ||
| time | Hora | filter | NO | >< |
| uniqueid | Identificador | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":35,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"agent","alias"
:"Operador"},{"name":"name","alias":"Nome"},{"name":"event","alias":"Evento"},{"name":"pause","alias"
:"Pausa"},{"name":"extension","alias":"Ramal"},{"name":"origin","alias":"Origem"},{"name":"duration"
,"alias":"Duração"},{"name":"uniqueid","alias":"Identificador"}]
}
Chats - Operadores, Metricas por Periodo¶
Report ID: 36.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| answered | Atendidas | info | ||
| chats | Chats | info | ||
| date | Data | parameter | YES | >< |
| login_time | Tempo Login | info | ||
| logins | Logins | info | ||
| logints | Hora Login | info | ||
| logouts | Logouts | info | ||
| logoutts | Hora Logout | info | ||
| name | Nome | info | ||
| pause_time | Tempo Pausa | info | ||
| pauses | Pausas | info | ||
| talk_time | Tempo Atendimento | info | ||
| unanswered | Não Atentidos | info | ||
| unpauses | Despausas | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":36,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"agent","alias":"Operador"},{"name":"name","alias":"Nome"},{"name":"chats","alias":"Chats"}
,{"name":"answered","alias":"Atendidas"},{"name":"unanswered","alias":"Não Atentidos"},{"name":"logints"
,"alias":"Hora Login"},{"name":"logoutts","alias":"Hora Logout"},{"name":"logins","alias":"Logins"},
{"name":"logouts","alias":"Logouts"},{"name":"pauses","alias":"Pausas"},{"name":"unpauses","alias":"Despausas"
},{"name":"talk_time","alias":"Tempo Atendimento"},{"name":"login_time","alias":"Tempo Login"},{"name"
:"pause_time","alias":"Tempo Pausa"}]
}
Chats - (Chatbot) Grupos, Registro Detalhado¶
Report ID: 53.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| agent | Operador | filter | NO | == |
| date | Data | parameter | YES | >< |
| destination | Destino | filter | NO | == |
| duration | Duração | info | ||
| extension | Ramal | filter | NO | == |
| messages | Mensagens | filter | NO | - |
| origin | Origem | filter | NO | == |
| queue_name | Grupo | filter | NO | == |
| status | Status | filter | NO | == |
| time | Hora | filter | NO | >< |
| uniqueid | Identificador | info |
Note
In the messages field you can see the [LF] and [CR] markings, which respectively mean “Line Feed” and “Carriege Return” of the message.
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":53,
"timeformat":0,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"origin","alias"
:"Origem"},{"name":"extension","alias":"Ramal"},{"name":"agent","alias":"Operador"},{"name":"destination"
,"alias":"Destino"},{"name":"queue_name","alias":"Grupo"},{"name":"status","alias":"Status"},{"name"
:"duration","alias":"Duração"},{"name":"messages","alias":"Mensagens"},{"name":"uniqueid","alias":"Identificador"
}]
}
Drill Down - DrillDown metricas de URA¶
Report ID: 49.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| date | Data | parameter | YES | >< |
| duration | TMU | info | ||
| order | Ordem | info | ||
| success | Sucesso | info | ||
| tag | Descritor | info | ||
| tag_description | Descricao | info |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":49,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"order","alias":"Ordem"},{"name":"tag","alias":"Descritor"},{"name":"tag_description","alias"
:"Descricao"},{"name":"flow_id","alias":"flow_id"},{"name":"parent_flow_id","alias":"parent_flow_id"
,"type":"text"},{"name":"success","alias":"Sucesso"},{"name":"tmu","alias":"tmu"}]
}
Auditoria - Mensagens registro detalhado¶
Report ID: 50.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| action | Acao | filter | NO | == |
| date | Data | parameter | YES | == / >< |
| file | Arquivo | info | ||
| name | Nome | info | ||
| prio | Prioridade | info | ||
| table | Tabela | filter | NO | == |
| time | Hora | filter | NO | >< |
| transcription | Transcricao | info | ||
| type_message | Tipo de Arquivo | info | ||
| user | Usuario | filter | NO | == |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":50,
"params":{
"date":{
"type":"==",
"values":["2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"user","alias":"Usuario"
},{"name":"table","alias":"Tabela"},{"name":"action","alias":"Acao"},{"name":"transcription","alias"
:"Transcricao"},{"name":"prio","alias":"Prioridade"},{"name":"name","alias":"Nome"},{"name":"file","alias"
:"Arquivo"},{"name":"type_message","alias":"Tipo de Arquivo"}]
}
Auditoria - Gravacoes registro detalhado¶
Report ID: 52.
Description of Columns:
| Column Name | Column Name Alias | Column Type | Required | Match Operator |
|---|---|---|---|---|
| action | Acao | filter | NO | == |
| date | Data | parameter | YES | == / >< |
| file | Arquivo | filter | NO | == |
| time | Hora | filter | NO | >< |
| user | Usuario | filter | NO | == |
JSON Sample
{
"login":"report_user",
"pass":"rTy334D3ddK4s",
"id":52,
"params":{
"date":{
"type":"><",
"values":["2016-11-17","2016-11-17"]
}
},
"columns":[{"name":"date","alias":"Data"},{"name":"time","alias":"Hora"},{"name":"user","alias":"Usuario"
},{"name":"file","alias":"Arquivo"},{"name":"action","alias":"Acao"}]
}