In this post I’ll show you how to make a Twitter Dashboard in Google Data Studio. This dashboard I created shows who’s been tweeting about the term#DataStudio.

IMPORTANT UPDATE: Twitter Connector no longer working

Hi everyone. So unfortunately the Twitter data connector I used for this blog post is no longer working.

So you will NOT be able to build a dashboard in the way I’ve described in this blog post.

If you’re looking for an alternate way to get Twitter data into Google Data Studio you might find this other blog post useful;

How to build a Twitter dashboard in Google Data Studio using IFTTT

I’m keeping the blog post content up in case someone is able to get access to the Twitter Data connector.

UPDATE: Please note that the following content may no longer be accurate.

I’m keeping it up just in case it is useful to anyone.

How to build a Twitter dashboard to see who’s tweeting about #DataStudio

The first step is to choose the Twitter connector under Data sources.

We can then type in the search term we’re interested in.

Important Note: The Twitter connector is not particularly stable or reliable. And it can be finicky and stop working at any moment.

Once we’ve added the Twitter data we can view as a data source.

One thing I’ve done is create a custom field that combines Favorite Count and Retweet Count into a new metric called “Tweet Interactions”.

Once we’ve added this custom field, let’s create the main table for the data.

I’ve created a table with this setup.

I’ve also decided to change the theme to Simple Dark.

With some cosmetic changes, our table can look something like this.

As mentioned before, the Twitter connector can be unpredictable and glitchy.

But one of the features that does work is generating a geo map based on the Twitter profile’s user location. Despite the formatting for user location being very varied Google Data Studio makes a brave effort to place them on a map.

For example, we can see lots of tweets from Rochester, NY that might be from Data Studio guru Lee Hurst!

It’s worth noting at this point that when the Twitter connector works its cool and useful. But you may see the following a lot when using it in Data Studio.

Hopefully the Twitter connector works for you and you can keep track of some trending terms!

And hope you enjoyed learning about creating a Twitter Dashboard in Google Data Studio.

If you liked this article you might like my other blog posts.

Or you can follow me on Twitter!