Sherpa by Human37

Sherpa is a solution developed by Human37 to handle the painful reality of historical backfills, schema mapping, and data cleaning. Sherpa isn't just a script; it's a comprehensive interface for managing complex data migrations with precision. We use it to guarantee zero data loss.

1. Auto detect deeply nested schema: Automatically uncovers hidden arrays, objects, and nested properties in your raw data logs.
2. Data integrity validation: Ensures type consistency (strings vs numbers) and format validity before any data moves.
3. Schemas conflict warnings: Alerts our team immediately when legacy events clash with your new tracking plan rules.
4. Import of tracking plans: Directly ingest tracking plans to guide the mapping.
5. Visual mapper: A powerful UI to map legacy fields to new destinations without writing custom ETL code.

Using Sherpa Mixpanel helps client with the following:

1. Historical Continuity: Sherpa ensures your "Year-over-Year" charts work on Day 1. We preserve original timestamps, user properties, and session data.
2. Pain-Free Backfilling: No engineering sprints wasted on one-off ETL scripts. Our proprietary engine handles rate limits, retries, and batching automatically.
3. Leave the Junk Behind: We don't just copy/paste. We map old, messy events to your clean, new tracking plan during the transfer.