Hmm, you could possibly have two tables, one for
Emails Sent and one for
Emails Sent table, you’d have the date an email was sent as well as all the email addresses it was sent to
You could then link the two tables together, and you’d then, through rollups, counts etc, be able to see in the
Email Addresses table how many times you’ve emailed them, when the last time you emailed them was, how many emails you’ve sent them in the last month etc
You can also hire me to just set it up for you too!
Couple of quick things here:
1: when we use a field to trigger an automation - we make that a date field so changing it to today’s date triggers the automation and also gives us an easy visual check of when it was sent.
2: having a ‘last contact field’ which is updated by an automation or zimilar (e.g. zapier if using different software for mailing)…
3: we set up automated mailings based on rules which include date fields to ensure regular but not too regular mailing