Analyse productivity

cwprod.cgi, the productivity reporting module, works hand in hand with cwappels.pl to create and to exploit a data base of time spent on projects and results obtained.

Sources of information

cwappels.pl draws information from two sources to create the BASEprod data base (a CallWeb-format data base):

  • daily, during the night, cwappels.pl creates the BASEappels data base which documents each call found in live projects. In the process, it tags each call as a completed interview or a refusal based on the call results and their behaviour. The module also converts GMT-based times stored in the call history to the local server time;
  • time spent on projects is obtained from the BASEtemps data base — but only from time transactions which
    • have not yet been processed, to avoid double counting;
    • which are CATI-related according to a flag placed by the interviewer interface when it created the time transaction; and,
    • which are closed.

cwappels.cgi matches time transactions to call results at the interviewer + project + time level and stores the resulting data in BASEprod; it is normally called once a day, at night. Once a time transaction from BASEtemps has been processed, it is not re-analyzed. Therefore, modifications to time transactions after cwappels.cgi has processed them are disallowed.

Producing reports

The cwprod.cgi module queries the BASEprod data base according to projects or interviewers or dates or shifts and returns a number of self-explanatory indicators of performance (e.g., the number of completed questionnaires per hour).

One final composite index requires some explanation. Labelled "index", it accounts simultaneously for completes and refusals while recognizing that there are circumstances when completes and refusals have differing values. Specifically, the default index equation is as follows:

    ( c1 + 2c2 + 5c3 - 3r1 ) / hours
    where
    • c1 = number of questionnaires completed on the first call
    • c2 = number of questionnaires completed on subsequent calls
    • c3 = number of questionnaires completed after a refusal
    • r1 = number of first refusals (note that refusals after an initial refusal are not penalized)
    • hours = number of hours logged in BASEtemps

This default index can be redefined by entering a new calculation in the productivity_index installation option, which affects all projects, or by adding a new calculation as part of a # Productivity index pound instruction, on a project by project basis.

Analyse productivity

cwprod.cgi, the productivity reporting module, works hand in hand with cwappels.pl to create and to exploit a data base of time spent on projects and results obtained.

Sources of information

cwappels.pl draws information from two sources to create the BASEprod data base (a CallWeb-format data base):

  • daily, during the night, cwappels.pl creates the BASEappels data base which documents each call found in live projects. In the process, it tags each call as a completed interview or a refusal based on the call results and their behaviour. The module also converts GMT-based times stored in the call history to the local server time;
  • time spent on projects is obtained from the BASEtemps data base — but only from time transactions which
    • have not yet been processed, to avoid double counting;
    • which are CATI-related according to a flag placed by the interviewer interface when it created the time transaction; and,
    • which are closed.

cwappels.cgi matches time transactions to call results at the interviewer + project + time level and stores the resulting data in BASEprod; it is normally called once a day, at night. Once a time transaction from BASEtemps has been processed, it is not re-analyzed. Therefore, modifications to time transactions after cwappels.cgi has processed them are disallowed.

Producing reports

The cwprod.cgi module queries the BASEprod data base according to projects or interviewers or dates or shifts and returns a number of self-explanatory indicators of performance (e.g., the number of completed questionnaires per hour).

One final composite index requires some explanation. Labelled "index", it accounts simultaneously for completes and refusals while recognizing that there are circumstances when completes and refusals have differing values. Specifically, the default index equation is as follows:

    ( c1 + 2c2 + 5c3 - 3r1 ) / hours
    where
    • c1 = number of questionnaires completed on the first call
    • c2 = number of questionnaires completed on subsequent calls
    • c3 = number of questionnaires completed after a refusal
    • r1 = number of first refusals (note that refusals after an initial refusal are not penalized)
    • hours = number of hours logged in BASEtemps

This default index can be redefined by entering a new calculation in the productivity_index installation option, which affects all projects, or by adding a new calculation as part of a # Productivity index pound instruction, on a project by project basis.