The easiest way to get your campaign performance and Google Analytics data in Google BigQuery
Your ad data and Google Analytics data in BigQuery without coding.
Cervinodata for Google BigQuery: No coding needed.
Data delivery you can trust
Get an alert if a connection is broken
Our data collection engine has multiple fail safe mechanisms to ensure great data delivery reliability. We'll alert you if a connection is broken, so you can fix it before your client finds out.
Historic data
From all your ad platforms and Google Analytics.
Cervinodata will collect your historic Google Analytics data and ad campaign data from Facebook Ads, LinkedIn Ads and other ad platforms and delivers this to Google BigQuery.
Drag & Drop ease of use
No coding. No it needed.
The easy to use interface is built for (and by) marketers and allows you to manage all your clients, ad platforms and campaigns without writing one line of code.
Fresh data every day
Talking care of conversion windows.
Cervinodata automatically updates your BigQuery project every day, keeping in mind the 7 to 30 day conversion window for some ad platforms.
Relational data model
Straight out of the box
When you connect Cervinodata to your BigQuery project, Cervinodata deploys a relational data model to your project and syncs all your campaign performance data.
Blend ad platforms & Analytics
Return on Ad Spend
Blend data from different ad platforms, multiple accounts and clients together with Google Analytics to connect the dots between ad spend and revenue.
Trusted by agencies around the world
Mark, technical advertising specialist
"The options within Cervinodata to group multiple campaigns from different platforms saves me about 4 hours every week. There is even a clever way to connect ad spend to ecommerce revenue. This allows us to adjust campaigns based on ROAS”
René, Digital Analytics Consultant at Onetomarket
“The Cervinodata Engine is a very simple yet powerful tool to get all our ad campaign performance and GA data of all our clients together in Google BigQuery. Cervinodata offers clever tools, like the query builder, that make it easy to get the right data in the right BigQuery table. This saves us a lot of time and hassle.”
Gido, Online Marketer at Booking Boosters
“The Cervinodata team deserves compliments for their support. We really appreciate the fast response times and quick fixes of issues or problems.”
How to get a set up Cervinodata for Google BigQuery
Cervinodata helps you save countless of hours setting up a relational data model in Google BigQuery. And maintaining it. Setting up is very easy. Just follow these steps.
Connect your platforms
Simply connect all your ad platforms and Google Analytics views to Cervinodata.
This allows you to blend, filter and group all your ad accounts together, multiple ad platforms and Google Analytics views together and even allows you to connect the Media spend to Revenue (for simple ROAS calculation). This setup is synced to your BigQuery project.
Switch accounts ON
Switch all accounts to ON to collect historic and current data. Cervinodata has multiple failsafe mechanisms to try and re-try collecting data. This ensures the highest possible level of data delivery reliability and performance.
When you switch an account to ON, historic data will be collected and then added to your Google BigQuery project. After that, as long as you keep the account switched to ON, new data will we added to your BigQuery project daily.
Choose a BigQuery project
Last step is to choose a BigQuery project.
You only need to choose a BigQuery project once. Cervinodata will automatically build a relational data model in this BigQuery project and will sync all available historic and current data to that relational data model.
Drag & Drop Query builder
To get started fast, Cervinodata comes with an easy to use drag & drop query builder that builds SQL statements based on the Cervinodata table structure (and names) in your project.
The Query builder makes it easy to filter specific data if you do not know how to write SQL statements. Or hit the ground running when you do.
Start a Cervinodata Free plan
Our free plan comes with 182 days data retention and weekly data refresh. Blend data from multiple ad platforms (like Facebook Ads, Google Ads and more) with Google Analytics and get your campaign performance reporting up and running in minutes. Free templates available.