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
-
Is domain redirection a good method for SEO?
I have a question and need suggestion from you guys. I’ve searched for my question on Google but don’t get exact information what I need. Maybe I can’t search perfectly.
White Hat / Black Hat SEO | | kamishah
Let me explain my confusion:
I’ve checked backlink profile of a website. He is not using his main domain while doing comment backlink. He put his another domain while doing comment backlink. The another domain redirect to the main domain. Why he use another domain while doing comment backlink?
Is it helpful to get better rank on Google? For example: My Main Domain = solutionfall.com
Another Domain= xyz.com (It redirect to solutionfall.com)
He just uses xyz.com while doing comment backlink. Thank You so much1 -
White H1 Tag Hurting SEO?
Hi, We're having an issue with a client not wanting the H1 tag to display on their site and using an image of their logo instead. We made the H1 tag white (did not deliberately hide with CSS) and i just read an article where this is considered black hat SEO. https://www.websitemagazine.com/blog/16-faqs-of-seo The only reason we want to hide it is because it looks redundant appearing there along with the brand name logo. Does anyone have any suggestions? Would putting the brand logo image inside of an H1 tag be ok? Thanks for the help
White Hat / Black Hat SEO | | AliMac261 -
It's possible a bounce-rate attack manipulate SEO?
My site has been visited by unusual users with one second session times. This leaves my analytics data confused.
White Hat / Black Hat SEO | | CompraBit0 -
How do I deal with Negative SEO (Spammy Links)?
For the past 12 months, our website has been hit by spammy links with annoying anchor text. We suspected one of our competitor are deploying negative SEO on us. The image is an example of the sites and anchor text we have been spammed with. The frequency is about 1 - 2 spammy links a day. I have a few questions from here onwards: Does those links affect our SEO? (Most are mainly nofollow) Other than disavow, what other stuff can I do? How will google and other search engines see this incident? TcmFsti
White Hat / Black Hat SEO | | Changsst0 -
SEO companies that own linking properties
Hi everyone, I do some SEO work for a personal injury attorney, and due to his profession, he gets cold-called by every digital marketing company under the sun. He recently got called by a company that offers packages that include posting in multiple directories (all on domains they own), creating subdomains for search listings, and PR services like writing and distributing press releases for distribution to multiple media outlets. The content they write will obviously not be local. All this and more for less than $500 a month! I'm curious if any of you have any experience with companies like this and whether you consider them black hat. I realize I'm asking you to speculate on a very broad description of what they offer, but their linking strategies sound risky to me. What experiences have you had with companies like this? Do you know anyone who has ever gotten a penalty using these tactics? Thanks, in advance, for sharing your thoughts.
White Hat / Black Hat SEO | | ptdodge0 -
Many Regional Pages: Bad for SEO?
Hello Moz-folks We are relatively well listed for "Edmonton web design." - the city we work out of. As an effort to reach out new clients, we created about 15 new pages targeting other cites in Alberta, BC and Saskatchewan. Although we began to show up quite well in some of these regions, we have recently seen our rankings in Edmonton drop by a few spots. I'm wondering if setting up regional pages that have lots of keywords for that region can be detrimental to our overall rankings.Here is one example of a regional page: http://www.web3.ca/red-deer-web-design Thanks, Anton TWeb3 Marketing Inc.
White Hat / Black Hat SEO | | Web3Marketing870 -
href="#" and href="javascript.void()" links. Is there a difference SEO wise?
I am currently working a site re-design and we are looking at if href="#" and href="javascript.void()" have an impact on the site? We were initially looking at getting the links per page down but I am thinking that rel=nofollow is the best method for this. Anyone had any experience with this? Thanks in advanced
White Hat / Black Hat SEO | | clickermediainc0 -
SEO dead?
What does everyone think about this article? http://www.forbes.com/sites/kenkrogue/2 … l-content/ I tend to think its off base, Link building still works and there are tons of things that have to do with SEO that have nothing to do with link building... I think its actually quite ridiculous and written by people that actually no nothing about SEO...kind of a lame attempt by Forbes, and if anything at all, this is just forbes practicing "SEO" with a link attraction post like this. Becase SEO, is NOT dead
White Hat / Black Hat SEO | | imageworks-2612901