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.
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
-
Should I noindex shop page and blog page for SEO?
I have about 15 products in my store. Should I noindex shop and blog page for SEO? The reason I ask this question is because I see someone suggesting noindex archives pages. And the shop page is product archive and blog page is archive too, so should I choose index or noindex? Thanks!
White Hat / Black Hat SEO | | Helloiamgood0 -
How much value does these have on SEO?
how much value doesn't having an address a phone numbe an https rather than http i appreciate any help.
White Hat / Black Hat SEO | | BobAnderson0 -
Change domains and start over?
We have a fairly new client who has taken part in many questionable SEO technique over the past few years (mainly buying links and directory web pages). In an effort to fix this they hired three separate SEO’s – we are the fourth. Over the past 3 months we have spent lots of time following best practice techniques to clean up and improve their rankings (including link removal requests but not yet disavow), and after some initially positive results, things are looking down again. Given Google’s apparent rolling algorithm updates and the mess we have found, we are wondering if the best option is to change domains and start over (downside is that they are in a highly competitive industry)? My other question pertains to a domain change and if we were to change from a plural to a singular, would that be enough for Google? (e.g from www.domains.com to www.domain.com). The idea is that we start the link building process again – but keep their brand intact. Really appreciate any feedback.
White Hat / Black Hat SEO | | E2E0 -
Competitor Bad Practice SEO Still Ranking Well But Why ?
Moz Friends, A very close competitor have always been challenging for similar competitive keywords. We seem to have the advantage for alot of long tail keywords but on one of the higher traffic relevant keywords they seem to do well. I really struggle to understand why, particularly with the back links they use Just my thoughts and notes on the two: Our Page Better written text content (Maybe slightly written to for experienced target audience but we are working on simplifying things) Good Clear site URL structure and navigation for usability Fresh content updates Mobile optimized Reasonable page speeds Good on-page optimization Good back links from industry influences Competitor Page Negatives Site structure and URL's are inconsistent and messy Lower quality content site wide They use tried and tested on page optimization methods like Keyword spamming, Bold Keywords,Underlining Keywords (Sarcasm) Terrible back links, all directories and free article submission sites (Seriously take a look) Less focused on page optimization Not mobile optimized Most of the rest of the sites carry on the same sort of differences, Engine: www.google.co.uk Keyword: Sound level meters **Our Page: **www.cirrusresearch.co.uk/products/sound-level-meters/ **Competitor Page: **www.pulsarinstruments.com/product-information/Sound-Level-Meter.html Any feedback would be greatly appreciated please, i am really struggling to get my head around this Thanks James
White Hat / Black Hat SEO | | Antony_Towle1 -
Changing url to recover from algorythmic penalty
Hello, If I think that a website was hit algorithmically, I would like to buy a new domain name and publish all the content from the first website there. I will take the first site down and this one would be the only one this content. Will Google see that it's the same content than a penalized website posted before and will penalize the new domain name even though it has 0 links pointing to it? Regards.
White Hat / Black Hat SEO | | EndeR-0 -
A case of negative SEO?
We came across today some very strange forum postings. Essentially they look like some nonsense text followed by a list of "adult" terms. In the middle of the list, completely randomly and strangely our brand terms appear in the list. There are no links to anything. The only thing I can think of is that someone is trying to make our brand terms algorithmically associated with questionable "red flag" terms in the eyes of search engines. I have no idea why else this would be happening. Could this be a case of some kind of Fiverr negative SEO attack? Is there any risk? Doesn't seem like anything we can do about it...
White Hat / Black Hat SEO | | edu-SEO0 -
Preparing for Penguin: Delete or Change to Branding 25 small blogs, anchor text
Hello, This site has 80 root domains pointing to the domain, call it site X. 25 of them are tiny blogs the owner put up himself. The blogs consist only of 4 posts or so, where each post has a 2 keyword anchor text links to each one of his 4 sites. One link in each post goes to the home page and one goes to an internal page. Let's concern ourselves with cleaning up the anchor text profile of site X. All blogs are on private registration. Half of the blog domain names are furniture related and furniture is not relevant to this niche. But 3/4 to 3/5 of the content of each blog (2 paragraphs per post and 4 posts) is relevant. My concern is that even though the anchor text is varied and there's only 2 links going out to site X per blog, none of it is branded and so I'm concerned about Penguin type updates. Should we change these to branded or delete them? We're working on content promotion for backlinks in case we have to delete these blogs, but it's a small budget. What should we do? '
White Hat / Black Hat SEO | | BobGW0 -
What if White Hat SEO does not get results?
If company A is paying 5k a month and some of that budget is buying links or content that might be in the gray area but is ranking higher than company B that's following the "rules" and paying the same but not showing up at all, what's company B suppose to do?
White Hat / Black Hat SEO | | EmarketedTeam2