Download .csv files of historical search query data from Google Trends

Download .csv files of historical search query data from Google Trends

Closed - This job posting has been filled and work has been completed.

Job Description

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):
USA
Germany
France
Spain
Italy
Portugal
Greece
Hong Kong

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:

Germany_BusinessAndIndustrial_AgricultureAndForestry.csv

---
Skills: data-collection

Open Attachment