How to export which randomised condition was assigned to each participant | XM Community
Skip to main content

I have a survey with randomisation in which participants are randomised to one of four conditions (each one is a different block of text). They then answer the same set of questions. I have attached a screenshow of my survey flow below, however, it appears that the ‘set embedded data’ sections in green were not published until later, and therefore not included in the survey that participants accessed. When I export the data, ticking the 'export viewing order data for randomized surveys', I get an empty column titled condition and a column titled ‘FL_8 - Block Randomizer - Display Order’ with letter and numbers as the values for each participant, and a column titled ‘Condition A - Display Order’, with most cells empty, but some filled in with ‘condition A’.

Can anyone help me work out how I get Qualtrics to export which of the four conditions each participant was shown into excel? 

Thank you

 

 

I have now seen that the column titled ‘FL_8 - Block Randomizer - Display Order’ has four options for its values:

  1. BL_cYKObuQXVIvWcJg

  2. BL_3rttonRTPZSqQLA

  3. BL_9uiX8YqbffbedUy

  4. BL_bQtfgmS72k295cO

I think that these correspond to the four conditions participants were assigned to, but I can’t work out which is which - can anyone help with this?

 

Thank you

 

Hi,

You can get the blocks IDs and descriptions with the Get Survey API.

Alternatively, you can get them in the URL if you use the preview block function.

 

 

 

Hi ​@MKW,
If you already have the values and just want to know which is which, you can just click on view response on a few individual responses in “Data and Analysis” tab.
 


This way you can know which randomization each value is referring to.

Hope it helps.
-- Rochak

Hello ​@MKW,

You can find out which condition each participant got by checking the randomization data in your export file.

In the exported data, look for the column called ‘FL\_8 - Block Randomizer - Display Order’. This column shows the flow IDs for the blocks each participant saw.

To see which condition matches each flow ID, Open your ‘Survey Flow’ in Qualtrics, Click ‘Show Flow IDs’ in the top-right corner, Note the flow ID for each condition under the randomizer.

Then, in your exported data, match the flow IDs from the ‘FL\_8 - Block Randomizer - Display Order’ column to the correct condition. You can use Excel’s ‘Find and Replace’ or do it manually.

Finally, create a new column in Excel called ‘Condition’ and fill it with the condition name (e.g., Condition A, Condition B) for each participant based on the matching flow ID.

 Let me know if this helps.

Terms & ConditionsAccessibility statement