Smart marketers know that there is a lot to be gained from integrating all of their 1st party data from external
marketing systems into one place. Roivenue helps them connect the worlds of marketing and business into one
Roivenue Data Integration is an ETL solution for your marketing, engineered to work with large sets of data. It connects directly to the
ever-growing number of marketing platforms like Facebook or Google DoubleClick and web analytical tools like Google Analytics or
Adobe Analytics and extracts the required data on the most granular (i.e. individual) level. It can also add any transformations along
the way like connecting data from web analytic tools and marketing platforms to analyse, for example, the ROI of your campaigns or
real cost per acquisition (CPA).
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
Connecting all of your data together is the first step toward becoming a real data driven business operation. Roivenue is here to be
your partner in this transformation. To get an idea about where it’s going to take you, we present a few of our data integration projects:
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
more than 10 verticals, we need to categorize them by vertical and connect them with acquisition marketing campaigns, which has
proven to be quite challenging. Our cooperation with Roivenue has started only recently and we already have a custom built database
available with all our marketing data, which is refreshed daily. Roivenue provides us with categorized data from campaigns connected
with website traffic and conversion data. Later, we connect this with our internal database, where we track the fulfillment of acquired
leads. With our acquisition and conversion funnel connected, we now see what really works and what doesn’t and we can thus focus on
optimizing our campaigns and services. It also pleases us that the Roivenue team is quite flexible with their offering and is willing to
work with us to find solutions matching our situation.
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.”
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
output table looks something like this:
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
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.
- Roivenue Data Integration integrates all data from your online marketing into comprehensive output
- This output is provided in the form of a cloud database
- The output structure is customized to your needs – you define what will be loaded and presented
- Data is refreshed daily
- You have full freedom to work with this database – built analysis by itself or connect it further with your internal database
- The Roivenue Data Integration is able to accommodate demanding needs of large enterprises, world class agencies as well as of fast-growing e-commerce projects
- The Roivenue team will assist you along the way and provide you with access to a library of Power BI templates