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
-
Changing Links to Spans with Robots.txt Blocked Redirects using Linkify/jQuery
Hi, I was recently penalized most likely because Google started following javascript links to bad neighborhoods that were not no-followed. The first thing I did was remove the Linkify plugin from my site so that all those links would disappear, but now I think I have a solution that works with Linkify without creating crawlable links. I did the following: I blocked access to the Linkify scripts using robots.txt so that Google won't execute the scripts that create the links. This has worked for me in the past with banner ads linking to other sites of mine. At least it appears to work because those sites did not get links from pages running those banners in search console. I created a /redirect/ directory that redirects all offsite URLs. I put a robots.txt block on this directory. I configured the Linkify plugin to parse URLs into span elements instead of a elements and add no follow attributes. They still have an href attribute, but the URLs in the href now point to the redirect directory and the span onclick event redirects the user. I have implemented this solution on another site of mine and I am hoping this will make it impossible for Google to categorize my pages as liking to any neighborhoods good or bad. Most of the content is UGC, so this should discourage link spam while giving users clickable URLs and still letting people post complaints about people that have profiles on adult websites. Here is a page where the solution has been implemented https://cyberbullyingreport.com/bully/predators-watch-owner-scott-breitenstein-of-dayton-ohio-5463.aspx, the Linkify plugin can be found at https://soapbox.github.io/linkifyjs/, and the custom jQuery is as follows: jQuery(document).ready(function ($) { 2 $('p').linkify({ tagName: 'span', attributes: { rel: 'nofollow' }, formatHref: function (href) { href = 'https://cyberbullyingreport.com/redirect/?url=' + href; return href; }, events:{ click: function (e) { var href = $(this).attr('href'); window.location.href = href; } } }); 3 });
White Hat / Black Hat SEO | | STDCarriers0 -
Negative seo by Shady SEO Firm?
Recently a former client of man called me up and said that his rankings for his Auto Repair Shop in Tacoma WA had dropped and he had his worst November in sales since they hired this new SEO firm to rebuild their website and provide SEO. Of course the first thing I did was check his back links and sure enough there are 22 links from Yellowbook.com all pointed to different cities I checked the SEO firms website and they and they had 4 links from YellowBook. The problem was the links from YellowBook were all optimized from different cities. I am pretty sure Google penalized my client for the unnatural back-links to YellowCrook.com. Does the community agree that these links caused the penalty? I included the links in pictures on my LinkedIn Profile. https://www.linkedin.com/pulse/case-study-how-google-erased-60-percent-revenue-from-small-meshach?published=t Here are the links. <colgroup><col width="202"> <col width="545"></colgroup>
White Hat / Black Hat SEO | | DavidMeshah
| http://www.yellowpages.com/seattle-wa/automotive |
| http://www.yellowpages.com/seattle-wa/auto-transmission | Auto Transmission in Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/kent-wa/auto-repair-service | Auto Repair Service in Kent, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/seattle-wa/truck-service-repair | Truck Service Repair in Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/lower-queen-anne-seattle-wa/truck-service-repair | Truck Service Repair in Lower Queen Anne Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/bonney-lake-wa/mechanic | Mechanic in Bonney Lake, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/seattle-wa/auto-mechanics | Auto Mechanics in Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/shoreline-wa/auto-transmission | Auto Transmission in Shoreline, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/kent-wa/auto-repair | Auto Repair in Kent, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/lynnwood-wa/auto-transmission | Auto Transmission in Lynnwood, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/monroe-wa/auto-repair-service | Auto Repair Service in Monroe, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/auburn-wa/auto-repair-service | Auto Repair Service in Auburn, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/redmond-wa/auto-repair-service | Auto Repair Service in Redmond, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/matthews-beach-seattle-wa/auto-repair-service | Auto Repair Service in Matthews Beach Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/kent-wa/auto-transmission | Auto Transmission in Kent, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/monroe-wa/truck-service-repair | Truck Service Repair in Monroe, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/wilburton-bellevue-wa/auto-repair-service | Auto Repair Service in Wilburton Bellevue, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/laurelhurst-seattle-wa/auto-repair-service | Auto Repair Service in Laurelhurst Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/seattle-wa-98166/auto-oil-lube |
| http://www.yellowpages.com/gig-harbor-wa/auto-oil-lube | Auto Oil Lube in Gig Harbor, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/northeast-seattle-seattle-wa/auto-repair-service | Auto Repair Service in Northeast Seattle Seattle, Washington with Reviews & Ratings - YP.com |
| http://www.yellowpages.com/auburn-wa/auto-transmission |
| http://www.yellowpages.com/burien-wa/automotive | Automotive in Burien, Washington with Reviews & Ratings - YP.com |0 -
Unique page URLs and SEO titles
www.heartwavemedia.com / Wordpress / All in One SEO pack I understand Google values unique titles and content but I'm unclear as to the difference between changing the page url slug and the seo title. For example: I have an about page with the url "www.heartwavemedia.com/about" and the SEO title San Francisco Video Production | Heartwave Media | About I've noticed some of my competitors using url structures more like "www.competitor.com/san-francisco-video-production-about" Would it be wise to follow their lead? Will my landing page rank higher if each subsequent page uses similar keyword packed, long tail url? Or is that considered black hat? If advisable, would a url structure that includes "san-francisco-video-production-_____" be seen as being to similar even if it varies by one word at the end? Furthermore, will I be penalized for using similar SEO descriptions ie. "San Francisco Video Production | Heartwave Media | Portfolio" and San Francisco Video Production | Heartwave Media | Contact" or is the difference of one word "portfolio" and "contact" sufficient to read as unique? Finally...am I making any sense? Any and all thoughts appreciated...
White Hat / Black Hat SEO | | keeot0 -
Preparing for Penguin: Remove, Disavow, or change to branded
For someone that has 80 root domains pointing to their domain and 10 of them are sitewide backlinks from 10 PR4+ sites. All paid for. All with the same main keyword anchor text Should I advise him to remove the links, dissavow the links, dissavow then remove or just change to branded anchor text for the 10 sitewide links. Another option is to just keep one link (preferrably editorial) from each site. The only reason not to pull them off right away is that the client could not sustain his business with a drop in sales. These are by far the strongest 10 root domains. Eventually, when he has enough good backlinks these are all coming off. There was a huge drop in sales for this site last fall, but it recovered almost completely by changing keyword stuffing and adding ecommerce content. Looking to keep his sales and also prepare for this years updates.
White Hat / Black Hat SEO | | BobGW0 -
Off-page SEO and link building
Hi everyone! I work for a marketing company; for one of our clients' sites, we are working with an independent SEO consultant for on-page help (it's a large site) as well as off-page SEO. Following a meeting with the consultant, I had a few red flags with his off-page practices – however, I'm not sure if I'm just inexperienced and this is just "how it works" or if we should shy away from these methods. He plans to: guest blog do press release marketing comment on blogs He does not plan to consult with us in advance regarding the content that is produced, or where it is posted. In addition, he doesn't plan on producing a report of what was posted where. When I asked about these things, he told me they haven't encountered any problems before. I'm not saying it was spam-my, but I'm more not sure if these methods are leaning in the direction of "growing out of date," or the direction of "black-hat, run away, dude." Any thoughts on this would be crazy appreciated! Thanks, Casey
White Hat / Black Hat SEO | | CaseyDaline0 -
Explain To Me How Negative SEO ISNT Real?
I'm seeing lots of "offers" springing up to do negative SEO on your competitors. I know people keep insisting this sort of thing is just a bogeyman, but follow my logic here: We know the Penguin update PENALIZED, and not just devalued "over optimization." Read: exact match keyword links. We know that if your link profile is too "unnaturally" keyword heavy, (it should be majority your brand or your domain or your company name, etc) you get penalized. Again, not devalued, PENALIZED. Ok. So what is to stop a blackhatter from using one of those software bots to just kill a competitor? Knowing the above two points, lets say a website is ranking for "cool widgets". Why not just create a bunch of exact match keyword spam links for "cool widgets" targeting that website. In a while, the Penguin penalty kicks in and bammo. The thing that scares me about the post Penguin landscape is that google has specifically named an activity ("over optimization") that will get you PENALIZED. So, don't do that, right? Except, that means they've explicitly outlined an activity that will be penalized, and is easy for others to do to you, and that you would be powerless to prevent. I await the usual "this is an age old worry that has never come true" replies. But if you reply that way, ask yourself, can you refute the logic of the points above? And also... oh no... It's happening. I'm seeing it.
White Hat / Black Hat SEO | | brianmcc1 -
SEO Experiment with Google Docs
Please check out this doc - https://docs.google.com/document/d/19VS4SnVvq6VJHQAIrB3CX7iL1ivZU4DH6fyfrHLsNFk/edit Any insights will be highly appreciated! Oleksiy
White Hat / Black Hat SEO | | wcrfintl0