File Structure

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

 

There are more than 40 different files that are used by the ComQuest program. Generally, you will not need to know much about the files themselves, as ComQuest will use each as it deems necessary.  All the data files are stored in the C:\ComQuest folder on the Fileserver (or in discrete data directories on your Fileserver, if you're testing more than one market).  Most data files end with a .DAT or .TPS extension, while their associated key files end with a .K0* extension.

 

As many of these files are related to each other, here is a brief overview of some of the most often used files and their contents.

 

Respondents - (RESPONDE.DAT) This is the primary file in ComQuest which contains all your respondent information including name, address, city, state, zip code, phone number, stations cumed and preferred, ethnicity, demo and gender.  This file is related to most of the other ComQuest files by a unique serial number (ID number) for each record. Keep in mind, the Respondent file is dynamic in nature (as opposed to static data such as your Defaults and Quotas).  As such, the profile information for individual Respondents is constantly changing and being updated (such as demo, stations listened to, etc.).  Keep this in mind when running various reports, such as Cume and Preference, at different intervals during or after specific research cycles.

 

History - (HISTORY.DAT) This ever-growing file contains one record for each interaction with each respondent.  Each time a respondent is called, whether that call results in a Busy, Answering Machine, Terminate or Take Test, a History record is added to document that fact.  (Attributes such as demo, gender, stations cumed and preferred and ethnicity are only saved once in the respondents file; this information is not duplicated in the History file).  Generally, the History file only contains date/time, status, interviewer and respondent ID information.

 

Schedule - (SCHEDULE.DAT) This file keeps track of respondents that must be called back at some date and time in the future.  This file will also continue to grow slightly as you continue using ComQuest.  Information contained in this file is limited to the date, time and respondent ID number for Call backs (status and last-called date/time information can be found in the related respondent record).

 

Auxiliary Stations - (AUXSTATI.DAT) This file contains radio station cume and preference listening information for related respondent records.  While information about the first six radio stations (the stations displayed on the main Make Calls screen) is stored in each person's respondent record, their listening to any of the (up to) 39 other Auxiliary stations is stored in the Auxiliary Stations file.

 

Scores - (SCORES.DAT) This file contains all the raw score data for each song scored by each respondent. Each record contains the respondent ID number it is related to, along with the Song ID number and score(s) for that song. The date the score was collected, along with the demo and gender of the respondent is also stored in this file, to accelerate processing when running song reports.

 

Prompts - (PROMPTS.DAT) This file merely contains the Song ID numbers of all the songs currently in your music test.

 

ComQuest Access File -  (COMQUEST.MDB) - This Microsoft Access file is used to synchronize the collection of song score data from respondents in the Song Survey program running on the Fileserver, and your data files in ComQuest. Tables in this file include the Respondents, Scores, Prompts and QPrompts files.  Your weekly results are also compiled into a Results table in this file, which provides you with instant access in the Pie Chart and Bar Graph procedures.

 

Questions - (QUESTION.DAT) Contains the sequencing and text for Interactive questions that are asked by the Fileserver, before respondents score your songs

 

Quest2 - (QUEST2.DAT) Contains the questions and sequencing for Perceptual Questions.

 

Surveys - (SURVEYS.DAT) Contains the names and serial numbers of each of the Perceptual Surveys in your system.

 

Responses - (RESPONSE.DAT) The respondent answers to all your Perceptual Surveys.  Various keys keep results from the different surveys and different questions segmented.