Open navigation

Instagram Insights and Instagram Public Data: Query setup guide

Once you’ve authenticated your connection to Instagram Insights OR Instagram Public Data, you’re ready to create your first query. 


This guide will walk you through Instagram Insights and Instagram Public Data query setup for Google Sheets, Data Studio, and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.

Before you begin

Instagram Insights

To connect Supermetrics to Instagram Insights, you need: 

  • An Instagram business account (sometimes called a professional account). Personal or creator accounts can't be used with Supermetrics. Visit Instagram’s help center to learn how to change your account type.
  • The Instagram account must be linked to an active Facebook Page.
  • The linked Facebook Page may need to be "claimed" before it can be properly connected
  • The Instagram account needs to use Facebook user authentication rather than Instagram user authentication.

The Facebook user account you use to log into Supermetrics must have sufficient access to the linked Facebook Page. Sufficient access means a valid Facebook user account with permissions sets View Page performance and Create ads. Admin access will also work.


If you’re using the new Pages experience, you must have full control access to the Facebook Page linked to the Instagram account.


Instagram Public Data

To connect Supermetrics to Instagram Public Data, you need:

Here's an example of sufficient user permissions:



Available fields

Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source. The complete list of data sources can be found on the left side of the page. 

  • Field label is the name that appears in the sidebar. 
  • Metrics can be found under type - “met”.
  • Dimensions can be found under type - “dim” .

Instructions

Google Sheets Data Studio Excel Data Integrations
  1. Authenticate the data source in Google Sheets
  2. Select Dates.  Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
  3. Select Metrics
  4. Select Split by Dimensions.

    You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.

  5. Click Get Data to Table to create your query and pull your data.


Advanced options for Google Sheets

  1. You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
  2. Under Options, you can add additional features to your query.
  • Replace blank metric values with zeros.
  • Combine new results with old.
  • Format results for Data Studio (to import data from Google Sheets to Data Studio).
  • No header row.
  • Highlight values with colours (green, red, etc.).
  • Advanced settings.


More resources

IGTV posts

With Instagram Insights you can fetch IGTV posts data with these media objects:

  • IGTV video title
  • Media product type


Instagram Public Data: Limitations

Hashtags
  • Querying with the same hashtag multiple times within the period only counts as 1 hashtag.
  • The hashtag limitation is tied to an Instagram profile. This means that if you fetch posts with #marketing using the Supermetrics profile, for example, that would count as 1 used hashtag for all the users who have access to the Supermetrics profile.
  • The Number of hashtags metric — and the Hashtags and Matching hashtag dimensions — only work with hashtags posted in captions. They omit hashtags added in comments.
Posts
  • Post search returns only posts that are public and do not contain identifiable information.
  • Stories, Reels, IGTV, and promoted/boosted media are not returned.
  • Post search doesn’t support emoji hashtags.
  • Recent search returns only posts published within the last 24 hours (API limitation), and results are capped at the 250 most recent posts. 
  • Top search returns 100 top posts. Top posts are defined by Instagram (and not necessarily based on likes/comments) and can vary per query. Please see hashtag Top search in IG as a reference. 
  • Username or other information from the posting account can’t be returned.
Searches
  • One Instagram profile can search max 30 hashtags within a rolling 7-day period. Having access to multiple profiles will increase the quota amount. 
  • If you have access to multiple profiles, Supermetrics divides the searches evenly among these profiles. This means that if you have access to 2 profiles, you can search for 60 different hashtags during a 7-day period.
  • Reaching the quota limit will cause an error.

Troubleshooting


Did you find it helpful? Yes No

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