• Registered: 2012-11-09
  • Posts: 34

Topic: Usage reports

Hi,

I have a couple of questions about usage reports. First, I would like a usage report with the following info: the caller's phone number, time stamp of the call and whether or not they selected English "1" or Spanish "2" at the prompt.

I see the usage report in "Account". And I have exported a CSV file of the call data. Here is a sample of the data I got:
Call Type    Number Dialed/Texted    Caller ID    Start Timestamp    Duration (in minutes)
inbound    8556550302    3035213501    1380808702    0.8

This is fine but how do I convert 1380808702 to a date and time I can use?

The second question is: how can I create a report that captures user input from the APP? i.e. whether the user selected English or Spanish.

  • admin
  • Administrator
  • Offline
  • Registered: 2010-06-15
  • Posts: 661

Re: Usage reports

We store our timestamps as Unix timestamps. For more info, please check out:  http://en.wikipedia.org/wiki/Unix_time

Feel free to convert the Unix timestamp into the format that you prefer. For example, you can use Excel to convert a Unix timestamp: http://spreadsheetpage.com/index.php/ti … imestamps/

To create reports based on user input, you will have to insert the user input into your database. You can either does this during the call with SOAP/REST webservice modules (http://quickfuseapps.com/docs/tutorial/ … webservice), or at the end with a post call processing SOAP webservice. This can be found your app's settings.

  • Registered: 2012-11-09
  • Posts: 34

Re: Usage reports

where do you store the timestamp? I know how to get the caller's ANI. But what do I do to get the date and time of their call to the APP?

  • Registered: 2012-11-09
  • Posts: 34

Re: Usage reports

okay I have the timestamp and date. I have the ANI. Now I need to capture the 800# that the call is calling in on. How do I it that?

Thanks.

  • admin
  • Administrator
  • Offline
  • Registered: 2010-06-15
  • Posts: 661

Re: Usage reports

Hi,

If you're looking to capture the DNIS (the 800 # that the caller is dialing into), you can use the Call Properties module and select "DNIS" from the Property drop-down menu.

Hope this helps,
PlumFuse Support

  • Registered: 2012-11-09
  • Posts: 34

Re: Usage reports

Hmm, well I tried that. I set a variable to the DNIS but when I tested to see if I captured the 800# correctly I got the statement "outbound" returned. I am looking for the actual number so i can export it to a report.

  • Registered: 2012-11-09
  • Posts: 34

Re: Usage reports

Please ignore the last post. I figured out my problem.

Thanks.