Welcome to the Q&A Forum
Browse the forum for helpful insights and fresh discussions about all things SEO.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
Any idea on what to suggest they write about? All of the franchisees are not my clients, but nevertheless I imagine the duplicate content is pulling my clients rankings down. Also if I could get this project that means more money:)
I have a client that owns one franchise location of a franchise company with multiple locations. They have one large site with each location owning it's own page on the site, which I feel is the best route. The problem is that each location page has basically duplicate content on each page resulting in like 80 pages of duplicate content.
I'm looking for advice on how to create unique content for each location page? What types of information can we write about to make each page unique, because you can only twist sentences and content around so much before it just all sounds cookie cutter and therefore offering little value.
What about with your guest posting? Are you using anchor text or branded terms?
How do you target other keyword phrases that a page is not totally targeted for when Google also doesn't want a bunch of pages on a site that target slightly different but simliar keyword phrases? Is this a matter of creating great content i.e. blog posts, linkbait, etc. that target those different pages?
What if the anchor text has a lot of variation but they are still exact keyword phrase, just a lot of different ones?
Hey Ryan,
Have you read this post by Dr. Pete http://www.seomoz.org/blog/penguins-pandas-and-panic-at-the-zoo#jtc180593? Wanted to get your thoughts on his suggestion not to submit for reconsideration.
My plan is to put all the root domains into http://netpeak.net/software/netpeak-checker/ check for PR main, status code, index, PA and DA. Then put them into Buzzstream which should go out and find the info for you. Then grab all the links from each spammy domain and provide them in the email to the webmaster to make them easier to remove. Hopefully this will make it a little more efficient.
Thanks Ryan you've given me a lot to work with. Hell if I get good at this I might just create a whole new service for my agency lol.
Oh one more question and then I'll leave you alone. What about sites that haven't been hit yet, but have used similar tactics? Would you start this process for them? Or cross fingers?
Yeah this all came right around "Penguin" so I'm fairly certain it's related. They do have a lot of exact anchor text too, but for a wide variety of terms. They were also using blog networks, and have spammy links, so it's really hard to pinpoint which of these or if all of them are the problem.
At any rate should this be my process?
Hopefully that will do it. What do you think of this process? Oh and Thank you very much for your help You're awesome.
Got another question for you. Do we even bother trying to get links from deindexed sites taken off or do you think Google takes those into account with the penalty?
I have some clients that recently got hit by "Penguin" they have several less than desireable backlinks that could be the issue? Does anyone have any suggestions on getting these removed? What are the odds that a webmaster on these spammy sites are going to remove them, and is it worth the time and effort?
Wow great info Ryan. Is there a way to know for sure that a website has been penalized by Google and if this process needs to be started?
Yeah this all came right around "Penguin" so I'm fairly certain it's related. They do have a lot of exact anchor text too, but for a wide variety of terms. They were also using blog networks, and have spammy links, so it's really hard to pinpoint which of these or if all of them are the problem.
At any rate should this be my process?
Hopefully that will do it. What do you think of this process? Oh and Thank you very much for your help You're awesome.
7/6/2012 A comprehensive Excel spreadsheet template that can be easily duplicated and handed off to an outsourcer for webmaster outreach to get links removed.