You can access anonymised, indexed, normalised and aggregated Google Trends data with BigQuery. The BigQuery datasets available on Google Cloud Marketplace includes the Top 25 overall and Top 25 rising queries from Google Trends from the past 30 days. These datasets are categorised into two geographic scopes: United States and International.
- United States data: Provides the Top 25 and Top 25 rising queries across 210 Designated Market Areas (DMAs). This dataset is optimised for domestic market analysis, allowing users to join search trends with regional boundaries to better inform localised marketing campaigns and product forecasts. US data is available at daily granularity for a rolling five-year historical window and hourly (six hours/four times daily) granularity for a rolling one-year historical window.
- International data: Covers approximately 50 additional countries, surfacing Top 25 and Top 25 rising queries by ISO country codes and sub-regions. This global expansion supports cross-border insights and is designed to mimic the US dataset's privacy-first architecture, ensuring that data is normalised and aggregated prior to publication. International data is available at daily granularity for a rolling five-year historical window.
BigQuery's Cost-Free Tier offers up to 1 TB/month in SQL queries and up to 10 GB/month in storage without charge. SQL queries above these thresholds are subject to regular BigQuery pricing.
Tip: To access BigQuery without a Google Cloud account or credit card information, use the BigQuery sandbox.
Explore Google Trends datasets with BigQuery
To explore these public dataset tables, query the top 25 stories and top 25 Rising tables from the BigQuery SQL UI.
To minimise the data scanned and processed, utilise the partition filter in your query:
SELECT * FROM `bigquery-public-data.google_trends.top_terms`
WHERE refresh_date = DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
Alternatively, you can explore Google Trends with other business intelligence (BI) tools such as Looker, Data Studio or with solutions from our partners.
Related resources
- Google Cloud datasets
- Top 25 stories and rising queries in US Google Trends daily dataset
- Top 25 stories and rising queries in US Google Trends hourly dataset
- Top 25 stories and rising queries in International Google Trends daily dataset
- Blog: US Google Trends dataset
- Blog: International Google Trends dataset