Google Guide – List of the search operators that work with each Google search service.
Google Guide – Summaries on how to use the basic search operators.
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.
distilled – Tom Critchlow talks about using Google Spreadsheets to build small, agile tools which can be built to match your exact needs.
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.
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.
SEER Interactive – Chris Lee introduces a function that can be used to get SERP results from Google.
distilled – A guide written by Distilled to help SEO professionals get meaningful information from mountains of data by making use of Microsoft Excel.
John Doherty – John Doherty writes about eight of his favorite Excel functions that make his life easier every day.
NielsBosma.se - Niels Bosma created SeoTools – a xls plugin for working with Excel SEO. Create SEO spreedsheets, Excel SEO reports.
distilled - Luke Masters shares working examples of how to SeoTools for Excel to complete SEO tasks faster and more easily.
SEOmoz - Mitch Monsen has assembled a list of the best SEO tools for Excel and Google docs.
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!
SEOmoz - Neil Patel reminds about semantic keyword research to help you focus your content and and improve your rankings.
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.
SEOgadget.co.uk – Richard Baxter shows you an incredibly simple way to get your SEOmoz data straight into Excel.
SEOmoz - Richard Baxter explains how to build a better Yahoo Site Explorer replacement by supplementing Open Site Explorer data.
SEOmoz – John Doherty shares about a framework through which to benchmark your site against others in your niche.
SEOmoz - Dr. Pete outlines the process on link profiling using Open Site Explorer data with examples.
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.
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.
Justin Briggs - Justin Briggs writes about using a Google Chrome extension called Scraper which allows you to scrape content in-line while browsing.
SEOmoz – Paddy Moogan shows how to search for link lists for potential link opportunities.
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.
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.
Point Blank SEO - Jon Cooper explains how to use the Chrome extension Domain Hunter Plus for link checking.
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.
SEOmoz - James Agate presents the unofficial quality rater handbook for guest posting campaigns.
Search Engine Land - Eric Ward points out possible red flags for Google to tag a link as bad.
Search Engine Land - Debra Mastaler draws the distinction between good and bad directories.
SEOmoz - Adria Saracino created this great step-by-step guide to qualifying link prospects and bucketing them to improve efficiency and workflow.
SEOmoz - Carson Ward talks about the different types of link spam to avoid.
SEOmoz - Rand Fishkin illustrates how you should perform searches that will result in high quality link acquisition targets.
SEOmoz - Rand Fishkin rounds up five link building tactics employing search queries to help discover and earn links.
SEO Takeaways - Himanshu Sharma presents an exhaustive list of beginner and advanced search engine queries which can greatly help you find potential linking partners.
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.
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
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.
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.
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.
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.
SEOmoz - Steve Webb shares his comprehensive guide for performing a technical SEO audit.
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.
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.
Point Blank SEO - Peter Attia made a quick and simple set of guidelines that can be used as a reference point for manual outreach.
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 – 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.
SEOmoz – Title tags, technically called title elements, define the title of a document and are required for all HTML/XHTML documents.
SEOmoz - Rob Millard shows how to pick out the landing pages that aren’t performing and give them an overhaul.
ConversionXL - Peep Laja shares about 8 web design principles you should know and follow.
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.
SEOmoz - Paddy Moogan focuses on new additions to every SEO’s toolkit when it comes to on-page optimization specifically for eCommerce websites.
ConversionXL - Peep Laja discusses about a formula on how increase online lead generation.
HubSpot Blog - Corey Eridon summarizes tips plus examples in creating effective landing page copies.
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.
tripwire magazine - Sonny Day lists valuable layout aid tools, prototyping tools, code generators, and a collection of inspirational responsive website designs.
Unbounce - Oli Gardner and Carlos del Rio showcases awesome landing pages to give you some inspiration for your next design.
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-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.
Photoshop Etiquette – 40 ways promoting web designer/developer harmony using Photoshop.
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.
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.
ReelSEO – In this post, Mark Robertson shows you why you should be using YouTube’s closed captions for SEO, amongst other compelling reasons.
SEOmoz - Richard baxter shows how to make super awesome, spiffy looking ranking charts, measuring positioning by keyword, over time.
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.
SEO Book.com - Taylor Pratt guides you on how to create custom reports to help analyze your analytics data faster and easier.
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
SEO Book.com - Taylor Pratt presents three actionable examples of 20 possible dashboards you could setup in Google Analytics.
The Portent Blog - Michael Wiegand outlines the characteristics of a good dashboard.
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.
SEOmoz - Eugen Oprea shares some Google Analytics tricks that you should use for your website.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
Koozai – A complete guide to domain names – from selecting a good domain to the on-going domain management.
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.
ASCII Codes – Table for easy reference of ascii characters and symbols, with conversion tables and HTML codes.
Search & Internet Marketing
Community-curated news and content from the world of inbound marketing: founded by Dharmesh Shah and Rand Fishkin
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.
Provides tips, tricks and advice for optimizing websites and getting better search engine rankings.
A search industry blog created by the readers of SEOmoz. Anyone can post and the best submissions get promoted to the main SEOmoz blog.
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.
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.
Curated tips, tricks, and technology for living better in the digital age.
Comics, quizzes, and stories.
Imgur is used to share photos with social networks and online communities, and has the funniest pictures from all over the Internet.