SEO Report Tool

IN PROGRESS
Project Budget (USD)
$80

Project Description:
I would like to create an SEO report tool that allows me to upload 2 Google Analytics reports from different time periods e.g July 2012 and July 2013 (Google Analytics keyword report sample with sample numbers attached). Based on these uploaded files, I would like the tool to generate a report of the following;nn- Sort and list the common keywords that appear on both GA reports by visits for 2012 and 2013 and have a column showing if each keyword has lost or gained traffic since that time. Please show the actual # of visits for each year and then the difference.nn- Sort and list any new keywords appearing on the 2013 list and the visits each keyword has generatednn- Sort and list any lost keywords that appeared in 2012, but don’t appear in 2013 and show the total visits lostnnAlthough the sample reports are based on keywords, I would also like to be able to upload a report based on landing pages. I would assume the tool would be able to work for both since the principles are pretty much the same (keywords get swamped for landing pages)nnLet me know if you can help!nnThanks :)n

Skills required:
Excel, Visual Basic
Additional Files: GA-july-2012-seo-report.csv GA-july-2013-seo-report.csv
Project offered by:
Verified