Handy Google Spreadsheet Keyword Generator

Sam Harrelson on March 9, 2013

I keep track of all our keyword bids, ideas, brainstorms and lists in Google Drive via Spreadsheets.

I had no idea this was possible but will be using the heck out of this feature now…

A Glimpse Into Google’s Brain, Hidden In A Spreadsheet App: “Yesterday TechCrunch reported that if you make a spreadsheet in Google Drive (Google Docs, formerly), enter and highlight the names of two beers, and pull down on the corner of the spreadsheet cell while holding Option or Control, the app will automatically fill the following cells with the names of other beers. The information is pulled, seemingly, from nowhere.”

And a few examples here.

And no, it’s not just for beer. I made a few quick tries with keyword lists for specific specialty clients and was impressed with the nature of the returns.

It’s not a replacement for keyword-specific tools, but a nice way to brainstorm from time to time.

Google Sets have been around for a while and I was always impressed with what was possible (and bewildered they “shut down” the service a few years back). Nice to see Sets having a long life ahead as a part of Google Drive.

On Page SEO: Online Marketing’s Building Blocks

Sam Harrelson on November 2, 2009

On Page SEO: Online Marketing’s Building Blocks
2009 Update: Changes You Need To Know

Search engine optimization comes in many flavors, but marketers must think about more than on-page elements and old best practices. Good on-page SEO is only part of the solution you need to attract quality visitors to any type of site. Good SEO is the heart of online marketing. Poor on-page SEO will cause any site’s efforts to crumble in other areas.

Marketers should already know about page titles (aka title tags), alt image text and font decoration. An online marketer must be able to speak with absolute conviction about the characteristics of these and other influencers.

A wise soul described search engine optimization as a predator and prey game where the search engines show just enough about ranking factors to aid their mission, but not enough so that the results can be gamed. As search technology changes, marketers must also quickly change.

Consider these 2009 changes to on-page SEO so far:

Changes To Previous Best Practices: After an off-the-cuff (that’s how it seemed from the audience at SES San Jose 2007) remark about “no follow” links, Google announced in June that this type of “page rank sculpting” was unnecessary. And in October, Google pulled “PageRank” from its Webmaster Tools console. Why? Google says it’s a good indicator to use as a success metric any more.

Google also confirmed in September that meta keywords convey no search ranking attributes. A month later, Yahoo said the same, but then admitted a week later that it assigned a weak ranking signal for meta keywords.

To reduce duplicate content, all four major search engines agreed in February to support the “canonical” tag. Multiple ways to address the same page, including those resolved by rewrite rules or redirects can be winnowed to one “canonical” page, deemed to be the source and authoritative page.

And the fastest way for any site to be indexed, Yahoo’s Paid Inclusion program, will end in 2009.

New Partnerships: After chasing Yahoo! for a web eternity, Microsoft announced a search deal in July that would combine the #2 and #3 company’s search results. The deal is nowhere near final, but happened fast on the heels of Microsoft’s June launch of its rebranded Bing search engine in June. The new entity, quickly dubbed Microhoo, is expected to use Bing algorithms on Yahoo! properties.

New media darling Twitter cut its own deal with Microsoft and quickly announced a nearly identical deal with Google as both companies try to move into “real-time search”.

New Search Results: Google debuted six variants of search engine results pages (SERPs) in 2009, starting in January with a Timeline view that had previously only been seen in Google Labs. The largest search company followed with announcements in March of its “Vince” update that gives more weight to brands and branded terms. Google also previewed “Caffeine” in August – a jumble of traditional search results, news, video and even blog comments on the same page, but mixed together.

Google had already taken steps to assume searcher intent by starting to automatically display local results for service and product searches even if a geographical term wasn’t included in the search. Combined with the Vince/brand update, ranking nationally for generic words that brands traditionally use became extremely difficult using traditional methods.

Bing quickly countered with visual search in September, and as Google shortened its hotlist of trends to 40 terms, other companies including Twitter, Wikipedia and Bing quickly filled the void and reported on what terms were seeing the most search activity.

Title tags are important. But as an online marketer, you must stay abreast of monthly, sometimes weekly, changes in on-page SEO to enjoy continued success.

Guest Blog by Silver Beacon Marketing

Google Levels the Playing Field?

Sam Harrelson on August 17, 2008

Robert Seidman guest-blogs on social media guru Louis Gray’s blog on the topic of how the Goog has made the playing field of web publishing much more accessible for anyone (rather than just an arena for A-Listers):

louisgray.com: Google Has Leveled the Internet Playing Field: ”
I know a lot in the tech blogging circles will opine on whether Google is good or evil. For now in my mind, Google is still good. It leveled the playing field for us. We have little in the way of expense overhead (almost $0, really) and sure, it may work out that I’ve made about eight cents per hour, but that’s the subject for another blog post. From my perspective, we are allowed to compete, and compete fairly without spending anything on marketing. It’s hard for me to find fault with a system that provides that sort of level playing field.

Organic Google search (including Google News) is our number one traffic source. This leads to a lot of referral traffic from other sites and a good bit of the direct traffic.”

The question of whether or not Google is “evil” or not is about as subjective as any subject you can imagine. For all of its occasional (or sustained) “big-brotherness,” Google does allow for a plethora of voices on topics. The key to ranking well in Google is not to rely too heavily on the mysticism of SEO, but to make good (and easily discoverable) content.

Buying Links: Good or Bad?

Sam Harrelson on June 13, 2008

At the https://www.fusionquest.com/cgi-bin/main/hotlinks.cgi?aflt=afc1&client=affsumAffiliate Summit West this year, one of the most talked about moments was the back-and-forth between SEO expert Wil Reynolds and Jason Calacanis during Wil’s session.

Here’s Wil’s take:

Well the BIG topic – buying links to help boost your SEO rankings, let me say again…if you properly analyze your landscape you can determine if you may or may not need to buy links. If you do, you should buy ones that are actually on GOOD sites – while producing great content is the ideal, you may have to prime the pump a bit with a few strategic bought links. This is an advanced tactic, if you don’t understand what makes a good vs. bad link, don’t buy one!

As you can imagine, Jason was not too supportive of the link buying tactic and has called out Google and SEO’ers many times over the issue (and created a company to combat the problem he sees in search today).

And thanks to the power of the interwebs, you have the chance to see the throw down (not really) between Wil and Jason (or head over to YouTube to see the annotations that Wil has added to the video… they don’t carry over to embeds):

The video also shows why you should be going to the https://www.fusionquest.com/cgi-bin/main/hotlinks.cgi?aflt=afc1&client=affsumAffiliate Summit in Boston this August. Unlike many of the shows I go to, there is both real substance and real discussions that go on during the sessions. This is just a taste of that.