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
-
Does same description in the directories of all affect SEO or not? - But unique on the website
Hi, I would like to do some directories. When I checked with a person for his recent work, he has given the same description in 50 directories he has done for a client. Does this affect SEO or not?
White Hat / Black Hat SEO | | AnuManish0 -
Canonical tag On Each Page With Same Page URL - Its Harmful For SEO or Not?
Hi. I have an e-commerce project and they have canonical code in each and every page for it's own URL. (Canonical on Original Page No duplicate page) The url of my wesite is like this: "https://www.website.com/products/produt1"
White Hat / Black Hat SEO | | HuptechWebseo
and the site is having canonical code like this: " This is occurring in each and every products as well as every pages of my website. Now, my question is that "is it harmful for the SEO?" Or "should I remove this tags from all pages?" Is that any benefit for using the canonical tag for the same URL (Original URL)?0 -
Are businesses still hiring SEO that use strategies that could lead to a Google penalty?
Is anyone worried that businesses know so little about SEO that they are continuing to hire SEO consultants that use strategies that could land the website with a Google penalty? I ask because we did some research with businesses and found the results worrying: blog farms, over optimised anchor text. We will be releasing the data later this week, but wondered if it something for the SEO community to worry about and what can be done about it.
White Hat / Black Hat SEO | | williamgoodseoagency.com0 -
Negative SEO from Spammers Killing Client Rankings
Hi - I have identified a client website which was; a ) hacked and had several fraudulent pages added e.g. www.xxx.com/images/uggaustralia.html added which have 301 redirect links to another fraudulent websites. b) had an auto generated back link campaign (over 12k back links at present) with targeted anchor text at cheap ugg boots, ugg sale etc. I've removed the dodgy redirect web pages and also undertook a link audit using Google WMT, OSE and Seo Majestic and have disavowed all the spammy links at domain level. Consequently my client has dropped from top three for the key phrase to #9. Google WMT now sees ugg boots uk, ugg boots sale etc. as some of the most popular anchor text for the site even though it's blatantly obvious that the site has nothing to do with Ugg boots. No manual webspam penalties are in place however the auto generated anchor text campaign is still ongoing and is generating more spammy links back to non existent web pages - which still Google appears to be picking up. Question is - how long do you reckon it will take for the links to disappear and is there anything I can speed Google along as this issue if not of my making? p.s. For the record I've found at least 500 sites that have been targeted by this same campaign as well.
White Hat / Black Hat SEO | | Door4seo0 -
Redirecting old domains for SEO ranking?
It's been a while since I read anything seriously out of the box on SEO but I thought I would see what others thought of the bold assertions made in this article. Most of it revolves around buying expired domains and using a 301 to point them, and their juice, to new sites. This guy makes a living doing this so he has to know a bit more than the average Joe but I'm wondering where the other shoe is and when it drops.
White Hat / Black Hat SEO | | Highland0 -
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 -
SEO problems with PR Newswires
Just been investigating PR newswires for the first time (despite having worked in PR for over a decade!) One of my clients has asked my to send out a news release via a newswire of my choice. I will not be posting the news release on my client's website, to avoid the most obvious duplication issue. Has anyone had SEO probs from newswires though? I just saw one which offered: "Minimum guaranteed number of media websites on which your release is posted" alarm bells!
White Hat / Black Hat SEO | | McTaggart0 -
EXPERT CHALLENGE: What link building strategies do YOU think will work after the latest 3/29/2012 Google algorithm change?
FOR ALL SEO THOUGHT LEADERS...What link building strategies do YOU think will work after the latest 3/29/2012 Google algorithm change? NOTE: My hope is that the responses left on this thread will ultimately benefit all members of the community and give recognition to the true thought leaders within the SEO space. That being said, my challenge is a 2 part question: With the 80/20 rule in mind, and in light of recent algorithm changes, what would YOU focus most of your SEO budget on if you had to choose? Let's assume you're in a competitive market (ie #1-5 on page 1 has competitors with 20,000+ backlinks - all ranging from AC Rank 7 to 1). How would you split your total monthly SEO budget as a general rule? Ex) 60% link building / 10% onsite SEO / 10% Social Media / 20% content creation? I realize there are many "it depends" factors but please humor us anyways. Link building appears to have become harder and harder as google releases more and more algorithm changes. For link building, the only true white hat way of proactively generating links (that I know of) is creating high quality content that adds value to customers (ie infographics, videos, etc.), guest blogging, and Press Releases. The con to these tactics is that you are waiting for others to find and pick up your content which can take a VERY long time, so ROI is difficult to measure and justify to clients or C-level management. That being said, how are YOU allocating your link building budget? Are all of these proactive link building tactics a waste of time now? I've heard it couldn't hurt to still do some of these, but what are your thoughts and what is / isn't working for you? Here they are: A. Using spun articles edited by US based writers for guest blog content B. 301 Redirects C. Social bookmarking D. Signature links from Blog commenting E. Directory submissions F. Video Submissions G. Article Directory submissions H. Press release directory submissions I. Forum Profile Submissions J. Forum signature links K. RSS Feed submissions L. Link wheels M. Building links (using scrapebox, senukex, etc.) to pages linked to your money site N. Links from privately owned networks (I spoke to an SEO company that claims to have over 4000 unique domains which he uses to boost rankings for his clients) O. Buying Contextual Text Links All Expert opinions are welcomed and appreciated 🙂
White Hat / Black Hat SEO | | seoeric2