blog post

Connect Instagram to Looker Studio : How-to, templates and metrics

Johan Chemin
November 20, 2023
Connect Instagram to Looker Studio : How-to, templates and metrics

Quick steps to create a Instagram report with Google Sheets:

You can easiliy create a Instagram report following this step :

  1. Get informations from the data integration from our Instagram connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Instagram data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Instagram report with Looker Studio:

You can easiliy create a Instagram report following this step :

  1. Get informations from the data integration from our Instagram connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Instagram at the end of the page.

The tutorial

Quick steps to create a Instagram report with PowerBI:

You can easiliy create a Instagram report following this step :

  1. Get informations from the data integration from our Instagram connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Instagram at the end of the page.

The tutorial

As marketing data becomes more complex, the need for clear visualization is paramount. This tutorial is designed to assist marketing professionals in integrating their Instagram analytics with Looker Studio, formerly Google Data Studio. By the end of this guide, you'll be able to create dynamic reports that vividly illustrate your marketing data, enabling better business decisions.

How to Connect Your Instagram Account to Looker Studio

Create an Account on Looker Studio

Embarking on your Looker Studio journey begins with account creation. For existing Google users, this step is as simple as linking your Google account to Looker Studio.

Creating a Looker Studio account

Connect Instagram to Looker Studio

We will guide you through a detailed, step-by-step process to connect Instagram to Looker Studio. Feel free to alter the guide for clarity as needed.

  • Navigate to your Looker Studio dashboard and click on "Create."
Looker Studio dashboard create button
  • Next, choose "Report."
Selecting Report option
  • In the data sources gallery, locate the Catchr Instagram data connector.
Finding the Catchr Instagram data connector

Step-by-step guide on the authorization step

If this is your initial authorization for this connector, a two-part authorization process is necessary: one for Looker Studio and another for Catchr.

Authorizing Looker Studio:

  • Select Authorize to enable the Looker Studio community connector.
Authorizing Looker Studio
  • Pick your preferred Google Account for connection.
Choosing a Google Account
  • Review the authorization details for Looker Studio, then scroll to the bottom.
Authorization details for Looker Studio
  • Click on Allow access.
Allowing access to Looker Studio

Your Google Account is now authorized for Looker Studio use. Next is enabling the Instagram connector for data retrieval from Catchr.

  • Click on the Authorize button under 'Instagram requires authorization to connect your data to Looker Studio.'
Authorization button for Instagram
  • Follow the straightforward instructions within the popup to authorize Catchr's connection to Instagram. Once completed, this confirmation popup will appear.
Authorization confirmation for Catchr
  • A brief loading period will follow. Once done, scroll down the page.
Post-loading page
  • Select the account that Catchr will access, then click on "Add."
Selecting an Instagram account to add
  • If you cannot find the 'Add' button at the bottom right, check the top right for a button labeled "Create Report" or "Report."

With that, your Instagram data is poised for integration into Looker Studio, empowering your marketing analytics.

Example of Metrics You Can Use with the Looker Studio Integration for Instagram

Integrating Instagram data with Looker Studio opens a wide array of analytic possibilities. Leverage metrics such as Profile Followers and Like Count to gauge your audience engagement. You can also employ Media Reach and Media Impression data to understand the extent of your content's influence. The Looker Studio platform allows you to craft visualizations that can represent the growth of your followers over time, the performance of individual posts, or even the demographics of your audience.

Capabilities of Looker Studio with Instagram include:

  • Creating time series graphs to track follower growth and post engagements.
  • Producing geo maps to visualize the geographical distribution of your audience.
  • Designing pie charts and bar graphs to compare engagement types, such as likes, comments, and saves.
  • Using filter controls for viewers to drill down into specific media types or date ranges.

Accessing a comprehensive list of fields provided by the Catchr Instagram connector is essential for expert data analysis. To explore the full breadth of analytics available to your reports, visit the detailed field listing here.

Example of the first report for Instagram using Looker Studio.

From your data source page, click on Create Report at the top right.

This page is your report creation interface. Here's a detailed article about it.

