Interactive portfolio dashboard

Customer Retention & Revenue Intelligence

Explore revenue, retention, customer activity, product categories, and regional performance from the Brazilian Olist ecommerce dataset.

Total revenueDelivered order payment value
Delivered ordersCompleted marketplace orders
Unique customersDistinct customer identifiers
Average order valueRevenue per delivered order
Repeat purchase rateCustomers with more than one order
Churn-risk customersInactive for more than 180 days

Monthly performance trend

Use the metric buttons to switch between revenue, order volume, customers, and average order value.

Business lens

Retention is the biggest opportunity: most customers purchase once and do not naturally return.

Start lifecycle campaigns in high-volume states, then measure repeat purchase rate and cohort retention each month.

Top product categories

Compare category contribution by revenue, orders, or customers.

Top customer states

Identify where retention and marketing tests can reach the largest customer base.

Average cohort retention curve

Month zero starts at 100%; later months show how sharply customer activity drops.

Customer activity mix

Inactive customers dominate the base, which points to win-back and post-purchase engagement.

Recommended next actions

Actions are prioritised for measurable revenue and retention impact.

1. Launch post-purchase journeys

Target Sao Paulo, Rio de Janeiro, and Minas Gerais first because customer density is highest there.

2. Cross-sell top categories

Use health and beauty, watches and gifts, bed bath table, and sports leisure as first campaign groups.

3. Track retention monthly

Make repeat purchase rate, cohort retention, inactive customer share, and AOV the executive KPI set.

Top state detail

The top ten states by revenue, including order volume, customers, and average review score.

State Orders Customers Avg review Revenue