Ground Work — Strategic Consulting & Data Solutions

Chef Lori Digital Relaunch — Data Recovery, Brand & Outreach

20 years of email history converted into organized client database with brand refresh, mobile site relaunch, and targeted email campaigns.

Book a 15-min consult

Impact & Deliverables

Situation: Two decades of client history trapped in a single Yahoo inbox with no organized contact list, outdated web presence, and no active client engagement.

What I built: Email extraction and filtering system isolating active clients. Parsed contact names, phones, and emails with deduplication and normalization. Segmented and imported data into Mailchimp, refreshed brand voice, launched mobile-first site on Hostinger with inquiry forms, established templates and reconnection campaign.

Outcome: Clean, CRM-ready audience and modern web presence enabling targeted outreach that re-engaged past clients with repeatable process for similar small businesses.

Yahoo Export

Filter to Client Emails

Parse Names/Phones

De‑dupe & Normalize

Segment & Tag

Mailchimp Import

Templates & Campaign

Hostinger Site + Forms

Yahoo ExportFilter to Client EmailsParse Names/PhonesDe‑dupe & Normalize

Segment & TagMailchimp ImportTemplates & CampaignHostinger Site + Forms

Workflow

Yahoo ExportFilter to Client EmailsParse Names/PhonesDe‑dupe & Normalize

Segment & TagMailchimp ImportTemplates & CampaignHostinger Site + Forms

Consulting Relevance

Demonstrates end-to-end execution for solo service professionals: data extraction to CRM-ready audience to brand and site to campaigns. Same approach works for any small business with messy legacy email data, converting unstructured messages into growth-ready outreach using lightweight tool stack (Excel, Mailchimp, Hostinger).

Data Recovery & Digital Relaunch

Legacy email extraction, contact normalization, audience segmentation, and integrated site and email platform delivery.

Email Extraction & Filtering

Source data export

Legacy message extraction from Yahoo inbox with header preservation for audit trail. Minimal payload retention during processing.

Client isolation

Filtered promotional content and newsletters to retain one-to-one client communications and service inquiries. Applied From/To/Subject heuristics for customer identification.

Contact extraction

Parsed names, emails, phone numbers, and service context (event types, meal keywords, location). Message body content excluded beyond initial parsing.

Output

Raw contact dataset ready for normalization with source references maintained for verification.

Data Processing & Segmentation

Contact Normalization

Name and phone parsing

Regex-based extraction from email signatures. Capitalization normalization and phone format standardization applied.

Service classification

Keyword tagging from subject lines and content (weekly meal service, events, corporate catering, special occasions).

Geographic data

City and state extracted from signatures and message context for regional targeting capability.

Deduplication & Quality Control

Identity resolution

Email-based primary key with secondary phone and name matching. Duplicate records merged with change logging.

List validation

Bounce list cross-reference, opt-out flag verification, and deliverability screening before import.

Audience segmentation

Tagged by service type (events, weekly meal plans, corporate), engagement recency, location, and client versus prospect status.

Platform Integration & Launch

Mailchimp integration

CSV import with segment tags and core contact fields. Consent and opt-out preferences honored. Branded templates developed with reconnection campaign sequence.

Website deployment

Mobile-first site on Hostinger with service-focused copy, menu showcases, clear CTAs, and inquiry forms integrated with email list.

Brand development

Updated visual identity, tagline, and messaging aligned to personal chef positioning. Service portfolio and client testimonials featured.

Maintenance protocol

Seasonal campaign schedule with menu updates. New inquiry capture workflow feeding back into Mailchimp audience.

Data Privacy & Operations

Contact data limited to essential fields with no sensitive message content retained. Opt-out preferences and permission-based sending enforced. DKIM/SPF authentication configured via Mailchimp and Hostinger. Cleaned contact list backed up with refresh activity logged.

Open to short consults and build sprints.

Book a 15-min consult

Home

About

Open to short consults and build sprints.

Book a 15-min consult

Home

About