I need historical search query data for a university research project. The task is as follows.
The .csv files can be found at http://www.google.com/trends/explore?hl=en-US#geo=US&cmpt=q by clicking on the cog in the top right corner and selecting "Download as CSV".
I need .csv files for all second level search categories in several countries. You can select a category on the left navigation pane. There are several nested levels of categories. I am interested in second level categories only. So for example I would need the .csv file for "Autos & Vehicles - Automotvie Industry" but not "Autos & Vehicles" (a first level category) or "Autos & Vehicles - Bicycles & Accessories - Bike Accessories" (a third level category).
Please also see the attached screenshot.
For each of those second level categories, I need the .csv file of the historical search query data.
I need the second level categories for the following countries (leave the 2004-present setting for the date range):
I am expecting a .zip file containing all the .csv files with the following naming convention:
Country_FirstLevelCategory_SecondLevelCategory.csv (do not use spaces, but camel case).
So for example, a file name would look like this: