Open navigation

Facebook Public Data connection guide

Use this guide to connect Facebook Public Data to Supermetrics. Any type of account can connect to this data source — you don't need specific permissions or user roles.


If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our prerequisite and filling guides.


Query types

Facebook Public Data has three query types. Each gathers:

  • Facebook Page data: Page data, including Likes, About, and the website link.
  • Facebook posts by a Page: Information on posts made to the Page, such as Post link, Reaction counts, and Comment counts.
  • Facebook shares for URLs: Data about specific shared URLs, like URL, Share count, and Comment count.


Instructions

For Excel users

If your team uses Supermetrics for Excel, you'll see different options for managing and sharing data source connections in that destination. Learn more.


Google Sheets Data StudioExcel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Click Create query.
  4. Under Data source, select Facebook Public Data.
  5. Navigate to Report configuration.
  6. Select a query type.
  7. Add your Page aliases or IDs under Facebook Page aliases/IDs. The alias is the name that follows the www.facebook.com/ address. For example, for www.facebook.com/Supermetrics, the alias is 'Supermetrics'.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.