seo

Making better use of Google Insights data

Google Insights is a great tool, however its data export format (only available when signed in) leaves a bit to be desired. Read on for a quick tip on how to format this data in Excel so it works a bit better for you…

The first problem is the dates are grouped by week, and the ‘Week’ column specifies a range rather than a specific date:

That’s pretty simple to fix – just hit CTRL-H and do a find and replace on ‘ – *’ to replace the “range” info.

Next, select the whole range, and do Insert -> PivotTable as below:

In the PivotTable, set up the Row Label to ‘Week’, and the Values to ‘Sum of…’ your data that you want to see.

Next, click into the Week column, and hit Options -> Group Selection – you should see a dialogue box come up:

By selecting the options here you can then group the data by months, years or quarters. If you select Month & Year together, you’ll see a data set like:

Now the data should be much easier to manipulate & summarise into useful graphs etc :)

Jaamit: an SEO Legend

The below is an internal email sent out today at OMD which I thought would be nice to share with the wider SEO community.

————

Today marks the day last year when we lost a highly valued colleague and friend on the OMD SEO team Jaamit Durrani. His dedication, passion, humour & intelligence he showed while he was with us has had a lasting effect on us personally, but also has been crucial to the SEO team’s growth from a very small team last year to a highly successful team of 15+ this year; a year where we’ve won our first ever major SEO-only client, scored 100% in client feedback and continue to build a better offering month on month.

As a small tribute, and hopefully an insight for those who weren’t lucky enough to meet or work with him, this week’s links highlight some of his best blog posts, as well as some of the tributes posted online:

1.    Seven sensational SEO tips for ecommerce sites | Econsultancy

econsultancy.com

For the first of my guest posts for Econsultancy I wanted to take a step beyond the generic, oft-rehashed ‘SEO tips’ (you know, things like “include keywords in your page titles” and “create great content”) and contribute something based on my experience. Guest post by Jaamit

2.    Nine common SEO campaign mistakes | Econsultancy

econsultancy.com

Running an ongoing SEO campaign is a lot like spinning plates. With so many factors in play in search engine algorithms, you really need to be aware of all of them at once to ensure a successful campaign. Guest post by Jaamit

3.    SEO Insight: Analysis and Rants on Search & Internet Marketing

web.archive.org

Jaamit’s blog is sadly no longer available (however we are looking into how it can be reinstated); this link from the Internet Archive luckily preserves most of his posts fully intact.

4.    SMX London – Top 10 Tips – By Jaamit Durrani – SEOgadget.co.uk

seogadget.co.uk

As an illustration of how open and sharing Jaamit was with his knowledge, this is a guest post he did for a competing agency’s blog :)

5.    PPC vs SEO Showdown: SES London 2010 Recap | Fresh Egg SEO Blog

www.freshegg.com

Before OMD, Jaamit kicked off his career in SEO with a small Brighton digital agency FreshEgg (owned by James Caan). Here’s one of his posts from their blog.

6.    Link building in real life – A practical guide to dominating the SERPS | Fresh Egg SEO Blog

www.freshegg.com

Coverage from FreshEgg of Jaamit’s first conference speaking engagement at Think Visibility in Leeds.

7.    Link Building in Real Life: Think Visibility 2010 Recap – SearchTalk | SearchTalk

searchtalk.co.uk

Coverage of the same talk from OMD’s Jamie Peach.

8.    Jaamit Tribute

explicitly.me

A touching tribute from one of Jaamit’s close friends in the industry.

9.    Jaamit Durrani Tribute – SearchTalk

searchtalk.co.uk

Another very touching tribute from Omnicom Head of Search Mark Mitchell, detailing the truly impressive impact Jaamit had in his short time at OMD.

10. @Jaamit – Twitter

twitter.com

Jaamit’s twitter account – it’s easy to see just how highly engaged he was with the SEO community and how willing he was to help out others whenever possible.

 

—–
Miss you mate.

Less Google keyword data = more black hat activity

This post purely reflects my own personal opinion, and does not reflect those of my employer or colleagues. For those faint of heart, warning: contains traces of black hat material.

So Google has taken our keyword data away, probably for good. What next for SEO?

I think we have to assume this rollout will eventually happen everywhere, for all users. Why? What’s in it for Google?

  1. Less competition – the data provided on search by firms such as Experian Hitwise, Comscore, Quantcast becomes far less valuable, meaning the only media company that can authoritatively provide keyword data is, you guessed it, Google.
  2. Less spam – from a purely objective point of view, I do think this will result in much less spam. Sites such as Mahalo, Experts Exchange, etc will all suffer as the pages generated purely based on search volume will die a death, and Google’s results will get better as a result.
  3. Less SEOs – I don’t think it will kill the industry, but measurement and keyword research becomes a lot harder. The focus will probably get more technical on-site and more social off-site. Google’s not known for its love of the SEO industry so this is probably a nice side benefit for them.

It’s easy to despair and mourn the death of SEO (again) but as long as organic results exist that’s pap.

Here are a few serious/non-serious ideas for workarounds:

1. Deep Content Analysis

Reports on content need to get A LOT better. For example tying up content and technical changes with organic traffic to those pages will become a lot more important in order to judge the success of content strategies.

2. Resurgence of rank tracking (for now)

With less keyword data, SEOs are forced back into the corner of going back to old-school rank tracking in order to measure success. This is a very sad thing considering ethical SEOs have been pushing keyword traffic as a key performance metric for a very long time now, and rankings were starting to become less important.

However I think relying too much on this may well leave SEOs in for a further shock down the line, as search results will probably start looking more like a JavaScript-based web app and less like traditional web pages, making them a lot harder/impossible to parse with traditional screen scraping tools (although maybe experts in Selenium could knock something up).

3. Don a black hat

None of these black hat methods are recommended; however are an indication of the direction certain people may choose to go in as a result of Google’s announcement.

Through hacking into a user’s browsing history (possible, though only for a pre-defined set of URLs), or other such nefarious/illegal activity, it’s probably still pretty easy to figure out referring keywords, and send the data in a manipulated request to Google Analytics (though likely to be against GA ToS).

3a. Develop a popular browser plugin

You may be able to regain some keyword data through developing a browser plugin that tracks a user’s browsing behaviour, much as Google did with their toolbar. Obviously to stay on the legal side of the fence you’d need to hide this as well as you can in the plugin’s T&Cs. Much as Google did with their toolbar.

3b. Develop & spread spyware

Clearly straddling the blackhat/illegal arena, tracking browsing activity through spyware is child’s play.

3c. Develop & spread a virus/trojan/worm

Again, frankly illegal, but another easy way to track the keywords that users are searching for.

4. Develop your own search engine(s)

Many in our industry assume Google has an unassailable position as a search engine. This may or may not be true (remember Altavista?), however that doesn’t mean there isn’t room for more search engines on the web. Given the sheer number of open source search engines available all you really have to do is choose one, and customise it for your chosen niche, add some nice features and then start tracking user behaviour.

5. Only allow Google to index your home page

Then put a big search box on your home page and track users’ search behaviour. Clearly has certain drawbacks and would only work if you had an absolute ton of branded searches :)

6. Start using a different search engine

I Still Haven't Found What I'm Looking For - Because I use BingA small protest perhaps, but an important one. Webmasters have dived in to Google products as they’ve given us a lot of great products for free. There’s far more in the way of good, free (or cheap) alternatives today to services such as Google Analytics than there were 5 years ago. Personally I’ve set Bing as my default search engine and am relatively happy so far (though the pangs of “I’ll just double check that on Google” have not gone away.)

So that’s just a few collected thoughts, please share your thoughts & ideas below!

Further Reading:

1 2 3 4 5 6  Scroll to top