Welcome to the Q&A Forum

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.

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?

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

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? Wait it out and see if the penalty goes away Try to remove spammy backlinks and resubmit (is this worth the time and effort) Build quality backlinks to offset (will this even work if they have thousands of spammy links) Blog more (I think this is probably a no brainer) Scrap the site and start from scratch (This is last resort and don't want to do this if at all possible) 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.

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?

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:)