Upload your Contact Volume Data
1. Prepare Your Data in 3 Columns in a Spreadsheet
Prepare your data in 3 columns in a spreadsheet- 1. Dates and time should be in the yyyy-mm-dd hh:mm format eg 2020-03-19 15:45
- 2. Contacts should be a whole number with no commas
- 3. Average Handling Time (AHT) should be a whole number in Seconds
! IMPORTANT ! - Make Sure you Have the Correct DateTime Format
| DateTime | Number of Contacts | Average Handling Time (AHT) Seconds |
Example | |
|---|---|---|---|---|
| 2020-03-19 00:00 | 11 | 257 | Download Excel file | |
| 2020-03-19 00:30 | 8 | 257 | ||
| 2020-03-19 01:00 | 7 | 257 | ||
| 2020-03-19 01:30 | 8 | 257 |
Here is a tutorial on how to format dates in Excel
Important Information
- The date format needs to be in the yyyy-mm-dd hh:mm format e.g. 2020-03-19 15:45
- Make sure you don't have any commas in the values e.g. 33,100 should be entered as 33100.
- If you are unsure on how to have your Excel spreadsheet formatted, please download this example - Online Excel Example
How to format dates correctly in Excel
The forecasting tool requires that dates are in the "date time" format yyyy-mm-dd hh:mm e.g. 2020-03-19 15:45To get the dates in this format
- Select the dates that you need to format
- Right click (not left click) on the mouse and select Format Cells
- Click on Number > Custom
- Replace the contents in the Type: box with yyyy-mm-dd hh:mm
- The dates should then be in the right format e.g. 2020-03-19 15:45
If you experience any issues, please email newsdesk@callcentrehelper.com.
