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,
• and which lead segments deserve prioritized sales engagement.

Without funnel intelligence, marketing investment becomes inefficient:

• acquisition budgets scale without proportional seller growth,
• sales teams focus on low-quality leads,
• and conversion leakage silently compounds across the onboarding process.

This mission was designed to transform raw seller acquisition data into a strategic funnel intelligence system capable of:

• measuring conversion efficiency,
• identifying high-potential lead segments,
• and optimizing seller onboarding performance.

The project combines:

• marketing funnel analytics,
• segmentation logic,
• conversion diagnostics,
• and operational dashboarding to improve acquisition ROI and seller conversion performance.

---

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.

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

855. 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.