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
-
'SEO Footers'
We have an internal debate going on right now about the use of a link list of SEO pages in the footer. My stance is that they serve no purpose to people (heatmaps consistently show near zero activity), therefore they shouldn't be used. I believe that if something on a website is user-facing, then it should also beneficial to a user - not solely there for bots. There are much better ways to get bots to those pages, and for those people who didn't enter through an SEO page, internal linking where appropriate will be much more effective at getting them there. However, I have some opposition to this theory and wanted to get some community feedback on the topic. Anyone have thoughts, experience, or data to share on this subject?
White Hat / Black Hat SEO | | LoganRay1 -
Best Link Building Strategies in Modern SEO
Hello, In light of all the updates and also in guest blogging being only for nofollow links now, what's some of the best strategies for link building for ecommerce sites? We're in an industry where the content doesn't get linked to very much. Thanks.
White Hat / Black Hat SEO | | BobGW0 -
Bay Area SEO Agency
Hi, Can anyone help with recommendations on good SEO agencies based in the Bay Area who have some history of working with gaming or adult brands which have been badly hit by rankings falls in the past 12 months, we suspect due to Penguin. Thanks
White Hat / Black Hat SEO | | BetAmerica0 -
Website "A Record" in DNS - Geotargetting
Hi, Our online shop is hosted with a French IP address. It is available in English and Spanish. I have noticed, as to be expected, that we get quite a few french visitors, probably related to our IP address Google must think its geo related. We don't want to particularly target any specific country, but more so english and spanish speakers. Can you have various A records around the world to help with this? Any suggestions or things I could look into?? thanks
White Hat / Black Hat SEO | | bjs20100 -
Which SEO companies offer Penalty analysis?
I'm having a hard time finding a (good) SEO company which specializes itself in Penalty analysis? Any recommendations? I only found Bruce Clay, but they charge 8,000$ :)...
White Hat / Black Hat SEO | | wellnesswooz0 -
Explain To Me How Negative SEO ISNT Real?
I'm seeing lots of "offers" springing up to do negative SEO on your competitors. I know people keep insisting this sort of thing is just a bogeyman, but follow my logic here: We know the Penguin update PENALIZED, and not just devalued "over optimization." Read: exact match keyword links. We know that if your link profile is too "unnaturally" keyword heavy, (it should be majority your brand or your domain or your company name, etc) you get penalized. Again, not devalued, PENALIZED. Ok. So what is to stop a blackhatter from using one of those software bots to just kill a competitor? Knowing the above two points, lets say a website is ranking for "cool widgets". Why not just create a bunch of exact match keyword spam links for "cool widgets" targeting that website. In a while, the Penguin penalty kicks in and bammo. The thing that scares me about the post Penguin landscape is that google has specifically named an activity ("over optimization") that will get you PENALIZED. So, don't do that, right? Except, that means they've explicitly outlined an activity that will be penalized, and is easy for others to do to you, and that you would be powerless to prevent. I await the usual "this is an age old worry that has never come true" replies. But if you reply that way, ask yourself, can you refute the logic of the points above? And also... oh no... It's happening. I'm seeing it.
White Hat / Black Hat SEO | | brianmcc1 -
What do you think of Theme pyramids for SEO?
Hi, Just been reading up on theme pyramids, I have seen these before but found a good article on the subject going into quite some detail. http://www.canonicalseo.com/theme-pyramids/ Using the word 'Pyramid' does scream black hat to me but looking at the structure, this must be the best way for internal linking. Even the keyword structure looks good, Example: homepage - shoes category - red shoes sub category - size 7 red shoes Building anchor text links for shoes, red shoes or size 7 red shoes will benefit all 3 terms. Negative/Positive comments please.
White Hat / Black Hat SEO | | activitysuper0 -
Help for a complete SEO newbie!
Hi all, I've just joined seomoz today to try and further my very young education on SEO. My major problem is i need my site to rank high in local search engines but feel that none of the customers read much of the content as i am a landscaper and feel they just search "landscaping in Newcastle" and are immediatly looking for a contact number to arrange a free estimate. I dont do any online sales, its just to generate leads. I've spent alot of time building a better site than my local competitors but they still out rank me on alot of keywords i.e. "Driveways in Gateshead" My question is do i keep adding more and more content hoping this will work long term or do i link build with anchor text etc or both? I cannot believe they still out rank me when i feel i have more links more anchor text and a load more origional content and images. I think it may be that my site is still under 1 year old. I feel i am boucing from content to link building then trying something else without any real knowlegde of what i really should be doing or what should be the priority at this young stage for my site. I have managed to get on page 1 of google for most of my keywords in local searches ( obviously not national) but still feel its been more down to luck and effort than actually knowing what i am doing when it comes to site and offsite optimization Any help, tips etc would be greatly appreciated. Many thanks John
White Hat / Black Hat SEO | | totaldriveways0