1. Standardizing CRM Exports
Data AnalystBackground
The analyst receives weekly lead exports with inconsistent header naming conventions like 'First Name', 'first_name', and 'FIRST NAME'.
Problem
Manual renaming is error-prone and slows down the data ingestion pipeline.
How to use
Upload the file and use the Alias Map JSON to group all variations under a single standard header name.
{"first_name":["First Name","first name","FIRST_NAME"]}Outcome
All variations are normalized to 'first_name', ensuring consistent data structure for downstream processing.