Google Keyword Data Processing Task
Budget: £20 – £250 GBP
Hi,
We have 72 spreadsheet .csv files of approximately 10,000 terms in total. They are from keywordtool.io. There are four categories "keywords", "related keywords", "questions", and "prepositions". I need someone to combine the data from all 72 spreadsheets into four spreadsheets titled "All Keywords", "All Related Keywords", "All Questions", and "All Prepositions" with all of the other data in the original files, like search volume etc.
You must also remove all duplicate values or duplicate entries of keywords and terms to clean the spreadsheet.
The spreadsheets should be filterable and easily searchable on metrics in microsoft excel.
I think this job just involve a lot of careful copy and paste. All 72 files are a total of 2.48MB in size so not very big.
If work good, may also have another project for processing of all terms into ad groups or completion of a bulk google ads upload spreadsheet for about 30 new campaigns and 150+ ad groups etc.
Thanks
Charlie
We have 72 spreadsheet .csv files of approximately 10,000 terms in total. They are from keywordtool.io. There are four categories "keywords", "related keywords", "questions", and "prepositions". I need someone to combine the data from all 72 spreadsheets into four spreadsheets titled "All Keywords", "All Related Keywords", "All Questions", and "All Prepositions" with all of the other data in the original files, like search volume etc.
You must also remove all duplicate values or duplicate entries of keywords and terms to clean the spreadsheet.
The spreadsheets should be filterable and easily searchable on metrics in microsoft excel.
I think this job just involve a lot of careful copy and paste. All 72 files are a total of 2.48MB in size so not very big.
If work good, may also have another project for processing of all terms into ad groups or completion of a bulk google ads upload spreadsheet for about 30 new campaigns and 150+ ad groups etc.
Thanks
Charlie