Synerise integration with Google BigQuery

At Synerise, we are committed to continually expanding our platform capabilities, and we understand the importance of providing our users with the ability to connect seamlessly with external platforms and tools.?

Today, we are excited to announce the latest integration of Synerise with Big Query, a cloud-based data warehousing solution. This integration opens new opportunities for Synerise users to manage their data. ?

What is Google BigQuery???

Google BigQuery is a cloud-based data warehouse solution that enables users to store, manage, and query data in a highly scalable and cost-effective way. It provides a fully managed, serverless infrastructure that eliminates the need for users to manage their hardware or software.?

What opportunities does this integration create??

• Seamless integration with one of the biggest cloud-based data warehouses,?
• Export different types of data collected in Synerise to BigQuery with ease,?
• Sharing data sent to BigQuery with other Google tools enables more effective decision-making by having a view of all data stored on other platforms,?
• Combine data from Synerise with data from other sources and platforms to gain a comprehensive view on the performed activities.??

What data can be exported??

With this integration, you can export a vast range of data, including events data (such as transactions or form submissions), customer information (such as marketing agreements), metric results, aggregates, expressions, reports, and more.?

How to perform this export??

We have created a dedicated “Upload data to the table” node, which enables pushing data from Synerise and adding it to BigQuery tables as rows.?

During the node's configuration, you can use Jinjava inserts which let you dynamically refer to the profile attributes and event parameters in the workflow.?

The process of creating the export is simple and consists of just a few steps. To build a workflow, you need to select a trigger and establish a connection between Synerise and Google BigQuery. ?Finally, fill out the form in the “Upload data to the table” node to send data from Synerise to a table in Google BigQuery. ?

Please refer to our User Guide for more detailed information about prerequisites and the complete configuration process of the "Upload data to the table" node.??

Check out new use cases?

We also prepared for you new use cases that demonstrate how to export both event and analytics data using this integration.?

• The first use case describes the process of sending NPS survey data to Google BigQuery.?
• The second use case describes the process of sending metrics results to Google BigQuery.?

We hope this integration will bring new opportunities to your current operations and help you use your data in the most efficient way!?

Klaudia Pociecha, Product Owner

Kateryna Tkachuk, Product Marketing Specialist