Outlet Visit & Transaction Behavior Analysis

Objective

Analyze the impact of visit duration and frequency on outlet transactions and conversion into active outlets

Project Details

• Cleaned and matched visit & transaction data using fuzzy matching techniques.
• Calculated visit duration and frequency per outlet, analyzing their relationships using correlation analysis.
• Segmented outlets into active vs non-active and targeted vs non-targeted groups.
• Developed an interactive dashboard to visualize key business insights.
• Discovered that visit frequency strongly drives outlet activation and conversion, whereas visit duration has minimal impact.
• Identified that most targeted outlets are under-visited (<13 visits), limiting their activation potential.
• Recommended increasing visit frequency to high-potential outlets to maximize transaction activation.

Comments (1)