Google Trends Connector for Data Studio – How to Supercharge Your Dashboards

Every data analyst knows the struggle around reporting is real. To reach the right conclusions and make the correct data-driven decisions, it’s important to have some baseline. And here, the historical data plays a significant role. There are a lot of people interested in bringing Google Trends data in their Data Studio dashboards.

However, Google hasn’t released an official integration for Trends and Data Studio.

That’s why we are grateful to our peers from StrategiQ, a UK based marketing company.

What did they do? They prepared an accessible solution: the – a Google Trends Connector for Data Studio, so all of us can enhance our reports with a new and easily digestible data visualization element. More than that, “in the spirit of providing resources to the community” it’s all free!  A big shout-out to you, guys!

We saw it, we used it, we loved it, and we showed you in the video that we embedded at the end of this article how to use it in your reports. 

Want to jump directly to the video?

Your Quick Access Links

What is Google Trends?

Google Trends is a free tool that gives you access to search requests across Google Search, YouTube, Shopping, and Images. By entering a keyword or a topic, you can explore what the world is searching for.

Google Trends data in Google Data Studio reports - the benefits

You might be asking yourself why you should add Google Trends data in your dashboard. Well, we can only see advantages:

  • Learn so you can adapt more quickly. Seeing the search trends can help you anticipate the outcomes and make the necessary adjustments or optimizations.
  • See long term search trends. Google Trends is a valuable resource for identifying keyword traffic, and for content planning.
  • Optimize your marketing budget. Seeing higher or lower interest patterns in searches for a particular product or service allows you to optimize your budget accordingly.

Gathering data is not trendy, it's essential

It's also not enough to just gather it, but to see it compiled in a comprehensive way. Get your own at-a-glance view of your key metrics!

Can I add a Google Trends graph to Google Data Studio?

Yeah you can! Let’s cover now the step-by-step process on how to embed Google trends in your dashboard. 

Step 1: Register for the API

Start by registering for the API key from StrategiQ here. You’ll get it via email.

Step 2: Add the connector

As soon as you have received the key, you can move on to adding the connector. First, create a data source for the keyword and region pair you want to see Google Trends data in your dashboard. 

Step 3: Make the configurations

Configure the data source using your API key, the keyword, and the region. Copy and paste the API key you received, add your phrase of interest, select a time range and the desired region. 

Tip: Don’t forget to tick the parameters’ boxes and allow them to be modified later in the reports.

Step 4: Play around with your new widget

The Google Trends Connector for Data Studio and your data source are now ready to use. Go to the chart and see how it’s configured. Have a look at the Google Trends data source, the dimension (the date), the metric (the search term), and the date. Just play around and format them however you want.

Video - How to add the Google Trends Connector for Data Studio

Watch the video below and see how I go through all these steps in just a couple of minutes. Adding Google Trends data in your Data Studio dashboard is pretty simple. If you have any questions, drop us a line.

Share this article:

Share on linkedin
Share on facebook
Share on twitter
Share on pocket
Share on reddit