Data Frame Report Issue
Posted: Fri May 07, 2021 4:28 pmHello, I'm sorry if I'm not using the right way this forum, but I'm new with this channel of comunication.
First of all, I'm a data analyst in a debt collection agency which has the Vicidial system installed and working for the management and calling of the accounts we have to collect.
I don't have complete access to the platform myself because it requieres a user and a password that I don't have assigned.
I only had a capacitation from a coworker from another area in the agency. If any of the following statements are wrong please make me know.
What I understood (in a rudimentary way) is that Vicidial works with 'Lists' and 'Campaings'.
The user uploads to a 'List' a list of telephone numbers, and then assign that 'List' to a 'Campaign' with logged in call center executives to recive the calls that Vicidial makes automatically.
The 'List' can be configured in many different ways.
When the user uploads a list of telephone numbers to a 'List', the user can assign to every telephone number a respective field to a Slot that the call center executive can visualise. for example the Vicidial "Name" slot with the field "PhoneOwner" from the telephone number's table the user uploads, etc.
In other words, the user uploads a dataframe which has the phone numbers among other important information that can be visualised to the call center executives through the Slots.
Then, after Vicidial automatically calls the telephone numbers in the 'List' and the call center executives take those calls, the user can download a 'Report' which is a dataframe containing the Date-Hour the call was made, and a Status of the outcome from that call.
Now, my issue is here:
Me as an analyst, needs to identify the phone number 's Owner by an idAccount that was uploaded together with the telephone numbers in the 'List'.
Here is my question:
Is there a way to add to the 'Report' dataframe the field IdAccount that was uploaded together with the telephone numbers?
You may think that the idAccount-TelephoneNumber relation is unique and therefore is not neccessary to add that field to the 'Report'. But this is not the case. It is possible that one TelephoneNumber has more than one idAccount.
Thank you for your attention and response.
First of all, I'm a data analyst in a debt collection agency which has the Vicidial system installed and working for the management and calling of the accounts we have to collect.
I don't have complete access to the platform myself because it requieres a user and a password that I don't have assigned.
I only had a capacitation from a coworker from another area in the agency. If any of the following statements are wrong please make me know.
What I understood (in a rudimentary way) is that Vicidial works with 'Lists' and 'Campaings'.
The user uploads to a 'List' a list of telephone numbers, and then assign that 'List' to a 'Campaign' with logged in call center executives to recive the calls that Vicidial makes automatically.
The 'List' can be configured in many different ways.
When the user uploads a list of telephone numbers to a 'List', the user can assign to every telephone number a respective field to a Slot that the call center executive can visualise. for example the Vicidial "Name" slot with the field "PhoneOwner" from the telephone number's table the user uploads, etc.
In other words, the user uploads a dataframe which has the phone numbers among other important information that can be visualised to the call center executives through the Slots.
Then, after Vicidial automatically calls the telephone numbers in the 'List' and the call center executives take those calls, the user can download a 'Report' which is a dataframe containing the Date-Hour the call was made, and a Status of the outcome from that call.
Now, my issue is here:
Me as an analyst, needs to identify the phone number 's Owner by an idAccount that was uploaded together with the telephone numbers in the 'List'.
Here is my question:
Is there a way to add to the 'Report' dataframe the field IdAccount that was uploaded together with the telephone numbers?
You may think that the idAccount-TelephoneNumber relation is unique and therefore is not neccessary to add that field to the 'Report'. But this is not the case. It is possible that one TelephoneNumber has more than one idAccount.
Thank you for your attention and response.