This guide contains all permissions and requirements for connecting your Google Trends data to Supermetrics.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in all available destinations.
Required permissions
Google Trends is a publicly available data source, so you don't need an account or any special permissions to access it.
Use it to:
- Inspect the popularity of one or multiple Google 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 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.
Query topics in Google Trends
In Google Trends, you can search for a specific search term or a topic that contains multiple search terms. Explore Google's documentation to learn about the difference between search terms and topics.
To query for a topic, you need to get a unique identifier called topic code for the topic you want to query. Follow these steps to find the topic code and build a query for a topic:
- Search for a topic on Google Trends.
- Copy the topic code from the browser's URL bar — this is the last section of the URL, beginning with a % symbol after a comma or equal sign (=). See the screenshot below.
In this example, the topic code starts after the comma. Note that the search term isn't encoded, which makes it different from a topic.
If you have searched for one topic only, the topic code starts with the % symbol that follows the equal sign. - Decode the topic code. Sites like URL Decoder are helpful for this.
- Insert the decoded topic code into the Search term field in Supermetrics when you're creating your query.
Query types
Query types define what sort of metrics and dimensions are available. You need to select one of the following query types when pulling data:
- Interest over time
- Interest by hour
- Interest by region
- Related queries
- Related topics
- Topic suggestions
- Daily search trends
Connection instructions
When connecting to Google Trends, you need to select a query type and enter the search terms.
- Select the Google Trends data source on the Supermetrics Hub or in the data destination.
- If prompted, choose to make this connection shared or private.
- Click Start.
- In your data destination, select a query type and enter the search term or topic code (see Query topics in Google Trends above) for each search term you'd like to query, separated by a comma with no whitespace (,).
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Google Trends from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer
More resources
- Google Trends report building guide
- About discrepancies in Google Trends data
- How to reauthenticate a data source in Google Sheets, Looker Studio, Excel, or Power BI
- How to reauthenticate a data source in data warehouse, API, or cloud storage platform
- How to manage data source connections on the Supermetrics Hub