To get the most out of your social media campaigns, you need to know a lot about your audience and how your Instagram posts are doing. For you, digital marketers who are in charge of multiple channels like Instagram, it's important to put this information into organized systems like Google Sheets so that they can analyze it better.
In this guide, we'll look at how to use the smart Catchr add-on to get all your data from Instagram to Google Sheets quickly. With step-by-step instructions and expert tips, you'll be able to set up automated reports quickly and focus on what really matters: your marketing strategy.
Google Sheets is a great way to organize information because your entire team can work on it, access it from the cloud, and use it on multiple platforms. When you integrate it with marketing platforms like Instagram, you can get a clear picture of how well your digital strategy is working.
But there are some other major benefits:
Transparency across teams: By centralizing Instagram data in one location that everyone has access to, all team members remain informed about the data's progress at all times.
Updates in real time: Your data analytics are always the most up-to-date because they are automatically refreshed.
Easily customizable reports: The ability to easily update formulas helps users tailor reports according to prospects' needs or your' preferences.
With that in mind, it's clear that using Google Sheet is a no-brainer.
The Catchr add-on makes it easy to connect marketing sources like Instagram or Facebook Ads and puts all the necessary metrics in your spreadsheet.
Follow these steps to start getting useful data from Instagram directly into your Google Sheets:
To install the Catchr Add-on to Google Sheets to extract your data from Instagram, you will have two options:
Option A: Via the marketplace:
Option B: Directly within a Google Sheet:
Once you have installed the add-on, you can start making requests.
After successful installation:
1. Click on Add-ons, which can be seen listed within your spreadsheet's top-left corner.
2. Navigate through the pop-up menu until you find “Catchr - Data connector". Choose "Launch".
3. A sidebar will appear, showing all your current available queries for the Google Sheet. Click on “New query”. Find and click on “Instagram”.
4. If no account listing shows up initially, create one yourself using any plus button across the displayed selections.
You need to select the Instagram account(s) you want to work on. You can select one or more accounts. Our system will aggregate your data automatically based on the dimensions.
This is where things might get interesting, because you can select any fields you want. On the metrics tabs, you can find metrics like “profile followers” or “media impressions.”
On the dimensions tab, you could choose the dimension you want to use to breakdown your data. It could be “Day”, “Media Type” or whatever you want.
On the Date Range tab, there is a selector that lets you choose any time range that makes sense for your data. Some presets are available by default, like “Today”, “Yesterday”, etc. But you could also provide a custom start and end date.
Sometimes you want to filter your data to get only the information you need. By way of example, if you want to get only the videos from your Instagram profiles, you could easily add a filter from the filter tab.
Just select “Media Type” in the selector, choose the “Equals” operator, and put “Video” in the field.
You can set up a query schedule to automatically update your data every week, every day, or even every hour. You can customize this in the Options tab. Activate "append rows" to add new data beneath old while preserving historical context. Alternatively, use "Combine rows" as it updates the entire range without losing vital prior comparisons!
Once ready, hit “Get Data".
Your data will be displayed in the spreadsheets automatically.
Let's say you're tasked with monitoring the success of a recent Instagram post. We will build this report easily with the Google Sheets add-on. Follow the following steps:
You will see something like this:
Congrats, you have created your first report with Catchr. You could now improve or use other report to build a beautiful dashboard for your business.