We have an ecommerce application which sends out transactional emails to customers for events like order placed, order shipped, order delivered etc. We used to send one bcc of every email to a gmail address to keep record. But due to large volume of emails, we are facing two problems:
- We need to buy storage from gmail and
- Recently we had an offer sales, which caused huge surge in orders as well as emails. Due to which gmail blocked receiving on that email id, which resulted in bounces.
My question is - What could be best way of keeping logs of transactional emails? Logs are needed sometimes to look back what communication was sent to customer, at what time, its delivery status.
I am thinking of having a table in database, which would store the following:
ToAddress Subject Body AttachmentFilePath SentAt DeliveryStatus
We daily send around 100K emails, I am thinking to clean records which are 3 months old.
- Is this a right approach? Or there is some other more optimal way of storing emails?
- Do big companies also keep logs of emails or not required?