Need to know how many contacts were invited to multiple surveys within specified time frame | XM Community
Skip to main content
Question

Need to know how many contacts were invited to multiple surveys within specified time frame

  • September 28, 2023
  • 4 replies
  • 108 views

Forum|alt.badge.img+7

Hello!  I need to know how many contacts were invited to multiple surveys in a specific time frame.  For example, how many contacts were invited to Survey A AND Survey B over the last 30 days. I have a distribution dashboard, but not sure if/how to decifer that.  I tried to use a Survey ID filter that the Survey ID = Survey A AND Survey ID = Survey B, but I’m not getting data when I do that. What am I doing wrong? 

4 replies

Forum|alt.badge.img+14
  • Level 5 ●●●●●
  • 276 replies
  • September 28, 2023

Do you have a unique ID for each survey respondent that you could tie the respondents by? You could export the 2 survey distribution lists and do a VLOOKUP in Excel to find respondents that are in both lists. 


InessaG
Level 5 ●●●●●
Forum|alt.badge.img+19
  • Level 5 ●●●●●
  • 410 replies
  • September 28, 2023

Maybe try a custom metric where you will do a count and set a filter with survey ID set to both, and then you can filter on the dashboard where count is >1


Forum|alt.badge.img+7
  • Author
  • Level 2 ●●
  • 15 replies
  • September 28, 2023

Thanks for the tips.  The custom metric was promising, but it kept adding the two surveys together.  What I was able to do was create an advanced filter so that it looked for one survey and having an embedded data variable that would only be populated if they received the other survey.  A sloppy solution but it’s close enough.  


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • 1091 replies
  • September 29, 2023

@Lelowe_COUNTRY You can checkout the directory respondent funnel here, it might helps you:
XM Directory Respondent Funnel (qualtrics.com)


Leave a Reply