Rolling up email campaign data (to calculate sent, open, reply rates)

Topic Labels: Base design
444 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I'm slowly learning some basics, and struggling to understand how I would use Rollups to get "total" metrics. 

I have a "contacts" base, and a "metrics" base. I'd like to pull from contacts, roll up the total "sent," "opened," and "replied" emails and then I can calculate my % off of those in another column.

Screenshot 2023-11-26 at 9.35.21 PM.pngScreenshot 2023-11-26 at 9.35.14 PM.png

2 Replies 2
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi, unlikely airtable doesn't have the function to calculate formula over the column, it works on row.

I have a suggestion for you, create a table with all emails (email as primary field), so you can roll up the emails on the table of "contacts" and count how many emails each contact got. Unlikely to have the "final table" for the metrics, you have to add it on excel and do the calculation there.





8 - Airtable Astronomer
8 - Airtable Astronomer

Okay, I found a way to calculate in airtable, 



you have to add a column with the status (multiple selection so an email that got a reply will have 3 status "sent" , "opened" and "replied". 



for sent email: 


and the calculation: 




and you have to do the same for each status .


I hope it helps 🙂 let me know if you have any other questions