Follow

Reports

The OnSIP reports tab provides summary CDR information broken down by User for outbound calls and by the Billable User for inbound calls.  Only one Billable User can be configured per phone number for inbound calls.  The Reports found here do not provide a breakdown of how the call made it to a specific User or feature.  For that type of reporting one would want an Enhanced Queue or use an API.

Reading the Account Summary Report

  1. Navigate to the "Reports" page and select the time period you would like to see for the report.

    Reports_Summary_Timestamp_Apr2018.png

  2. The summary for the time period chosen above will be displayed in the body of the page. The summary totals for inbound minutes, outbound minutes, and cost are at the top of the page. Each of the previous metrics is then broken down by the user in a table under the totals. 
  3. Downloading Detailed Call Reports:  OnSIP provides a link to download the current time period's call detail records (CDRs) as a CSV file from the Reports page. Simply click the "CSV" link near the top of the page to retrieve an in-depth breakdown of all your month's calls. Call duration in the .csv is in seconds.

Reading User's Summary Report

  1. Click on a username then "Show CDRs" in the lower right of the box to open that user's detailed report (see below, lower right arrow).
  2. The report is broken down by call type, i.e. inbound, outbound, toll-free, and on network calls. The first column of each row displays the number of minutes used, the second column displays the number of calls, and the third column displays the total cost of the current call type. The cost of all this user's calls for the given time range is the value listed in the user's summary row.

Reports_downloadCSR_Apr2018.png

 

Expanded_View_CDRs_Oct2018.png

 

Reading the Downloaded .CSV file

Once you download your .csv file into whatever program you plan on using, here is what each of the fields mean:

CDR ID: More for OnSIP's use, you could pare this out of your sort

User ID: More for OnSIP's use, you could pare this out of your sort

DateTime(UTC):

  • If this says "UTC" you may want to go back to your Reports tab >change the timezone > generate a report > download .csv file again
  • When call was first dialed/start of call

Caller ID: self-explanatory

Source: Number that was Called or Number User Called

Destination: Reverse of Source (number the Caller dialed or number User is calling)

Disposition:

  • Answered = call was answered
  • Unanswered = no one answered the call and caller/callee hung up
  • Failed = Unable to complete the call (inbound or outbound) / never connects

Length: call duration reported in seconds

Price: total cost of call

Cost: placeholder / not used

Answer Date: typical the same as DateTime

End Date Time (UTC): 

  • If this says "UTC" you may want to go back to your Reports tab >change the timezone > generate a report > download .csv file again
  • When call was ended

Routing: 

  • Termination - Outbound call placed by User
  • Origination - Inbound call

Name: for OnSIP use, you could pare this out of your sort

Auth User Name: for OnSIP use, you could pare this out of your sort

 

Please Note: SIP to SIP (this includes extension to extension calling) will not appear on the reports. The reports only reflect charged calls.

 

Updated October 2018

 

Learn more about OnSIP's built-in reporting tools

Download the OnSIP Reports & Dashboards Guide

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk