If any one has any pressing Excel queries then I am more than happy to run through them on my blog - tweet me or get at me tripleseo.com/contact-me/
@JHTScherck 1. You can use the filters in the Pivot table to select the PR and TLD no need to filter it and then copy into a new sheet?
2.Use the formula =LEFT(A1, FIND(“/”,A1,8)) to extract the domain name A1 is the cell containing the URL
For starters - if this is something people would use then I could create a spreadsheet to automate this :)
Nice work... I think there's a few more Excel Hacks I can show you to speed this up a bit :)
Nice idea... I'm not surprised of the common error where people are linking to Businesswee and not Businessweek considering their title tags refer to business wee, http://www.businessweek.com/terms.html
@s_rvll yep, seeding content in the right places doesn't require any sort of outreach there was a piece by Carson Ward recently where he spent $300 on Stumbleupon and got 140 LRD's
http://www.distilled.net/blog/seo/link-building-seo/buying-awareness-build-links/
@JulieJoyce with or without automation you've probably got this Link building thing down to a fine art...
@wilreynolds Thanks for dropping by Wil, glad it's given you some food for thought.
@egobaiting @HathawayP his face is so memorable because he looks like he's going to punch you into next week :)
@HathawayP I prefer Livefyre - I've used Disqus in the past but have to admit this is far easier to install and get going with
@HathawayP I did mention this to Sean the other day that employing a commenting system such as LiveFyre or Disqus might actually make it easier for people to engage in discussions on the Saloon.