Ritual obtains a unified view of sales data from its brick-and-mortar partners.
Direct-to-consumer (DTC) startup leverages data automation to support expansion with brick-and-mortar partners.
The era of chain stores We recently spoke with Brett Trani, Director of Analytics at RitualLearn how a digitally native health and wellness company specializing in a variety of women’s vitamins successfully sells its products through brick-and-mortar retailers like Target and Whole Foods with data support from Snowflake and Crisp. Learn more about what’s going on.
as You started selling your product line through retail partners, but what problems did you run into?
When we moved to brick-and-mortar, we needed to interface with systems that were older than our internal systems, and we couldn’t easily extract data from them. To get data on what was actually happening at Target and Whole Foods on a daily basis, sales teams had to log into portals and manually download data from various platforms.
They were spending a lot of manual effort to capture partner data into record sheets. If your company knows about the sheet, you’ll likely have access to it. But it was kind of siloed, and then we ran into a problem where someone went on vacation for a few months and no one knew how to get that data out.
As a result, the process was very manual and very time-consuming, and the data could not be shared between other parties in the company.
How did you begin your efforts to improve integration with your brick-and-mortar partners?
We tried to build the integration ourselves using an existing Snowflake Data Cloud implementation. For example, we were able to take data transferred from sources such as the Target API and put it into Snowflake. However, issues still occurred such as permissions expiring, schemas changing, and the structure of the data itself changing.
What was the next step?
We decided to start investigating if there were any vendors or platforms that could help us capture and store third-party data on the Snowflake platform. We discovered Crisp SaaS-based collaborative commerce solutions from industry recommendations. That company had a model that fit what Ritual was looking for. It was something we could set up and run without any management on our part.
How did you implement Crisp?
Since Crisp is a partner in the Snowflake vendor marketplace, there was no real integration process and the implementation was smooth. When it came to setup, such as getting data from our retail partners, we were able to do his 15 minute process ourselves, which mainly involved entering credentials.
Data started appearing after a few hours. Ritual has been using Crisp and Snowflake for about six months.
How has Ritual benefited from implementing this technology?
All manual tasks such as regular meetings, coding, and check-ins were eliminated, saving approximately 10 hours of physical labor per week. Over the course of a year, this equated to approximately 500 hours of labor saved, which was an immediate and immediate return on investment.
The second benefit is that we can integrate all of this partner’s retail and sell-through data into our larger data ecosystem. So instead of treating brick-and-mortar stores as separate channels that tend to be siled, we can bring all our data together in a unified ordering model that allows everyone to see our business and integrate all these data sources. I did it like this.
Use visualization tools to integrate all your data. This means that people up to the executive level within a company can consolidate and see all the different types of data from different sources, instead of manually pulling and combining all of these disparate reports. Masu.
This data is so reliable that we are now more proactive in not only optimizing inventory, but also addressing issues such as impending out-of-stocks. These are just beginning to emerge because we now have good underlying data.
[Read more: How important is direct-to-consumer for CPG companies?]
