Exporting Google Trends data into Google Sheets (unlimited number of keywords)
HTML-код
- Опубликовано: 8 сен 2024
- Easily export trends data from Google Trends directly into Google Sheets. Use our template to export data for as many search queries as you need.
Full article about the tool on our website:
www.analyticsh...
Link to Download our Google Sheet template for extracting Google Trends data into Google Sheets: drive.google.c...
Our website:
analyticshacke...
Book a free enquiry call
www.analyticsh...
Book a 1 hour paid consultation:
www.analyticsh...
IMPORTANT UPDATE: The tool has been updated to reflect changes made by Google. Please re-download the updated version: www.analyticshacker.com/google-trends-tool-for-google-sheets
Fantastic tool! Is it possible to include categories on top of date and country? It would be incredibly useful to filter out noise.
you are pro, thanss my friend
Thank you very much!!
New queries do not seem to update the Graphs tab. Is there somewhere other than Column G on the Criteria tab in which we should put the country code? Or is there some other reason this would be happening? The text on the Graphs tab still says "pivot table (and chart) showing Country = GB" and pivot table (and chart) showing Country = DE" as in your sample sheet.
The main aim of the tool is to pull the data from Google Trends, and not necessarily to populate the graphs. The Graphs included in the template are just an example of how you could plot the data. Having said that, if you did manage to populate the data (in the "Results" tab), then the "Graphs" tab should populate the results too, though note that each of the Pivot tables in the Graphs tab is filtered by country (GB and DE respectively). Meaning that you need to filter the pivot table/-s for the country that you do want to be shown (if different to GB or DE)
@@agnieszkab4332 Thank you so much. I got the pivot table sorted, but the data that is being delivered isn't accurate. I can definitely use this tool if it is pulling the correct data trends information, but that doesn't seem to be the case. For example, if I put in the query codes for George Washington, John Adams, and Thomas Jefferson, Washington should by far be the most searched, followed by Jefferson, and then Adams. However, Adams comes out highest, followed by Washington and Jefferson. I don't think I'm entering the information incorrectly and have tried this with other similarly differentiated data points with similar results.
@@JasonRussell-nh6uh the tool pools each keyword individually (just as if you had many tabs opened with google trends data, with one keyword results per tab). Meaning, you should not use it to compare the relative values of the different keywords. You can only use it to compare the trends.
We have build this tool this way so people can pull data for more than 5 keywords at a time.
Google trends has a limitation of how many keywords you can see in comparison. The limitation is 5 keywords.
If helpful, i will upload by next week a similar tool which would pull up to 5 keywords only (so you can then compare the relative values of those keywords). I will let you know once available .
@@agnieszkab4332 Thank you for the reply. I was under the impression that the tool was intended to be able to compare the trends of topics. It would absolutely be helpful to have something that can compare topics with other topics as well!
Hi Jason. We have created a similar tool, but this one allows to pull up to 5 keywords at a time (and these can be compared to each other). The tool can be found here: drive.google.com/drive/folders/11cST3HvcMvyVUhby3TySk28NV_qG6VaS?usp=share_link.
Hey, I keep getting this error while trying your script:
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
in ()
108
109 new_final = []
--> 110 for i in final_df_list:
111 new_i = i.reset_index().set_index(['date'])
112 new_final.append(new_i)
TypeError: 'NoneType' object is not iterable
Getting this same error :/