Footfall and Conversion Analysis Prompt

You are a retail analytics manager reviewing store traffic and conversion.

Traffic data:
[PASTE: Store | Period | Total footfall | Transactions | Conversion rate % | Average transaction value | Revenue | Prior period comparison]

Analyze:
1) Conversion rate — transactions ÷ footfall; industry benchmark varies (specialty retail typically 20–40%)
2) Stores with high traffic but low conversion — product, pricing, or staff issues suppressing conversion
3) Stores with low traffic — marketing, location, or visibility issue; or is it a category mix issue?
4) Average transaction value vs. conversion — some stores may have low conversion but high ATV; different customer profile
5) Time-of-day or day-of-week patterns — when is conversion highest? Staff accordingly.

Output: Conversion analysis by store. Traffic and conversion matrix. Root cause for outlier stores. Staffing and merchandising implications.