Missing records after contact import

user80437
Rookie
0 Votes

I'm importing contacts from an Excel spreadsheet, but after import, there are records missing from the list.  For example, I imported a list of lapsed members from Excel (five members total), and when it is done, I get the message "Import complete.  5 contacts were updated."  However, the lapsed member list only shows a total of 3 contacts.  I tried importing a second time to the same list, with the same results.  I attached a screenshot below, note the green message bar that says 5 contacts were updated, but the Lapsed Member list only shows 3 contacts.  Has anyone else experienced this, and have you found a resolution?

 

 

2 REPLIES 2
Caitlin_M
Administrator
0 Votes

Hi @user80437. I have removed the image you included in your original post as it contains account information.

 

 Since we do not have access to the file you uploaded, we're not able to easily determine why the full list did not upload. There are a few reasons why it can occur such as the contacts being unsubscribed or the address is not formatted correctly like not belonging to the primary email column.

 

If you would like for us to further investigate this, please email the file to communitysupport(at)constantcontact(dot)com with the file, your username, and a reference to this post. Thank you!

--

Caitlin M.
Community Manager
user80437
Rookie
0 Votes

Thank you for your response, I appreciate the quick reply.  All the fields were formatted the same, but when I clicked into the details for more information, I saw a message that said one of the contacts was not uploaded because they had previously unsubscribed.  When I downloaded that file, I saw that both of the missing contacts were listed, so apparently they had both unsubscribed previously.

  • Avatar

    Featured Article

    The Power of Direct Subscriber Feedback: Measuring Customer Satisfaction

    Today, understanding customer satisfaction is crucial. How can you know if customers are happy with your products or services?

    See Article
  • Avatar

    Featured Thread

    The Unintentional Humor of Spam Emails

    Have you ever wondered who or what is on the other side of a spam email? Take 10 minutes out of your day and watch this lighthearted video!

    View thread
  • Avatar

    Featured Thread

    How to Create Images of Multi-Page PDFs

    Discover the process of transforming PDFs with multiple pages into image files directly on Constant Contact.

    See Article
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
FEB 27
From Blank Page to Engaged: Marketing When You’re Not Sure What to Send
2PM - 3PM EST