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?

1. Resubmit to Google
2. See if they answer back and with what
3. If no answer proceed with removal
4. Get links from webmaster tools
5. Parse out Root linking Domains
6. Run through Netpeak Checker (awesome tool if you haven't used it) finds PR, SEOmoz stats, Google index, status code, etc.
7. First remove all PR 0 and live pages
8. Resubmit to Google
9. Second remove all deindexed PR 0
10. Resubmit to Google
11. Get other link source data (Majestic SEO, Opensite Explorer)
12. Remove PR 0 links
13. Resubmit to Google

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?

So Ryan in your opinion if they saw some major drops in rankings you would think it would be a safe bet that the site was penalized?

They were also using Blog networks that got shut down, so those links have obviously been deindexed and therefore have no value which would drop the rankings anyway.  That's the tricky part is the drop in rankings because the blog networks are gone or they are penalized.

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?

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?