To help us compile monthly reports for our clients, we need to get data from Google Analytics, Google Adwords and Google SERP Ranking Reports into Excel and then get the corresponding data into Word documents for monthly reports. Each report requires different information although it's different variations from Google Adwords / Analytics,/ SERPs.
If you have experience with Google Analytics it will be advantageous, but a good understanding of excel and functions within excel is important.
We have a total of 8 reports to be compiled per month and this should take somewhere in the region of 5 hours per month. I'll await to see the respondents and send a few of them a copy of the reports so that you can then give me further information. I don't want to put all my reports up on Freelancer at this time.
It is imperative that you have a decent understanding of IF statements, VLOOKUPs, SUMIFs, COUNTIFs and other Excel formulas to fully be able to complete the work.
We get the results on the 1st of the month and the reports need to completed by the 3rd working day of the month. So if it is a monthly job, all the work needs to be completed in the first 3 days of the month.