Menu

Using BigQuery to forecast demand and drive operational efficiency

FreshDirect

Challenge

Post-pandemic, FreshDirect was experiencing record demand – but the company also very quickly observed that many potential customers were abandoning carts when customers they saw no available delivery time slots at checkout

Post-pandemic, FreshDirect was experiencing record demand – but the company also very quickly observed that many potential customers were abandoning carts when customers they saw no available delivery time slots at checkout

Solution

By integrating GA4 and BigQuery, Napkyn was able to develop reporting dashboards to create a much deeper view of customer behavior, enabling marketing and operations managers to better understand and anticipate demand. Napkyn also used GCP to regularly push GA4 user activity data to FreshDirect’s Oracle systems, enabling FreshDirect’s operations team to immediately optimize delivery slots and corresponding truck capacity.

By integrating GA4 and BigQuery, Napkyn was able to develop reporting dashboards to create a much deeper view of customer behavior, enabling marketing and operations managers to better understand and anticipate demand. Napkyn also used GCP to regularly push GA4 user activity data to FreshDirect’s Oracle systems, enabling FreshDirect’s operations team to immediately optimize delivery slots and corresponding truck capacity.

Results
  • Immediate 3x conversion rate lift by optimizing delivery slots and delivery truck capacity to better align with customer behavior

  • Stable & sustainable process for analytics & operations teams to optimize all aspects of delivery workflow on an ongoing basis

  • Immediate 3x conversion rate lift by optimizing delivery slots and delivery truck capacity to better align with customer behavior

  • Stable & sustainable process for analytics & operations teams to optimize all aspects of delivery workflow on an ongoing basis

Back to Case Studies

Latest Insights and Education

Latest Insights and Education

August 2024 GA4 & GMP Updates

Napkyn

Sep 4, 2024

Implementing Enhanced Conversions in Google Ads and GA4

Monika Boldak

Associate Director, Marketing

Aug 29, 2024

Why Investing in Proper Google Analytics 4 Implementation is Essential for Maximizing Marketing ROI

Monika Boldak

Associate Director, Data Solutions

Aug 28, 2024

More Insights

Sign Up For Our Newsletter

Sign Up For Our Newsletter

Napkyn Inc.
204-78 George Street, Ottawa, Ontario, K1N 5W1, Canada

Napkyn US
6 East 32nd Street, 9th Floor, New York, NY 10016, USA

212-247-0800 | info@napkyn.com