How to Create Twitter Analytics Reports in Google Data Studio (Step by Step Guide)

Google Data Studio is one of the most powerful, yet underrated free technologies available on the internet. Google Data Studio makes it incredibly easy to pull data from tons of different sources and compile them in easy to understand graphs, charts, and visualizations. Whether you own a marketing agency, are the head of a marketing department, or are an entrepreneur trying to take a more data-focused approach to growing your company, Google Data Studio offers a powerful solution.

Using Google Data Studio for Twitter

As mentioned, Google Data Studio can link to hundreds of different sources of data from around the internet automatically. Some options include Google Analytics, Google Search Console, and Google Sheets.

Now for some bad (and good) news. Google Data Studio can’t be directly linked with Twitter. The good news, however, is that it does work with Google Sheets and Twitter’s analytics suite makes it easy to export data in a CSV format.

In this guide, you will learn how to pull important analytics data from your Twitter account into Google Data Studio to create beautiful and helpful social media reports for your company, your clients, or yourself.

Step 1: Get Your Data From Twitter

The first step in this process is navigating to Twitter Analytics on your computer.

To get there, you can click the link in the previous paragraph or simply go to twitter.com. From there, click the ‘more’ button at the bottom left of the screen.

Twitter menu dashboard

This will open up another menu with more options. Choose ‘Analytics’.

How to find Twitter analytics

Once you do that you will be brought to your Analytics Suite. At the top, you will see a menu with the option “Tweets”. Click that.

Finding Twitter tweets analytics

You can now see your tweet activity. At the top right of the screen is two dropdown menus. For the first, choose the time frame you would like to export and analyze (more is better).

Then, with the next drop-down menu, choose to export data by day. This will ensure the exported file is in the proper format to be analyzed on a time-basis.

Note: it appears data can only be exported one month at a time. If you wish to analyze data from multiple months, you will have to download each month separately.

A CSV file will be downloaded automatically.

Exporting data from Twitter Analytics

Step 2: Import Your Data to Google Sheets

Now that you’ve exported your Twitter data. It’s time to put it somewhere that Google Data Studio will be able to access it. Google Sheets is a great place for this.

Create a new spreadsheet in Google Sheets and copy-paste your data.

Like we mentioned earlier, Twitter can only export data one month at a time. So, if you are analyzing statistics from multiple months you will have multiple CSV files that need to be combined into one.

Step 3: Link Google Data Studio with Google Sheets

You have your data in Google Sheets. Awesome! We are almost there.

Now its time to actually open Google Data Studio.

Once you are here its time to add your Google Sheet as a Data Source. To do this, click the ‘Create’ button on the top left.

Create a data source in Google Data Studio

This will bring up some of the many data source options available to you. Choose the Google Sheets option.

Syncing Google Sheets with Google Data Studio

You’ll now see all of your Google Sheets spreadsheets. Select the one you pasted your Twitter data to. If you have multiple worksheets within your spreadsheet choose the one with all of the data.

Editing Google Sheets data in GDS

Then, click the blue ‘Connect’ button on the top right.

Step 4: Create a Report

After you’ve connected your new data source its time to add it to a report. There are two ways to do this.

  1. Click the blue ‘Create Report’ button on the top right
  2. Exit this screen and go to create a new report from a template you already have. The Twitter data will now show as an available data source.

If you don’t already have any reports created just go with option 1.

It will now open up a new report. Woohoo!

It probably created a graph for you that isn’t too useful for analyzing your data. Let’s change that!

In the image below you can see that it is displaying my Twitter data by record count. To change that click on the graph and check out the ‘Metric’ area on the right side of the screen.

Let’s change ‘Record Count’ to something more useful like ‘impressions’.

Now, right below that, you will see ‘Add Metric’ if you’d like to analyze other metrics this is the time to add them. Google Data Studio is highly customizable. For this example, I will add the metric engagements.

Editing metrics in Google Data Studio

Now all your twitter data is plotted by date, impressions, and engagements. You did it (almost).

Step 5: Format Your Report

Next, let’s format the report in a way that’s more readable like a time series chart. To do this, click on where it says ‘Chart > Table’ above the data metrics area on the right.

Now, hover over each graph option until you find ‘Time Series Chart’. Select that.

Viola! Your chart is now a beautiful time series chart.

Google Data Studio twitter time series chart

But, as you might notice, the graph is plotting impressions and engagement on the same x-axis which makes engagements really hard to see. An easy fix!

Click on the chart. Within the chart options area on the chart is the option ‘Style’. By clicking on this you’ll open up the styling options.

Editting Google Data Studio Axis for Twitter Report

Your chart now has both the impressions and engagement data in a super easy-to-read format. Awesome!

Google Data Studio Twitter Analytics Report

Pat yourself on the back because you are now a Google Data Studio guru!

Share Your Report

If you’d like to share this report with someone like a client or colleague, Google Data Studio has made it super easy.

On the top right of the screen, you can find a ‘Share’ button. Click here and add the email address of whomever you’d like to share your new report with!

For more helpful tips and guides follow me on Twitter, listen to Coinbound’s marketing podcast, or get weekly marketing tips sent straight to your inbox by entering your email below.

  • Coinbound Newsletter Banner Ad
Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from Youtube
Vimeo
Consent to display content from Vimeo
Google Maps
Consent to display content from Google
Spotify
Consent to display content from Spotify
Sound Cloud
Consent to display content from Sound
Cart Overview