Profile cover photo
Profile photo
Ethan Lyon
2,131 followers
2,131 followers
About
Ethan Lyon's posts

Post has attachment
This is the North Face closed sign. Taking the time to add character to the small things, you can make even the most mundane thing (a closed sign), memorable. In that way, anything can be used for marketing and building a relationship.
Photo

Post has attachment
Want to check Google's cache date for multiple URLs? Check out this Google Doc:

Post has attachment
Want an automated way to flag spammy websites? Check out a quick, new tool I hacked together in Google Docs:

https://docs.google.com/a/seerinteractive.com/spreadsheet/ccc?key=0AvrsfAmTCtRudEFHTGx0SjVKaUpDUTlCOTVpMnotQkE#gid=0

Just make a copy, type in your website and it will scrape several sites to see if it has issues.

Post has attachment
Want to scrape Pinterest for user websites? Just created a tool that will pull all of the users for a given search term, go to their Pinterest page and pull their web address.

Thoughts on make it better?

Huge thanks to +Stephanie Beadell for the idea and +Chris Le for importxml2.

Post has attachment
+SEER Interactive had a lot of great questions at its Q&A #seochat  yesterday (see: http://ow.ly/dGC6h). +Wesley Exon had a great question about competitive analysis that I wanted to explain in more detail in the tutorial below.

Here ya go!

QuickSEOTip: How to visualize linking strategies over time

Updates like Penguin have made it more important to know the historical linking strategies of a given website before you jump in. If a site has huge spikes in low quality directory or comment linking, you might want to accelerate higher quality linking to offset the low quality stuff. 

I’d like to show you how to visualize linking strategies over time. Here’s how we’re going to do it:

Google Webmaster Tools > Open Site Explorer > Link Detective > Excel

Google Webmaster Tools
1. Log into Webmaster Tools
2. Go to Traffic > Links to Site > Download Latest Links
3. Export to Excel

Open Site Explorer
1. Link Detective uses OSE exports so we’ll need a sample report with the proper headers
2. Remove all Linking Page URLs
3. Paste the Links from the Google Webmaster Tools export into the Linking Page URLs column from the OSE export
4. Replace the Target Page url with the your website (make sure not to include http://, www. or subpages)
5. Make sure all of the other data between Linking Page URLs and Target Page is filled in (it should be one chunk of data with no gaps)
6. Save the file

Link Detective (huge shoutout to +Eppie Vojt for this awesome tool)
1. Log into Link Detective
2. Create a new project
3. Select your modified OSE csv export
4. Hit go and wait until the export is ready
5. Export the Link Detective data

Excel
1. Copy and paste the Link Detective data into a new sheet in our Google Webmaster Tools export
2. Use =vlookup() in a new column next to the Google Webmaster Tools First Discovered column (here’s a good tutorial on =vlookup(): http://ow.ly/dD32a) to pull in Type from the Link Detective sheet
3. Select the Links, First Discovered and Type columns in our Google Webmaster Sheet and insert a pivot table
4. Put First discovered into rows, right click on the dates, select Group and group by year and months (see here for a tutorial on Grouping: http://ow.ly/dGzNq)
5. Put Type into the column labels and Links into values. You should have a hideous looking chart (e.g. http://ow.ly/dGA1Y)
6. Insert a pivot chart or select the data (do not include grand totals) and insert a line chart
7. If everything went to plan it should look like this: http://ow.ly/dGASy 

Voila! Now we can see directory linking has been a consistent strategy over the course of the site and makes up 34% of the sites backlinks (see: http://ow.ly/dGBo9) and forum linking has taken off in the past few months. Either Google just found the pocket of links or it was recently built and something we should investigate further.

Let me know if you have any questions on the above. Thanks!
Photo
Photo
2 Photos - View album

Post has shared content
We'll be hosting our bi-weekly #SEERQandA Sept. 12 at 12pm EST on our G+ page (https://plus.google.com/110773419613073577531/posts). Please join us with ANY of your burning SEO questions!

Post has attachment
QuickSEOTip 1: Reclaim pages that mean something to your business

Almost all websites have pages that once had a lot of traffic and conversions that are now dead. It’s a bad user experience and Google and other search engines aren’t very likely want to send users there. You can either 301 redirect the page or use the content that was once on the page and make it live. Here’s how we find’em:

Google Analytics > Excel > Screaming Frog > Excel

Google Analytics: 

1. Go to content > landing pages in the sidebar
2. Extent the date range to a year or more
3. Show as many rows as possible. (use this to get more: http://ow.ly/dD35g)
4. Export the results into Excel

Excel

1. Recreate the entire URL (Analytics typically removes the domain)
2. Open a new Excel file and paste the URLs (no headers)
3. Save as a txt file (tab delimited text)

Screaming Frog

1. Go to Mode > select list
2. Click the button that used to be the url box
3. Open the txt file
4. Hit go
5. Click on the response code tab
6. Export the URLs

Excel

1. Paste the response codes into another tab on our Google Analytics workbook
2. Go to the Google Analytics sheet
3. Use =vlookup() to pull the response codes from the Screaming Frog sheet (Don’t know =vlookup()? Here’s a good tutorial: http://ow.ly/dD32a)
4. Filter the table and only select 404s and 302s
5. Sort visits or conversions by greatest to least
6. Now that you have a prioritized list of URLs that had conversions or traffic, either recreate the content or 301 those bad boys! +Screaming Frog SEO Spider 

Post has attachment
Just mapped 3,200+ chamber of commerces in the US, with links to their websites. Might be more efficient to find chamber of commerces in your area. #fusiontables   #google  

Enjoy: http://ow.ly/dxNIO +John Doherty +Mark Cianfrani +Nico Miceli +Rebecca Shapley 

Post has shared content
Why hiring employees that actually care is so important:
 
                 Customer Service……. Indian Style!
Photo

The new MS tablet looks great with its keyboard and track pad but I cannot get over how terrible the interface is. Oh, well, they try. 
Wait while more posts are being loaded