My company currently emails users in batches of hundreds, and we’ve now grown to the point where we’re concerned about contacting the same people too frequently. Any thoughts on how I could use Airtable to address this issue? Thanks so much!
Hmm, you could possibly have two tables, one for Emails Sent and one for Email Addresses
In the 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!
We do this for research participants, and track the last time an email was sent to a user, as well as the last study a user participated in, which I convert into “days since” fields to make it easier to look at.