VERSION: 2.13-576a BUILD: 161126-2138 | asterisk 1.4.27.1|single server |Centos6.0 |One Digium card | No cluster
We have an outbound Callcenter Setup with 7 Agents.
Around 10 campaigns are there and each campaign is mapped to one particular list. i.e., list id 111 is mapped to campaing id 111 ,list id 332 is mapped to campaing id 332...so on
Agents will be selling the products through 9 Campaigns and based on the disposition of the call,confirmed sales will be inserted into separate campaing with separate lead id.
Below is the Vicidial_list and Vicidial_agent_log
Vicidial_list
| lead_id | entry_date | status | list_id |
+---------+---------------------+--------+---------+
| 37563 | 2018-09-04 15:15:14 | SALE | 332 |
| 37584 | 2018-09-04 15:32:04 | VS | 111 |
In the above output, Agent placed an order at 15:15 Hrs through 332 List id and it was pushed into 111 List id for verification of product order.
Vicidial_agent_log
| agent_log_id | user | event_time | lead_id | campaign_id | status |
+--------------+------+---------------------+---------+-------------+--------+
| 162882 | 3003 | 2018-09-04 15:08:17 | 37584 | 111 | VS |
| 162938 | 3012 | 2018-09-04 15:18:11 | 37563 | 332 | SALE |
| 162945 | 4000 | 2018-09-04 15:21:31 | 37563 | 222 | SALE |
When you refer the above vicidial_agent_log table, have the below observations.
1. Agent log id 162938 is correct i.e., agent has called the customer at 15:18 Hrs and placed the order.
2. Regarding Agent log id 162945 , unable to understand ,how the call got initiated through 222 campaign,while that number itself is not available in that list id.
Below is my list id mapped table.
select list_id,campaign_id from vicidial_lists where list_id in ('332','111','222');
+---------+-------------+
| list_id | campaign_id |
+---------+-------------+
| 111 | 111 |
| 222 | 222 |
| 332 | 332 |
+---------+-------------+
can you please help in tracing the issue?
Regards,
chak