Query Google Trend using Big Query

Google Cloud Data Analytics
1

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

2

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

2 Likes
3

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