Instacart is an online grocery store that operates through an app. Instacart already has very good sales, but they want to uncover more information about their sales patterns. The objective of this project is to analyse customer behaviour and uncover patterns for growth.
Consistency checks, wrangling and column derivations were conducted to ensure data accuracy and integrity
Recommendations for ad placement include targeting the post-work window around 4-5 PM when people are more likely to be influenced by ads due to mental fatigue, utilizing lunch hours when consumer phone activity peaks, and ramping up ads over the weekend when people have more time to shop.
Emphasize variations in ordering behaviors between customers with and without dependents.
Investigate early morning sales (2 AM to 7 AM) where higher prices and greater price variability suggest a market for premium products related to morning routines.