Sync BigQuery customer data with all of your 3rd party tools

Grouparoo's Google BigQuery integration allows you to sync all of your customer data that lives in your Google BigQuery data warehouse with various destinations such as CRMs, Customer Support Tools, and Marketing Tools.


BigQuery

BigQuery






Grouparoo

Grouparoo



Grouparoo & BigQuery

Grouparoo is open source data infrastructure to keep your customer data in-sync with 3rd party tools.

Grouparoo pulls customer data in real-time from your database, data warehouse, and other data sources.

Use Cases

  • Easily connect your production data with 3rd party tools
  • Create a unified customer definition in Grouparoo
  • Easily make cohorts and segments out of your BigQuery data warehouse
  • Denormalize your database so you can easily send customer data to tools like CRMs, marketing automation, and email marketing


Free and Easy to Install

Add the @grouparoo/bigquery package to your project, restart your server, and you're good to go! Learn more about working with plugins.

$ grouparoo install @grouparoo/bigquery
$ grouparoo start

Community Edition

Once you've installed the BigQuery plugin, you can begin to configure it by adding an App.

Enterprise Edition

Our Enterprise Edition enables you to configure your BigQuery apps through the UI.

An Overview of Grouparoo's Data Model

Grouparoo's core objects are Profiles and Profile Properties. These objects are defined based on your data such as the data in your BigQuery data warehouse. You can pull this data in with Grouparoo's help or you can write SQL queries directly.

Once you've defined these Profiles and Profile Properties, you can use Grouparoo to create dynamic segments and cohorts.





Easily connect your BigQuery data

Since Grouparoo is installed in your cloud infrastructure, you can easily point Grouparoo to any number of BigQuery instances you may have running.

Grouparoo BigQuery settings


Define Profile Properties without needing to write SQL queries

Grouparoo is low-code, so less technical team members can create new Profile Properties without needing to work with engineers. They can pull the data they need when they want.

Grouparoo table source settings


But you can also write SQL if you want

Some Profile Properties will require joins across tables or more complex queries. Use Grouparoo's Query mode to pull the data you need.

Grouparoo query source settings



Send your customer data from BigQuery to these tools




Get Started with Grouparoo

Easily install the Grouparoo application, join the community, or schedule a demo to learn more.




Or learn more about the company or how to get support.