I would like to set up a database which sends emails as a marketing platform for our clients. The emails would be identical for each client, with the exception that the header, signature, and return email address would be unique to each client. I would like to be able to create the content for the email one time and schedule the email(s) to be sent. I expect each client to have on average 2500 emails.
Each client will have an email list which will need to be updated on a regular basis - could be weekly or monthly.
Emails could be segmented by a field within the list - but in general emails would be sent out to the entire list regularly (say weekly or bi-weekly).
The client would be able to log in and see their list and make updates - ie. correct invalid emails, manually unsubscribe emails.
Clients may also either send an updated email list (may include new and old emails) in bulk to update their list.
I would like to have data analysis on any of the progress of the emails - opens, unsubscribes, etc.
I am familiar with sending emails using SMTP on a one-at-a-time basis, but it is possible that I would have to send 25,000 or 100,000 emails in a single day should my client list grow.
I would like to automate this process as much as possible, and have questions regarding database design and implementation.
1. Should I be using a mail service such as SendInBlue or Mailchimp, or maintain the list myself sending out emails with SMTP?
2. Does anybody have experience with different email services? Good ones, ones to avoid?
3. If a service is recommended, would you recommend maintaining a separate account for each client? Would you recommend using a Xojo database (I mean a SQL database that I maintain) to store emails and update the service list (is this possible, can it be automated)?
4. If I maintain the entire database of emails myself, how is it recommended to send out such large volume? I know that if you push out too many at one time you can be blocked.
Just looking for advice in initial setup and design. Thanks.