Business Case: One of the largest food E-Commerce platform in the country.Every day more than 1 million users are transacting on the platform. Let’s say you are growth and strategy analyst of Swiggy and you need to generate insight on the company’s performance in 2019. For this, you are going to use the ‘Funnel Case Study Data’ workbook which has 3 worksheets. You can find the details of the sheets below: Session Details sheet has date wise session count. You can find listing sessions, menu sessions, cart sessions, payment sessions and order sessions day over day Channel wise traffic sheet has traffic (listing sessions) breakup at the date level.Supporting Data sheet has other information at the date level which might help you solve the case. The description of the columns is written below Metric Description Count of restaurants Number of operating restaurants for the day
Average Discount Average discount given to all the transacting customers
Out of stock Items per restaurant Average out of stock items per restaurant
Avg.Packaging charges On an average what is the packaging charges paid by customer while placing the order
Avg. Delivery Charges On an average what is the delivery charges paid by customer while placing the order
Avg Cost for two Cost for two is approximate spent for creating meal
Number of images per restaurant Count of images listed per restaurant on menu page
Success Rate of payments Ratio of successful transactions and payments initiated