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
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
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_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
From EFS 10.3: Date of last rating given.
track_date_ratingreceived
Date of last rating recei- ved
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
Date of the last survey start. This covers the following cases:
a panelist starts a survey.
a panelist restarts a survey after reset with / without deletion of data.
a panelist restarts a survey when multiple participation is permitted.