Migrate Urchin to Angelfish

Creation date: 5/18/2022 5:09 PM    Updated: 6/10/2022 2:52 PM
Angelfish includes two utilities for migrating from Urchin 7 to Angelfish:

configmigration
migrates config settings from Urchin to Angelfish: user accounts, passwords, profiles, filters, log sources

datamigration
migrates report data from Urchin to Angelfish, using the Urchin 7 API

If you have your log files, it's best to only run migrate config information and reprocess the logs in Angelfish.

If your data is stuck in Urchin 7 and you don't have log files, the datamigration utility should be used.

Step 1 - Migrate Configuration information

The configmigration utility is located in the Angelfish installation directory.  Please run  ./configmigration --help  for a full explanation of required and optional flags.

NOTES
  • The "admin" user account is not moved, since one already exists in Angelfish
  • Funnel paths are not migrated
  • Inactive Urchin goals are not migrated

Here's an example command for the configmigration utility:

./configmigration --dir /usr/local/urchin7 --profiles 1,3,6,8,14 --skipsummary


STEP 2 - MIGRATE REPORT DATA
The datamigration utility is also located in the Angelfish installation directory.  Please run  ./datamigration --help  for a full explanation of required and optional flags.

Migrating data from Urchin to Angelfish will take a significant amount of time due to limitations in the Urchin 7 API.  The datamigration utility requests data from the Urchin API and recreates a hit for each pageview.  Each newly created hit is then processed by Angelfish.  

NOTES
  • Ecommerce/CPC data is not migrated
  • IT Reports Data is not migrated
  • Geolocation Data will be different - use of different geographic database.
  • Average Time on Site will be different.  Angelfish calls it "Engagement" and it excludes bounces.
  • Log tracking data isn't migrated, which means Angelfish might "re-read" a log file again during processing.
  • Migrated visitor data will have different visitor IDs in Angelfish than in Urchin
  • Angelfish does not store events.

Here is an example command for the datamigration utility:

./datamigration --startdate 2011-01-01 --enddate 2011-12-31 --apiuser johndoe --apipass itsasecret --apiport 9999