Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
| Live Search | ||||
|---|---|---|---|---|
|
| Info | ||
|---|---|---|
| ||
All tracking data explained below cover at most the 380 days default interval. This applies, in particular, to counter variables as e.g. track_num_completed: This value is the number of all completed panel and master data surveys during the last 380 days. |
| Variable | Meaning | Export variable | Data type | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
track_date_avgratinggiven | Date of last rating given | Date | From EFS 10.3: Date of last rating given. This date is technically necessary for tracking the average values. | ||||||||||||
track_date_avgratingreceived | Date of last rating received | Date | From EFS 10.3: Date of last rating received. This date is technically necessary for tracking the average values. | ||||||||||||
track_date_completed | Last completed survey | modcpl | Date | Date of the last completed survey. Is set when the panelist reaches the final page of a panel or master data survey and is assigned status 31 or 32. | |||||||||||
| track_date_completedcustomone | Number of custom completed surveys (Disposition code 33) | Date | Customized track_date_completed value. | ||||||||||||
| track_date_completedcustomtwo | Number of custom completed surveys (Disposition code 34) | Date | Customized track_date_invited | Last invitation | modinvcompleted value. | ||||||||||
| track_date_credit | Date of last allocation of bonus points | Date | Date of the last invitation to a panel or allocation of bonus points. | ||||||||||||
track_date_invited | Last invitation | modinv | Date | Date of the last invitation to a panel or master data survey. The first mail sent to the panelist in a project is regarded as the invitation, all subsequent mails are counted as reminders. It does not matter if you send the mails from inside a sample or if the dispatch is triggered by an update rule. | |||||||||||
| track_date_quality | Last quality problem | modqul | Date | Date of the last quality problem. Currently, a quality problem is defined as the panelist’s quality correction value being smaller than 0.2. This requires activation and triggering of quality correction in the respective survey. There are plans to develop a more advanced definition of “quality” for tracking purposes for a future release. | |||||||||||
track_date_quoted | Last rejection due to closed quota | modqut | Date | Date of the last rejection due to closed quota. This rejection occurs when a panelist is assigned status 35, 36 or 41 upon reaching the final page in a panel or master data survey. | |||||||||||
track_date_ratinggiven | Date of last rating given | Date | From EFS 10.3: Date of last rating given. | ||||||||||||
track_date_ratingreceived | Date of last rating recei- ved | Date | From EFS 10.3: Date of last rating received. | ||||||||||||
track_date_reminded | Last reminder | modrem | Date | Date of the last reminder of a panel or master data survey. Each repeat mail sent to the panelist in a project is regarded as a reminder (i.e. as of the second mail all subsequent mails are reminders). | |||||||||||
track_date_sampled | Last sample membership | modsam | Date | Date of the last inclusion of a panelist into the sample of a panel or master data survey. (The sample “Internal” is considered, too.) | |||||||||||
track_date_screened | Last screenout | modscn | Date | Date of the last screen-out. A screen-out occurs when a panelist is assigned status 37 upon reaching the final page in a panel or master data survey. | |||||||||||
| track_date_started | Last survey start | modstr | Date | screenedcustomone | Date of the last survey start. This covers the following cases:
| ||||||||||
track_date_unavail | Last unavailability | modunl | Date | Date of the last unavailability of the panelist.
| track_date_unavail_customone | Date of last custom availablity (Disposition code 18) | track_date_unavail_customtwo | Date of last custom availablity (Disposition code 19) | track_num_ avgratinggiven | Average rating given | From EFS 10.3: Average value of the ratings given by the panelist. | track_num_ avgratinggiven1, 2, 3 | Average rating given( | From EFS 10.3: Average value of the ratings given by the panelist, restricted to the last 4 / 8 / 12 weeks. | track_num_ avgratingreceived | Average rating received | From EFS 10.3: Average value of the ratings received by the panelist. | track_num_ avgratingreceived1, 2, 3 | Average rating received (last 4 / 8 / 12 weeks) | From EFS 10.3: Average value of the ratings received by the panelist, restricted to the last 4 / 8 / 12 weeks. |
track_num_ completed | Number of completed surveys | numcpl | Counter | Number of all the surveys the panelist has completed within the last 380 days. This includes only panel and master data surveys in which the panelist has reached the final page and was assigned status 31 or 32. Each project is counted only once, i.e. several completions of the same project (e.g. in case of multiple participation) do not count repeatedly. | |||||||||||
track_num_ completed1, 2, 3 | Number of completed surveys last custom screen-outs (Disposition code 38) | Date | Customized track_date_screened value. | ||||||||||||
| track_date_screenedcustomthree | Date of last custom screen-outs (Disposition code 40) | Date | Customized track_date_screened value. | ||||||||||||
| track_date_screenedcustomtwo | Date of last custom screen-outs (Disposition code 39) | Date | Customized track_date_screened value. | ||||||||||||
track_date_started | Last survey start | modstr | Date | Date of the last survey start. This covers the following cases:
| |||||||||||
track_date_unavail | Last unavailability | modunl | Date | Date of the last unavailability of the panelist.
| |||||||||||
| track_date_unavail_customone | Date of last custom availablity (Disposition code 18) | Date | Customized track_date_unavail value. | ||||||||||||
| track_date_unavail_customtwo | Date of last custom availablity (Disposition code 19) | Date | Customized track_date_unavail value. | ||||||||||||
track_num_avgratinggiven | Average rating given | From EFS 10.3: Average value of the ratings given by the panelist. | |||||||||||||
track_num_avgratinggiven1, 2, 3 | Average rating given( | From EFS 10.3: Average value of the ratings given by the panelist, restricted to the last 4 / 8 / 12 weeks. | |||||||||||||
track_num_avgratingreceived | Average rating received | From EFS 10.3: Average value of the ratings received by the panelist. | |||||||||||||
track_num_avgratingreceived1, 2, 3 | Average rating received (last 4 / 8 / 12 weeks) | numcpl1, 2, 3 | Counter | track_num_completed valueFrom EFS 10.3: Average value of the ratings received by the panelist, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_ completed | Number of completed surveys | numcpl | Counter | Number of all the surveys the panelist has completed within the last 380 days. This includes only panel and master data surveys in which the panelist has reached the final page and was assigned status 31 or 32. Each project is counted only once, i.e. several completions of the same project (e.g. in case of multiple participation) do not count repeatedly. | |||||||||||
track_num_completed1, 2, 3 | Number of completed surveys (last 4 / 8 / 12 weeks) | numcpl1, 2, 3 | Counter | track_num_completed value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
| track_num_completedcusomone | Number of completed surveys (Disposition code 33) | numcplcustomone | Counter | Customized track_num_completed value. | |||||||||||
| track_num_completedcusomone1, 2, 3 | Number of completed surveys (Disposition code 33) (last 4 / 8 / 12 weeks) | numcplcustomone1, 2, 3 | Counter | Customized track_num_completed value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
| track_num_completedcusomtwo | Number of completed surveys (Disposition code 34) | numcplcustomtwo | Counter | Customized track_num_completed value. | |||||||||||
| track_num_completedcusomtwo1, 2, 3 | Number of completed surveys (Disposition code 34) (last 4 / 8 / 12 weeks) | numcplcustomtwo1, 2, 3 | Counter | Customized track_num_completed value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_credit | Received bonus points | Counter | From EFS 10.3: Number of bonus points received. | ||||||||||||
track_num_credit1, 2, 3 | Received bonus points (last4/8/12 weeks) | Counter | track_num_ invited1, 2, 3 | Number of invitations (last4/8/12 weeks) | From EFS 10.3: track_num_ | Number of completed surveys (Disposition code 34) | track_num_completedcusomtwo1, 2, 3 | Number of completed surveys (Disposition code 34) (last 4 / 8 / 12 weeks) | track_num_ credit | Received bonus points | From EFS 10.3: Number of bonus points received. | track_num_ credit1, 2, 3 | Received bonus points (last4/8/12 weeks) | From EFS 10.3: track_num_credit value, restricted to the last 4 / 8 / 12 weeks. | |
track_num_ incomplete | Number of incomplete surveys | numinc | Counter, derived | track_num_started-track_num_completed-track_num_- screened-track_num_quoted Please note: If a panelist participates repeatedly in a survey and reaches various statuses on the final pages, e.g. first 37, later 31, this can result in a negative value or 0. Therefore, the results are limited to the range 0...n. If the result of the calculation is < 0, then 0 will be displayed. | |||||||||||
track_num_ invited | Number of invitations | numinv | Counter | Sum total of invitations to panel or master data surveys within the last 380 days. The first mail sent to the panelist in a project is considered an invitation. Please mind:
| |||||||||||
numinv1credit value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||||||
track_num_incomplete | Number of incomplete surveys | numinc | Counter, derived | track_num_started-track_num_completed-track_num_- screened-track_num_quoted Please note: If a panelist participates repeatedly in a survey and reaches various statuses on the final pages, e.g. first 37, later 31, this can result in a negative value or 0. Therefore, the results are limited to the range 0...n. If the result of the calculation is < 0, then 0 will be displayed. | |||||||||||
track_num_invited | Number of invitations | numinv | Counter | Sum total of invitations to panel or master data surveys within the last 380 days. The first mail sent to the panelist in a project is considered an invitation. Please mind:
| |||||||||||
track_num_invited1, 2, 3 | Number of invitations (last4/8/12 weeks) | numinv1, 2, 3 | Counter | track_num_invited value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_quality | Number of quality problems | numqul | Counter | Sum total of quality problems. A quality problem is defined as the panelist’s quality correction value being smaller than 0.1. Repeated quality problems of a panelist in the same project are not counted repeatedly. | |||||||||||
track_num_quality1, 2, 3 | Number of quality problems (last 4 / 8 / 12 weeks) | numqul1, 2, 3 | Counter | track_num_ quality value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_ qualityquoted | Number of quality problemsnumqulrejections due to closed quota | numqut | Counter | Sum total of quality problems. A quality problem is defined as the panelist’s quality correction value being smaller than 0.1. Repeated quality problems of a of rejections due to closed quota. A rejection occurs when a panelist is assigned status 35, 36 or 41 upon reaching the final page in a panel or master data survey. Repeated rejections of the panelist in the same project (multiple participation) are not counted repeatedly. | |||||||||||
track_num_ quality1quoted1, 2, 3 | Number of quality problems rejections due to closed quota (last 4 / 8 / 12 weeks) | numqul1numqut1, 2, 3 | Counter | track_num_quality quoted value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_ quotedratinggiven | Number of rejections due to closed quotanumqutratings given( | Counter | Sum of rejections due to closed quota. A rejection occurs when a panelist is assigned status 35, 36 or 41 upon reaching the final page in a panel or master data survey. Repeated rejections of the panelist in the same project (multiple participation) are not counted repeatedlyFrom EFS 10.3: Number of the ratings given by the panelist. | ||||||||||||
track_num_ quoted1ratinggiven1, 2, 3 | Number of rejections due to closed quota (last 4 ratings given (last4/8/12 weeks) | numqut1, 2, 3 | Counter | track_num_quoted valueCounter | From EFS 10.3: Number of the ratings given by the panelist, restricted to the last 4 / 8 / 12 weeks. | ||||||||||
track_num_ ratinggivenratingreceived | Number of ratings given(received | Counter | From EFS 10.3: Number of the ratings given received by the panelist. | ||||||||||||
track_num_ ratinggiven1ratingreceived1, 2, 3 | Number of ratings given received (last4last 4 / 8 / 12 weeks) | Counter | From EFS 10.3: Number of the ratings given received by the panelist, restricted to the last 4 / 8 / 12 weeks. | track_num_ ratingreceived | Number of ratings received | Counter | From EFS 10.3: Number of the ratings received by the panelistrestricted to the last 4 / 8 / 12 weeks. | ||||||||
track_num_reminded | Number of reminders | numrem | Counter | Sum of reminders of panel or master data surveys within the last 380 days. All follow-up mails sent to the panelist in a project are considered reminders (i.e. at least one mail has already been sent to the panelist from that project). Multiple reminders are counted multiple times. | |||||||||||
track_num_ ratingreceived1reminded1, 2, 3 | Number of ratings received reminders (last 4 / 8 / 12 weeks) | numrem1, 2, 3 | Counter | From EFS 10.3: Number of the ratings received by the panelisttrack_num_reminded value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_ remindedsampled | Number of reminderssample memberships | numremnumsam | Counter | Sum of reminders of panel or Number of sample memberships (assignments to samples) of the panelist in panel and master data surveys within the last 380 days. All follow-up mails sent to the panelist in a project are considered reminders (i.e. at least one mail has already been sent to the panelist from that project). Multiple reminders are counted multiple timesThe membership is established by drawing a sample (regardless of whether the project is active and in the field) or by assigning the panelist to a sample by other means (update rules, panelist administration, registration on website, adding of tester). Only one membership per project is included in the count. | |||||||||||
track_num_ reminded1sampled1, 2, 3 | Number of reminders sample memberships (last 4 weeks) | numrem1numsam1, 2, 3 | Counter | track_num_reminded sampled value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_ screened | Number of screen-outs | numscn | Counter | Number of all screen-outs. A screen-out occurs when a panelist is assigned status 37 upon reaching the final page in a panel or master data survey. Repeated screen- outs of the panelist in the same project (multiple participation) are not counted repeatedly. | |||||||||||
track_num_ screened1, 2, 3 | Number of screen- outs (last 4/ 8 / 12 weeks) | numsam1 numscn1, 2, 3 | Counter | track_num_ screened value, restricted to the last 4 / | track_num_ screened | Number of screen-outs | numscn | Counter | Number of all screen-outs. A screen-out occurs when a panelist is assigned status 37 upon reaching the final page in a panel or master data survey. Repeated screen- outs of the panelist in the same project (multiple participation) are not counted repeatedly8 / 12 weeks. | ||||||
| track_num_screenedcustomone | Number of screen- outs (Disposition code 38) | numscncustomone | Counter | Customized track_num_screened value. | |||||||||||
| track_num_ screened1screenedcustomone1, 2, 3 | Number of screen- outs (Disposition code 38) (last 4/ 8 / 12 weeks) | numscn1numscncustomone1, 2, 3 | Counter | Customized track_num_screened value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
| track_num_screenedcustomonescreenedcustomthree | Number of screen- outs outs (Disposition code 3840) | numscncustomthree | Counter | Customized track_num_screenedcustomone1screened value. | |||||||||||
| track_num_screenedcustomthree1, 2, 3 | Number of screen- outs outs (Disposition code 3840) (last 4/ 8 / 12 weeks) | track_num_screenedcustomthree | Number of screen- outs (Disposition code 40) | track_num_screenedcustomthree1, 2, 3 | Number of screen- outs (Disposition code 40) (numscncustomthree1, 2, 3 | Counter | Customized track_num_screened value, restricted to the last 4 / 8 / 12 weeks). | ||||||||
| track_num_screenedcustomtwo | Number of screen- outs (Disposition code 39) | numscncustomtwo | Counter | Customized track_num_screened value. | |||||||||||
| track_num_screenedcustomtwo1, 2, 3 | Number of screen- outs (Disposition code 39) (39) (last 4/ 8 / 12 weeks) | numscncustomtwo1, 2, 3 | Counter | Customized track_num_screened value, restricted to the last 4 / 8 / 12 weeks). | |||||||||||
track_num_started | Number of survey starts | numstr | Counter | Number of all survey starts within the last 380 days. This covers the following cases:
Repeated survey starts of the panelist in the same project (multiple participation) are not counted repeatedly. | |||||||||||
track_num_started1, 2, 3 | Number of survey starts (last 4 / 8 /12 weeks) | numstr1, 2, 3 | Counter | track_num_started value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_num_unavail | Number of unavailabili- ties | numunl | Counter | Number of all unavailabilities within the last 380 days. Unavailability is manually assigned by the admin to individual members of a sample. If a mail cannot be delivered to the receiving server, this is regarded as unavailability as well, and the status is changed automatically by the system. Repeated unavailabilities in a project are not counted repeatedly. | |||||||||||
track_num_unavail1, 2, 3 | Number of unavailabilities (last 4 / 8 / 12 weeks) | numunl1 | Counter | track_num_unavail value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
| track_num_unavailcustomone | Number of unavailabilities (Disposition code 18) | numunlcustomone | Counter | Customized track_num_unavail value. | |||||||||||
| track_num_unavailcustomone1, 2, 3Number of unavailabilities (Disposition code 18) (, 3 | Number of unavailabilities (Disposition code 18) (last 4 / 8 / 12 weeks) | numunlcustomone1, 2, 3 | Counter | Customized track_num_unavail value, restricted to the last 4 / 8 / 12 weeks). | |||||||||||
| track_num_unavailcustomtwo | Number of unavailabilities (Disposition code 19) | numunlcustomtwo | Counter | Customized track_num_unavail value. | |||||||||||
| track_num_unavailcustomtwo1, 2, 3 | Number of unavailabilities (Disposition code 19) (last 4 / 8 / 12 weeks) | numunlcustomtwo1, 2, 3 | Counter | Customized track_num_unavail value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_rel_completed | Proportion of completed surveys | relcpl | Probability (0..1), derived | track_num_completed/track_num_sampled If a panelist has completed more surveys in the period under review than he had sample memberships, the value might be greater than 1. Therefore, the results are limited to the range 0...n. If the result of the calculation is > 1, then 1 will be displayed. | |||||||||||
track_rel_completed1, 2, 3 | Proportion of completed surveys (last 4 weeks) | relcpl1, 2, 3 | Probability (0..1), derived | track_rel_completed value, restricted to the last 4 / 8 / 12 weeks. | |||||||||||
track_rel_started | Proportion of started surveys | relstr | Probability (0..1), derived | track_num_started/track_num_sampled If a panelist had more survey starts than sample memberships in the period under review, the value might be greater than 1. Therefore, the results are limited to the range 0...n. If the result of the calculation is > 1, then 1 will be displayed. | |||||||||||
track_rel_started1, 2, 3 | Proportion of started surveys (last 4 weeks) | relstr1, 2, 3 | Probabil- ity (0..1), derived | track_rel_completed value, restricted to the last 4 / 8 / 12 weeks. |