From time to time, questions in a tracker will change. Most commonly, this will involve the addition or deletion of categories (e.g., adding new brands), although more fundamental changes may occur (e.g., turning a single response into a multiple response question).
Accidental changes when outfiling data
Sometimes data from a tracker are exported inconsistently. For example, in one wave gender may be in a variable called gnd and in another data file it may be called q2. When you import the updated data, Q will automatically identify such problems, provided that you are not using a CSV file. Although such problems can usually be fixed within Q, it is almost always preferable to have the person that provided that data file re-export so that it is consistent with the original data file structure.
Ad hoc changes
Common ad hoc changes include adding additional brands and changing image statements.
New codes in Pick One and Pick – One Multi questions
Where a new code is added to a Pick One or Pick One – Multi question, this is almost entirely automatically handled by Q. Where you are required to make decisions about how to deal with the change, these are flagged both at the time of import and in the Status column in the Variables and Questions tab. Please note, however, that any analyses done on the variables will implicitly assume that same code frame has been employed throughout the data. That is, if a new brand is introduced in 2010, any analyses run in 2009 will show the brand (but with a value of 0 or NaN, depending upon the analysis). A solution to this is to export the data as Pick Any questions, as then missing values can be used in periods where the data did not exist.
Removed codes in Pick One and Pick – One Multi questions
If a code is deleted in the questionnaire (e.g., a brand has left the market and is not asked in the questionnaire), if there is a need to continue to report on the brand, then the code should still be included in the exported data file.
Changed code frames in multiple response questions
When multiple response questions are changed, such as adding a new brand, this can cause considerable complexity, particularly if the question is then used to construct filters and other questions. In general, the best approach to dealing with this is to anticipate this possibility when setting up the data collection program (see Data File Setup for Tracking Studies ).
The various tools for Setting Up Data are useful when dealing with questionnaire changes. Where there are two different versions of a question, these can be automatically combined in the Variables and Questions tab using Insert Ready-Made Formula(s) and Merge Questions.
How to Set Up a Data File for Tracking Studies
How to Setup for Advertising Trackers
How to Build Tables that Automatically Show Results from the Latest Period
How to Dynamically Filter Data to the Latest Waves
Article is closed for comments.