Get Facebook Insights data to Google Sheets

Easily automate and extract Facebook Insights data to Google Sheets, simplifying data processing, visualization, integration with other sources, and collaboration with your team.

Why connect Facebook Insights to Google Sheets

Understand your audience with demographic data

Understand your audience with demographic data

Facebook Page Insights provides a wealth of demographic data about your audience, including age, gender, location, and language. This information can help you tailor your content to better suit your audience's preferences and behaviors, leading to increased engagement and reach.

Track post performance and engagement

Track post performance and engagement

With Facebook Page Insights, you can monitor the performance of your posts in real time. This includes data on reach, engagement, likes, shares, and comments. By analyzing this data, you can identify which types of content resonate most with your audience and adjust your content strategy accordingly.

Evaluate your page's overall performance

Evaluate your page's overall performance

Facebook Page Insights also provides an overview of your page's overall performance, including total likes, page views, post reach, and engagement. This data can help you understand how your page is performing over time and identify any trends or patterns. This can be particularly useful for tracking the effectiveness of specific campaigns or initiatives.

Facebook Insights to Google Sheets : what to export

Export all important Facebook Insights Metrics and Dimensions for analysis in Google Sheets

Page insights

Page insights

Discover how many people like your page, have seen your content, and have engaged with your posts using Facebook Page Insights. Keep track of the number of new page fans added and measure the organic reach of your content to improve your operations. Analyze the number of impressions and post engagements, including likes, comments and shares, and paid reach. Also, track the total number of "like" and "love" reactions on a post to gain insight into your audience's preferences.

Post lifetime insights

Post lifetime insights

Analyze post performance with Facebook Page Insights' metrics. Use Post Lifetime Insights to gauge Post Reach- how many people have seen your content, and Post Impressions- total times your content was displayed. See reactions to your content with "like," "love," "wow," "haha," "sorry," and "anger" to adjust content accordingly. Use Post Organic Reach to monitor unpaid content appeal.

Time

Time

Track engagement and performance over time using Facebook Page Insights' time-based reporting. Monitor visitor activity by month, week, and year to optimize your content schedule and pinpoint high-traffic periods. Use data to create actionable analytics and make informed decisions about social media operations.

Page

Page

Track your Facebook page popularity by monitoring the number of likes and followers with Page Insights. Use Page Name to ensure branding consistency, and Page ID to easily reference in your metrics. Gain insights to adjust your strategy and optimize engagement.

Post

Post

Analyze post engagement, determine best days to post, and track post performance using Facebook Page Insights' post-related data. Improve your social media strategy by studying your post message, URL, ID, image, status type, and story. Keep track of when your post was created and updated, and identify sharing patterns to increase reach.

Video

Video

Analyze your Facebook page's video performance using metrics such as video post publish status, video created datetime, video source URL, and more. Gain insights into your audience's engagement and refine your video strategy to improve your operations. Use video titles and descriptions to optimize your posts and track performance over time.

Video lifetime insights

Video lifetime insights

Analyze your Facebook video performance with insights like lifetime views, organic views, and unique views. Also, determine the total video length to identify audience engagement patterns. Use these insights to create reports and improve your operations by producing better content that resonates with your audience.

Page lifetime insights

Page lifetime insights

Discover how many people have liked, followed and rated your Page with the lifetime insights feature on Facebook. Use this data to monitor the growth of your Page and track engagement rates. As a result, your reports can offer valuable insights for improving your operations and optimizing your Page for better engagement.

Post comment

Post comment

Analyze the engagement levels of your Facebook page by checking the number of comments, comments per post, and comment reaction rate. Use this to improve content and engagement strategies. Track comment histories and sentiment to assess the effectiveness of replies and gauge public perception of your brand.

How to export Facebook Insights to Google Sheets & automate it

Google SheetsGoogle Sheets
Step 1

Install Two Minute Reports (TMR) for Google Sheets

Open Google Sheets and install Two Minute Reports from the add-ons menu. No credit card required.

Step 2

Connect your Facebook Insights with Two Minute Reports

Open TMR add-on and select Data Source from the menu button. Click Add and add your new Facebook Insights data source

Step 3

Select the Facebook Insights data you need

Open the Queries menu and create a new query. Select the Facebook Insights data source you added along with the Facebook Insights metrics and dimensions you want.

Step 4

Automate Schedules to Facebook Insights export to Google Sheets

