Google's Matt Cutts on .com Relevancy in UK

Some UK Google users have noticed that search results pages are showing more results from .com sites these days, than in the past. They are used to .co.uk sites getting better rank, and assuming that they are more relevant to their geographic location.

Certainly in some cases the .co.uk site would be more relevant to a UK searcher, but that is not always the case. Google's Matt Cutts has posted a video in which he answers a question on this subject from a user. The question was:

Why are the UK SERPS still really poor with irrelevant non UK sites (US/Aus/NZ) ranking very high on Google.co.uk since early June?
Cutts says it is true that searchers in the UK will see more .com results, and that is simply a product of Google getting better at determining geographic relevancy.

As Google gets better, they're more willing to show .com results if they're relevant to the country. "If the best result for a British searcher is something that ends in .com, we still want to show that to that British searcher," says Cutts.

According to Cutts, this is a change that Google will not likely reverse, although he does encourage users to let them know if they see such results that aren't relevant, because they would want to improve this.

The bottom line is that Google is just learning more these days about what sites are associated with what countries, and they're better at detecting it. The goal is to supply relevant results.

As a bonus, Cutts posted to his blog that he's already received some criticism about his answer in the above video and responded:

There’s a couple effects going on:

- first, we’ve been making changes that make it much more likely to see .coms in the UK. I’d say that’s 80-90% of the changes that people are seeing. Most of the generic TLDs (.com, .net, etc.) that are showing up now are .com sites like tescofinance.com and churchill.com that are relevant to the UK even though they don’t end in a .co.uk.

- I’ve been following some of the examples people have pointed out. I remember kiva.org in particular was mentioned and that probably is off-topic for the UK. I dug into that one, and it was an unrelated ranking experiment that was going on that we changed.

Google Suggest Suggestions for Indians & Americans

Google Suggest Suggestions for Indians & Americans

Google Update August 2009 Caffeine Update

Google start to make major changes in is search engine results.

Google Update August 2009 called “Ceffeine Update” are not been update yet in Google normal search results and been test in -> Google Caffeline Test.

this update look like it’s going to be more all about in site seo then links back.

i think this is a smart move from Google because this way the real interesting sites with content on them will rank hi then sites with lot’s of links just because webmaster that locking for links all day and paid of links instead of writing useful information, that is all about when a internet user looks for information in search engines.

i hope this will put an end of this links war and make the internet a better please

read more about this update at Matt Cutts Caffeine Update.

Analytics Data In Excel Through Our API

Many of our clients use Excel to manage their ad campaigns, visualize marketing performance, and perform complex data analysis. Most analysts use the Google Analytics Export feature to manually export their report data to CSV files. Then they import the CSV file into Excel. No longer! Now, with the Google Analytics API you can bypass this manual step and export Google Analytics data directly from within Excel! Once you’ve set it up, there’s no need to visit the Analytics reports to view data in Excel.

Thanks to a variety of developers, here are four solutions that can transform you from a reporting monkey to an analysis ninja (as Avinash would say).

• VBA Macros – The simplest solution of them all. Mikael Thuneberg’s page explains how to make API requests directly from Excel using VBA Scripts and includes a pre-built Excel worksheet to get you started.
• The Tatvic Excel Plugin – Another easy-to-use plugin for Windows users that supports both Excel 2003 and Excel 2007. To get started you download the plugin then register to use the tool. Its simple UI helps you build complex queries and get data from Analytics right into your Excel worksheet.
  Tatvic’s Plugin Query Builder
• Excellent Analytics – Is an open-source initiative by Mark Red and Dropit. This Excel 2007 plugin works on Vista/XP and comes with a query builder to help you create Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin.
  Excellent Analytic’s Query Builder Interface
• ShufflePoint – Works somewhat differently than the solutions above. ShufflePoint has developed a query language that works with the Google Analytics API to achieve common tasks, such as defining the last 30 days as a date range. One then uses this language to construct an Analytics Data Export API query either by navigating to a URL within Excel, or by using their web-based query builder, then importing this data into Excel. This process allows the ShufflePoint solution to work across most versions of Excel, as well as Powerpoint, and iGoogle gadgets.
  Shufflepoint’s Web Based Query Builder

We continue to be impressed by the new solutions developers are bringing to market by leveraging the Google Analytics Platform. If you have developed a useful new tool or integration on top of Google Analytics, drop us an email at analytics-api@google.com. If it’s innovative and useful we’ll highlight it to our readers on this blog.

Posted by Nick Mihailovski, Google Analytics API Team

Google buys On2’s video technology. Why?

Google announced today that they intended to purchase On2 technology for $106.5 million. While just a drop in Google’s seemingly limitless ocean of cash, this acquisition seems to be for a technology component (or two). On2 specializes in making video processing codecs and software that optimizes video for the Internet.

The big question is: Why?

Here are some reasons which I think may make the most sense:

First, Google’s YouTube unit has many Petabytes of video stored on Google’s server farms around the world. Every day that number grows. It costs a lot of money to keep that data live, online and backed up. It also costs a lot of money in bandwidth to deliver it to Google’s users. One of On2’s core competencies is bringing the size of SWF Flash (and H.264) files down while keeping the quality level high. As Google moves to make more and more of Youtube’s videos High Definition, this becomes even more important.

Even single digit percentage drops in file size to Youtube’s collection would make the technology valuable enough over a few years to make the sale a good deal. But there could be more to it than that.

On2 also makes software that optimizes video for mobile. Not only does Google have the Android handsets, but it also has users with iPhones, Blackberries and Windows Mobile devices that are going to be downloading more and more of their content.

Another big deal is the HTML5 standard that embeds native (not Flash) video. The standard is up in the air right now because Apple and the Open Source community both have different ideas of what should be the standard format for video. Apple obviously wants its Quicktime friendly H.264 while many in the Open Source community want Ogg Video. On2 could have either a third choice or a technology that allows both to be generated for webpages using HTML5. Either way, google is a big player in this space and will want to have a say.

What I think is at play here is that major advertisers are getting ready to sign up for big campaigns with Hulu. Google, when all is said and done, is an advertising company. They make 99% of their money from ads and everything else they do are just ways of getting those ads into our eyes.

They see Hulu’s platform (based on the On2 technology btw) as the biggest competitor to their Youtube juggernaut. While Youtube can be mildly entertaining for viral videos, Hulu is grabbing more eyes for a longer period of time with better quality programming. If Google wants to participate in this space, they are going to want a piece of that action. And at $100 million, they can afford to get into the game.