Migrate from OneAdvanced Legal to Mailchimp

OneAdvanced organizations representing law firm clients map to Mailchimp contacts. The organization name migrates as a custom field (Client_Firm_Name__c) since Mailchimp contacts are individual subscribers without a native organization name field — the subscriber's full name is the primary identifier.

OneAdvanced contact records (individuals linked to clients) map 1:1 to Mailchimp subscribers. First name, last name, email address, and phone number transfer directly. Any contact without a valid email address is flagged and excluded — Mailchimp requires an email to create a subscriber.

The email address field is the primary key in Mailchimp, and every subscriber record requires one. Contacts in OneAdvanced without an email address cannot be migrated and are flagged for manual review. When the same email appears across multiple matter records in OneAdvanced, FlitStack resolves to the contact with the most recent last-modified timestamp, keeping the most current name, phone, and address data while stacking matter tags from both records on the single subscriber.

Phone numbers transfer to Mailchimp's PHONE merge field. If your Mailchimp account has SMS marketing enabled, these numbers become available for SMS campaigns. Otherwise, the field stores the number for reference purposes only. Mobile and landline numbers are merged into the same field with preference given to mobile.

OneAdvanced postal addresses containing street, city, postcode, and country map to Mailchimp's standard address merge fields (ADDR, CITY, STATE, ZIP, COUNTRY). These address fields enable geographic segmentation within Mailchimp, supporting regional client outreach campaigns and location-based filtering.

OneAdvanced matter reference codes such as CLT-2024-001 map to Mailchimp tags with a practice-area prefix, for example Litigation:CLT-2024-001 or Corporate:CRP-2024-015. This tagging approach maintains the matter connection without exposing confidential case details, while enabling segment filtering based on matter type.

OneAdvanced practice area classifications such as Family, Litigation, Corporate, and Private Client become Mailchimp tag categories that group matter tags under a parent label. This mirrors Mailchimp's native tag organization structure and allows campaign filtering by practice area within a single audience.

OneAdvanced matter status values (Active, Closed, On Hold, Archived) have no direct Mailchimp equivalent. We create a ClientStatus__c merge field as a pick-list and map each status value. This enables Mailchimp segments for 'Active Clients Only' or 'Re-engagement Campaign for Closed Matters.'

OneAdvanced contact creation timestamps transfer as a custom merge field (ClientSince__c) in Mailchimp, preserving the original client-onboard date. This field supports retention-focused segmentation by allowing you to target clients based on tenure rather than relying on Mailchimp's native account-age calculation.

If OneAdvanced stores marketing consent data, consent=YES maps to Mailchimp Subscribed status; consent=NO or blank maps to Unsubscribed. Contacts with no consent record cannot be imported as Subscribed — Mailchimp requires explicit opt-in. We flag these records so your team can run a re-permissioning campaign before importing.

The OneAdvanced fee earner assigned to a matter maps to a Mailchimp tag (e.g., FeeEarner:JohnSmith). This lets the marketing team route campaigns to the correct fee earner's client list or tag campaigns for internal attribution without exposing the internal user assignment model.

Documents attached to matters in OneAdvanced, including contracts, wills, and correspondence PDFs, do not migrate. Mailchimp has no document management layer — attachments in emails must be uploaded at send time as file uploads and are not stored as records. Documents must remain in OneAdvanced to satisfy compliance and audit trail requirements.

Billing records, invoice amounts, payment status, and trust account entries remain entirely in OneAdvanced. Mailchimp has no financial object — billing data cannot be represented in the email marketing platform and must stay in the practice management system for regulatory compliance purposes.

Billable time entries associated with matters do not migrate to Mailchimp. The platform has no time-tracking capability and no concept of matter-level billing entries. Fee-earner productivity reports and time analysis must continue to run using data from OneAdvanced.

OneAdvanced matter-stage workflows such as notifications triggered when a matter reaches Discovery have no Mailchimp equivalent. Email marketing automations in Mailchimp, including welcome series, birthday emails, and re-engagement flows, must be designed and built from scratch targeting the migrated contact audience.