Report Daily New Followers in Facebook and 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 Enterprise plans or it is available for $49.95 USD in our other plans.
Configure your query
In Twitter, 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.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
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 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 Lifetime Reach Has Lower Number Than Daily Total Reach
Facebook Insights reports of Lifetime Reach can show a value that is lower than daily Total Reach. This article will help you identify and troubleshoot the issue. This article will address the following issue: In your Facebook Insights reports, the ...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 ...Instagram Insights Data Connector User Guide
Instagram Insights provides valuable data about your Instagram business or creator account's performance, audience, and content. This guide will walk you through connecting Instagram Insights to Power My Analytics and creating reports with the data. ...