Google Big Query
Google Big Query is Google's powerful and low cost data storage service (More about it's low cost , article in Dutch). For most professional users, it is thé starting point of their reporting and data interpretation infrastructure,
Keeps all your data in one place
With it's flexible table structure and options to add new tables to existing ones, it's possible to build a database structure to keep all your clients in one relational database structure. Go deeper and also add campaign level and ads level to the data. And of course connect to Google Analytics to see what your campaigns do for revenue. Designing a database structure and it's relations will require the proper knowledge in your team to make it work.
If you wish to save time: Cervinodata Gold (see pricing here) comes with the delivery of a relational table structure in Google Big Query that get's you started right away.
Connects to best-in-class reporting tools
It's easy to feed dashboards, reports and BI tools using Google Big Query. Due to it's native integration with leading data visualisation tools like Klipfolio, Google's own Data Studio, Sigma Computing, Tableau and others it's easy to use Google Big Query as the central data source.
- See how to connect it to Klipfolio
- See how to use Google Data Studio
- Watch the video how to connect it to Sigma Computing
- And check out the support page of Tableau
If Google Big Query is too advanced for your needs, Cervinodata also offers a simpler data feed function for Klipfolio and Google Data Studio, starting with Cervinodata Bronze, including data storage.
Keeps your data up-to-date
It's possible to keep updating Google Big Query to have the most recent data available for reporting or interpretation. There are native connections to Google's own services (like Google Analytics, Adwords and Search Console) but adding other channels (like Adform, Facebook Ads, etc) will require you to either develop (and maintain) your own API connections. It also requires you to think about all the mapping of metrics and dimension when combining all the data.
Cervinodata is a smart data collection and delivery service that keeps your Google Big Query database up-to-date. It collects the key metrics & dimensions from your online marketing channels and syncs it (up to) multiple times per day with Google Big Query.
Able to add intelligence to the data
With Google Big Query as a starting point, it's relatively easy to dive deeper into the numbers. Google offers a whole range of data preparation and interpretation tools, as part of their Google Cloud Service.
But even if you have the right skills in your team, finding relevant patterns and trends can be difficult. That's why Cervinodata is experimenting with adding intelligence to the data. We plan to develop additional and more advanced intelligence and automation services as we move forward.
- See intelligence in action: the smart product monitor
Get in touch
If you need more information about how Cervinodata can work for you, feel free to get in touch. Just send us a mail: firstname.lastname@example.org. You will be part of a fast growing community of online marketing agencies and larger organisations that use Cervinodata for reporting and interpretation.