Hi all, long time lurker here deciding to seek direct support from the experts here as I didn't find articles that would address my specific question.

Context:

We've carried out a survey to identify which attributes respondents consider to be more important. Altogether, we have around 1000 responses, each respondent is shown 13 sets of 5 statements. In each set the respondent has to mark which one is more/least important for him/her when making a certain decision. Altogether there are 23 attributes which are rotating. We're carried out this part of the research using a Survey tool called "Alchemer". For those of you, who have used the tool before, might know that the aggregate output that this tool provides is fairly limited (but that's a different discussion).

Objective:

Back to the point. We would like to estimate individual level utilities (rankings) based on each respondent's answer patterns. Ultimately, the goal would be to use this data to inform our decisions around customer segmenting.

While I've done quite a bit of work with Stata in the past (back in my uni days), I've been withdrawn from the field for a couple of years now. As such, my memory and knowledge of Stata concepts is a bit hazy.

Has anyone in this forum previously encountered a similar task? How did you solve it? Could some of the experts provide some guidance?

P.s. Image attached below of the data export that we get from Alchemer is structured in the following format (for the sake of brevity, let's assume there are 3 sets shown to each respondent, with 4 options to choose from). Best/Worst columns indicate which Attribute (1...4) was selected.