First of all, I'd like to thank all in the community who helps in advance!
I have chosen Base Design for this post's location, though formulae etc will also be appreciated.
I'm running a SMMA and am still new to Airtable despite making good progress over the last week and need guidance setting up a base in Airtable to gather metrics via scraping.
This base has three main tables, Post View, (Social Media) Account View, and a client View.
In Post View, info about each individual post our clients make such as # of views, # of shares etc as well as the time and date of posting is collected. In the Account View, data pertaining to view, shares, data the view, share, like and comment count data for both (Today) and (Yesterday) are displayed. The third table is further aggregation to give a better top-down view.
I have two main questions.
In the second table and third tables how can I ensure that the data for 'Views Today' becomes the data in 'Views Yesterday'?
Also, specifically for the last table, I have many fields, but I will only mention a set of them as the same principle can easily be applied to the others. These are Views Today, Views Yesterday, Views Last 7 Days, Views Last 14 Days and son on for a year. If I have the data for 'Views Today' and 'Views Yesterday', how can I ensure that the 'Views Last 7 Days' accounts for the data collected over the last 7 days if I do not have fields specified to keep count of the data collected on days 3, 4, 5 and 6 days?
I have attached some screenshots below, and I thank you again for your help.
Thanks!
The issue I have
