GroupM, Sazka and Ušetřeno.cz are Connecting Marketing Data and CRM with Roivenue Data Integration
Sazka is a leading lottery company in the Czech Republic with billions in revenue. It offers a whole range of betting products including lottery tickets and sports bets as well as non-lottery products like a virtual tele-operator and an event ticket portal. With such a wide product mix, dozens of websites and a rich portfolio of ad technologies, the robustness and flexibility of Roivenue Data Integration was exactly what their CMO was looking for.
GroupM is the world’s largest advertising media company in terms of billings. With tens of thousands of clients and over 30,000 employees spread out in 81 countries, GroupM always utilises the best state-of-the-art MarTech and AdTech solutions on the market that can stand up against its high expectations.
Ušetřeno.cz is a leading Czech utility comparison website which was recently acquired by ČSOB, a subsidiary of KBC. The service has helped over 2.2 million people find cheaper energy, telco, internet, loan, mortgage, credit card and bank account providers. The ability to fine-tune the data integration separately across their different verticals was a crucial decision factor when choosing a provider.
Thanks to the transformation you can create a much deeper and detailed analysis which analytics tools provide, only on higher level like event or path analysis. You can even create your own data warehouse for data from web analytics tools and marketing platforms and have them stored in a way that every data analyst (not just web data analyst) can understand and work with them. Finally, it stores the data in a cloud storage of your choosing, for instance, MS Azure Blob Storage or Google Cloud Storage. The ability to run an unlimited number of connectors and data requests makes Roivenue Data Integration a sought out solution for large enterprises as well as agile and fast growing e-commerce retailers.
While the Roivenue Attribution product focuses on advanced marketing challenges like post-view attribution or CLV analysis, Roivenue Data Integration is the backbone of any data processing within a marketing department. If you need to have all of your data in one place for further analysing and dashboarding, look no further.
Main strengths of Roivenue Data Integration:
- Extraction of online data on a selected granular level, working with personal or even impression level data
- Robustness of the solution, engineered to handle large datasets
- Presentation of data in your destination of choice and updated daily
- Growing the number of connectors to marketing platforms
The Use Cases
Martin Novák, Head of Business Intelligence
"Our focus on the online part of our business has been increasing over the past few years. To be able to cope with the ever-increasing amount of data from our online marketing campaigns, we have started developing our own in-house analytics team. For them, the Roivenue Data Integration solution has proven to be very valuable. Not only is it saving us a huge amount of time on data collection and preparation, it's also enabling us to analyze our online data in a way that would otherwise be very difficult and costly. The daily refreshed dataset of connected funnel from investment to conversion with all the metrics we need has proven to be a very valuable resource. We also see great benefit in the fact that we can operate Roivenue platform connectors, which gives us freedom in selecting exactly what data we want to extract and analyze."
As a result of this project, we’ve been able to cut reporting time costs by 90% and thanks to automatic data flows we are now able to look at our business in a way which previously wasn’t possible."
Michal Charvát, Data Manager
"Roivenue data integration enables us to access all data from our client campaigns in a structure which complies with our planning and reporting standards. The Roivenue team has worked with us closely during the implementation phase and made sure that the prepared database will fit our specific needs. Now we have all the data at hand necessary to track the performance of our campaigns and also to build custom reporting for our various clients. With many hours saved on data preparation, we can now fully focus on what we are best at.
Thanks to Roivenue Data integration, we have saved 10 hours weekly on budget reporting per agency within our group."
Take a look under the hood of Roivenue's Data Integration Solution
Dimensions > Source, Medium, Campaign, Adgroup, Keyword/Banner, TransactionID
Metrics > Cost, Views, Impressions, Clicks, Sessions, Pages per Session, Bounces, Conversions, Revenue
The example above is our answer to the traditional question in marketing - what does my spending actually bring back in? If you are more so interested in a deep analysis of a single platform, queries can be set up to load data combinations based on your preference. In-depth reporting on display campaigns from your favorite DSP? Properly evaluating the reach from Facebook and AdWords campaigns? Products sold with traffic sources evaluation over time? You name it.
Link up to data in your database by transaction ID and let your data analyst go crazy. Don’t have transaction ID tracking setup finished yet? No problem, we have experience with this as well and we’ll be glad to work out the right solution for you.
There are no worries about the freshness of data either. We’ve optimized the process to such a degree that we’re able to provide complete data up to the last day at 8 AM each morning. This way you can start your day off with all the information you need.
And where might this take you? One of the cases is realizing the real impact of product campaigns on sold items. Consider the following example:
In an online sports apparel store, you are running a product campaign for shoes, but the orders placed resulting from these campaigns consist of many other product categories. Could it be that people tend to click through shoe campaigns, but in the end they purchase shirts? And what types of shirts? What is the typical basket resulting from this shoe campaign comprised of? What are the best acquisition product campaigns?
All of these questions can be solved, all you need is data. That’s where we come in.
- Define which marketing platforms will be connected
- Talk to your CSM about the ways in which you want the data to be presented - on what level of granularity and if you want to have some specific parameters included in the output
- The Roivenue team prepares everything for you - from data loading to the defining of the export structure
- A loaded and polished dataset is waiting for you in the cloud database, refreshed daily
Now what? Well, if you have an in-house analyst, it’s his time to get to work. In any instance, you can count on the availability of a growing library of Power BI templates developed by the Roivenue team on our many use cases. These templates can be connected to the cloud database and visualize the data it contains for you.