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.


Main features

With Google Trends, you can:

  • Inspect the popularity of one or multiple keywords over time
  • Compare up to 30 keywords at once
  • Inspect keyword popularity by geolocation
  • Fetch trending searches by country

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


Querying topics 

To generate the Search term, follow these steps. Learn more in Google's documentation

  1. Search for a topic in Google Trends.
  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 that code into the Supermetrics data source, under the Search term field.


Data protection agreement 

If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.


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. Click Add-ons → Supermetrics → Launch to open the sidebar.
  3. Under Data source, select the data source.
  4. Navigate to Report configuration.
  5. Select Query type.
  6. Search by Term. To select multiple terms, separate them by commas or new lines.
  7. Depending on the query type you choose, you can select additional options (country, type, category etc.).


Next steps

Learn how to create your first Supermetrics query with Google Trends.




Did you find it helpful? Yes No

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