Omnycode is a boutique ecommerce agency providing a wide range of services and solutions. Their passion and expertise lies in helping small and medium omni-channel businesses grow. Omnycode supports their clients in the following areas: go-to-market strategy, digital marketing, ecommerce design and development.
Cherrybrook is an Omnichannel business with several online stores, marketplace stores and brick and mortar locations. Cherrybrook licensed Glew Plus through Omnycode and their Insights Platform.
Challenge
As an Omnichannel business with many different revenue sources and data sources, it was very difficult for Cherrybrook to have a clear view of overall business performance. They had been using many data sources and doing a lot of spreadsheet work to bring things together in a single viewpoint. The data analysis was time consuming and not as actionable as it could have been if it were easier to generate.
Solution
The program began with standard Glew.io integrations. Shortly after Cherrybrook became familiar with the platform, Omnycode built reports in BI Tunnel that enabled an omnichannel snapshot view of the online performance consolidating all ecommerce and marketplace sales into a single report.
The “All Channel Profitability” was later expanded to include the brick and mortar sales through integration of a Custom Table Upload (CTU). The CTU allows clients to add additional data from outside sources to the data warehouse within Glew. For the first time ever, this report allowed Cherrybrook to see total company daily performance in one report.
Several other custom reports have brought Cherrybrook enhanced visibility into their business. One example is the “Shipping Profitability Report” which allows Cherrybrook to see Net Margin at the Order level including the Product Revenue, Cost of Goods Sold, Shipping Revenue and Shipping Costs. This report also allows the users to specify date ranges and channels and then export the data for further analysis. Another example is the “Paid Search Dashboard”, which combines data from Google Adwords, Google Analytics and their ecommerce platform to provide a clear view of Ad Spend, Return on Ad Spend, Gross Margins, etc.