How do you keep a record of your onsite SEO changes
-
Hi Everyone,
I'm new to the whole SEO process, so was wondering if anyone can help me.
I want to keep a record of all SEO activities in one place for the website i'm trying to optimise for.
I have created an excel sheet which have the follwoing tabs
-Overview & Rankings
- Keyword Research- Competitior Analysis
- Keyword Distribution Map - Onpage SEO
- Link Ideas
- Link Research
-Link Building Log
- PPC Campaign
Does this all seem correct?
Could anyone help in telling me what process you do to keep a record of all SEO onsite activity?I hope this isn't a stupid post, but help would be very much appreciated
Many Thanks
Matt
- Competitior Analysis
-
We use excel. It's a bit old school, even though I have an Access certification and could prob dev something sexier. It's easier for sharing with clients and no training is needed. It's easy to let it get overwhelming, so we oly keep the key metrics that matter. On page updates, link building activity, and ranking results. It's let's us see enough info over time for us and our clients. Also is a good place to store all those passwords!
-
I think that an SEO log should look like a log for a science experiment....
I did xxx because I thought it would result in yyyy. Two weeks later here is what happened. Four weeks later here is what happened.
The main value of an SEO log is to learn from the changes that you make on your site and how those changes influenced your rankings, conversion rate, etc.
-
I use Excel as well. However, I try not to keep all the elements in one excel file.
I have a file for rankings another for link building etc. It's way simpler and it doesn't take 1 minute to save the file.
Having just one file can be somewhat confusing. Moreover if you loose your file, you loose eerything.
-
Just like Alan,
I use excel but it also gets a bit hard over tome with rows and rows of data being collected.
I ike to keep each section tabbed and this allows me to track things far easier.
Old school rocks
-
iPad 2 notes...honestly...
-
Hi Matt
I used to use Excel, but it can get out of hand over time. Personally, I prefer a project management system, such as Basecamp. You can set up milestone actions with a date of delivery, that becomes the date of record of completion. You can add to-do lists, files, notes, messages all tied to the milestone. Everything is then stored and can be archived for future retrieval.
It's not perfect, (no solution I've ever used is perfect), but it's much more organized and manageable than Excel, unless you are really skilled at Excel and have the patience and willingness to deal with it when it's got years worth of data.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Want to remove a large amount of links from spam sites. SEO company says we will lose a lot of link juice?
Hi, We have a lot of links that have a spam score above 30% and 60%. I don't know if someone has spammed our website. However our SEO company has said we should remove these carefully over a period of 3 months while they add new good links. I don't quite trust this advice. Are they trying to get more business?? They have put doubt in our mind. Can anyone please shed any light on this?? Thank you
White Hat / Black Hat SEO | | YvonneDupree0 -
WordPress Tags and SEO
Good Morning everyone, I am trying to decide how I am going to handle an issue on two WordPress websites. I recently acquired 2 new clients that used to do business with the same SEO company. Neither of the clients know of the other but both had the same story about said SEO company. The usual complaints, I wont get into details. My issue is the old SEO company basically was spamming keywords and utilized tags to do this. For each of these clients they had very thin spammy blog posts written and then had a multitude of spammy tags used as keywords here is an example https://captainjacksboatingschool.com/middlesex-county-boating-safety-class/ Each one of these tags is creating duplicate content. How do i properly handle these tags? Do i delete? Do i need to redirect into one main page after deletion. I much rather use plain English and authoritative based Categories. In fact I never use tags, only categories. They do not seem to have much seo value. Both clients who were with this company have the same Tag setup... Any advice would be greatly appreciated as I do not want to loose the customers current rank because i want to do things my way Thanks, Don Silvernail
White Hat / Black Hat SEO | | donsilvernail0 -
Is linking out to different websites with the same C-Block IP bad for SEO?
Many SEOs state that getting (too many) links from the same C-Block IP is bad practice and should be avoided. Is this also applicable if one website links out to different websites with the same C-Block IP? Thus, website A, B and C (on the same server) link to website D (different server) could be seen as spam but is this the same when website D links to website A, B and C?
White Hat / Black Hat SEO | | TT_Vakantiehuizen0 -
LOCAL SEO / Ranking for the difficult 'service areas' outside of the primary location?
It's generally not too hard to rank in Google Places and organically for your primary location. However if you are a service area business looking to rank for neighboring cities or service areas, Google makes this much tougher. Andrew Shotland mentions the obvious and not so obvious options: Service Area pages ranking organically, getting a real/virtual address, boost geo signals, and using zip codes instead of service area circle. But I am wondering if anyone had success with other methods? Maybe you have used geo-tagging in a creative way? This is a hurdle that many local business are struggling with and any experience or thoughts will be much appreciated
White Hat / Black Hat SEO | | vmialik1 -
Redirecting an image url to a more SEO friendly image url
We are currently trying to find the best way of making the images on one of our sites more SEO friendly, the easiest way for us would be to redirect the image URL to a more SEO friendly image URL. For example: http://www.website.com/default/cache/file/F8325DA-0A9A-437F-B5D0A4255A066261_medium.jpg redirects to http://www.website.com/default/cache/file/spiral-staircase.jpg Would Google frown upon this as it's saying the image is one thing and then points the user somewhere else?
White Hat / Black Hat SEO | | RedAntSolutions0 -
On page SEO? (This is good! I promise)
I have been doing some research on onsite optimization and I hit a dead end, need some help with OnSite.... These three I get for the most part... (If you would like to add anything please do) Title optimization - needs to be unique with keywords included under 90 words Meta description - needs to be unique with keywords included under 150 words Meta keywords – all keywords Questions begin here... H1 headings – Should this be the first thing the spider crawls? Should they be unique? Is there a penalty for having this content the same on every page? (H1s are under the logo at the top of every one of my sites pages) H2-H6 headings – Should they be unique? Is there a penalty for having this content the same on every page? Bold text – does this matter for SEO? Italic text - does this matter for SEO? Link anchor text – These are the same on most pages. However, most of these links are part of the navigation, does this matter for SEO? is this duplicate? how does the search engine analyze this data? Image alt attributes – I have the share image buttons on my site (Facebook, Twitter, etc...) and they have the same alt attributes on each page. Does this matter for SEO? Body text – I found a competitor site that’s ranking #1 for a key term. This competitor has 11,106 words in their body with the keyword mentioned 29 times (0.8%). They placed all this text in a small scroll down on the bottom of their page. Its strange how they included it. Please review attached image. the competitor URL is http://www(dot)1804design(dot)com/ w6AiM.png
White Hat / Black Hat SEO | | SEODinosaur0 -
How much pain can I expect if I change the URL structure of the site again?
About 3 months ago I implemented a massive URL structure change by 'upgrading' some of the features of our CMS Prior to this URL's for catergorys and products looked something like this http://www.thefurnituremarket.co.uk/proddetail.asp?prod=OX09 I made a few changes but din't implement it fully as I felt it would be better to do it instages as the site was getting indexed more thouroughly. HOWEVER... We have just hit the first page for some key SERP's and I am wary to rock the boat again by changing the URL structures again and all the sitemaps. How much pain do you think we could feel if i went ahead and optimised the URL's fully? and What would you do? 🙂
White Hat / Black Hat SEO | | robertrRSwalters0