Greetings,
I just sent an email campaign. Noticed that there are 80 customers on my list with invalid email addresses that bounce. How can I delete those addresses from my customer list, WITHOUT deleting the actual customer record? I don’t want to do them one at a time, for obvious reasons. So I’m hoping that there is some automated way to accomplish this and clean up my customer list.
Thanks,
Chip
@Joe Thanks for the reply. Please do flag this to the Product Teams. If they look, they will see that quite a few of the bounced addresses “Square Network Email” addresses — ie - We sellers can’t see the actual address and can’t change it other than deleting the complete customer record.
Can you tell me if Square Marketing considers these “reachable” addresses — in other words do they count against my customer limit for the various Marketing tiers? If so, I really (really!) think that this needs to have a fix.
For now, I guess I’ll just manually delete those 80 customer records.
Chip
@jtrietsch10 Unless there is some new, unannounced feature my original issue is still unresolved. My experience with Square is that if a post gets minimal or no attention from them, they seem to be uninterested in resolving it. Also, if they say it is “not on the roadmap” or that “it works as designed,” you can be pretty sure that is the last word on the issue as far as they are concerned. That’s not a complaint, just an observation that is reinforced over a long time, and I’m a firm believer in living in reality and not my ideal fantasy world. I have two or three other such issues that have been pretty much ignored. In all cases, after about a month I take the hint (silence = go away) and do one of two things — figure out how to work around the issue, or remove that particular functionality from my account and find a third party who does it better. Much less drama and angst!
At this point, the only thing I can tell you is that if you have a bunch of invalid email addresses on your list that are bouncing consistently, print that list and delete them manually one-by-one. It’s clunky, unnecessary and frustrating. But it gets the job done.
Best,
Chip
Hi @ag818. Lots of reasons. The customer changes or deletes the email address we have on file. Their inbox is full. Their email server is returning any number of other errors. In any case, they are unreachable via email tag that address.
Hi @flounderbrewing. There is a formal feature request into Square to give us this capability. Here is a link to it. Please go there and like/upvote it. On, and everyone else in this thread please do the same.
However, in another thread I did propose a short-term workaround that will do what you want for now, while we wait for Square to add the capability. It’s a little manual work, but not nearly as much manual work as unsubscribing a lot of customers manually. I’m copy/pasting it here.
When you view a campaign report, you can export a list of all subscribers to a CSV. That list shows statistics like last opened, number of times opened, and even a column for “bounced.”
You could export two things:
- The marketing campaign CSV report I mentioned above
- Your current customer list CSV
You could then use a spreadsheet to clear the Customer CSV “email address” field for every email address marked “Yes” in the bounced column of the Marketing Campaign CSV, as well as change the field Email Subscription Status to “Unsubscribed” for those. Then you’d need to re-upload ONLY those customers whose email address was blanked out — not the whole customer list. Here’s a link to a help article about importing customer data.
This will have the effect of removing customers with bounced email addresses so that you don’t pay for them in future campaigns. I know it’s not the perfect solution you are looking for, but it does work.
Let me know if you have any questions about how to implement that. You might need to enlist the assistance of someone who is good with spreadsheets.
Regards,
