What does "(other)" mean in my reports?

Have you ever seen that annoying "(other)" line in any of your reports and wonder what it means. Obviously, it's not telling you anything useful other than something is generating visits on my site, but what?! Let's take a few steps back and talk through how Urchin works.

As Urchin's processing __utm.gif hits from a log file, it's storing all that data in a table in a database. Each one of those tables has a limit - the DB Row Limit. By default, this is set to 100,000 in Urchin 6, but may be increased up to 500,000. This limit tells Urchin the maximum number of unique entries to store in each table. If the limit is reached, every other unique item is stored in the database as "(other)". So, what that pesky row is really telling you is that there's more unique entries in the table than Urchin is currently configured to store.

The DB Row Limit may be increased for just that profile under the DB/Settings tab for the profile. Alternately, to increase the limit for all profiles, set all profiles to use "Global Default" and raise the DB Row Limit for all profiles under Settings >> Global Settings >> DB Settings.