How to Bring Social Media Data to Google Data Studio
How-To Guides

How to Bring Social Media Data to Google Data Studio

Diana Gogolan
Diana Gogolan

Table of Contents

If you feel like technology is way ahead of you, then you might not be the only one. You may have some issues with keeping up with everything tech, but there are also so many ways to learn anything you want.

Google Data Studio is a good example, considering that I knew nothing about it myself. Trying to understand how everything works, I started to look for any type of article or tutorial that could introduce me to this world.

I have gathered all the data needed, all the information from multiple sources, and I put it all together here in order to make the process easier.

The purpose?

To understand how Google Data Studio works with social media data, what it does, how to use it, and how Socialinsider can help you with this entire process.

I will walk you through my own journey of learning Google Data Studio in hopes that youโ€™ll find some valuable information that could help you out as well.

How to build social media reports in Google Data Studio

  1. What is Google Data Studio

  2. Benefits of using Google Data Studio

  1. Build a social media dashboard in Google Data Studio

  2. Google Data Studio and Socialinsider

1. What is Google Data Studio

The short version of the explanation: it is a data visualization platform.

If you want to have everything in one place, Data Studio is the answer to your prayers. In other words, it is everything you need to keep up the good work.

Google Data Studio is a tool that will keep track of everything analytics and more. If youโ€™re familiar with Google Sheets, then you might find this one easy to use. Or, at least, to find the workflow pretty similar.

2. Benefits of using Google Data Studio

As we said before, this tool turns the data you need into easy-to-understand dashboards and reports.

Well, first of all, I shall assume that you work with a lot of data. That would explain your interest in learning more about Google Data Studio.

So, dear data geeks, be prepared to have an easier life with this platform. Whatโ€™s the deal?

There are a few exciting things about Google Data Studio that I knew nothing about before.

  • Free tool

The first best thing about Data Studio is that the tool is 100% free, and it is available for anyone.

Just like any other Google feature, you can use it without any cost. You just need internet access, thatโ€™s all.

  • Everything is customizable

Google Data Studio allows you to create custom reports, and it gives you a variety of designs, styles, and so on. There is also an entire report gallery where you can find reports created by the community.

And there are many templates that you can choose from.

What can you customize:

  • Page layout
  • Text
  • Graphs
  • Metrics
  • Style elements
  • Interactive platform

Whatโ€™s great about Google Data Studio is that you donโ€™t have to be very technical about it, and you donโ€™t need to be good at graphic design.

With just a few clicks, you can create a fantastic dashboard that will be appealing and easy to read.

Google thought about the recipient of the report, giving him the ability to play around a bit. The viewer can:

  • Control the date range
  • Set different filters
  • Sort by different metrics
  • Select optional metrics
  • Dig into data
  • Automated reports

Any type of manual work can be really time-consuming. Google knows that time is everything, so it gives you access to more features.

You can create fully automated reporting dashboards with real-time data. This will definitely save you a lot of time.

  • Shareable dashboards

Google Data Studio encourages collaboration among people. This means that you can choose between the viewer or editor access and share your reports with your colleagues.

You can share them via link or email.

  • Filters

The filters will let you adjust your data based on any dimension or metric. Here are some examples:

  • Date range
  • Account
  • Campaign
  • Location

How to add filters in Google Data Studio

You can apply the filters to your reports, and they can also include conditions such as and/or to go beyond the normal social media data.

  • Exporting options

I personally love when I can choose how to export the report I want.

Google Data Studio gives you the following exporting options:

  • PDF
  • Excel
  • Google Sheets
  • Email

People have their own preferences, so the more options, the merrier. You can also schedule automated email exports if you want to.

  • Google Data Studio connectors

One of the best things about Google Data Studio is that you can connect to a variety of data sources: Google Analytics, Google Ads, Google Search Console, Google Sheets, SEO performance, Ads spend, mentions, etc.) all in just one dashboard.

More than that, you can also blend data from different sources to create the dashboard you want.

Accessing all the data you need at once will save you a lot of time and energy. And this is amazing.

3. Build a social media dashboard in Google Data Studio

So now that weโ€™ve gone through the basics, letโ€™s see how to create a dashboard from scratch with your social media data.

As we saw before, you can use any template you want, but if you want to build it yourself there are a few elements you should be familiar with. Take a look at some of the existing templates to make an idea how it works.

When building a social media report from scratch, I strongly recommend you explore the platform a bit first. Play around with the features and see what you can like and what you donโ€™t.

Now, click on Blank Report. Google Data Studio then asks you where to get the data from.

How to create a new report in Google Data Studio

I chose Socialinsider Analytics because there is the place where I put all my social media data, but you can select any other connector you want.

Just go to the search bar and look after it.

Choose what data to add in Google Data Studio

After that, Google asks you to select what data you need to connect to Google Data Studio. There are three drop-down buttons: metrics type, platform, and project.

