- Log in to the dialer as an admin.
- Click "Reporting" and choose "Dialer Result Download."
- Select "Dial Leads-Last Pass" and "All" under "Realtime Reports."
- Choose the desired Start/End Date for the reports.
- For Report Type, select "System Disposition" and the associated script (usually the same as the PO#).
- Check the boxes for "Include Aux Data" and "Report On All Calls."
- Download the report.
- Log in to cOS and click "Centers" to download the center call file.
- In the dialer report, sort by PO#, create a new spreadsheet, and transfer the relevant data. Essential columns include: ID (cr_id), Phone, Agent Disposition (status_code), Pass Disposition, Call Start (call_time), Duration, Agent ID (TSR), Spoke to (spoke_to), and Results (Q1).
- For ROBOS, the essential columns are: ID (cr_id), Lead_Phone (phone), Pass Disposition (status_code), Call_Start (call_time), and Duration.
- Copy/paste all recorded completes with no answer in Q1 to a new spreadsheet and send to a staff member for monitoring.
- Sift through question responses (1,2,3), making a Complete for each. Sort by other Status Codes and delete non-essential columns.
- Change headers in the dialer list to match those in the center file, and change agent dispositions to standard cOS status codes.
- Sort the agent disposition by blank records, copying the value from the pass disposition column.
- Sort status codes by Complete (C), then filter the blanks in Q1. For completed calls, clear out any non-available dispositions and assign each a number.
- Delete all monitor pending calls from the list.
- Ensure there are no blanks in the spoke_to column.
- Save the center file, open FileMaker, and import the dialer list, updating matching records.
- Arrange by "Matching Names" and make cr_id=cr_id.
- Enter the Call Date and replace all (Command + =).
- Export the file, change it to .csv, and upload it to cOS.
- Double-check the report, ensuring the completes at the top match the completes at the bottom, and follow all other standard procedures.
Rewritten instructions for Loading Back ROBOS into COS:
- Sign into COS and go to the robo PO.
- Click on "Centers" and "Download Call List" (to be used later).
- Log in to the dialer at https://portal.vacd.biz/manage/#/login.
- Go to "Reporting" > "Realtime Reports" > "Dialer Result Download."
- Ensure the start and end dates reflect the day the robo ran.
- For Report Type, select "Dialed Leads: Last Pass."
- Download the report.
- From the report, keep only the following columns: ID (change to cr_id), lead_phone (change to phone), pass_disposition (change to status_code), call_start (change to call_time), and duration (no change needed).
- Delete all other unnecessary columns.
- In Excel, use the "Find and Replace" feature to update the following:
- "NOANSWER" = N
- "HANGUP" = N
- "ANSWER" = C
- "MACHINE" = LM
- "BUSY" = B
- "CONGESTION" = B
- "DISCONNECT" = D
- "INTERCEPT" = D
- Save the data results file.
- Open FileMaker, import the dialer list, and update matching records.
- Arrange by "Matching Names" and make cr_id=cr_id.
- Enter the Call Date and Spoke_To, replacing all (Command + =).
- Export the file, change it to .csv, and upload it to cOS.
- Double-check the report, ensuring the completes at the top match the completes at the bottom, and follow all other standard procedures.