← All projects

TripleTen Data Analyst Bootcamp · SQL · Funnel & Cohort Analysis · Jan–Aug 2025 · Rodrigo Garza García

MercadoLibre — Funnel & Retention Analysis

E-commerce Conversion Funnel and User Retention

Used SQL to examine the e-commerce conversion funnel and D7, D14, D21 and D28 retention across ten Latin American countries, comparing markets and customer cohorts.

Business questions

Overall conversion funnel

MercadoLibre overall conversion funnel
Conversion rates across the six observed funnel stages.
Funnel stageConversion rate
Select item76.90%
Add to cart11.01%
Begin checkout4.00%
Add shipping information2.42%
Add payment information2.09%
Purchase1.25%

The largest drop occurred between product selection and cart addition: 65.89 percentage points. This is the clearest point in the observed journey to investigate before users formally begin checkout.

Country-level funnel comparison

MercadoLibre funnel performance by country
Add-to-cart performance varied across the ten markets analyzed.
CountryAdd-to-cart rate
Uruguay22.73%
Chile17.53%
Brazil8.90%
Argentina8.75%

Uruguay and Chile recorded the strongest add-to-cart results, while Brazil and Argentina showed the weakest among the countries highlighted.

Cohort retention

MercadoLibre retention by cohort at D7, D14, D21 and D28
Retention in the January 1–6 cohort declined from 86.2% at D7 to 3.0% at D28.
Retention periodJanuary 1–6 cohort
D786.2%
D1456.2%
D2124.1%
D283.0%

At D28, Peru (3.2%) and Mexico (3.1%) showed the strongest results; Chile (1.7%) and Colombia (1.6%) were among the lowest.

Methodology

Business recommendations

Tools and methods

SQL · Common Table Expressions (CTEs) · Funnel Analysis · Cohort Analysis · Retention Analysis · Data Validation · KPI Interpretation · Executive Reporting.

The original SQL queries were executed in TripleTen's learning environment and are not currently available outside that platform. The repository documents the business problem, methodology, results and recommendations; it does not reproduce the original SQL scripts. The analysis is descriptive and does not establish causality. The available data does not include qualitative evidence explaining why users abandoned the funnel.

Project deliverables

Project repository ↗ Analysis workbook ↗