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 that trailing slashes necessity for an SEO doing blogs
Hi, I have a website, https://australiatimenow.com.au/ I would like to remove the trailing slash and move to .HTML formal. I have never done SEO on my articles. Is that, any issue causes if I move to .HTML format?
White Hat / Black Hat SEO | | joshnajenny0 -
Is toggle Good For seo
Hi there, I have Client Who dont want to show his content to publicly, So team decided to use toggle, So Google can also See Content, But i want bu sure. Does Google will really cache that Content?? Does it down my website Ranking?? Please any one can Help, I need urgent basis Thnx in advance Falguni
White Hat / Black Hat SEO | | iepl20010 -
Pharma Hack/Grey hat SEO. Cannot get site to rank, tons of incoming bad links
I have been working on a website trying to get it to show up in the SERPs again. It is being indexed which is great, it has some errors that I'm fixing now. But for the most part it should be ranking. It don't show any penalties going on, but when I did a backlink search we keep getting the cialis, viagra etc inbound links. First thought was Pharma Hack. But it's not a WP site and I recently rebuilt it. So whatever bad code could have been there it's not anymore. It doesn't show up in google either for the search site:www.mysite.com viagra cialis etc... So I'm wondering if anyone has any insight in a direction to point me? I don't understand what would be causing this to still not rank. Only thing it ranks for is it's name. Any suggestions would be very appreciated.
White Hat / Black Hat SEO | | WeBuyCars.com0 -
SEO Company claiming our results?
This company http://www.synapseinteractive.com/portfolio/kempnrugelawgroup.php is linking to us, with a bs graphic about how they improved our rankings for some keywords. I have no idea who this company is. Does this happen often? Also, I'm tempted to contact them to take it down, but I really don't need some questionable company getting annoyed and then linking 10,000 spam sites to me. Any thoughts on what to do? I'm tempted to just do nothing, but for I ignore it, I want to make sure there's insidious about this link that would cause me any problems down the road. No, I haven't got any GWT or BWT messages about it. Thanks, Ruben
White Hat / Black Hat SEO | | KempRugeLawGroup0 -
SEO best practice: Use tags for SEO purpose? To add or not to add to Sitemap?
Hi Moz community, New to the Moz community and hopefully first post/comment of many to come. I am somewhat new to the industry and have a question that I would like to ask and get your opinions on. It is most likely something that is a very simple answer, but here goes: I have a website that is for a local moving company (so small amounts of traffic and very few pages) that was built on Wordpress... I was told when I first started that I should create tags for some of the cities serviced in the area. I did so and tagged the first blog post to each tag. Turned out to be about 12-15 tags, which in turn created 12-15 additional pages. These tags are listed in the footer area of each page. There are less than 20 pages in the website excluding the tags. Now, I know that each of these pages are showing as duplicate content. To me, this just does not seem like best practices to me. For someone quite new to the industry, what would you suggest I do in order to best deal with this situation. Should I even keep the tags? Should I keep and not index? Should I add/remove from site map? Thanks in advance for any help and I look forward to being a long time member of SEOMoz.
White Hat / Black Hat SEO | | BWrightTLM0 -
Banner Ads help seo?
I see in OSE banner ads counting ads as incoming links - My question is has anyone done a study showing a non tagged banner ad link and its effects on seo? Does google counting it as organic since it has no tagging or since its in a ad spot its ignored?
White Hat / Black Hat SEO | | DavidKonigsberg0 -
Is our sub-domain messing up our seo for our root?
We have a website (mysite.com) that we control and a subdomain (affiliate.mysite.com) that is 3rd-Party Content completely out of our control. I've found that nearly all or our Crawl Errors are coming from this subdomain. Same deal with 95% of our warnings: they all come from the subdomain. The two website are very much interlinked, as the subdomain serves up the header and footer of the root domain through iFrames and the 3rd-party content in the middle-section. On the root domain there are countless links pointing at this 3rd-party subdomain. How do these errors affect the root domain, and how do you propose we address the issue?
White Hat / Black Hat SEO | | opusbyseo0 -
Is this SEO correct?
Please view website http://www.staddonsbeds.co.uk. In the footer is the keywords the client is aiming for. These pages have been created separately to the sitemap. Is this tactic and pages white hat seo or is this considered black hat seo such as gateway pages? Could you please confirm Thanks Paul
White Hat / Black Hat SEO | | paulbaguley0