I use Amazon SES as an email provider for many clients for different softwares.
While each software has their own version of email stats dash board, I am keen to create a generic dashboard that pulls data from SES/SNS.
I am looking for basic data like delivered date and time, open date, number of opens, link clicks, bounces, type of bounce, unsubscribe etc. This data is shown in Amazon but grouped and I can see this data per email address / email / campaign.
Google searches reveal no simple solution.
I am sure I could use n8n to achieve this. Even if as simple as populating a google sheet to start with.
Any n8n’ers had any luck pulling this kind of data from SES/SNS?