P-004
Marketing Funnel Intelligence & Seller Conversion Optimization
Olist generates thousands of Marketing Qualified Leads (MQLs) through multiple acquisition channels, but the organization lacks visibility into: where leads are being lost, which channels produce high-quality sellers, a...
Pillar: propulsion · Status: draft
Economic Gravity
Under the principle of Diminishing Acquisition Efficiency, increasing lead volume alone does not guarantee proportional business growth. As acquisition scales, organizations often experience declining conversion quality due to:
- inefficient targeting,
- funnel leakage,
- and poor resource prioritization.
Businesses that fail to identify high-conversion lead segments waste marketing capital on low-probability prospects while underinvesting in channels with stronger economic return.
Strategic funnel intelligence enables organizations to:
- allocate resources more efficiently,
- prioritize high-value acquisition paths,
- and maximize seller onboarding ROI.
Flight Plan
- →* Clean and preprocess MQL funnel dataset
- →* Standardize lead origin and conversion records
- →* Analyze MQL-to-Won Deal conversion flow
- →* Calculate overall funnel conversion efficiency
- →* Identify major drop-off stages within acquisition process
- →* Segment MQLs based on conversion likelihood
- →* Compare acquisition channel performance
- →* Evaluate conversion efficiency by timing and lead source
- →* Detect inefficient marketing segments with high leakage
- →* Build executive-level Tableau funnel intelligence dashboard
- →* Translate findings into seller acquisition optimization strategies
Standard Equipment
- →* Python
- →* Pandas
- →* SQL
- →* Tableau
- →* Funnel conversion analysis
- →* Marketing attribution analytics
- →* Segmentation framework
- →* KPI monitoring
- →* Time-series trend analysis
- →* Seller acquisition dataset
- →* GitHub documentation workflow
Analysis
Key Takeaways: Unlocking Conversion Potential
Significant Funnel Leakage - A Major Opportunity:
- **Out of 8
000 total MQLs
a substantial 89.5% do not convert
resulting in an overall MQL-to-Won Deal conversion rate of just 10.5%. This highlights a significant bottleneck in our current funnel that
if addressed
could yield substantial growth in seller acquisition.**
Segmentation Reveals Diverse Conversion Potential:
- **Our MQL segmentation successfully categorizes leads by their conversion likelihood
enabling a more nuanced approach:**
- **The "Very High Potential - Organic (Mon/Tue)" segment is our top performer
boasting the highest conversion rate at 12.88%. This validates the effectiveness of combining specific lead origins with optimal timing.**
- **Conversely
the "Medium Potential - Social" segment dramatically underperforms with a mere 5.56% conversion rate
making it our least efficient segment.**
Volume vs. Quality: Directing Strategic Effort:
- **The "Other Potential" segment
while not the highest converting
represents the largest pool of MQLs (3
- and
consequently
the biggest volume of unconverted leads (3
415). Even small improvements here could yield substantial new sellers.**
- **The "Medium Potential - Social" segment
despite its low conversion rate
accounts for a sizable volume (1
300 MQLs). This indicates a significant area of inefficiency where current marketing efforts may be misdirected or require fundamental changes.**
- **Conversely
the "Very High Potential" segment
though smaller in volume (823 MQLs)
demonstrates high efficiency (106 won deals)
justifying focused
high-touch engagement.**
Channel Performance Varies Significantly in Efficiency:
- **When evaluating channels
Paid Search exhibits a higher conversion rate than Organic Search
suggesting it delivers more efficient MQLs.**
-
The prominence of Null and unknown origins in terms of conversion highlights critical data attribution gaps that need immediate investigation to truly understand and leverage these lead sources.
-
**Channels like Email and general Social show lower conversion efficiency
signaling a need for re-evaluation of their quality or the strategies applied to them.**
Early 2018 Saw Promising Funnel Growth & Efficiency:
- **The period of January-April 2018 showcased a strong
synchronized surge in both MQL volume and overall conversion rates
indicating a highly effective period for our marketing and sales operations. This trend suggests potential seasonality or the positive impact of specific campaigns during that time.**