Analytics

Releasing gtrends.app – A Google Trends Connector for Data Studio

by Simon Thompson
4 min read
Analytics, Tools & Resources
gtrends-1

Way back in July last year we put together a Google Trends connector for Data Studio, to help meet the reporting needs of some of our clients. It’s pretty straightforward in the scheme of things, but in practice it allows us to pull Google’s search trend data (like the below) directly into our reports.

Since the original tweets we put out, we’ve been using it internally, but have had a fair bit of interest in us opening it up for wider use.

As such, in the spirit of providing resources to the community, today we’re opening it up for free.

 


 

How it works

For those interested, the setup of the connector is pretty simple and has two components working in the background;

  1. gtrends.app API
    Unfortunately, Google has no official API for Trends data. To work around this, we’ve built a small API which – when given a phrase and region pair – goes off and fetches the data from the Google Trends UI, then returns it as JSON.
  2. Data Studio Connector
    The Data Studio connector itself is a Google Script which allows you to configure the data source, sends calls to the gtrends.app API as needed, and then shuffles the data into a format that Data Studio can use.

 


 

Step 1: Register for an API Key

To help prevent any abuse of the API, we require you to register an API key. All that’s required for this is a valid email address, which will allow us to get in touch if your use of the service is causing any problems at all.

You can register for a key using the form below – it’ll be sent via email straight away.


 

Step 2: Add the Connector

Once you’ve received your API key, you’ll need to work through the following steps to add Google Trends data to your Data Studio reports.

  1. Create a data source
    Create a data source by clicking this link.
    Add one data source per keyword/region pair you wish to import data for.
  2. Configure the data source
    Configure the data source with your API key, plus a phrase and region.
  3. Use the data!
    Now your data source is ready, you can start using the data.

 

Disclaimers

As always, there are a few caveats and disclaimers;

  • gtrends.app is a free service – we offer no SLA or uptime guarantees.
  • We reserve the right to block abusive API accounts, without notice.
  • This isn’t an official Google service.
  • If you do use the service for any research/tools, please do cite us.

 


 

If you’re having technical troubles or are interested in direct API access, drop me a message on Twitter @Simon_JThompson and I’ll do my best to help.

Otherwise, Happy Reporting!

 

Releasing gtrends.app – A Google Trends Connector for Data Studio

We don’t want briefs.
We want problems.
That’s where the magic happens.

StrategiQ Full Awards List
2024
UK Dev Awards
Rising Star
UK Dev Awards
Fintech Website
UK Dev Awards
Third Sector Website
Campaign Best Places to Work
26/100
UK Dev Awards
Retail/Ecommerce Website
UK Company Culture Awards
Best HR Tool
Sunday Times' 100 Best Places to Work
Small Organisations Category
2023
UK Dev Awards
Best Third Sector Website
UK Dev Awards
UX Award for StrategiQ
UK Paid Media Awards
Best Use of Linkedin Ads
UK Paid Media Awards
Paid Media Agency Led Campaign Of The Year
European Paid Media Awards
Best Use of Linkedin Ads
UK Agency Awards
Best Culture Transformation Initiative
UK Search Awards
Best Use of Search (Travel)
Social Media Awards
Best Use of Instagram
Social Media Awards
Best Use of Linkedin
Social Media Awards
Best Audience Engagement Campaign
DEVELOPHerAWARDS
Emerging Talent
UK Search Awards
Best Use of Search
2022
Elite Agency
Campaign Best Places to Work
Winner Top 50
UK Dev Awards
Project of the Year
UK Dev Awards
Travel Website of the Year
UK Dev Awards
Best Site Migration
UK Dev Awards
B2B Website of the Year
UK Paid Media Awards
Local Campaign of the Year
UK Paid Media Awards
Best Use of Attribution
UK Search Awards
Best Local Campaign (PPC) (LARGE)
UK Search Awards
Travel / Leisure (PPC) (LARGE)
UK Search Awards
Retail / Ecommerce (SEO) (LARGE)
The Drum Awards
Best Business Development Initiative
2021
UK Dev Awards
Best Migration
Campaign Best Places to Work
Winner Top 50
UK Agency Awards
Covid Response (Silver)
UK Agency Awards
Campaign Effectiveness Award (Silver)
UK Search Awards
Best Use of Search Third Sector (Silver)
UK Search Awards
Best Use of Content Marketing (Silver)
UK Search Awards
Best Large SEO Campaign
2020
Campaign Best Places to Work
Winner Top 50
Suffolk Business Awards
Business of the Year
Suffolk Business Awards
Small & Medium Business of the Year
2019
DXA Awards
Best PPC Strategy with Powertool World
Suffolk Business Awards
Best Employer
2018
Best Employers Eastern Region
Best Digital & Technology Business
UK Search Awards
Best Small Integrated Search Agency
2016
EADT Business Awards
One To Watch Award
Read
Play
Hover