This looks great! Sounds like you track events like opens, clicks SES features..
does that mean you need a specific table in my database?
What data about my users would be stored in your database, vs my database?
What data about my users would be stored in your database, vs my database?
As for the data question, when you create a campaign, the following gets stored for each email that will get sent:
- email address - JSON blob of the required variables that exist in the subject and body of the email (ex: {first_name: "John"}
That's pretty much all the data that will be stored in our database which is sourced from your database. This data is stored for 30 days then removed, but I'd like to make this be configurable.