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 gtrends.app – 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.
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
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
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.