Export Response data + Metadata | XM Community
Skip to main content
Solved

Export Response data + Metadata

  • January 25, 2022
  • 2 replies
  • 143 views
M
Forum|alt.badge.img

Is there any way to export Metadata with the survey response data?
Problem- I have two surveys (A & B) that I want to merge and then clean the combined data.
A] within Qualtrics:- Using the "response type" variable to remove observations that are reported as spam; system test etc
I merge the data (export A then import into Project B)
When I Import (as CSV or TSV) data file, the "response type" variable reports "imported" for all responses - I want a variable that reports the original "response type" for the imported file.
B] Using STATA: Exporting the data from the two surveys & then appending this in STATA and using the metadata to clean and remove the fraudulent observations.

Best answer by StephH72

You could add an embedded variable into the survey flow. Then export both surveys to excel and copy across the "response type" data into the blank embedded data column. Then import both surveys into a new blank survey and the data will be captured.
I don't think there's a way to keep metadata when importing, but embedded variables work a bit better for this.
Hope this helps :)

2 replies

StephH72
Level 2 ●●
Forum|alt.badge.img+16
  • StephH72
  • Level 2 ●●
  • Answer
  • January 25, 2022

You could add an embedded variable into the survey flow. Then export both surveys to excel and copy across the "response type" data into the blank embedded data column. Then import both surveys into a new blank survey and the data will be captured.
I don't think there's a way to keep metadata when importing, but embedded variables work a bit better for this.
Hope this helps :)

M
Forum|alt.badge.img
  • Malhotra
  • Author
  • January 25, 2022

Thank you, Steph. I'll try that.


Terms & ConditionsAccessibility statement