InkImpact: Strategic Retention & LTV Intelligence for the Tattoo Removal Parlor

Project Summary

InkImpact is a decision-ready marketing analytics project built for the Tattoo Removal Parlor. By analyzing session telemetry, retention milestones, and acquisition channels, I identified where the business was losing nearly 44% of its revenue and translated that analysis into a concrete plan for improving retention and reallocating spend toward higher-value channels.

💼 The Business Challenge & Opportunity

• The Problem: The Parlor lacked visibility into the “Drop-off” points in the multi-session treatment journey. This resulted in high acquisition costs with low session completion rates.
• The Opportunity: Predictive insight into client behavior allows for targeted “Intervention Milestones”—incentivizing clients at the exact moment they are most likely to quit.

⚙️ Technical Architecture: From Data Cleaning to ROI

I utilized a diagnostic framework to bridge the gap between operational logs and marketing profitability.

1. Retention Funnel Mapping

I tracked client progression through session milestones (1 through 10+). By calculating the percentage of clients lost at each step, I visualized the “Leakage Points” in the business.

2. LTV & Channel Optimization

• LTV Calculation: Aggregated total revenue per unique client to establish a “Source Channel vs. Value” matrix.
• Correlation Analysis: Used Seaborn to identify the primary drivers of revenue.
• Key Finding: I discovered an extremely strong correlation (0.90) between Total_Sessions and Days_Since_Prior, proving that clients who commit to the long-term process—even with gaps—are the most profitable.

🔍 Key Business Insights

• The 43.8% Gap: The single largest point of leakage occurs between Session 1 and Session 2.
• High-Value Channels: Tattoo Artist Referrals and Google Search produce clients with the highest retention and LTV.
• Underperforming Channels: Facebook Ads and Word of Mouth leads show significantly lower LTV, suggesting a need for better lead qualification.

🚀 Strategic Recommendations

1. Automated Intervention: Implement a “Second Session” incentive for Google/Instagram leads to bridge the initial 43.8% churn gap.
2. Budget Reallocation: Shift marketing spend from Facebook Ads toward Tattoo Artist Referral partnerships.
3. Commitment Packages: Introduce bundled pricing (e.g., “6-Session Package”) to capitalize on the high correlation between session volume and profitability.

📽️ Technical Presentation & Code

This presentation details the full Exploratory Data Analysis (EDA) and the strategic roadmap developed for the Parlor.