First, I must decide what metrics and dimensions to follow on my Instagram dashboard.

My metrics:

  • Followers ->The total number of followers.
  • Profile Views -> How many times my profile page was visited?
  • Media Id -> To count the number of posts published.
  • Media Impressions -> The number of time my ads was shown.
  • Media Reach -> The number of person that view at least 1 post.
  • Media Engagement -> The number of interaction with my post

And dimensions: 

  • Media Thumbnail Url -> To identify the post with its thumbnail
  • Media Created at -> To have the publication date for a post.

Now we can start adding charts to our report.

Add charts to my Looker Studio report.

Scorecard:

We will now place some cards to have global metrics:

  • Click on Add a Chart, then Scorecard
  • In the metrics, choose Followers.

Repeat this action with the Profile View.

We will also use the Media Id on a card. Looker Studio will automatically count the number of Media Ids and display it. This gives us the number of posts during the period.

Table:

We want to see a table with the list of posts, with each post's Impression, reach, and engagement.

To do so : 

  • Click on Add a Chart, then Table. Place it on the canvas.
  • In dimensions, choose Media Created at and Media Url.
  • Add Media ImpressionsMedia Reach, and Media Engagement to the metrics.
Create a table and add metrics and dimensions.
Create a table and add metrics and dimensions.
  • Configure the Media URL to be a type of Image.


Configure type URL -> Image
Configure type URL -> Image

Change the sort order to use the created date (if you want them ordered by publication date) or by Impression (if you want to see the most viewed post).

Style your report : 

Now we have a report with our main KPIs and a table by post. Let's add a few things to try to have an excellent report:

  • You can add a shape to use as the header or footer:
  • Locate the Shape button in the shortcut bar.
  • Click on it and place the form on your canvas.
  • Change the back-ground color and adapt its size.
  • Copy and paste it to create your footer.
Add a shape and style it
Add a shape and style it

Add a Title thanks to the Text component:

  • Locate the Text shortcut, and click on it.
  • Place your textbox, and modify the font size to 30px and the font color to white.
  • Write your title
Add a text box.
Add a text box.

Add your logo or the one of your client:

  • Locate the Pictures shortcut, and click on it.
  • Select your Image.
  • Place it on the report.
Add an image in a Looker Studio report.
Add an image in a Looker Studio report.

Style a scorecard and copy/paste only the style:

  • Select a scorecard.
  • Center the text and number.
  • Add a blue border and a border radius.
Style a scorecard
Style a scorecard
  • Copy the scorecard.
  • Right click on the selected scorecards, and click on Paste Special -> Paste style only
Copy Style only
Copy Style only

Style the table:

  • Select the table.
  • Change the font color to white and the header background-color to blue.
  • Add a blue border and a 5px radius.
Style table
Style table

Bonus : Your free Instagram Followers Template

In this Instagram template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Instagram Followers OverviewTemplate for PowerBI

In this Instagram template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Instagram

Explore your Instagram marketing KPI in PowerBI : How-to, templates and metrics

Unlock the power of Instagram marketing analytics with PowerBI through this detailed tutorial. Learn how to connect your Instagram account to PowerBI using Catchr, enabling you to import and visualize key Instagram metrics. Discover how to create insightful dashboards in PowerBI, leveraging Instagram data for comprehensive analytics and strategic decision-making. This guide provides step-by-step instructions for integrating Instagram with PowerBI, offering marketers a powerful tool for data-driven storytelling and campaign analysis.

Florian Cabirol

Connect Instagram to Looker Studio : How-to, templates and metrics

Learn how to use Looker Studio with your Instagram data, get a free template and adapt it to your need quickly!

Johan Chemin

How to Get Data from Instagram to Google Sheets

Discover how you can efficiently get data from Instagram campaigns into Google Sheets with the powerful Catchr Add-on. Automate your reports quickly & effectively!

Florian Cabirol

Top KPIs You Need to Track for Instagram in 2023

Learn how to improve your Instagram marketing strategy by tracking essential KPIs like reach, engagement, and sales. Access your analytics and start monitoring your progress now.

Florian Cabirol