Unlocking Marketing Insights with Shopforward by building an Analytical Database

Client Overview:

Shopforward is a performance-based marketing agency that runs risk-free campaigns, only charging clients upon successful sales. They run thousands of campaigns at their own cost and only get paid by their clients if there is a sale. There is a lot of incentive in trying to see which campaigns are the most effective. Therefore they reached out to KYD Analytics to help build a Data Infrastructure to help analyse their data.

Current Stack: SQL Database.

Implemented Stack: Databricks and PowerBI.

Challenges Faced:

Lack of unified campaign insights across multiple channels: They are running campaigns in multiple different channels and each channel offers their own dashboards. If they have customers who have ads running on multiple channels they cannot infer if collectively they are going in the right direction with this customer’s product.
Data Bottleneck: As of now, they have to rely on their database administrators to extract or export some data they might need to do some analysis leading to slow turnover time and marketers need faster accessibility so they can try different strategies real time.

Solution:

KYD Analytics B.V. collaborated closely with the Shopforward to realise their first iteration of their Data Infrastructure and Provided training to their marketers to better understand how to use Powerbi:

Data Model based on MySQL: Build the first iteration of an Analytical Database in MySQL by taking their 3 important Data Sources of Campaigns, Sales, and Geodata. Transform them into a Dimensional Model ready to be imported into Powerbi.
Empowering their Marketers: Provided comprehensive training to marketers enabling them to independently create reports using PowerBI and derive actionable insights for strategy optimization.

Results Achieved:

First Step into their Data Journey: The first iteration of the Data Model is already showing promising insights and value to Shopforward. So much so that they have decided to transition to Databricks soon after our Collaboration.
Accessibility to Data and Insights: The Powerbi implementation supported the marketers to be able to swiftly find their insights and work on optimising their strategies. They find so much value in their insights that they have onboarded an internal data scientist to support them in building better insights.

Our Client's Testimonials

Working with KYD Analytics has been transformative for Shopforward. Their expertise in building our Data Infrastructure has provided us with invaluable insights into our campaigns and customer behavior. With their support, we've streamlined our analytics processes and empowered our team to make data-driven decisions in real-time. This partnership has not only enhanced our efficiency but also significantly improved our campaign outcomes. We look forward to continuing our journey with KYD Analytics as we further leverage data to drive success.

– Dirk Verzijden,

Founder, Shopforward

We had the pleasure to work with KYD Analytics B.V., which really paid off with getting PowerBI integrated in our daily routine. The whole integration went really smoothly, not only because of their knowledge, but also due to the fact that their response time was really fast and their ability to cope with business specific issues we faced. Abdul also adjusted to the desired 'pace' of integration. This meant sometimes we needed to go through the same processes twice, but also that we could skip certain things since the knowledge and logic was already there. I can only recommend working with KYD Analytics B.V. and would definitely reach out to them myself again the moment we are in need of help.

Conclusion: Through collaboration with KYD Analytics, Shopforward has leveraged data analytics to optimize workflows and enhance campaign effectiveness. With the new Data Infrastructure setup and Insights available at the fingertips of the marketers. Shopforward will be able to optimise their campaigns and get better value for them and their clients.