TLC SEO: The Linking Man's Blog

How To Scale Link and Citation Prospecting

I love the idea of scraping…. but I just can’t do it. I’ve sat through presentations from Annie Cushing and Eppie Vojt, and I still can’t do it. I’ve had Ethan Lyon sit me down, and try and teach me – but it doesn’t sink in. I don’t do much intense data collection, all I want to do is scrape search engine results in mass.

That’s why I use Link Prospector.

how to scale link building


The custom report feature in Link Prospector can hold up to 300 custom advanced queries and can scrape in multiples of 1, 3, 5, 10, 20, 50, 100, 200, 300 – all the way up to 1000 results. It will also remove duplicates and group results by domain, get the  home page Tool Bar Page Rank, and pull title tags and meta descriptions.

How to Use Link Prospector Custom Reports

Let’s say I am launching an infographic about wine, and I want to find a large collection of sites that are hosting wine infographics.

Start by taking a look at the competitive landscape. Let’s look at the related searches for [wine infographic] (not actually using brackets).

wineinfographic

 

Not much to go off here, let’s try wine illustration:

 

wineillustrationsuggestedsearch

 

Illustrator cs2 wine and wine adobe illustrator are red flags. I need to remove the following keywords on every single query:

  • -cs2
  • -adobe
  • -winehq

Finally, let’s go with one that is sure to get us some strong results, [wine chart].

wine_chart_suggested_search

This gives us a good idea of how to structure our advanced queries:

Prefixes:

  • types
  • type
  • tasting
  • sweetness
  • pairing

Suffixes:

  • 2012
  • 2011
  • 2013
  • red
  • white
  • sparkling

Let’s start building advanced queries:

link_prospecting_combinations

 

From here you can either concatenate all your results, or you can use the baked in tool that Link Prospector offers:

kw_combiner

Note: the third column narrows everything down. If you are trying to get as many results as possible, add a block for just the negatives to column C.

Here’s to set up Link Prospector for bigger scrapes:

custom_report_set_up

Click To Enlarge

  • Web and blog results
  • 100 results deep
  • Any TLD is fine
  • Published any time
  • No filtering

Once you get the export, turn it into a quick Link Prospecting Pivot Table and go from there.

How To Scale Citation Prospecting

Let’s say I am building citations for a world-class, outstanding, unbelievable Chicago Restaurant. Do a search that triggers a local pack and copy and paste the local pack into excel.

Here’s a video of how to do it

on a Mac in Excel… gross.

For each of the advanced queries – use the address and the telephone number as two separate queries.

Citation Sources In Link Prospector

Click to Enlarge

 

The results aren’t too shabby.

 

Link Prospector Results

If you follow the Link Prospecting Pivot Table Process, you can quickly minimize garden variety citation sources. When opening their home pages, search for “add”, “register” or “submit” and you will generally find the link to the sign up page pretty quickly.

But for local businesses, reviews from popular magazines and websites don’t only help with local rankings, they build a local presence and can bring new business in the door.

citation pivot table

Click to Enlarge

This Link Prospector export included:

ArchPaper.com – An architectural site that happens to review spectacular restaurants.

Check Please from WTTW – The definitive Chicago food lovers show on PBS, it’s an honor to be featured.

Grubstreet, Serious Eats and Chicagoist are top notch blogs.

AndrewZimmern.com – Could we put something bizarre on the menu and as bait and try to get the producer’s attention?

The Red Eye – A free newspaper put out by the Chicago Tribune. Search for food reviews on the site and start tracking all their food journalists.

Bacon Fest – Not only does it sound awesome, they are giving out links, citations and tons of press for participating.

Recork.org – An environmental organization hosting an interactive map for locations that offer cork drop off for recycling - Awesome, let’s sign up for a good cause and get the citation while we are at it.

Chicago Foodies - This is exactly the type of readership we want to get infront of

This tactic yields a lot of high quality PR targets, as well as pulling in a ton of great citation sources.

All in all, it took 40 minutes to copy the local pack into link prospector, let the report run, turn into a pivot table and go through the first 100 results and find these high quality prospects. So stop doing grunt work – become efficient and start scaling.

 

6 comments
e.adam.quinn
e.adam.quinn

"Do a search that triggers a local pack and copy and paste the local pack into excel."

This step inspired me to share this scraper tool I've been using for a few months now.  It seems like it could help your scaling by doing all your searches and only copying and pasting once.  Here's the scraper: http://bit.ly/13QZXvc

Hope it helps.

Miguel Salcido
Miguel Salcido

FINALLY! Someone is providing useful real world cases on different ways to leverage Link Prospector. I've been waiting for this. Out of the box its difficult for people to really leverage all it can do. I mean they did a great job of making it as user friendly as possible, with the various runs you an do with it (directories, guest posting, etc.). But I know its even more powerful.

YuriyYarovoy
YuriyYarovoy

Solid write-up. I agree that Link Prospector is the proverbial tits for scaling this type of tedious work. One question though, Excel for Mac? Really?

JHTScherck
JHTScherck moderator

@YuriyYarovoy Thanks for stopping by Yuriy, I was using a friend's computer.... I still feel sick from using Excel on a Mac.