The results for studies can be downloaded from the Admin Dashboard, by selecting the study, and then selecting Download Results. The results are downloaded as a .xlsx file that may be opened in any spreadsheet program such as Google Sheets or Microsoft Excel. The results spreadsheet is split into four worksheets:
1) The Overview Worksheet: This sheet contains information about the study the results are from, the number of participants, and when the results were downloaded.
2) The Posts Worksheet: This sheet contains all the interactions participants made with the posts that they were shown, as well as information about those posts.
3) The Comments Worksheet (optional): This sheet contains the reactions of participants to comments on posts. If your study contains no comments, this sheet will not be included.
4) The Participants Worksheet: This sheet contains a list of all the participants in the study, when they completed the study, and their completion codes.
If you wish to view some example results from a user experience study ran using The Misinformation Game, they can be accessed from the example results page.
This sheet contains information about the study that the results are from, the number of participants, and when the results were downloaded.
The identification number used in the URL of the study to identify it. It is unique for each study.
The name that was configured in the configuration spreadsheet for the study.
The number of participants that completed the study.
The date and time that the results were downloaded, in UTC time.
This sheet contains all the interactions of participants with the posts that they were shown, as well as information about those posts.
The session ID can be used to uniquely identify a participant in their play-through of the game. The session ID is always available, and it is unique for every participant.
The ID that the participant entered when starting the study, or that was filled in for them through the URL. The participant ID is not guaranteed to be unique, as multiple participants could enter the same participant ID. It is also not guaranteed to be present if the study has been configured to not require identification.
A number starting from 1 that represents when the participant was shown the post associated with this row of the results. For example, a Post Order of 1 would represent the first post shown to a participant, and a Post Order of 4 would represent the fourth post the participant was shown.
The Post ID of the post that was shown to the participant. This is the same ID that was specified in the configuration spreadsheet for the post.
The Source ID of the source that was associated with a post that was shown to the participant. This is the same ID that was specified in the configuration spreadsheet for the source.
The credibility of the source that was associated with a post shown to the participant.
The number of followers of the source that was associated with a post shown to the participant.
The Headline of the post shown to the participant. This is the same headline that was specified in the configuration spreadsheet for the post. This will be empty if the post did not have a headline.
The number of like reactions to the post shown to the participant. This does not include the increase to the number of likes if the participant liked this post. This column will only be included if Post Likes are Enabled.
The number of dislike reactions to the post shown to the participant. This does not include the increase to the number of dislikes if the participant disliked this post. This column will only be included if Post Dislikes are Enabled.
The number of share reactions to the post shown to the participant. This does not include the increase to the number of shares if the participant shared this post. This column will only be included if Post Shares are Enabled.
The number of flag reactions to the post shown to the participant. This does not include the increase to the number of flags if the participant flagged this post. This column will only be included if Post Flags are Enabled.
Whether the participant liked the post. This column will only be included if Post Likes are Enabled.
Whether the participant disliked the post. This column will only be included if Post Dislikes are Enabled.
Whether the participant shared the post. This column will only be included if Post Shares are Enabled.
Whether the participant flagged the post. This column will only be included if Post Flags are Enabled.
Whether the participant explicitly chose the skip post
reaction. If reactions are not required, or if the study
is using the feed mode, then participants may move past
a post without interacting with it. In those cases, this
value will be FALSE, as they did not select the skip
post reaction.
The comment that the participant made on a post. If the
participant did not comment on the post, then this cell
will be empty. This column will only be included if
Require Comments
is set to Required or Optional.
The amount of time that this post was accessible by the participant, in milliseconds. If in feed mode, then this metric may count time in which the post was off of the screen. This value will always be available.
The time from the post becoming visible to the participant’s first interaction with the post, in milliseconds. Interactions include comments on posts, or reactions to posts. Once a participant has made their first interaction with a post, this value will no longer change. If the participant had no interactions with a post, then this cell will be empty.
The time from the post becoming visible to the participant’s last interaction with the post, in milliseconds. Interactions include comments on posts, or reactions to posts. If the participant had no interactions with a post, then this cell will be empty.
The change to the participant’s credibility after they interacted with the post.
The change to the participant’s number of followers after they interacted with the post.
The credibility of the participant before they interacted with the post.
The number of followers of the participant before they interacted with the post.
The credibility of the participant after they interacted with the post.
The number of followers of the participant after they interacted with the post.
This sheet contains the reactions of participants to comments on posts. If your study contains no comments, then this sheet will not be included.
The session ID can be used to uniquely identify a participant in their play-through of the game. The session ID is always available, and it is unique for every participant. This is the same Session ID that is stored in the Posts Worksheet.
The ID that the participant entered when starting the study, or that was filled in for them through the URL. The participant ID is not guaranteed to be unique, as multiple participants could enter the same participant ID. It is also not guaranteed to be present if the study has been configured to not require identification. This is the same Participant ID that is stored in the Posts Worksheet.
A number starting from 1 that represents when the participant was shown the post associated with this row of the results. For example, a Post Order of 1 would represent the first post shown to a participant, and a Post Order of 4 would represent the fourth post the participant was shown. This is the same Post Order that is stored in the Posts Worksheet.
The Post ID of the post that was shown to the participant. This is the same ID that was specified in the configuration spreadsheet for the post.
A number starting from 1 that identifies the order in which the comments were displayed beneath a post. For example, a value of 1 would represent the first comment below a post, and a value of 3 would represent the third comment below a post.
The text contents of the comment that was displayed to the participant.
The number of like reactions that was associated with the comment. This does not include the increase to the number of likes if the participant liked this comment. This column will only be included if Comment Likes are Enabled.
The number of dislike reactions that was associated with the comment. This does not include the increase to the number of dislikes if the participant disliked this comment. This column will only be included if Comment Dislikes are Enabled.
Whether the participant liked this comment. This column will only be included if Comment Likes are Enabled.
Whether the participant disliked this comment. This column will only be included if Comment Dislikes are Enabled.
The time from the post becoming visible to the participant’s first reaction to this comment, in milliseconds. Once a participant has made their first reaction to a comment, this value will no longer change. If the participant did not react to the comment, then this cell will be empty.
The time from the post becoming visible to the participant’s last reaction to this comment, in milliseconds. If the participant did not react to the comment, then this cell will be empty.
This sheet contains a list of all the participants in the study, when they completed the study, and their completion codes.
The session ID can be used to uniquely identify a participant in their play-through of the game. The session ID is always available, and it is unique for every participant. This is the same Session ID that is stored in the Posts Worksheet.
The ID that the participant entered when starting the study, or that was filled in for them through the URL. The participant ID is not guaranteed to be unique, as multiple participants could enter the same participant ID. It is also not guaranteed to be present if the study has been configured to not require identification. This is the same Participant ID that is stored in the Posts Worksheet.
The code that the participant was shown when they completed the study.
The time when the participant first accessed the game and entered their ID, in UTC time.
The time when the participant completed the study (before being shown the debriefing), in UTC time.
The time when the study was last updated, in UTC time. When a study is enabled or disabled, or when the contents of a study are updated, this value will change. Therefore, if a study is re-run multiple times, and disabled in-between, this value can be used to differentiate runs.
Back to Top