Query Google Trend using Big Query

[sidd313]

I need help with google BigQuery. I am using big query to query data from Google Trends.

I want to get data using a specific keyword example "Coronavirus", and get the result in regions like CSV downloaded in google trend "interest over time".  But google trend dataset in BigQuery offers only  25 top-trending terms , top-term.

Any help with this is quite appreciated.

@marout@Roderick @Eduardo_Ortiz @Poala_Tenorio @ms4446 

[nceniza]

If you can't query a specific term, chances are that term is already replaced with another. Google Trends public datasets appends daily and will be expiring after 30 days:

---

This dataset includes the Top 25 stories and Top 25 Rising queries from Google Trends. It will be made available as two separate BigQuery tables, with a set of new top terms appended daily. Each set of Top 25 and Top 25 rising expires after 30 days, and will be accompanied by a rolling five-year window of historical data in 210 distinct locations in the United States.

 See full description here and sample query here: https://console.cloud.google.com/marketplace/product/bigquery-public-datasets/google-search-trends

[sidd313]

thanks @nceniza 

My question is , is there exist any table for specific term.

I saw a Blog post using a table which I can't find in BigQuery Google Trends.

bigquery-public-data.google_trends.daily_trends

SELECT keyword, date, SUM(value) AS search_volume FROM `bigquery-public-data.google_trends.daily_trends` WHERE keyword IN ('streetwear', 'sustainable fashion', 'luxury brands', 'activewear') AND geo_code = 'US' -- limit results to United States AND date BETWEEN '2018-01-01' AND '2022-12-31' -- limit results to years 2018-2022 GROUP BY keyword, date ORDER BY keyword ASC, date ASC