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 Looker 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.
Related Articles
X Analytics (Twitter) Data Connector User Guide
X Analytics (formerly Twitter Analytics) is a powerful data source that provides valuable insights into your X account's performance, audience engagement, and tweet activity. This guide will walk you through the process of setting up X Analytics as a ...Facebook Insights Data Connector User Guide
Facebook Insights provides valuable data about your Facebook Page's performance, audience, and content engagement. This guide will help you set up and use Facebook Insights as a data source in Power My Analytics. Prerequisites Before connecting ...X Ads (Twitter) Data Connector User Guide
X Ads (formerly Twitter Ads) is a powerful advertising platform that allows marketers to reach their target audience on one of the world's most popular social media networks. This guide will walk you through the process of connecting your X Ads ...Facebook Insights November 2025 Deprecated Fields
Facebook Insights November 2025 Deprecated Fields Meta has deprecated several Facebook Insights metrics as of November 15, 2025. This can affect your report data in PMA reports that use these metrics. On November 15, 2025, Meta deprecated several ...Missing Pages in Facebook Insights
Sometimes, Facebook changes app permissions and they need to be refreshed. This can cause frustration when you're trying to connect to Facebook Insights and you see missing pages. This page will help you get back on track. This page will assist you ...