Create a new schedule to automatically fetch live data from Facebook Insights at periodic intervals. You can even send emails, PDFs or Excel sheets on schedule.

Step 5

Skip steps and jump start Facebook Insights with Templates

Instead of creating a report from scratch use our premade Facebook Insights templates below and get started in no time

Start using these quick templates Now

Facebook Insights - Post Insights and Analysis
Looker Studio
Facebook Page Insights Monthly Performace Overview Report
Looker Studio

Automate Facebook Insights to Google Sheets export & do more with Two Minute Reports

Two Minute Reports for Google Sheets has these features for you

Ease of Use

Ease of Use

Two Minute Reports is designed to be user-friendly and easy to navigate. With its intuitive interface, you can quickly generate reports and track your marketing campaigns without the need for extensive training or technical knowledge.

Battle tested by Millions of Users

Battle tested by Millions of Users

By working with BI platforms developed with Billions of Investment by Google - like Google Sheets and Looker Studio, Two Minute Reports provides robust capabilities and a secure infrastructure for your Reporting

Data Integration and more

Data Integration and more

Two Minute Reports integrates with Facebook Insights and over 30+ Marketing platforms so that you can analyse and visualize your data in the BI platform of your choice.

Why use Two Minute Reports to import Facebook Insights data to Google Sheets

Marketers know how critical it is for a business to correctly measure the performance of ad campaigns. Using standard Facebook Insights tools, the in-line performance analytics are pretty straightforward. But things can change if you need to analyse custom metrics over an extended period. Generic Facebook Insights dashboard tools are simply not intended for more detailed analysis that includes customizing filters and analysing the performance of multiple campaigns from multiple accounts. That is where Two Minute Reports steps in. Its Facebook Insights to Google Sheets integration allows you to automate the process of extracting data from Ads on a custom schedule. You can merge data on multiple campaigns and ads in a single sheet, applying all the powerful tools Google provides. These include pivot tables, graph visualization, formulas, and team sharing capabilities.

Facebook Insights

Facebook Insights

88arrow
Google Sheets

Google Sheets

88arrow
fads

Manage, Share, Analyze

Do more with Google Sheets + Facebook Insights

With Two Minute Reports, you can get Facebook Insights data in Google Sheets and also merge it with other Advertising data from platforms like Facebook Insights, Instagram Insights, LinkedIn Pages, YouTube Analytics. Not just that, you can also get data from different types of Mobile, Database, Advertising (PPC), Web Analytics, SEO, E-Commerce, Other sources, Social Media, Email, Customer relationship management Data Sources.

fins

Facebook Insights

ins

Instagram Insights

lps

LinkedIn Pages

ya

YouTube Analytics

Get Facebook Insights data in other tools too

We also help get your Google Sheets to the following Tools

Looker Studio

Looker Studio

Two Minute Reports for Google Sheets helps you to get your Facebook Insights data to Google Sheets. You can not just analyse data you do much more there. By running on top of Google Sheets, we support a range of customization options, including the ability to create custom formulas and functions, unlimited formatting and sharing capabilities, Google Sheets has a friendly interface that many of us are familiar with. Spreadsheets are easier to handle when you are looking at a lot of Data and you dont have to learn a new tool.

Connect other Ad Platform Data Sources with Google Sheets

You can combine data from other Ad data sources with your Facebook Insights Reports

Image
Facebook Insights

Facebook Insights

Data analytics tool for Facebook business pages.

Instagram Insights

Instagram Insights

Social media analytics tool for Instagram business accounts.

LinkedIn Pages

LinkedIn Pages

Business networking platform for brand visibility and connections.

YouTube Analytics

YouTube Analytics

In-depth tool for analyzing comprehensive YouTube video performance metrics and trends.

Connect other Marketing Channels with Google Sheets

You can combine Facebook Insights data with not just Ad Platforms but also with other Platforms too

Mobile

Mobile

The category includes Data Sources like the Apple App Store and Google Playstore. That have information on apps that are provided to the data sources.

Database

Database

The category includes SQL based data sources connectors such as Cloud Firestore, MariaDB, MySQL, Postgre SQL.

Advertising (PPC)

Advertising (PPC)

This falls in the advertising category, more evidently Pay Per Click Connectors, for Facebook Ads, Google Ads, Snapchat Ads, LinkedIn Ads, TikTok Ads and Miicrosoft Ads

Web Analytics

Web Analytics

Data Sources like Google analytics, that analyzes the behaviour of visitors to a web site, falls in this category.