(Excel-based exercise) How would you evaluate if conversion rates are going up or down? Sales funnel data for 3 successive months were given in an excel sheet
Sigiloso
I compiled a consolidated sheet and constructed a simple pivot table and grouped the time-framed into a logarithmic scale for simplification. It was clear that the conversion was going down. Interviewer had some follow up questions on how I would prioritize various product features that would improve conversions given this data . I answered this stating that we should look at what the inherent trade-offs are: e.g. if you improve sign up rate, then you may lower account verifications, etc.