Open navigation

Google Trends: Connection guide

This guide will walk you through how to connect Google Trends with Supermetrics in Google Sheets, Data Studio, and Excel.


Before you begin

Main features

With Google Trends, you can:

  • Inspect the popularity of one or multiple search terms over time
  • Compare up to 50 search terms at once
  • Inspect search term popularity by geolocation
  • Fetch trending searches by country
  • Fetch data for by search term or by topic

Search volume is returned as a relative metric, where 100 represents the highest volume within the time range selected.


Searching topics

Supermetrics Google Trends connector allows you to query a specific search term or a topic that contains multiple search terms (read more about difference between search terms and topics from here).


If you want to create a query that searches for a topic, you need to go through the steps below to find a topic ID and to set up your query:

  1. Search for a topic on Google Trends website.
  2. Copy the topic code from the browser's URL bar — this is the last section of the URL, beginning with a % symbol that follows a comma. See the screenshot below.
  3. Decode the URL. Sites like URL Decoder are helpful for this.
  4. Insert the code you get from URL decoder into the Search term field in Supermetrics when you're creating your query.


Instructions


Google Sheets Data Studio  Excel Data integrations
Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.
  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Under Data source, select Google Trends.
  4. Navigate to Report configuration.
  5. Select Query type.
  6. Select Search by term. Enter the unique identifier (see Generate a unique identifier above) for each search term you'd like to query, separated by a comma with no whitespace (,).




Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.