Many of the Jet Interactive reports are able to be downloaded as an image for Behaviour graph reports, and as a csv for any tabular reports.
This allows you to download the raw data of your call reports with Jet, and load this into a third-party program like Excel, Google Sheets or your choice of database tool to run formulas or queries against your data for deeper analysis.
You can use the Download options shown below to download any report as needed.
Data FAQ
Date/Time
All calls in downloaded reports are provided in UTC time. You can use a simple formula like below in a new column to give you the correct local time:
=A1+Time(10,00,0)
This would convert you into AEST (time in Sydney from approx April to October).
For AEDT (October to April), you would use 11 instead of 10.
Phone Numbers
All phone number fields will be displayed in International format, for Australia this is +61.
Duration
Your duration is sent through in format hh:mm:ss.
Formatting in Excel
When loading a csv into Excel, the program will automatically recognise and format your data based on what it thinks the cell contains.
This can commonly affect the way the data is displayed, most notably in columns of date/time, any columns that include phone numbers (eg: service number, caller's number, answering point), and duration.
You can fix this very quickly by updating the formatting for these cells. For columns where Call Date & Call Time is separate, you can use the standard fields provided in Excel. When this is combined (such as the SMS Report, you can use a custom field display like the image below:
For any phone number fields, this should be formatted as a number with no decimal places.
Formatting in Google Sheets
Google Sheets is very helpful when importing data, as you can choose to NOT convert your data to numbers, dates and other formulas it recognises.
This is turned on by default, so if you do import with data converting on, you can use the Format menu in Google Sheets, which has a lot of your values as preset options.
You can use the Plain Text option for most phone number fields.
Comments
0 comments
Please sign in to leave a comment.