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

one to market logo black and white
Mediaxplain
Emakina
logo_artefact bw

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.

Agency favourite: You can have multiple connections to the same platform.

Cervinodata platforms Google Data Studio
Turn accounts ON

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.

Get alerted when a connection to an account gets interrupted.

Choose a BigQuery project

Last step is to choose a BigQuery project.

  • Connect Cervinodata to a BigQuery account
  • Choose one of the available BigQuery projects from the list
  • Press "Choose this project". DONE.


  • 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.

    Choose a Google BigQuery project
    SQL statements BigQuery

    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.

    Use the Query builder to build your own SQL statements for BigQuery a lot faster.

    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.

    Further reading

    BigQuery Case studies

  • google-bigquery-case-study-mediaxplain
  • Onetomarket Cervinodata bigquery
  • Support articles related to BigQuery

  • What is google bigquery
  • What is in the Relational data model