Adding additional Embedded data post survey launch | XM Community
Skip to main content
Solved

Adding additional Embedded data post survey launch

  • June 29, 2020
  • 9 replies
  • 1132 views
P

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

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.

TusharDalwani
A

9 replies

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • June 29, 2020

Have 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.

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
P
  • Polly7451
  • Author
  • June 29, 2020

Hey rondev ,

Unfortunately it doesn't seem to add retrospectively

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • June 29, 2020

One 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.

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
P
  • Polly7451
  • Author
  • June 29, 2020

rondev will this not work with the "Import" function instead, or do I have to create an API?

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • June 29, 2020

https://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.

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
P
  • Polly7451
  • Author
  • June 29, 2020

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?

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • Answer
  • June 29, 2020

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.

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
P
P
  • Polly7451
  • Author
  • June 29, 2020

Thanks rondev that makes total sense

nlanda
Level 2 ●●
Forum|alt.badge.img+8
  • nlanda
  • Level 2 ●●
  • February 13, 2023

Hello, I'm trying to do this too. How did you end up retaining your start/end/recorded dates?

Terms & ConditionsAccessibility statement