How do I extract a list of respondents who saw a stimulus first in a monadic block?

You can identify which respondents were exposed to each stimulus first in a monadic block by working with your Excel report. Once you have extracted the relevant participant IDs, you can upload them as External Variables in your online report for further analysis.

Try Insights Explorer first

Before working through the manual Excel steps below, consider using Insights Explorer. Its AI-powered chat interface can analyse your data and extract respondent lists automatically — just describe what you need in plain language. This is often the quickest approach.

If you prefer to do it manually in Excel, follow the steps below.

Step 1: Open the ‘Answers to questions’ tab

In your Excel report, go to the ‘Answers to questions’ tab. Create a new column next to ‘Participant ID’ in column B.

Step 2: Filter for respondents included in the report

To show only respondents included in the report, enter the following formula in the new column:

=XLOOKUP($B4,Respondents!$A:$A,Respondents!$S:$S)

Then drag the formula to apply it to all rows.

Note: This formula links the ‘Participant ID’ and ‘Is included in current report’ columns in the ‘Respondents’ tab.

Filter for rows with a 1 value to show only respondents included in the current report.

Step 3: Filter by question and shown order

Next, filter for the relevant value in the additional_question_id column that corresponds to the monadic block question you are interested in. (In the example below, the value is 5447368.)

Then filter the shown_order column for the lowest shown_order value associated with that question. This is the first occurrence of the monadic block question in the survey, and identifies the stimulus shown first to each respondent. The value depends on how many questions appear before the monadic block in your survey — for example, if there are two preceding questions, the first monadic question will have shown_order = 3.

For more information about how shown_order is recorded, see How to view the order of questions shown to respondents?

Step 4: Identify stimulus IDs

Refer to the stimulus IDs associated with each option in your study. For example:

You can find the stimulus IDs for your own study in the ‘Answers to questions’ tab under the stimulus_id column.

Step 5: Extract respondents for each stimulus

Filter the stimulus_id column for the first stimulus (e.g., 2198596 for ‘New Logo (With Name)’) to show only respondents who saw that stimulus first.

Copy the list of participant_id values and paste them into a new sheet. Similarly, copy the list of shown_order values and paste them into the same new sheet.

Rename the new sheet to something descriptive, for example: Seen New Logo (With Name) First.

Step 6: Repeat for remaining stimuli

Repeat the same process for each remaining stimulus (e.g., 2198597 for ‘Current Logo’ and 2199963 for ‘New Logo (No Name)’), creating a separate sheet for each. Save the Excel file when done.

Step 7: Save each sheet as a CSV file

Click on each newly created tab and save it as a .csv file.

Step 8: Upload as External Variables

Now that you have created the CSV files, you can upload each one as an External Variable in your online report. For guidance, see External Variables.