Hi,
I wonder if anyone can help.
I we have a survey which is now closed, that I have built dashboards on. I've had a request to add in an additional filter for data we don't currently store in Qualtrics.
Subsequently, I have added this data to the contact list, but It does not appear as embedded data within the "Data and Analytics" tab of the survey, nor am I able to add it as a field on the dashboard.
Can anyone advise how I can get the data into the dashboards to filter on it?
Note we have thousands of responses, the data is demographic, adding it in manually, as a calculated column is not really a feasible option for us.
Thanks,
Polly
Solved
Adding additional Embedded data post survey launch
Best answer by rondev
https://www.qualtrics.com/community/discussion/comment/27290#Comment_27290So this is one more thing that we need to know - Every time you import the data, it will add new rows and create new response id for the new row. So you need delete the previous data and then import it.
+22Have you added this embedded data in the survey flow as first element of survey flow?
I am not sure if contact list embedded data gets updated retroactively in data analysis, but you can try the above.
+22One of the solution can be: To create a CSV file with response id and that embedded data value. You can create this csv file using vlookup on data and analysis export and that contact list exports common field.
Then, you can create a API that would read this CSV file and for each row/ record, you can run this update response api in a loop.
+22https://www.qualtrics.com/community/discussion/comment/27288#Comment_27288Yes, nice thought, it can work with import/export option too, but then the start date, end date of all respondent would change when you re-import it. But then again you can store this start and end date in some other embedded data, to retain them if needed.
rondev one last question (I think!). I am doing some tests with importing the data and it appears to append, not merge (i.e i will end up with a new row of data, rather than the original data being enriched) I am importing with the same response_ID but it seems to add a new ID to the imported data. Is there a way to merge appose to append do you know?
+22https://www.qualtrics.com/community/discussion/comment/27290#Comment_27290So this is one more thing that we need to know - Every time you import the data, it will add new rows and create new response id for the new row. So you need delete the previous data and then import it.
+8Hello, I'm trying to do this too. How did you end up retaining your start/end/recorded dates?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.