SEO Report Tool



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: Excel, Visual Basic

See more: time in ga, generate visits google analytics, analytics seo report, google analytics reports, report generate, upload tool, seo july 2012, generate report, google analytics seo reports, seo monthly traffic report template, google keywords tool, landing pages sample, generate visits, swamped work, sample graphical report seo traffic, report files attached, google analytics report, common keyword list, keywords tool, difference year, seo landing pages, sample reports, seo adult traffic, tribalwars tool report maker, calculate year difference years using javascript

Project ID: #4869130

Awarded to:


Hired by the Employer

$80 USD in 3 days
(75 Reviews)