I would like to integrate our Marketing reporting into Airtable. We are currently using Google Sheets.
But I can’t figure out how to make it work.
We are looking at different KPIs e.g. average order value, traffic, clicks, return on investment, revenue, spend etc. for different channels such as homepage, email, paid advertising etc. We are looking at MTD and last year’s numbers and calculate the change in %.
The problem is that in Airtable I can’t use different types for different columns. I would need to be able to use the $, % and formula type in the same row.
Your help is really appreciated.