Instagram has become one of the most popular social media platforms around the globe. The photo-sharing service allows users to share their photos and stories through various means, such as posting them on their profile or tagging other users.
In addition to being a fun way to share pictures, Instagram also offers some valuable features. For example, it lets you create beautiful collages from multiple images. And if you want to get even better at using the platform, you should check out these top Instagram hacks.
You can now easily create stunning visual presentations using Google Data Studio. This tool makes it easier to analyze data and present it visually. You’ll love this new feature if you already use Google Analytics.
Free Instagram connectors for Google Data Studio
There are several ways to pull Instagram data directly into Google Sheets. One of the easiest methods is through an Instagram API Version. This method allows you to connect to Instagram without downloading the app. You use the Instagram URL and copy/paste it into your spreadsheet. But there are some limitations. For example, you cannot access user profile information such as bio, followers, likes, etc.
Another popular method involves downloading the Instagram app onto your phone and connecting to the account via OAuth 2.0. Once you’ve done that, you’ll be able to view all the same information and edit the metadata associated with each photo.
The third option is to use a third-party tool like InstaGraphy. This tool allows you to scrape Instagram photos based on hashtags. It works very similarly to how Pinterest scrapes images from pinterest.com.
Instagram post metrics and dimensions
Data Studio now supports Instagram posts. This feature lets you see how many impressions, likes, comments, and shares each post received. You can use it to compare your posts across different posts, such as images, videos, stories, and carousels.
You can also use the Instagram posts insights connector in Data Studio to analyze your Instagram performance. For example, you can see how often people clicked on your link, what countries your audience lives in, and how much money you spent promoting your posts.
Setting up an Instagram pages report on Data Studio
Instagram Pages Report allows you to see how many followers each post has, what type of posts are most popular, and much more. You can set it up in minutes and start seeing real insights into your audience.
Here’s how to set it up:
1. Log in to Data Studio.
2. 3. Select Instagram Pages Report.
4. Enter the name of your account in the Name field.
5. Choose whether you want to include likes and comments in the report. If you choose yes, enter the number of likes and comments in the Likes & Comments fields.
Filters and controls
A filter is a tool to find specific information within a large amount of data. Control lets you manipulate the data in some way. For example, you might use control to change how many people are included in a report. You could even use it to ensure no one else sees the report. These are both examples of filters and controls.
Google Analytics allows you to build custom reports based on pre-existing metrics like visits, bounce rate, sessions, average session duration, etc. However, it doesn’t let you create new calculations based on those metrics. For example, you could use the number of daily sessions to determine how many people are active during peak hours. Or you might want to know how long visitors spend on each page. You can do that now with custom formulas.
A case statement allows you to create new dimensions from existing ones. For example, say you want to know how many people live in each state. You could use the following code:
SELECT STATE_NAME, COUNT(*) AS THE NUMBER OF PEOPLE FROM THE COUNTRY GROUP BY STATE_NAME ORDER BY STATE_NAME;
This works fine, but it doesn’t consider whether the state name is capitalized or lowercase. To fix this problem, we can use a CASE expression. This type of statement lets us specify what happens when a certain value matches one of several conditions. In our example, we’d like to count the number of states regardless of whether the state name is upper or lowercase. We’ll start by creating a table named States with three columns: StateName, UpperCaseStateName, LowerCaseStateName. Then we’ll add some data to this table:
INSERT INTO STATES VALUES (‘Alabama’,’ALABAMA’, ‘alabama’);
INSERT INTO STATESVALUES(‘Alaska’,’AKASKA’,’akaska’);
INSERT INTO STATES VALUES (‘Arizona’,’ARIZONA’,’arizona’);
INSERT INTO STATETABLE VALUES (‘Arkansas’,’ARKANSAS’,’arkansas’);
Customizing your report
You can easily change the design and feel of your dashboard by adjusting the colors, fonts, images, etc. But what about the data itself? How do you make it easier to understand? There are many ways to customize your report. This article will show you how to use Dimensions & Metrics to customize your report.
To start, let’s look at some examples of different dimensions and metrics you could use in your report.
A dimension represents one piece of information about your data. For example, you might want to know how much each customer spent on average. Or perhaps you’d like to see how many customers bought something during a specific month. These are called “dimensions.”
A metric measures the performance of an individual record. For example, you could measure the total amount of money a customer spends over a certain period. This is known as a “metric.”
Let’s say you wanted to compare the sales revenue generated by your store in January to February. To do this, you’d need to find out how much each customer spent in January versus February. Then, you’d divide the difference by the number of customers.
Hugo is another Data Studio fan that specializes in reports and dashboards. He runs is own business from home and uses Google Data Studio in his reporting for his clients