Archive for 2009

Jun
12

Search Ranking Factors

Posted by: | Comments (0)

The holy grail of search engine optimization is to master the factors affecting page rank. SEOmoz.org has a beautiful and highly detailed (forensic!?) explanation of the elements of a web page which influence page rank. I wouldn’t try to print it, though – the solid backgrounds used would run through three ink cartridges in moments.  Enjoy!

Update: (2/2010) – evidently someone at SEOmz read my ink cartridge remark, because they’ve reworked their content to by much more friendly. Cheers!

Categories : SEO
Comments (0)
Jun
01

Welcome, Bing!

Posted by: | Comments (0)

MSN has converted itself into Bing.com.  Now all web analytics packages are momentarily obsolete – until the next upgrade, code release, or until you take matters into your own hands and update the product you use.

First, let’s see how Bing identifies itself as a referring site in your logfiles:

http://www.bing.com/search?q=querystring_here&FORM=MSNH11

Nothing too fancy here.   The fully specified domain name and query string value is here. I’m not yet too sure about the ‘FORM=MSNH11′ value – I am sure it is a useful item yet to be discovered.

Google Analytics
I know that Google Analytics (GA) will allow users to add new search engines with a special API call that you need to add after the first pageTracker() call:

pageTracker._addOrganic("bing.com","q");

What is not clear is if this call should be made only once, or if it should remain part of your tagging at least until GA reports Bing data on its own. More on this later.  Somehow I suspect Google will be a bit lackadasical about adding a competing search engine to is reports.

Omniture
SiteCatalyst appears to report on Bing referrals just fine. It nicely displays as ‘Microsoft Bing’ instead of just ‘Bing’. This will help SiteCatalyst users make the transition visually.

Webtrends
The WebtrendsOutsider blog has documented how to update self-hosted Webtrends installations to report Bing data properly. For users running a custom keywords.ini file, this post explains how to make the update.  For users running the ‘factory’ keywords.ini and browser.ini files, just hop over to Webtrends and pick up new versioned copies of both files and place them on your WT server.

Categories : Web Analytics
Comments (0)

Lots of sites use Google Analytics and that is good news.  The next question becomes: ‘is it installed correctly’?  Here’s one tool which can help answer the question: SiteScan™ by EpikOne. It will check up to 1000 pages on your site and report the results via email. Pretty nice for a great price: free.

Categories : Web Analytics
Comments (0)

Social Networking (SN) is rapidly becoming an accepted practice in the business world. Branding and brand protection are some of the main reasons businesses are using SN sites. A great way to find a name or ‘handle’ for your business which can be the same across all or many SN sites is to use namechk in much the same way as finding a valid domain name to register.

Categories : Social Networking
Comments (0)
May
20

Google Analytics API listing found

Posted by: | Comments (0)

I finally found in one place the Google Analytics API documented in one place, all on one page. This page lists the myriad functions which can be called from the pageTracker object.

Categories : Web Analytics
Comments (0)
Apr
03

Logfile Analysis – no way around it

Posted by: | Comments (0)

It’s true – the best way to understand and be sure what activity happens on your website is to open the logfiles. You’ll find a lot of activity which is good for your cause, such as search engine spiders and real human visitor activity, and you’ll find abuse such as hacker attacks and content theft. Blogger Eric Lander wrote this thorough post which introduces log file analysis to webmasters and SEOs.

This Wikipedia entry provides a most complete list of server log analysis tools, but remember, to get started looking at logs, all you really need is a good text editor. Even Notepad works in a pinch.

Categories : Web Analytics
Comments (0)

Big time DBAs, don’t laugh! But honestly, couldn’t it have been easier to format a numeric value as an amount with decimals? Maybe it will help others trying to format dollar amounts which are stored like 1234.1861 in SQL Server to look like 1234.19, for example. So deceivingly simple…

Here is how I searched BigG and found little:

TSQL display dollar amount

TSQL format dollar amount

TSQL format currency no dollar sign

Just pop this around the field name you need to format and you’re in business!

CONVERT(VARCHAR(10), CONVERT(MONEY, fieldname)) AS PRICE

Cheers!

Comments (0)

Tags

 

February 2012
S M T W T F S
« Jan    
 1234
567891011
12131415161718
19202122232425
26272829