Report Daily New Followers in Facebook Insights and X Analytics (Twitter)
Reporting daily new followers in these social media platforms is important for understanding the success of the account, but the APIs do not provide this information. Luckily, it is possible to calculate using our Google Sheets add-on. Follow the instructions in this article to learn how.
Begin in Google Sheets
If you do not have our Google Sheets add-on installed, follow these directions.
The Google Sheets add-on is included in our Pro and Custom (formerly Enterprise) plans.
Configure your query
In your X Analytics report, choose Followers Count for your metric and Month Day for your dimension.
In Facebook Insights, choose Total Page Followers (Lifetime) for your metric and Date for your dimension.
Calculate New Followers
Create a new column labeled New Followers. Enter this formula next to the most recent date and follower count. Substitute the row and column references for your own. Then apply the formula to the entire column:
=arrayformula(if(len(A2:A),iferror(B2:B-offset(B2:B,-1,0),""),""))
Connect Google Sheets to Data Studio
Find our Google Sheets connector in your Hub.
Select the spreadsheet that you created along with the appropriate page and click Connect.
You will now be able to create tables with your new metric or blend with a report you already have using Date as a join key.