Solved

FileMaker Database for Call Center Agent monitoring

Posted on 2007-03-27
8
557 Views
Last Modified: 2008-02-01
I work at a small call center with about 40 customer service reps. I am trying to create a FMP database for quality control purposes.

A single supervisor monitors random incoming calls that agents take. While monitoring the call, the supervisor will input the agents name and check a series of Yes/No radio buttons. Example: Yes the agent verified information or No agent did not verify information.

There is about 20 questions on my form and grouped into sections

Obtaining and Verifying Information
Customer Interaction Skills
Proper Use of System

We are an outsourced call center so we have approximately 8 accounts that we work with. I have each account in its own table. Each table has account specific questions that agents are required to ask tied to a Value List of Yes/No.

What I am trying to do is run a daily and weekly analysis report based off the yes/no answers. This can be account specific or overall for all accounts. Example 20 agents verified information and 10 agents did not.

Can anyone give me some direction on how to create such a report? I have some understanding of FMP but not as proficient as I would like to be.

I am using FMP 8.5 Advanced.
0
Comment
Question by:Vassillios
  • 4
  • 3
8 Comments
 
LVL 6

Expert Comment

by:shayneg
ID: 18803490
I would export the data from FM Pro to a CSV file and then use Excel to import the data and to report on. Or you could use Crystal Reports. You could use Filemaker but Excel would be better for reporting
0
 
LVL 9

Expert Comment

by:jvaldes
ID: 18804248
It would help to see how you have set up the database, but assuming that all the fields are in one table the find command will help you find the records that have the specific common find combinations. For example to find out how many calls were made by rep 1 . Search the rep field for rep1 and get the found record count. You can copy that result to another table so that you can later write a report with the data. You can also find records that meet multiple criteria , such as rep = rep1 and verifed = yes now you can determine how many records are by rep1 and were verified, etc. By copying the results to another table you can create result entries by rep and get detailed reporting. If you would like an example , send me the database and I will see if I can help...
0
 

Author Comment

by:Vassillios
ID: 18804268
jvaldes, how would I send the database to you? Thanks for the help!
0
 
LVL 9

Expert Comment

by:jvaldes
ID: 18804322
IF you have an FTP site you can put it there. If you have a Mac.com account you can use the idisk. or there a number of free sites that provide hard disk space on the net. Mynetstorage.com, Xdrive.com provides it free... up to 5GB
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Vassillios
ID: 18804640
vassillios.homeunix.net
port 21
anon

MonitorForm.fp7

An example would be appreciated. I'm very much a novice..
0
 
LVL 9

Expert Comment

by:jvaldes
ID: 18805318
I will get one for you tomorrow, I should get a chance then
0
 
LVL 9

Accepted Solution

by:
jvaldes earned 500 total points
ID: 18829457
The file example is at http://homepage.mac.com/beckyv/

I didn't use summary fields since it would not be as flexible for the number of things you are testing and it would require portals to get refined counts

All you need to do is add all the tests you want to the script., The script is designed to work with as many Monitor records as you have and as many choices for dealer as you happen to have . I guess this routine could take a while if you have thousands of dealers, but I don't think that si the case.

If you need any more help just let me know, sorry it took 2 days to get back
0
 

Author Comment

by:Vassillios
ID: 18829872
Thank you very much Gary. That is what I had in mind. I will be playing around with the script. Thanks again.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now