Social Media: Follower Total for yesterday
I am trying to create a formula that Account Engagement Rate. As a part of the calculation I need to work out what the most recent follower count is for the account. This would naturally be for the previous day as this will be the latest update.
Does anyone know how to achieve this? Is it something like: Date (To-day - 1 (Follower growth))?
The wider formula is: ((SUM(`Likes`) + SUM(`Comments`) + SUM(`Saves`))/ COUNT(DISTINCT `Media Type`)) / Date (To-day - 1 (Follower growth))