This step gives you the option to add the social media data to Google Data Studio.

Socialinsider Analytics for Google Data Studio

Decide on whatever option you need, and then a new report is created. Give your project a name, and feel free to play around.

You can click on Add Page if you want a report with more than one page. By clicking on Add Data, you can connect your data through different connectors in order to mix things up a bit.

How to add a new chart in your Google Data Studio dashboard

You can also add a new chart. From tables, bars, pie charts to maps and geo charts, you will never get bored.

For example, I added a new chart (time series) that shows me the engagement, impressions, and reach for the last 28 days. Whatโ€™s really interesting is that you can also compare your social media data with the results from another period of time of your choice.

Compare data with another date range in Google Data Studio

If you want to see data like user counts or numbers, click on one of the Scorecard options.

On the right side, you will see two sections: Data and Style. Data will tell you where the element is getting its data from, while the Style section is the place where you can change the color and edit fonts to make everything look as close as you imagined it.

Letโ€™s take a look at how you can change the style of your charts. Go to Style and explore that section a bit. As you can see, I chose to show you the before and after of the same chart.

Change the style of your chart in Google Data Studio

Series #1, Series #2, Series #3 are the equivalent to the social media data: engagement, impressions, reach. These are shown as bars here because thatโ€™s what I selected for each of them.

Change line charts to bar charts in Google Data Studio

You can also change the line/bars color, while for the line visualization, you can even change the line weight and show points for each peak in the chart.

Change colors for your chart in Google Data Studio

More than that, you can change the theme and layout with just a few clicks for even more customization.

Change the theme in Google Data Studio

Add a text that you can change whenever you want in order to create a legend for your own dashboard. This way, it will be so much easier to read the data.

You are able to add an image, line, or shape if this will make your dashboard better. Itโ€™s your choice. Click on Insert and find everything right there.

4. Google Data Studio and Socialinsider

We like data just as much as our customers do, so we wanted to make everybody happy. You can now connect your Socialinsider data to Google Data Studio and dig into your metrics.

Setting up the integration is very easy. Hereโ€™s how.

After following those steps, you will have to select:

  • What metrics you want to add
  • From what platform
  • The project that you need

Previously, I have shown you how to integrate Instagram data into your dashboard through the Socialinsider connector. But this tool can do more than that.

Letโ€™s create a new dashboard to show you what I mean by that.

You can add three types of social media metrics to Google Data Studio:

  • Post level metrics
  • Profile times based metrics
  • Benchmarks metrics

All these metrics are available for: Facebook, Instagram, Twitter, LinkedIn.

Bnchmarks metrics with Socialinsider and Google Data Studio

In this example, I have added the benchmarks metrics for Facebook. In the project were included the Facebook pages for Nike, Adidas, and The North Face.

But I wanted more than that.

So I added more charts (Scorecard, Pie Charts) to have a better look at my social media data, and I also wanted to play with the edit options.

More benchmarks options with Socialinsider and Google Data Studio

Of course, you can again change the theme, colors, and so on. Create the design that you want.

Here is another example of Socialinsiderโ€™s performance on Instagram. I have also added a date range control (go to Add Control - Date Range Control) to have the time range there.

How to create an Instagram report with Socialinsider and Google Data Studio

There is a chart with the Instagram engagement by type of post, with another pie chart to make everything more visually pleasing.

Discover what 102,700,573 posts show us about Instagram Engagement!

The Scorecards show the total metric for each one of them during the selected period of time.

Letโ€™s say that maybe you donโ€™t want the message metric. Just go to Metric, click on message and change it to whatever you need.

How to edit the metrics in Google Data Studio

There is a list with the metrics provided. Change any of them every time you want to.

Change the Scorecard in Google Data Studio

Voilร ! There it is - changed it into video_views.

Final thought

Learning to use Google Data Studio in order to write this little article seemed a bit intimidating and challenging at first, but it turned out to be easier than I thought.

Of course, there are more things that I havenโ€™t covered here, but there is always room for improvement, and donโ€™t forget: Practice makes perfect!

Bring your social media data to Google Data Studio and discover secrets every single day.

Get ready to create in-depth and visually beautiful reports with Google Data Studio and Socialinsider.

Diana Gogolan

Diana Gogolan

Product Manager @ Socialinsider

Passionate about telling stories that take different forms and shapes.

Improve your social media strategy with Socialinsider!

Use in-depth data to measure your social accountsโ€™ performance, analyze competitors, and gain insights to improve your strategy.

Start a Trial
  • High performer
  • High performer
  • High performer
  • High performer
  • High performer
  • High performer

Leader in Social Media Analytics Category

High Performer social media analytics tool for brands and businesses.

G2 Crowd
  • Users Love Us

Users Loves US Award


G2 Crowd
  • Captera

Capterra Reviews