In New York City, a number of companies such as 1520, Fridge No More, JOKR and BUYK have started offering local grocery delivery in 15 minutes from dark stores. As these services expand out into other, less densely populated cities, understanding how to optimize delivery operations will be critical to ensure profitability.
To explore what’s possible, we simulated a site selection process for dark grocery stores in Seattle using geospatial data and analysis with CARTO Analytics Toolbox for Snowflake. This includes using existing data from Snowflake, enriched with insights from CARTO’s Data Observatory.
A dark store (also known as a “ghost store”) is a fulfillment center that doesn’t offer in-store pickup or shopping - instead, these grocery stores function like a warehouse with the main site selection goal being location convenience for quickly fulfilling and delivering online grocery orders. In some cases, like Kroger’s ghost grocery store in Florida, the warehouse in itself is operated by robots while human delivery drivers pick-up and drop-off orders at the customer’s door.
With online grocery orders now driving 12.3% of all grocery sales and delivery experiencing a 20% year-over-year revenue increase from USD $2.9 billion to USD $3,5 billion, more grocers are beginning to incorporate the dark store fulfillment model into their expansion plans. For example, British online grocer Ocado and Kroger partnered three years ago to build ghost stores across the United States, and invested USD $55 million alone simply into the construction of its first fulfillment center in Florida.
Now that we know some of the details around what a dark grocery store is, let’s explore a scenario that will help us understand how to use geospatial data from the CARTO Data Observatory and Snowflake Data Marketplace to determine the optimal locations for the placement of ghost grocery stores. In this example, the user is an Expansion Manager who needs to find five ideal sites for ghost grocery stores in Seattle, Washington.
When expanding to new markets, the first item to focus on is the suitability of the market, including high-level factors of population density and consumer segments.
The harder job is on the ground, finding ideal locations for the ghost grocery stores. In this scenario, our Expansion Manager has been handed 7 potential locations by their Real Estate team. How can we find the 5 best locations for maximum coverage and market fit?
We can analyze each potential location by looking at a number of spatial factors within each delivery zone using the CARTO Data Observatory and Snowflake Data Marketplace, including:
Using a spatial index, in this case, H3 cells, we can create a grid around the entire city and for each cell, measure multiple spatial data streams.
We can normalize these measures to create a suitability index to score each cell for all these variables. In this map, darker cells have more of the attributes for a successful location.
The power of Snowflake and spatial analytics provided by the CARTO Analytics Toolbox allows the Expansion Manager to enrich with hundreds of variables in grids covering every single market nationwide.
This provides complete coverage in every market and granular insights to help find the best possible locations.
Using location-allocation analysis along with current app sign-ups already stored in Snowflake, we can find the most suitable 6 locations.
We use local only roads, since our riders will use bikes. The analysis, called the Location Set Covering Problem (LSCP), is the same that is used to locate the best sites for fire stations, for example. It gives us the maximum demand coverage within a minimum service time or distance.
We now have a total of six locations that give us the required coverage of one mile from the dark stores.
Exactly half of the locations came from our Real Estate team, the other half from our suitability index. We now have target areas for our Real Estate team to explore and find locations, and we can start to lease the other locations right away!
Look no further - you’ve found it! Tap into powerful spatial analytics with CARTO and your data warehouse to locate the optimal location for your next ghost grocery store.
To get started, you can sign up for a CARTO account, connect to your data warehouse of choice and voilà! You’re ready to begin using our Analytics Toolbox. You can also easily access data from the CARTO Data Observatory within the platform.
|This project has received funding from the European Union's Horizon 2020 research and innovation programme under grant agreement No 960401.|
Over the past years, many of the extreme weather events that occured around the world are known to be worsened by man-induced climate change through green-house gas emissio...Spatial Data
Please fill out the below form and we'll be in touch real soon.