Designing a Foot Traffic Analytics Model: From Passing Data to Conversion Insights

In retail analytics systems, a common mistake is:

👉 Tracking only in-store traffic.

But without passing traffic, you cannot measure conversion.

Core Data Model
Passing Traffic
Dwell Traffic
In-store Traffic
Funnel Design
Passing → Dwell → Enter
Metrics
Entry Rate = In-store / Passing
Engagement Rate = Dwell / Passing
Efficiency = In-store / Dwell
Example
Passing: 1000
In-store: 80

Entry Rate = 8%

Engineering Challenges
Deduplication across sensors
Staff filtering
Dwell time detection
Key Takeaway

Without passing traffic:

👉 Conversion analysis is impossible.