Data Challenges
At an early stage of inception, Javier knew that loading data manually wasn’t feasible as it would take up too much time and won’t scale with WellBefore’s increasing data needs. To avoid this situation altogether, Javier set up a cloud-based ETL tool, Skyvia, which worked out fine for some time, but eventually, he started facing some deal-breaking problems.
Our previous solution, Skyvia, wasn't as advanced as Hevo. It didn’t have a REST API or any equivalent and that was important for us as we needed it to load data from our inventory platform, QuickBooks Commerce.
Due to a lack of REST API functionality, Javier started looking for an alternative solution that could connect to their inventory platform, QuickBooks Commerce, and provide more flexibility in terms of connecting more data sources in the future.
The Solution
After evaluating some of the other cloud data pipeline providers, Javier decided to go ahead with Hevo primarily because of its REST API functionality and Shopify integration coupled with a user-friendly interface. The drag and drop transformations are also a handy way to format data before loading it into the warehouse.
We were able to switch to Hevo from Skyvia within an hour, after that it was just a day or two’s work to migrate all the pipelines to Hevo. The entire process was really quick and efficient. Hevo is an extremely easy to use and feature-rich platform that has helped us move quickly with all our data needs.
Now, Javier uses Hevo to sync sales and eCommerce data from Shopify to Wellbefore’s BigQuery data warehouse to build custom reports. Additionally, he integrates data from QuickBooks Commerce using the REST API and Google Sheets to BigQuery, this data is then used to manage and update inventory on the WellBefore website.
Key Results
Hevo is a fully managed solution that helps Javier save almost 10 hours per week. Pipelines created with Hevo are fault-tolerant and the auto-schema management feature ensures that the source schema is automatically reflected in the destination without any manual intervention or data loss. This has helped Javier save a lot of time that was otherwise spent on pipeline maintenance. He is now able to focus on delivering the best-in-class eCommerce experience to its customers with the help of unified data and it has increased their overall operational efficiency.
One of the best things about Hevo is that I don’t have to go on the platform very often, I can just set up my data pipelines and forget about them. Hevo’s support is great, best in class for sure. Then the way things are set up in terms of building pipelines is very intuitive and the new paginated logic is awesome. To date, I haven’t encountered any discrepancies as far as accuracy is concerned. It’s user-friendly and overall a very well thought out platform.
Javier uses Hevo to load close to ~300k events per month with 100% accuracy. He is also planning to use Hevo to integrate data from Klaivyo to BigQuery to obtain deeper insights into WellBefore’s customer data. WellBefore has emerged to be a key player during the pandemic for providing essential medical supplies at an affordable price to all. Hevo is extremely happy and proud of the growth that WellBefore has achieved in such a short time and we’re looking forward to working together in solving more business problems with the help of data and analytics.
Excited to see Hevo in action and understand how a modern data stack can help your business grow? Sign up for our 14-day free trial or register for a personalized demo with our product expert.
