As a 65-year-old brand that has been online for nearly 20 years, The Spice House has a lot of data.
To manage it, the team had been using the BI tool Glew for insights and analytics, but they often opted for Google Sheets because it enabled the sort of customizable reporting and analysis that Glew could not provide. However, as demand for more sophisticated analyses with larger amounts of data grew, manipulating data in Google Sheets became unsustainable.
The missing ingredient? Daasity, which helped The Spice House easily build customized reports, provided a way to better centralize and analyze multi-channel data, and saved the team time on pulling data and doing more complex data analyses.
The Spice House leverages Daasity to send automated daily business health reports via Slack. These serve to keep the entire business, including store teams, customer service, and inventory warehouse managers all on the same page on how sales are performing for the day, week, month, and year.
Additionally, The Spice House uses brand-supplied data in Daasity to report their actuals against their plan and keep the business on track. They’ve customized this reporting by tracking sales goals by channel, such as against separate budgets for retail and online.
When The Spice House launched ExactPacks, a one-time-use easy meal product, the team wanted to better understand customer behavior and the impact on customer lifetime value—and use this data to guide future product launches. Using Daasity, the team tracked who was buying the new products, which other products were purchased with ExactPacks, and any differences in customer behavior between the first versus the second purchase of the product.
The Spice House needed a way to create a centralized data source for its multiple sales channels: DTC eCommerce, retail, and wholesale.
Often, those data worlds collide. On the retail side, by setting up custom filters in Daasity, the team can simply track buy-online-and-pickup-in-store (BOPIS) orders and accurately attribute sales to the right channels. On the wholesale side, Daasity enables the team to filter out the wholesale orders that come through Shopify and report on those separately from their eCommerce sales.
Daasity also enables The Spice House to pull in historical data when needed. Although the brand has been selling online for quite a while, they didn’t launch a Shopify store until 2019.
Therefore, the team was challenged by a lot of noise in its multi-channel historic data. Using Daasity, the team can choose to include or exclude historical data in its reporting, to enable analyses based on particular data sets.
The Spice House team appreciated Daasity’s preset dashboards as a starting point to quickly implement further customization and filtering for the reports it wanted to create for its business.
With this foundation already built in, the team felt confident in trusting the numbers–that all its reporting, even from more complex data analyses, would reflect the right variables, such as time period, channels, and types of orders.
The team liked that Daasity enabled them to be very hands-on with the data and do its own customization, as opposed to depending on a platform customer service team and potentially paying additional fees, as can be the case with other platforms.
The ability to cut data in many different ways before exporting (versus exporting raw data) saves the team significant time every month to run more complex and ad hoc analyses.
.png)
