Learn how Creative Dock uses Keboola to keep track of acquisition costs and sharing it across departments.
Creative Dock is a Czech startup studio where ideas for new businesses are born, and under their management these ideas become fully-fledged companies. As a client Creative Dock, therefore, represents several clients from different sectors with different needs. A client like this can be a tough nut to crack. When we won the proposal for Creative Dock it meant implementing several tools at a time, and we knew we were in for a rough ride. But we like a challenge. As we want you to give you a glimpse into that process, we spoke to Mirek Esser, Head of IT at Czech Creative Dock, about how they use data and Keboola Connection to run their business of bringing new companies to life.
Mirek, what exactly is your IT department’s work at Creative Dock?
Our domain is data science. Everything from processing sensory data from phones in order to provide usage-based insurance, to calculating the cost of solar panels just from one photograph of the roof in question. We often set up fraud detection as well. These services are both sold to outside customers and used in our internal projects, and the process is highly autonomous. We are there for them when they want us, but they have the freedom to make their own decisions.
The implementation of Keboola has helped a lot with internal sales, as people are understandably interested in automating their reports. We began to notice a trend: as soon as people within a project saw the potential of what we could offer using Keboola, they found greater cause to calculate & evaluate much more data by themselves with the technology. We were able to add in new metrics that, in turn, increased the value of our service for further projects in Creative Dock.
When did you first hear about Keboola?
We heard about Keboola through Roman Pichlík, when he joined Zonky (one of the first companies on the Czech market providing peer-to-peer loans). At that time we were dealing with ETL for Cofidis (European financial company specializing in long-distance online loans) and Roman recommended Keboola to me for the project. It was not long before we were using it with Zonky as well.
We were mainly interested in automating reports, particularly acquisition reports. So we announced a tender and Keboola won it. The fact that the group are from Karlin was a major factor in our choice – we could easily call them or just go there and meet face-to-face. They are nice guys and I find them great to work with. Setting it all up took a mere three weeks and although initially there were some stumbling blocks, the reports delivered from the very beginning.
How had you dealt with ETL until then?
In the traditional, old-school way: data was cast into some server or another, I adjusted it via the client, used SQL, and produced a data mart table. I then moved this over to Excel and made final adjustments before presenting it to the client, voilà. The report came out either weekly or fortnightly.
We knew that we wanted this process automated. After Zonky and ETL, it only made sense to implement this throughout the whole of Creative Dock.
Home Credit bought Zonky in the autumn. Do they still use Keboola?
I’m not sure. I presume so because as soon as you begin there is no reason to go elsewhere!
I began to lobby for us to employ Keboola for other projects we develop here at Creative Dock, such as HoppyGo and ActivePass. Our internal projects benefited hugely from automated reporting and these benefits could expand across the board. I liked the way it had worked at Zonky and I trust Keboola; I know it has a future and that the group are by no means resting on their laurels. These are concerns I have had about other tools. I have the peace of mind with Keboola that if I have a problem, I can simply pick up the phone and call Petr Šimeček, for example, and he will deal with it. I have had no major issues yet but I know the quality of their support & reliability. I do not have to worry that the company has checked out after making the sale.
How specifically do you work with Keboola?
Our data team uses and modifies the actual interface to create operative reports, typically with new customers, average earnings from a customer, data about use, churn rate, etc. Above all, Keboola suits us for reporting the cost of acquisition from online campaigns. We actually apply this throughout all the projects that we have – meaning 15, maybe 20 projects.
We load data from GA, from the servers on which the services run, from the individual databases of actual projects, from MySQL databases and from Facebook. We also use manual input from Google Sheets, which we connect through Google Data Studio. This process used to be awful, but has recently greatly improved and is now optimized to work with.
We gather all of this data through Keboola and, after simple transformation, we publish it in a place where it can be easily analyzed by the business users, e.g. marketing departments, project leaders, etc.
Eventually, I hope that the data input stage will also be automated, and all we will have to do is add or delete projects once completed or handed over. We’re not quite there yet, though.
Is there anything else you would like to improve, optimise?
It goes without saying that, initially, it was not quite perfected. When I opened Keboola for the first time there were things that exasperated me, some things seemed poorly thought out. Keboola had to customize components to satisfy our needs and everything has now been sorted out or is in the process of.
Together we have made a massive improvement on how data management works at Creative Dock. I truly enjoy working with Jakub Turner from Keboola and he makes great efforts outwith the business as well. He has linked me with other people, we have even done a Hackathon together.
One last question: How do you see the role of data in business?
I always say that big data is only important if it has a big impact on the actual business of a particular company. There is no need to go overboard. If the data is relevant to the core upon which the company is built, and is necessary for business to work, then it is big data. I really don’t care if I can pour in terabytes or petabytes in milliseconds. What is important is what I can produce as output from such data. That is what makes it indispensable to the company.
Thank you for talking to us. We hope everything goes well at Creative Dock!
