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
-
What is the proper URL length? in seo
i learned that having 50 to 60 words in a url is ok and having less words is preferable by google. but i would like to know that as i am gonna include keywords in the urls and i am afraid it will increase the length. is it gonna slighlty gonna hurt me? my competitors have 8 characters domain url and keywords length of 13 and my site has 15 character domain url and keywords length of 13 which one will be prefered by google.
White Hat / Black Hat SEO | | calvinkj0 -
"Fake" market research reports killing SEO
Our robotics company is in a fast growing, competitive market. There are an assortment of "market research" companies who are distributing press releases about their research reports (which are of less than dubious quality). These announcements end up being distributed through channels with high domain authority. The announcements mention many companies in the space that the purported report covers - including ours. As a result, our company name and product brand is suffering since the volume of press announcements is swamping our ratings. What would you do? Start writing blog postings on topics and post through inexpensive news feeds? Somehow contact the firms posting the contact and let them know they are in violation of our trademarks by mentioning our name? Other ideas?
White Hat / Black Hat SEO | | amelanson1 -
SEO results hacked?
Hi there, Since last Saturday I noticed a big traffic drop on at least the following two pages:
White Hat / Black Hat SEO | | MarcelMoz
http://www.smartphonehoesjes.nl/apple/ and http://www.smartphonehoesjes.nl/apple/iphone-6/. I did some research and I noticed something realy strange. Unknown sites seems to hijacked my organic results by using the exact same page title and META description but leading traffic to another their domain. Look at those pictures: http://imgur.com/v6kglLU and http://imgur.com/Whx4l8K. Edit: a competitor seems to have a same problem: http://imgur.com/Zzhter4. I just fetched both URL's in GWT as Google. In Bing there is a little sign of this problem too, so this is not a Google only thing. Can anybody please help me here? This has cost me some real money since Saturday. Tnx in advance. Marcel0 -
Would having a + plus sign between keywords in meta title have an effect on SEO?
I have seen one of my clients' competitors do this in their meta title and it got me a little intrigued... I understand that google uses the + sign as an operator in adwords, and to a certain extent, as a search tool, but would it help or make any difference to the SEO in the meta title/data (eg. 'SEO+Marketing+Services')? Thanks
White Hat / Black Hat SEO | | LexisClick10 -
Wordpress keeps reinfected
hello my wordpress theme keeps reinfected i dont know were the virus is coming from, they upload archives on ftp and redirects all wordpress pages i installed this pluggin http://sucuri.net what is your opinion about this pluggin my wordpress is all actualized. Any ideas to spot reinfections
White Hat / Black Hat SEO | | maestrosonrisas0 -
Definition of Black Hat SEO
I recently had an old client that called me in a bit of a panic over a significant loss of rankings due to penguin. The internet marketing company she had hired, is actually a very large player in the industry, but because I'm not out to slander anyone, I won't name names. They engaged in some "link building" that resulted in the vast majority of the website's anchor text being keyword-rich, exact match anchor text from such gems as www.link-add.net. They also placed a couple dozen incredibly keyword-rich articles on the site that were clearly not meant for human consumption, and were only accessible through a footer link that's only located on the homepage. The client forwarded me a response from them saying, (quoting verbatim). "We have never engaged in any black hat SEO techniques, nor will we ever engage in any black hat SEO techniques. Just that notion is ridiculous" So clearly, the strategy I outlined above, in the mind of this company, is not black-hat SEO. So getting to my point: **if that's not black hat, then what is? ** I'm posing this question largely because I'm appalled that a large internet marketing company seems to be suggesting that the aforementioned techniques represent good, sound SEO, and I'd like to get an idea as to what people in our industry actually feel are good, acceptable practices. Where is the line? Can we not set higher standards for ourselves?
White Hat / Black Hat SEO | | stevefidelity0 -
Is my SEO strategy solid moving forward (post panda update) or am I doing risky things that might hurt my sites down the road?
Hey all, WIhen I first started doing SEO, I was encouraged by several supposed experts that it was a good idea to buy links from "respectable" sources and as well make use of SEO experimentation offered on Fiverr. I did that a lot for the clients I represented not knowing if this was going to hurt. But now after the latest Google shift, I am realizing that this was stupid and thus deserving of the ranking drops I have received. In the aftermath, I want to list out here what I am doing now to try to build better and stronger rankings for my sites using white hat techniques only... Below is a list of what I'm doing. Please let me know if any of these are bad choices and I will immediately dump them. Also, If i am not including some good options, please let me know that too. I am really embarrassed and humbled by this and could use whatever help you can offer. Thanks in advance for your help... What am I doing now? *Writing quality articles for external blogs with keyword links back to sites *Taking the above articles and spinning them at SEOLINKVINE to create several articles *Writing quality articles for every site's internal blog and using keywords to link out to other sites that are on different servers - All articles are original, varied and not duplicate content. *Writing quality, relevant articles and submitting them to places like Ezine *Signing clients up for Facebook, Yelp, Twitter, etc so they have a social presence *Working to fix mistakes with onsite issues (mirror sites, duplicate page titles, etc.) *Writing quality keyword-rich unique content on each page of each site *Submitting URL listings and descriptions to directories like JoeAnt, REALS and business.com (Any other good ones that people can recommend that give good link juice?) *Doing competitive research and going after highly authoritative links that our competitors have That is about it... HELP!!! Thanks again
White Hat / Black Hat SEO | | creativeguy0 -
Seo style="display: none;" ?
i want to have a funktion which shortens text in categorie view in my shop. apple is doing this in their product configurator see the "learn more" button at the right side: http://store.apple.com/us/configure/MC915LL/A apple is doing this by adding dynamic content but i want it more seo type by leaving the content indexable by google. i know from a search that this was used in the past years by black had seos to cover keywordstuffing. i also read an article at google. i beleive that this is years ago and keywordstuffing is completly no option anymore. so i beleive that google just would recognise it like the way its meant to be. but if i would not be sure i would not ask here 🙂 what do you think?
White Hat / Black Hat SEO | | kynop0