Migrate from Lead Perfection to Mailchimp

Lead Perfection contacts migrate as Mailchimp subscribers, using the email address as the unique key. First name, last name, phone, and address map to Mailchimp’s built‑in merge fields (FNAME, LNAME, PHONE, ADDRESS). Owner assignment resolves by matching the owner’s email in Lead Perfection to a Mailchimp subscriber; if no match exists, the owner tag is omitted and can be added later. Duplicate email addresses are flagged for review before import.

Lead Perfection company name migrates as a text merge field labeled COMPANY on the Mailchimp Audience. N:N company associations (one contact can link to multiple companies) collapse to the primary company name in the merge field; remaining associations exported as a reference CSV.

Lead Perfection lead status values (New, Contacted, Qualified, Sold, Lost) become both a LEAD_STATUS merge field and corresponding Mailchimp tags on each subscriber. The merge field stores the status text, while the tags enable source‑based campaigns. For instance, you can build a segment for contacts tagged ‘Internet’ to deliver a nurture sequence, or target ‘Referral’ contacts with a thank‑you email. Using merge field and tags gives you flexibility for reporting and workflows.

Lead Perfection lead source values (Internet, Referral, Walk‑in, etc.) become both a LEAD_SOURCE merge field and corresponding Mailchimp tags on each subscriber. The merge field preserves the text, while the tags enable source‑based campaigns. For instance, you can build a segment for contacts tagged ‘Internet’ to deliver a nurture sequence, or target ‘Referral’ contacts with a thank‑you email. Using merge field and tags gives you flexibility for reporting and workflows.

Lead Perfection appointment records (date, time, assigned sales rep, outcome) have no direct Mailchimp object equivalent. Appointment notes and scheduling data are exported as a reference CSV for manual entry into Mailchimp automations or a separate scheduling tool. To retain appointment context within Mailchimp, we create tags such as ‘Appointment‑Scheduled’ or ‘Appointment‑Completed’ on the contact record, enabling basic workflow triggers based on appointment status without native scheduling support.

Lead Perfection deal records with amounts, pipeline stages, and close dates do not have a Mailchimp equivalent. Deal data is exported as a reference CSV. Pipeline stage distribution can be recreated in Mailchimp segments using contact tags if deal history is relevant for re-engagement campaigns.

Lead Perfection custom properties on contacts map to Mailchimp merge fields. Mailchimp limits each Audience to 40 merge fields with character limits per type (text: 255; number: 12 digits; date: MM/DD/YYYY). Exceeding 40 custom properties requires prioritizing the most business-critical fields.

Lead Perfection zip code assignments per contact migrate to a ZIP_CODE merge field in Mailchimp. This field allows you to create geographic segments for location‑targeted campaigns, such as promotions for specific service areas or seasonal offers tied to regional weather patterns common in home improvement marketing. Zip‑code data can also feed automated workflows that trigger follow‑up emails based on proximity to a sales office or service zone.

Lead Perfection owner assignment migrates as an OWNER tag on the contact in Mailchimp. This tag preserves accountability for which sales rep generated or manages the lead, allowing you to segment your audience by sales territory or individual rep. You can then send rep‑specific follow‑up emails, performance reports, or territory‑based offers directly from Mailchimp, using the OWNER tag as the targeting criterion.

Lead Perfection product interest fields (Windows, Roofing, Siding, etc.) migrate as both a PRODUCT merge field and corresponding Mailchimp tags on each subscriber. When a contact expresses multiple interests, each interest generates a separate tag, allowing you to build product‑specific segments for targeted email campaigns. The merge field retains the full interest list for reference, while the tags drive automation workflows such as product‑launch announcements, maintenance tips, or seasonal promotions.

Lead Perfection activity notes (call logs, meeting summaries) migrate as Mailchimp contact notes on each subscriber. Original timestamps are appended to each note entry, preserving the chronology of interactions. Rich formatting, images, and embedded links from Lead Perfection are stripped during migration, leaving plain text that Mailchimp’s note field can display reliably. These notes can be reviewed by your team in Mailchimp to inform follow‑up timing and personalize email content based on past conversations.

Mailchimp does not expose the original contact creation date, so we create ORIGINAL_CREATE__c and LAST_UPDATED__c merge fields to preserve Lead Perfection timestamps. These date fields enable you to segment contacts by their original creation window, run time‑based reports on lead age, and trigger automations that act on the age of a lead. They also allow you to maintain reporting continuity when analyzing campaign performance against the historical lead pipeline.