Use the Google Trends data source connector to pull data such as time, geo, trending searches, and interests. With the data, you can create a report to predict the demand for your product based on the number of searches the selected keyword gets.
For a full list of metrics and dimensions available in our Google Trends data source connector, take a look at our Google Trends documentation.
Once you've connected to Google Trends, you're ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Query types for this data source
When connecting to the Google Trends data source, you must select a query type to use. The query type defines what sort of metrics and dimensions are available. Google Trends has the following query types:
- Interest over time
- Interest by hour
- Interest by region
- Related queries
- Related topics
- Topic suggestions
- Daily search trends
All query types use the "Interest" metric. The numbers the Interest metric shows represent the search interest relative to the highest point for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. A score of 0 means there was not enough data for this term. When fetching rising related queries, this metric will return percentage growth.
Note that if you need to use multiple query types in your Looker Studio report, you'll need to create separate connectors for each query type you use.
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See interest over time for a search term
Take a look at how interest in a search term has changed over time.
Use the Interest over time query type.
For best results in Looker Studio, use the time series chart type.
- Select the Interest over time query type.
- Insert the search term in the Search term text box, and select additional settings.
- Set the date range to This month to date.
- Select the Interest metric.
- Select the Search terms and Date dimensions to split the query results by search term and date.
See interest for a search term by country
Explore where interest in a search term has been the highest.
Use the Interest by region query type.
For best results in Looker Studio, use the pie chart or Google Maps heatmap chart type.
- Select the Interest by region query type.
- Insert the search term in the Search term text box, and select additional settings.
- Set the date range to Last week.
- Select the Interest metric.
- Select the Country label dimension to split the query results by country.
See related queries
View queries associated with a keyword for the ongoing month. In this example, we select a region to look into.
Use the Related queries query type.
For best results in Looker Studio, use the table chart type.
- Select the Related queries query type.
- Insert the search term in the Search term text box, and select the region you want to fetch data for.
- Set the date range to This month to date.
- Select the Interest metric.
- Select the Related query, Search term, and Country dimensions to split the query results by related search terms and country name.
Set up scheduled refreshes for your reports
You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel.
In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.
More resources
See the Supermetrics blog for tips on benchmarking competitor data using public data sources.
You might also be interested in: