admin's blog

Error

Symptoms

• Occurs when trying to process a profile.
• Recently upgraded Urchin.

Potential Cause
Difference in datamap between different Urchin versions.

Potential Resolution

1. Manually delete the data files for the current month under urchin/data/reports/<account>/<profile>/
2. Reprocess the profile for the entire current month.

With the advent of Urchin 6.6, new reports and reporting features were added to Urchin. NOTE: Historical data will not be seen in these reports unless data is reprocessed.

Rollup Report

The home page (the page first seen after logging in) now includes aggregated metrics for each profile (Time on Site, Visits, etc.) as well as the status from its last processing run. Metrics may be seen for the current day, previous week, month, and year.

Urchin 6.6 includes a new Data Extraction API, allowing you to retrieve Urchin reporting data via SOAP 1.x or REST protocols.

Get List of Accounts and Profiles

Using the API, you may return a feed of all accounts and profiles that exist in the Urchin instance. Previously, this could only be done by querying the Urchin database directly.

When exporting a given report to a TSV, XML, or CSV file, all "Average Time" metrics are returned as seconds (a decimal). If viewing this in excel, the average time will not look the same as it would in Urchin. For example, Urchin may show an Average Time on Page as 00:00:34. After exporting, this value will be just 34 (there may be a decimal value as well if any rounding was performed).

To convert the seconds value to hh:mm:ss format in Excel, follow these steps:

The Urchin tracking code (both urchin.js or ga.js) collects standard information about a visitor and the pages he/she is viewing. However, this is often not enough. You may run into a situation where you'd like to collect information that is specific to your website, making your Urchin reports much more useful. This is accomplished with a user defined variable.