The exported call list in Excel
The call list is very useful if you want a bit more information about your calls, or if you want to apply your own statistics skills to it, and thereby get to know your telephony situation better.
The biggest difference with the call list you can find in your Freedom portal is that a distinction has been made between the waiting time and the total call duration.
Which variables can I find in this list?
- Foreign code This is your own customer number, as stated on the invoices and in the dashboard of your Freedom portal.
- Client This is equal to the company name as it is visible in Freedom.
- Account / Phone number This contains either the VoIP account ID, or the phone number you call with, or are being called on.
- Date The date and time at which the call was initiated. Also known as the created-time.
- Inbound/Outbound Here you find the direction of the call.
- Amount The number of calls. This is always 1, except when you group the data yourself for further analysis.
- Duration (aka. call duration time) The duration is the time between when the call is answered and when it ends again. This thus covers all steps between "Answered" and "time-ended":
- Answered: the call is picked up by a device. The call begins.
- In-progress: the call is taking place.
- time-ended: the moment at which the call ends. This can be because:
- someone picks up
- all devices are busy
- no one has picked up
- the call has failed due to technical reasons
- the caller has hung up before anyone could pick up
- or a caller disconnects while waiting in the queue.
- Source Here you find which phone number or VoIP account initiated the incoming or outgoing call.
- Destination Here you find which phone number or VoIP account answered the incoming or outgoing call.
- Destination code This provides more info about the destination. Such as whether it is the country code, whether it is a special number, or a mobile number.
- Waiting time
- Call is answered The waiting time starts running from when the call starts (time-created) until when the call is picked up.
- Call is not answered - no voicemail If no one picks up, the waiting time runs from when the call starts (time-created) until the end time of the call (aka time-ended). More info about these variables can be found on this page.
- The call is not answered - but voicemail With voicemail, the waiting time covers the total duration of the call. This is because with voicemail there is no switch to an external device.
- From when the call starts (Time-Created) until when the call is picked up (Answered / Transfer).
- If no one picks up, or it goes to Voicemail: from when the call starts until the time-ended.
So in short:
FAQ
‣
‣
‣
‣
‣
‣