Jump to: Google Search | Spreadsheets | Keyword Research | Link Building | Mobile | On-page Optimization / Web Design | Web Analytics | Paid Search | SEO | Social Media | Others | Subscriptions
Google Search
Google Search Operators
Google Guide – List of the search operators that work with each Google search service.
Google Special Characters
Google Guide – Summaries on how to use the basic search operators.
Spreadsheets
Google Docs
Google spreadsheets function list
Google Docs Help – Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. These formulas can be used to create functions that manipulate data and calculate strings and numbers.
How To Build Agile SEO Tools Using Google Spreadsheets
distilled – Tom Critchlow talks about using Google Spreadsheets to build small, agile tools which can be built to match your exact needs.
SEOmoz data for Google Docs
SEER Interactive – Chris Le has an update to Tom Anthony‘s original tool to get SEOmoz data into Google Docs. This includes a simpler setup and fewer rate limit errors.
Web lookup using Google Spreadsheets
s-anand.net – S. Anand shows how to extract data from a web page, does a web-based vlookup on another service, and returns the results as an RSS feed – all using Google spreadsheets.
Google Scraper in Google Docs (Update)
SEER Interactive – Chris Lee introduces a function that can be used to get SERP results from Google.
Microsoft Excel
Microsoft Excel for SEOs
distilled – A guide written by Distilled to help SEO professionals get meaningful information from mountains of data by making use of Microsoft Excel.
Eight Useful Excel Functions for SEO
John Doherty – John Doherty writes about eight of his favorite Excel functions that make his life easier every day.
SeoTools for Excel
NielsBosma.se - Niels Bosma created SeoTools – a xls plugin for working with Excel SEO. Create SEO spreedsheets, Excel SEO reports.
Awesome Examples of How to Use SeoTools for Excel
distilled - Luke Masters shares working examples of how to SeoTools for Excel to complete SEO tasks faster and more easily.
Excel and Google Docs: Tools for the Ultimate SEO Dashboard
SEOmoz - Mitch Monsen has assembled a list of the best SEO tools for Excel and Google docs.
Keyword Research
Explode your Keyword List for Linkbuilding Magic
John Doherty - John Doherty shows you how to blow out your keyword list using tools like UberSuggest and Soovle so that you can identify the terms around your head terms, create content and build links to your site using all of the related terms, still rank for your head terms, AND capture the longtail traffic!
How to Improve Your Rankings with Semantic Keyword Research
SEOmoz - Neil Patel reminds about semantic keyword research to help you focus your content and and improve your rankings.
How to Build an Advanced Keyword Analysis Report in Excel
SEOmoz – Dan Peskin writes about analyzing keyword performance, discovering new keyword opportunities, and determining which keywords to focus efforts on which can be painstaking when you have thousands of keywords to review.
Link Building
Competitive Research
Fun With The SEOmoz API – Get Links Data Straight into Excel
SEOgadget.co.uk – Richard Baxter shows you an incredibly simple way to get your SEOmoz data straight into Excel.
6 Cool Ways to Supplement Your Open Site Explorer Data
SEOmoz - Richard Baxter explains how to build a better Yahoo Site Explorer replacement by supplementing Open Site Explorer data.
Competitor Analysis and Benchmarking With the New Domain and Page Authorities
SEOmoz – John Doherty shares about a framework through which to benchmark your site against others in your niche.
Link Profiling with Open Site Explorer
SEOmoz - Dr. Pete outlines the process on link profiling using Open Site Explorer data with examples.
Making SEOmoz’s SERP Analysis Tool More Awesome
John Doherty - John Doherty have taken the SEOmoz SERP Analysis Tool export and modified it to spin you out a bunch of graphs that will show you where your site might be weak against your competitors.
Identifying Link Patterns with SEO Tools
John Doherty - John Doherty talks about how to quickly and easily identify your client’s (or your own) main competitors, and even further which competitors you need to examine more closely for their backlink strategies.
Link Prospecting
Quick Link Prospecting with Scraper Extension
Justin Briggs - Justin Briggs writes about using a Google Chrome extension called Scraper which allows you to scrape content in-line while browsing.
The Power of Using Lists for Link Building
SEOmoz – Paddy Moogan shows how to search for link lists for potential link opportunities.
Want Guest Post Links? Find Them Via Twitter [TOOL]
SEOmoz - Ethan Lyon shares a tool pulls the RSS feed that he had in his Google Reader into Google Docs, finds all of the t.co URLs, enlarges them, eliminates duplicates based on domain, and presents them in a nice package.
9 Actionable Tips for Link Prospecting
SEOmoz - Paul Rogers enumerates actionable tips on how to generate a broader set of quality prospects, identifying a huge selection of relevant, high quality blogs and industry websites within different sectors.
Domain Hunter Plus – Next Generation Link Checker
Point Blank SEO - Jon Cooper explains how to use the Chrome extension Domain Hunter Plus for link checking.
Prospecting with Power – Using Link Prospector with Screaming Frog for Brands
SEER Interactive – I’ve been using Screaming Frog for about a month now, and have never heard of Link Prospector until this post. John-Henry Scherck shares about a killer-combo of both for power link prospecting.
Link Qualifying
How to Evaluate Guest Post Opportunities
SEOmoz - James Agate presents the unofficial quality rater handbook for guest posting campaigns.
Can There Really Be 85 Types Of Unnatural Links?
Search Engine Land - Eric Ward points out possible red flags for Google to tag a link as bad.
Why You Can’t Dismiss All Directory Links
Search Engine Land - Debra Mastaler draws the distinction between good and bad directories.
The Definitive Guide to Qualifying a Link Prospect [with Video]
SEOmoz - Adria Saracino created this great step-by-step guide to qualifying link prospects and bucketing them to improve efficiency and workflow.
17 Types of Link Spam to Avoid
SEOmoz - Carson Ward talks about the different types of link spam to avoid.
Search Queries
Long List of Link Searches for SEO
SEOmoz - Rand Fishkin illustrates how you should perform searches that will result in high quality link acquisition targets.
Non-Intuitive Search Queries & Resources for Link Building
SEOmoz - Rand Fishkin rounds up five link building tactics employing search queries to help discover and earn links.
10000 Search Engine Queries for your Link Building Campaign
SEO Takeaways - Himanshu Sharma presents an exhaustive list of beginner and advanced search engine queries which can greatly help you find potential linking partners.
Email Outreach
Writing Email Subject Lines: 6 Ways to Improve Your Open Rate
Copy Hackers – So, what can you do to improve your open rate so you stand a better chance of converting your list? Joanna Wiebe shares some actionable open rate boosting tactics.
4 Pitches That Any Respectable Blogger Will Always Ignore
BlueGlass – Are you not hearing back from the bloggers you pitch? Brittany Klontz thinks you might be committing one of these common pitching errors.
Tips and Guides
Getting Buy In For Link Building
distilled – Geoff Kenyon shares about getting links that don’t require resources. While these are only a handful of ideas, it should give you the ability to build enough links to see some improvements in the SERPs, especially when targeting less competitive keywords.
The 6 Month Link Building Plan for an Established Website
SEOmoz – There are an abundance of link opportunities (and challenges) that are pretty unique to an established website. James Agate walks us through a six-month link building plan for an established website.
Broken Link Building Guide: From Noob to Novice
SEOmoz – This post by Anthony Nelson is about broken link building. It’s been a popular topic in the industry, but he also noticed that SEOmoz didn’t have a lot on the subject, so he thought it would be nice to write a kick-a*s piece for the large SEOmoz community. Don’t forget to check out the comments section for valuable advice from other members.
PHP Errors as a Means of Getting Links
SEOmoz – Eugene Krall shares his incredible and effective link building tactic which you can follow. If you liked broken link building, you’ll definitely want to include this in your arsenal.
How to Perform the World’s Greatest SEO Audit
SEOmoz - Steve Webb shares his comprehensive guide for performing a technical SEO audit.
Strategies for Diagnosing Penguin and Recovering
distilled - John Doherty discusses what Penguin is, how to diagnose a Penguin traffic drop, how to check the toolbar PageRank (TBPR) or Page Authority (PA) of links, how to check indexation of links quickly, and gave some overview strategies about how to approach different Penguin scenarios.
5 Creative Broken Link Building Strategies
Point Blank SEO - Jon Cooper shares a few miscellaneous “outside of the box” strategies for broken link building you probably haven’t heard of before.
Guest Blogging Guidelines – An Extensive Guide
Point Blank SEO - Peter Attia made a quick and simple set of guidelines that can be used as a reference point for manual outreach.
Mobile
4 Tips For Your Mobile SEO Strategy – Whiteboard Friday
SEOmoz – In this Whiteboard Friday, Aleyda Solis shares about four fundamental questions that will help you assess the best alternatives to start taking mobile search into consideration for your site.
On-page Optimization / Web Design
Design Seeds – For All Who Love Color
Design Seeds – Awesome color palletes based on real photographs. If you’re a web designer (or a photographer – the photos are great too), check this site out.
Title Tag SEO Best Practices – Meta Tag Optimization
SEOmoz – Title tags, technically called title elements, define the title of a document and are required for all HTML/XHTML documents.
CodePen Beta
CodePen - A site by Alex Vazquez, Tim Sabat, and Chris Coyier for building stuff from HTML, CSS and JavaScript. Perhaps for yourself to remember later, perhaps to suss out a bug or make a reduced test case, or to show off some cool idea you have.
Identifying and Fixing Your Worst Landing Pages
SEOmoz - Rob Millard shows how to pick out the landing pages that aren’t performing and give them an overhaul.
8 Universal Web Design Principles You Should Know
ConversionXL - Peep Laja shares about 8 web design principles you should know and follow.
25-point Website Usability Checklist
usereffect - Dr. Pete has developed a 25-point website usability checklist – a way to create a method making sure that he doesn’t forget anything critical when working with a new client.
Perfecting On-Page Optimization for Ecommerce Websites
SEOmoz - Paddy Moogan focuses on new additions to every SEO’s toolkit when it comes to on-page optimization specifically for eCommerce websites.
Ridiculously Effective Technique for Online Lead Generation
ConversionXL - Peep Laja discusses about a formula on how increase online lead generation.
The 7-Point Checklist for Powerful Landing Page Copy
HubSpot Blog - Corey Eridon summarizes tips plus examples in creating effective landing page copies.
13 Sloppy Mistakes You’re Making With Your Calls-to-Action
HubSpot Blog - Corey Eridon writes this blog post that can serve as your reference next time you create a new CTA or modify an existing one.
35 Useful Responsive Web Design Tools
tripwire magazine - Sonny Day lists valuable layout aid tools, prototyping tools, code generators, and a collection of inspirational responsive website designs.
35 Beautiful Landing Page Design Examples to Drool Over [With Critiques]
Unbounce - Oli Gardner and Carlos del Rio showcases awesome landing pages to give you some inspiration for your next design.
[How To] Write a Call-to-Action that Converts – With Case Studies
Unbounce – This guide by Michael Aagaard, packed with case studies, examples, and simple optimization principles, will teach you exactly how to write calls-to-action that converts. Great read. I learned a lot from this.
CSS
CSS Style Guides
CSS-Tricks – Ordering properties is just one choice you have to make that makes up a complete styling strategy. Naming is a part of it. Sectioning is a part of it. Commenting, indentation, overall file structure… it all makes up a complete CSS style guide. Chris Coyier rounds up some existing ones.
Graphics
The Photoshop Etiquette Manifesto for Web Designers
Photoshop Etiquette – 40 ways promoting web designer/developer harmony using Photoshop.
Site Structuring
Internal Linking Strategies for 2012 and Beyond
SEOmoz – A followup to last Friday’s Whiteboard Friday, John Doherty clarifies some of the points he made with illustrations, mockups, and examples that show good vs risky examples of internal linking. The goal is to remain competitive, but to link in smart ways with varied anchor text. These strategies should keep you competitive while also looking towards the future and not worrying about over-optimizing your internal links, including links from your microsites or ccTLDs.
Videos
Winning the Video Thumbnail in Google Universal Search
SEOmoz – Have you noticed that more and more video results are showing up in Google search results? Everywhere you turn, it seems that Google is providing options of videos to watch on the first page of their search results. Jeff McRitchie talks about how to rank your videos on the results page.
In-Depth Look At YouTube Closed Captions, SEO and Indexing
ReelSEO – In this post, Mark Robertson shows you why you should be using YouTube’s closed captions for SEO, amongst other compelling reasons.
Web Analytics
Using Excel
How To Make Awesome Ranking Charts With Excel Pivot Tables
SEOmoz - Richard baxter shows how to make super awesome, spiffy looking ranking charts, measuring positioning by keyword, over time.
How to Automatically Track Your Google Positions in Microsoft Excel
Search Engine People - Yoav Ezer made a project that serves as a good example for how you can use Excel to “scrape” search results and monitor your rankings.
Custom Reporting
Maximizing Google Analytics Insight for SEO with Custom Reports
SEO Book.com - Taylor Pratt guides you on how to create custom reports to help analyze your analytics data faster and easier.
Custom Reporting using Google Analytics and Google Docs – The Ultimate Analytics Mashup
SEOmoz - Jamie Steven writes about how to create a custom report by connecting a Google Spreadsheet directly with data from Google Analytics.
Tips and Tricks
Setting Up Actionable SEO Dashboards in the New Google Analytics
SEO Book.com - Taylor Pratt presents three actionable examples of 20 possible dashboards you could setup in Google Analytics.
The Perfect Google Analytics Dashboard
The Portent Blog - Michael Wiegand outlines the characteristics of a good dashboard.
When to Use Google Analytics Goal Values
The @KISSmetrics Marketing Blog - Lars Lofgren teaches how to get your goal values set up so you can start tracking the ROI of your website.
11 Google Analytics Tricks to Use for Your Website
SEOmoz - Eugen Oprea shares some Google Analytics tricks that you should use for your website.
Advanced Google Analytics – Tips and Tricks
SEOmoz - Fabian Alvares talks about some great advanced segments, how to do multiple goal conversion tracking and the secret to success behind cross domain tracking.
Paid Search
What is PPC: The Complete Beginner’s Guide to Paid Search Advertising
Rise Interactive - Rise Interactive created a reference guide meant to provide an overview of the essential pieces of paid search advertising, as well as some basic strategies and tools to get anyone new to the game off on the right foot.
Search Engine Optimization
Seventeen Ways To Improve Your Blog – Case Study
SEOmoz – In this amazing post, Dan Shure of Evolving SEO takes us on a riveting case study to show how we can improve our chances at being successful with blogging. Talk about actionable real-world tips. This is a great read for experienced bloggers and starters alike.
How to Prepare for AuthorRank and Get the Jump on Google
SEOmoz – This article is definitely a must-read for everyone in the industry. In this write-up, Mike Arnesen doesn’t just simply discuss about properly setting up Authorship via Google+ and how it affects your SEO efforts, but more importantly explains how to get started on making yourself trustworthy not just by the search engine but by the online community as well.
Rock Your SEO with Structured Social Sharing – #MozCon Presentation
SEOmoz – In Dana Lookadoo’s speech at MozCon 2012, attendees learned about the Structured Social Sharing Formula (SSSF): 10 steps to optimize and track social share snippets on Facebook, Google Plus, and Twitter – and she’s sharing that sweet guide in this post, the all-in-one formula to optimize your social engagement.
HTTP Status Codes SEO Best Practices
SEOmoz – The SEO best practices of various HTTP status codes. HyperText Transfer Protocol (or HTTP) response status codes are returned whenever search engines or website visitors make a request to a web server.
SEO: The Free Beginner’s Guide From SEOmoz
SEOmoz - New to SEO? The Free Beginner’s Guide to SEO has been read over 1 million times and provides the information you need to rank better.
Guide to the Facebook Open Graph
distilled - Phil Nottingham shares how Mixcloud’s Mat Clayton gave the low-down on Facebook Open Graph — what it is, how it works and how you can use it to increase traffic and user engagement.
Social Media
Facebook Advertising / Marketing: Best Metrics, ROI, Business Value
Occam’s Razor - Learn best ways to create value for your business on Facebook, how to measure online and offline return on investment, and which metrics are most insightful.
9 Facebook Marketing Tips From Top Experts
Social Media Examiner – Find out the hottest facebook marketing tips for your business and use these marketing tactics to take you to the next level. Cindy King shares about them.
Ten Painless Tactics To Earn Attention On Twitter – Whiteboard Friday
SEOmoz – Twitter is similar to passing signs at full speed on the highway. How do you get your signs (tweets) noticed and read? How can your profile stand out from the rest? For many, Twitter can be a fun and exciting, yet illusive and challenging social media platform. In this Whiteboard Friday (to be followed by a Whiteboard Plus and Moz YouTube post), Dan Shure shares ten Twitter tactics for you to put to good use.
Others
The Ultimate Domain Guide
Koozai – A complete guide to domain names – from selecting a good domain to the on-going domain management.
PHP Manual
PHP.net - This manual consists primarily of a function reference, but also contains a language reference, explanations of some of PHP’s major features, and other supplemental information.
Table of ascii characters and symbols
ASCII Codes – Table for easy reference of ascii characters and symbols, with conversion tables and HTML codes.
Subscriptions
Search & Internet Marketing
Inbound.org
Community-curated news and content from the world of inbound marketing: founded by Dharmesh Shah and Rand Fishkin
Search Engine Land
Hub for news and information about search engine marketing, optimization and how search engines such as Google, Yahoo, Microsoft Live.com and Ask.com work for searchers.
SEOmoz Blog
Provides tips, tricks and advice for optimizing websites and getting better search engine rankings.
YouMoz Blog
A search industry blog created by the readers of SEOmoz. Anyone can post and the best submissions get promoted to the main SEOmoz blog.
Web Design
Hakim El Hattab
The portfolio of interactive web developer Hakim El Hattab. Check out his latest projects, read about what he’s up to or browse through his interactive HTML5 experiments.
CSS-Tricks
A web craftsman, blogger, author and speaker. If web design’s your cup of tea, Chris Coyier and the CSS-Tricks community shares with you a great resource for everything that makes the web a vibrant and exciting place to stay.
Free Time
Lifehacker
Curated tips, tricks, and technology for living better in the digital age.
The Oatmeal
Comics, quizzes, and stories.
The Imgur Gallery
Imgur is used to share photos with social networks and online communities, and has the funniest pictures from all over the Internet.