Missing contacts when creating Contact List | XM Community
Skip to main content
Solved

Missing contacts when creating Contact List

  • September 21, 2018
  • 6 replies
  • 139 views

Forum|alt.badge.img+11
I'm trying to create a new Contact List from a CSV file of 400.000 contacts. When I upload it and enter the contact list, in the bottom it says the list has only 339.788 contacts. There are many repeated emails, but I checked manually and there are 388.363 unique emails, so even if qualtrics if consolidating them automatically, there are still 48575 missing contacts. Does anyone know what are the possible reasons for these behaviour? Thanks.

Best answer by PeeyushBansal

Check if you have trimmed emails while uploading. Also it happens due to invalid emails.

6 replies

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • Answer
  • September 21, 2018
Check if you have trimmed emails while uploading. Also it happens due to invalid emails.

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • September 22, 2018
Even if the emails are duplicates these get uploaded in target audience . The reason it is happening may be invalid emails or the trimming not done. When you upload you get option to view result. Checking this you can know which emails got declined.

MohammedAli_Rajapkar
QPN Level 5 ●●●●●
Forum|alt.badge.img+20
Please refer to this documentation, just to make sure the content in each field is appropriate. https://www.qualtrics.com/support/iq-directory/lists-tab/creating-mailing-lists/#UploadaFile

Forum|alt.badge.img+11
  • Author
  • QPN Level 2 ●●
  • September 22, 2018
Apparently there were some invalid emails that finished with a dot, or didn't end in '.com', etc. and Qualtrics was automatically ignoring them, but because it didn't show me any warning message I didn't know what was going on.

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • September 22, 2018
You can check this by view result only.

LaurenK
Former XM Community Team Member
Forum|alt.badge.img+13
  • Former XM Community Team Member
  • September 28, 2018
Hey @fstram! If you have not yet already, I would recommend reaching out to our Support Team so they can further troubleshoot and escalate if needed!