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 Agency 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 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.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Facebook Insights Data Connector User Guide
The following article is a guide to automating reports with your Facebook Insights connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Facebook Insights reports. To ...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 ...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 ...Twitter Analytics Data Connector User Guide
The following article is a guide to automating reports with your Twitter Analytics connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Twitter Analytics reports. To ...Missing Demographic Data in Facebook Insights
This article will help you troubleshoot missing Facebook Insights demographic data in your PMA reports. Cause Facebook Insights has API limitations regarding demographic data. If there are fewer than 100 views, or the most recent 3 days are included, ...