Data Mapping Guide
Understanding how your data flows into Milemarker
What is Data Mapping?
Data mapping is the process of aligning data fields from your custodians and other sources to Milemarker's data model. This ensures that account names, positions, transactions, and other information display correctly in the platform.
Key Data Elements
Household & Client Data
Client names, contact information, relationships, and household groupings. Mapped from your CRM or custodian data.
Account Information
Account numbers, registration types, account names, and custodian identifiers. Essential for proper account linking.
Holdings & Positions
Security symbols, CUSIP/ISIN, quantities, cost basis, and market values. Pulled daily from custodians.
Transactions
Buys, sells, dividends, transfers, fees, and other activity. Transaction type codes are mapped to Milemarker categories.
Data Flow
Custodian
Source Data
Mapping Layer
Transform & Validate
Milemarker
Unified View
Common Mapping Tasks
Account Type Mapping
Map custodian account type codes (IRA, JTEN, TRUST) to Milemarker's standardized categories.
Transaction Type Mapping
Align custodian transaction codes with Milemarker's transaction categories for consistent reporting.
Security Classification
Define asset class, sector, and style classifications for proper allocation reporting.
Household Grouping
Link accounts to the correct households for consolidated reporting.
Data Issues?
If you notice any data discrepancies, contact your Success Manager. They can review mappings and make adjustments.