What does an unusual start and end date on the spreadsheet mean? | XM Community
Skip to main content
Solved

What does an unusual start and end date on the spreadsheet mean?

  • March 16, 2022
  • 4 replies
  • 134 views
alioudosdiallo
Forum|alt.badge.img+2

Hello,
I collected pilot data with my Qualtrics survey and downloaded the results in the form of an excel spreadsheet. When I opened the file, I saw that some start and end dates were unusual in the sense that they were not actual dates and time but decimal numbers (e.g., one row has 2.799 as start date and 52.809 as end date). You can see this in the attached screenshot where I highlighted said odd numbers.
What does this mean?
Thank in advance for your response.
Capture.PNG

Best answer by wpm24

I am not sure, but it isn't just your start and end dates, that (approximate) value appears to repeat in each column thereafter. What comes up in the 'status' column for these participants? It could be spam or bots. To understand your status column follow these instructions, I believe the section on status is in the beginning of the webpage - https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/understanding-your-dataset/

4 replies

wpm24
Level 2 ●●
Forum|alt.badge.img+8
  • wpm24
  • Level 2 ●●
  • Answer
  • March 16, 2022

I am not sure, but it isn't just your start and end dates, that (approximate) value appears to repeat in each column thereafter. What comes up in the 'status' column for these participants? It could be spam or bots. To understand your status column follow these instructions, I believe the section on status is in the beginning of the webpage - https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/understanding-your-dataset/

alioudosdiallo
Forum|alt.badge.img+2

Hello wpm24 ! Thank you for your prompt response. To answer your question, the status column for these participants contains decimal numbers as well.

wpm24
Level 2 ●●
Forum|alt.badge.img+8
  • wpm24
  • Level 2 ●●
  • March 17, 2022

https://community.qualtrics.com/XMcommunity/discussion/comment/44640#Comment_44640I would assess these as bot responses and delete them then. It doesn't really make sense that this could be a real participant as those variables are all embedded from qualtrics. So it could either be an error on qualtrics end (which questions the data from the participant) or is a bot, which you don't want obviously.

alioudosdiallo
Forum|alt.badge.img+2

wpm24 okay, great thank you. I will delete them all.

Terms & ConditionsAccessibility statement