Report Daily New Followers in Facebook and Twitter

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.




    • 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

      <div><span style="background-color: rgb(193, 225, 244); border-right: 5px solid rgb(167, 212, 234); margin: 10px 0px; position: relative; display: inline-block; padding: 10px 10px 10px 40px" ...

    • 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 ...

    • Troubleshooting Facebook Insights

      Meta's Facebook Insights API is complex and often difficult to work with due to continuous changes and little documentation or support. Here you will find the most up-to-date information we have to troubleshoot issues that arise while making Facebook ...