With TMR’s Facebook Insights Connector, you can effortlessly track Facebook Page Insights directly in your Google Sheets. Simply connect your client’s Facebook accounts to pull actionable metrics, monitor performance, and build custom reports without code. Before connecting your Facebook Insights data with Google Sheets, ensure you have the following permissions:
Required permissions
To connect Two Minute Reports to Facebook Insights, you need Administrator access to the Pages you want to pull data from. If you’re connected with Business Manager, you’ll need at least Page editor access to those pages.
Learn more about adding permissions to a Page and adding users to a Page in Business Manager.
Your account needs Partial access to the linked page if you’re using the new Pages experience.
Once you confirm these prerequisites, follow the steps below to connect your Facebook Page Insights to Google Sheets via TMR.
Step 1: Install and launch Two Minute Reports
Begin by installing TMR in Google Sheets using this step-by-step tutorial: How to install TMR in Google Sheets?
Once done, you can connect your Facebook Insights account to extract page performance data into Google Sheets.
Step 2: Create a new Connection to your Facebook Insights account
Click Menu at the top left of the sidebar to navigate to the Connections section. Next, click Add to create a new Connection.
When the “Adding New Connection” dialog box appears, complete the following three key steps to access your Facebook Insights accounts:
- Selecting the Facebook Insights Connector
- Authenticate your account
- Enable the respective accounts with the Facebook Insights Connector
Choose Facebook Insights from the list of options, and authorize your Connection by entering your login credentials.
After successful authentication, you will see a screen showing your Account name, ID, Connection name, Status, and SpeedBoost, as shown below:
Enable the accounts for which you want to run queries. Once enabled, Speedboost is automatically activated, allowing you to retrieve Facebook Insights data within seconds. Please note that you cannot run queries from disabled accounts.
Once an account is enabled, Speedboost performs two functions:
- Warm-up – Prepares your account for faster data retrieval by caching your historical data.
- Periodic sync – Ensures your data stays updated automatically at regular intervals.
| To ensure the connected accounts are reflected in the TMR sidebar, click “Refresh Connections.” |
Now, you can extract Facebook Insights KPIs into Google Sheets for actionable content performance insights.
Step 3: Fetching Facebook Insights data to Google Sheets
- You must create a new query by navigating to the Data Queries section to extract specific Facebook Insights data.
- Click Add and choose the Facebook Insights accounts you wish to analyze.
- You can manage multiple clients’ Facebook accounts under one interface. Simply select one or more accounts to obtain actionable performance insights.
- Alternatively, you can navigate to the Clients section to add your clients and map their corresponding Facebook Insights account.
- Click on “Manage Clients” and map the necessary account details, then click “Save & Close” to save your client’s details for future reference.
- Next, add Facebook Insights metrics and dimensions you want to analyze and select the date range to track your client’s page performance.
- Configure your data reporting by selecting relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the information that matters.
Once you finish these steps, click Run Query to visualize the output.
Now, you can use different Google Sheet features, such as pivot tables and VLOOKUP(), to extract critical insights and build charts to visualize your Facebook Insights data.
| Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action. |
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient’s email ID and save the new schedule.
You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’ Schedule Refresh feature has further capabilities. Continue reading about this feature: “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. If you have any questions, please contact our support team at support@twominutereports.com.