How to set up the Looker Studio template for social media followers

1. Select the Facebook Insights data source by Supermetrics.
2. Connect to the data source.
3. In the setup view, don’t select reporting timezone or localization. If you have the reporting timezone or localization set up, data blending doesn’t work correctly. Start the setup process from the beginning without these selections.
   
4. Otherwise, there are no restrictions; the only mandatory field is the page selection. 

1. Select the Instagram Insights data source by Supermetrics.
2. Connect to the data source.

You can get followers and new followers data directly from the data source. However, note that the "New followers" metric only supports querying data for the last 30 days, excluding the current day. You can't use comparison either if the comparison time is longer than the last 30 days.

For Twitter data, set up the Twitter Public Data data source in Looker Studio and Twitter Premium data source on Google Sheets. 

You can get the Twitter total followers data directly to Looker Studio using the Twitter Public Data, but to get the date associated with the Twitter followers from the Twitter Premium data source, you need to do some calculations in Google Sheets. New followers calculations can't be done on Looker Studio directly. To get the new followers data, collect the data on Google Sheets and then bring that data to Looker Studio for visualization. 

Set up Twitter Public Data

1. Select the Twitter Public Data data source in Looker Studio.
2. Connect to the data source.
3. Select the "Twitter user data" query type. With this, you get the followers data, which is a lifetime metric.

Set up Twitter Premium

Follow these instructions to set up the new follower calculations on Google Sheets and bring this data to Looker Studio.

Set up the query

1. Go to Google Sheets and open the Supermetrics sidebar
2. Select the Twitter Premium data source.
3. Connect to the data source.
4. Select the account you want to fetch data for. 
5. In Report configuration, select the Common account information query type.
6. Select the Append new results to old option.
7. Data coming from the Twitter API does not have the date field. Enabling the Append new results to old option creates a “fetch date” and makes it possible to calculate the new users moving forward. Historical date breakdown, however, is not possible to get.
   
8. Select the Follower count metric and the Name dimension (account name). 
9. Run the query.
10. You should now see columns: Fetch date (today’s date), Name, and Follower count.
11. Give your Google Sheet and its tabs names that describe the content. You need to find the tab later.

Here is an example of query created on March 29, 2023.

Set daily refresh

To automatically refresh the query and add a new fetch date to the table, set up a scheduled refresh. 

1. Go to the Schedule tab.
2. Set the action to Refresh daily.
3. Click Save changes.

Create the new followers field

Once there is data accumulated, create a field called “New followers” using calculations between the current and previous date.

To do this with arrayformula (no need to copy paste the formula to another cell), create a helper column “Previous day followers”.

1. Create a helper column and name it Previous day followers.
2. Paste the arrayformula to the first cell of the column:
   =ARRAYFORMULA(
   IF(ROW(A:A)=1,"Previous day followers",
   IF(NOT(ISBLANK(A:A)),
   IFERROR(XLOOKUP((A:A-1),A:A,C:C),"N/A"),
   "")))
   In the example, the "Previous day followers" column is in column D:
   
3. Create a new column and name it New followers.
4. Paste the arrayformula to the first cell of the column:
   =ARRAYFORMULA(
   IF(ROW(A:A)=1,"New followers",
   IF(NOT(ISBLANK(A:A)),
   IFERROR((C:C)-(D:D),"N/A"),
   "")))
   In the example, the “New followers” column is in column E:
   

Use data in Looker Studio

Use the Google Sheets connector to bring the data from this spreadsheet in Looker Studio. 

1. Select the Google Sheets data source by Google.
   
2. Select the correct Google Sheets spreadsheet and the tab where your new table is created.
   

For the template, you need to set up two data sources from LinkedIn Company Pages data source by Supermetrics. Give the data sources unique names to identify them later.

Set up the Follower details query type

1. Select the LinkedIn Company Pages data source by Supermetrics.
2. Connect to the data source.
3. Select the "Follower details" query type. This query type gives you the total number of followers.
4. Name the data source LinkedIn Company pages - Follower details.

Set up the Historical follower statistics query type

1. Create a new data source with LinkedIn Company Pages data source by Supermetrics.
2. Select the "Historical follower statistics" query type. This query type gives you the number of new followers.
3. Name the data source LinkedIn Company pages - Historical follower statistics

1. Select the YouTube data source by Supermetrics.
2. Connect to the data source.

The YouTube data source has fields “Channel subscribers count” and “Subscribers gained”.