Google Trends: Connection guide

Supermetrics Support Site Team

Modified on: Mon, 13 Dec, 2021 at 4:27 PM

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:

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

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

Search for a topic in Google Trends.
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.
Decode the URL. Sites like URL Decoder are helpful for this.
Insert that code into the Supermetrics data source, under the Search term field.

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

Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.

Open a new Google Sheets file.
Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.
Under Data source, select the data source.
Navigate to Report configuration.
Select Query type.
Search by Term. To select multiple terms, separate them by commas or new lines.
Depending on the query type you choose, you can select additional options (country, type, category etc.).

Open the Supermetrics data source gallery.
Navigate to the data source and click Try.
Click Authorize to authorize Supermetrics in Data Studio.

If you're authenticating the data source for the first time, log in with the Google account you use with Supermetrics. Click Allow.
Click Authorize to log in to your data source.
Under Query type, select the query type. Click Next.
Search by Term. To select multiple terms, separate them by commas or new lines.
Depending on the query type you choose, you can select additional options (country, type, category etc.).
Click Connect on the top right-hand side. This will open a full list of fields available in this connector. You can skip this list.
Click Create report.
Click Add to report to complete the authentication steps.

Before you can authenticate the data source in Excel, you need to install the Supermetrics add-on.

Open an Excel file.
Click Data → Show Supermetrics.
Under Data source, select the data source.
Navigate to Report configuration.
Select Query type.
Search by Term. To select multiple terms, separate them by commas or new lines.
Depending on the query type you choose, you can select additional options (country, type, category etc.).

Explore our guides to set up data transfers to various destinations.