Filter ETL Records if Row Already Exists as Survey Response | XM Community
Skip to main content
Question

Filter ETL Records if Row Already Exists as Survey Response

  • February 10, 2025
  • 0 replies
  • 12 views

Forum|alt.badge.img+10
  • Level 2 ●●
  • 10 replies

Has anyone set up a survey with multiple channels of access (both an emailed personal link and anonymous link/QR code)? I am envisioning a scenario where individuals would be invited to participate in a survey immediately following an interaction/experience through the use of a QR code/anonymous link if the individual chooses not to utilize the QR code/anonymous link the next day they would be added to a survey distribution and subsequent reminders using the Send Survey via Email Task. In both scenarios, the individual would authenticate into the survey against a Contact List.

Obviously, I do not want to invite someone to participate via email that already completed the survey via QR code/anonymous link. I’m planning to use the ETL workflow in Qualtrics to set up a daily invitation to those that completed the interaction/experience but I am getting on hung up on how and where to insert the step remove records that already completed the survey.

 

Thanks for any suggestion/insight you can provide!

0 replies

Be the first to reply!

Leave a Reply