Bookmark-worthy

The following is a list of articles, websites, and other resources – most have been sitting around my bookmarks bar for a long time as I find value in them and often refer to whenever needed; some I have thoroughly digested and have learned a lot from; some I have not but am planning to. A few may already be outdated but still contains useful information. Of course, they are not just the good ones out there.

Everyday, new ideas and innovations show up on the web. I’m doing my best to keep this page up-to-date as frequently as possible. If you have something interesting you’d like to share with me, tweet me the link and I’ll check it out. I might even include it in this list. Also, I often share some cool stuff related to what I do on Twitter (@bibianowency). Let’s be friends. :)

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

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.

Twitter

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.

This page was last modified on April 24, 2013.

WordPress + Social + Local Search

Hey, Bibiano here! I'm not accepting projects or jobs as I am fully employed, but I'd like to help you. I'm no expert, but I'm writing based on experience - tried-and-tested successes and mistakes.

In a nutshell, this blog is an unorthodox guide on how to get started and thrive online with your business. Subscribe to my newsletter below to begin. Everything's free. No spam. No salesman talk. Just what matters to your business.

You can also contact and get quick updates from me through the following:

Not sure what to do next? Start here.