Welcome to the Q&A Forum

Do you mind if I ask who designed the site for you.  Did you do it in house or through an agency?  So hard to find a good designer these days.

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?

I have a client that owns a Video production company.  They have a lot of video examples of all their different types of services i.e. commercial production, TV broadcast production, business videos, training videos, etc.

Where should I host their portfolio of videos, should I:

A:  Use a paid video hosting solution like wistia

B. Upload to youtube or vimeo and embed to my own site

The only videos titles with keywords that I could see bringing any type of conversions for their business would be their demo reels, for example:  "Atlanta Corporate Video Production Demo Reel."  The other videos would be the name of the video "Court TV:  Cop On Trial For Killing Wife" and therefore wouldn't bring the kind of visitors that are searching for a video production service.  This is why I'm curious about what the best hosting option is.

Any advice would be a great help.

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.

With the launch of Google's Penguin I know that footer links could possibly hurt rankings.  Also too many links on a page are also bad.  I have a client http://www.m-scribe.com  That has footer links creating well over 100 links on many of their pages.  How should I handle these footer links?  Suggestions are greatly appreciated.

I have a client that's traffic dropped off on April 10th.  They did get a message in GWT on March 21st.  The April 10th date leads me to believe that it is a manual penalty and couldn't be penguin since penguin was released on April 24th.

I guess either way backlinks need to be cleaned up though.

So my question is, if you are getting guest posts on sites with high Domain Authority, is it really that benefitial since the actual post will have a low page authority?  Is just getting a post on a high domain authority that good?

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?

Is there a way to find out if your site has an over optimization penalty?

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.

By 301'd their way out what do you mean?  Do you have a link to the post I can read?

What about low authority, but highly relevant directories?  What are your thoughts on these types of links?

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 see a lot of opportunity to get lower quality, but highly relevant backlinks, should we try to get these?  I'll give you an example, lets say we have an asphalt paving company ( not a lot of authority blogs out there, that we can find yet)

We found this one http://www.wolfpaving.com/blog/ - DA of 27 and PA 29 should we go after links like this.  I would actually like to know about sites with less authority than this one, I would probably go for this one without question.  So Should we go after worse DA and PA but still legitimate looking sites and highly relevant?

What are your suggestions about moving forward with sites hit by the "Penguin" penalties?

1. Wait it out and see if the penalty goes away
2. Try to remove spammy backlinks and resubmit (is this worth the time and effort)
3. Build quality backlinks to offset (will this even work if they have thousands of spammy links)
4. Blog more (I think this is probably a no brainer)
5. Scrap the site and start from scratch (This is last resort and don't want to do this if at all possible)
6. Or any other ideas are greatly appreciated

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?

I was checking a few of my clients backlinks that recently got hit by the "penguin" update to possibly try and remove some of the potentially spammy links.

I ran reports in both opensiteexplorer.org and majesticseo and majesticseo brings back a ton more links, and these are sites that don't even have the max 10,000 backlinks that OSE should be bringing back.  Does OSE bring back reliable backlink data?  I'm starting to wonder.

The problem I'm running into is that I have an agency, and not all my clients have social media accounts (trying to change that), but nevertheless it's an issue.  I know people on here probably frown upon something like synnd.com, but to do this at scale is there another option? Particularly for clients who don't have social media accounts?

Once your guest posts go live do you do anything to promote them or do you just wait and hope they get indexed?  If so what do you do exactly?

Were you logged into Google when you did this search, when you saw your sites?  If so Google was showing you results based on personal search.  Sites that you've clicked on recently will show up on the first page.

Well yeah you've got to build some high quality relevant links.  Your site is not just going to rank from on page optimization unless it is a very uncompetitive niche.  Which Dentists is probably going to take some linkbuilding.

My guess is that you got hit by the penguin update.  What kind of linkbuilding have you been doing?  Also it would be nice to see the site and no what keywords you were targeting.

Thanks Mcarle.  Great info!!

I own an agency and have several local clients.  Particularly clients in the service areas - Window replacement company, Roofing company, Foreign Car repair company, and an Asphalt paving company.  I really want to run some link bait campaigns, and would love any input you guys might have.  Thanks in advance for your ideas:)