Getting Started with Instagram Insights - Data Warehouse, Cloud Storage, BigQuery & API

This guide covers the basic functionality of the Supermetrics Instagram Insights connector, and gives examples of how to set up a data transfer with Data Warehouse, Cloud Storage & BigQuery, and how to set up a query with API.  


Quick links to specific sections: 

Data Warehouse & Cloud Storage 

API 

BigQuery


Data Source Access Requirements:

Before authenticating the connector, please make sure you have gone through the rights and permissions required for this data source. To learn more, please refer to these guides:


Access requirements for user account:

  • The Instagram account must be an Instagram Business Account (may also be called a "Professional account"). It does not work with Personal or Creator accounts. (Instructions for how to change your account type)
    • The Instagram account must be linked to an active Facebook Page. (Instructions for how to do this). 
    • The linked Facebook Page may need to be "claimed" before it can be properly connected - see here for how to do this.
  • The Instagram account must use Facebook user authentication. It does not work with Instagram user authentication.
  • The Facebook user account you will be logging into the Supermetrics connector with must have sufficient access to the linked Facebook page. Sufficient access means in this case a valid Facebook user account with permissions sets "View Page performance" and "Create ads". Admin access ( "Admin Access - Manage Page"), while not required, will also work.
  • If connected to New Page Experience, you must have full control access to the Facebook page linked to the Instagram account.


Documentation:

The complete list of available fields (metrics and dimensions) for Instagram Insights, can be found here.


Data Warehouse & Cloud Storage products - Data transfer setup example

This guide assumes that you have already installed a data destination for Snowflake Data Warehouse, or Azure Storage Container, or Amazon S3 Bucket, or Google Cloud Storage Bucket. If you haven't created a data destination, see: How to configure a data destination


How to configure a data transfer

1. Go to team.supermetrics.com and under INTEGRATIONS → Transfers click on the Create new button.



2. Select Instagram Insights and click on OK.



3. Click on the pen icon and choose a display name (can be anything), that will be used to distinguish the transfer you are creating from others.



4. The destination that has been created before the transfer setup (see How to configure a data destination). License: Your Supermetrics connector license, see License management.

5. Schedule your transfer. 

  • Frequency: How often the transfer will be repeated. If you select the Daily option, new data will be added once a day.
  • Time: The time when the transfer will be repeated.
  • Refresh window: A refresh window setting of 1 means that it's going to pull the calendar day it’s running on, which is typically less than 24 hours. To get a full day’s data updated each day, use the default value or minimum of 2. On the other hand, a higher value means the transfer will run more times each day, so it proportionally increases the total load time.


6To authenticate Instagram Insights click on + add user, under sources. 


7. Click on start to proceed.



8. If you are logging in for the first time, insert your credentials (username & password) and click on log in.


9. Click on continue as X if you wish to login with that specific user account. If you want to access by using another user account, click on log into another account.


10. Select the account/s and click on next.



11. Select the page/s and click on next.


12. Click on done. If you wish to learn more about data security and data privacy, please see this page.


13. Click OK to confirm.


14.  You have completed all the authentication steps. You should receive a confirmation to close the browser page. 



15. Hand-pick the account(s) you wish to proceed with, and click on SAVE. If you wish to select all accounts click on "select all". The right-hand side lists the account objects that have been selected to be used in the data transfer.



Adding additional user accounts:


1. Click on "add another user" to add additional user accounts.


Re-authenticating with Data WareHouse and Cloud Storage Products:


To re-authenticate the data source with any Data Warehouse and Cloud Storage product, please refer to this guide


API - Query setup example

1. Go to the Team Management site at team.supermetrics.com and log in with your Google or Microsoft account.

2. In the top navigation, go to INTEGRATIONS → Query Manager. 


3. Select Instagram Insights in the sidebar.



4. Click on start to proceed.



5. If you are logging in for the first time, insert your credentials (username & password) and click on log in.


6. Click on continue as X if you wish to login with that specific user account. If you want to access by using another user account, click on log into another account.


7. Select the account/s and click on next.



8. Select the page/s and click on next.


9. Click on done. If you wish to learn more about data security and data privacy, please see this page.


10. Click OK to confirm.


11.  You have completed all the authentication steps. You should receive a confirmation to close the browser page. 



12. You have completed all the authentication steps. You can now go back to the sidebar, click on query, and select your Instagram Insights account(s) under select account.



13. Select dates. Choose one date range (today, yesterday, last week, etc). To select a custom date, you can either insert the date manually on start and end or select it from the calendar bar.




14. Select metrics. To see all metrics that can be fetched with Instagram Insights, please see Instagram Insights documentation. To deselect a metric click on the X next to the metric's name.



15. Split by dimensions. You can choose dimensions in rows and/or columns. To see all dimensions that can be fetched with Instagram Insights, please see Instagram Insights documentation.


The query example above is with JSON. 

For instructions on using the URL to get your data to specific destinations, see:

Connecting to Power BI with Supermetrics API

Connecting to Tableau with Supermetrics API

Connecting to Qlik Sense with Supermetrics API


Re-authenticating with API: 

To re-authenticate the data source with API, please follow all the steps from this guide.


BigQuery - Data transfer setup example


This guide assumes that you have already enrolled for Supermetrics Facebook Ads in the Google Cloud Platform Marketplace. If you haven't, see First Steps: Getting Supermetrics into your BigQuery project

1. Go to BigQuery at https://console.cloud.google.com/bigquery and click on Data transfers.


2. Click on + CREATE TRANSFER.



3. Under the source drop-down, select Instagram Insights by Supermetrics



4. Add a Transfer config name (can be anything) for the transfer. 



5. Set up your scheduling options for when the transfer will run.

  • Select Start now to have the initial transfer start immediately after the configuration is saved.
  • Set Repeats to Daily to have new data added once a day.
  • The Start date and run time is locked with Start now selected.

6. Set the Destination settings.

  • If you have an existing dataset you want to use for the transfer, simply select it from the dropdown. For instructions on creating a new dataset, see Creating a BigQuery dataset for your data transfer.
  • The default refresh window varies per data source. You can also set the number of days you want to include in each daily data transfer manually.


8. A pop-up will appear asking you to enable a third party connection. To accept and proceed, click on ACCEPT AGREEMENT.

9. Sign in with your Google account that has access to your BigQuery project.

10. Click on start to proceed.



11. If you are logging in for the first time, insert your credentials (username & password) and click on log in.



12. Click on continue as X if you wish to login with that specific user account. If you want to access by using another user account, click on log into another account.


13. Select the account/s and click on next.



14. Select the page/s and click on next.


15. Click on done. If you wish to learn more about data security and data privacy, please see this page.


16. Click OK to confirm.


17.  You have completed all the authentication steps. You should receive a confirmation to close the browser page. 



18. Select the account(s) you wish to have as part of the data transfer – you can select more than one account. If you wish to select all accounts, click on "select all" and click on submit.



19. Click on SAVE to save the transfer. This will also start the initial data transfer.


Re-authenticating with BigQuery:

To re-authenticate the data source with BigQuery, please follow all the steps from this guide.


Further assistance 

If you followed all the above steps and you still encounter an error, please create a new support request with the details of the issue and we will assist you.

Did you find it helpful? Yes No

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