I need you to go to [url removed, login to view]
There are 30 categories there. Each category contains around 20-30 subcategories. So in total there are approx. 750 sub-categories.
For each subcategory, you can click any article within it and at the bottom is a list of the 15 most viewed articles in the category for the last 90 days.
If you click any of these 15 articles and scroll to the bottom, you can see the number of article views as "This article has been viewed X time(s)"
I need you to make a spreadsheet in Excel. Each row in the spreadsheet is for a single sub-category, so total no. of rows should be approx. 750.
Column A is sub-category name
Column B is parent category name
Column C is no. of views for article no.1
Column D is no. of views for article no.2
Column P is no. of views for article [url removed, login to view]
Column Q is no. of views for article [url removed, login to view]
I don't care how you achieve this project so long as you make the deliverables as requested. Some expert coders of you may be able to automate this using web data parsing, otherwise it will be a manual job.