Bring customer records, usage metrics, and product events from Google BigQuery into Cust. Choose the data with SQL, preview the result, and match source identifiers to the right company or contact.
Each sync defines its destination, selected fields or metrics, and refresh schedule. Read all rows or use a change-tracking timestamp to import only new and changed rows after the initial run.
Sync companies, contacts, custom objects, metric snapshots, individual measurements, and product events into Cust.
Inspect sample rows and match source identifiers to customer records before enabling a sync.
Read all rows or only new and changed rows using a change-tracking timestamp. Review run status, row counts, and errors in Cust.
Open BigQuery in Settings → Integrations. Follow the service-account setup instructions, grant BigQuery Job User and Data Viewer access, and provide the JSON key.
Create a sync, choose a destination, and enter your SQL. Preview sample rows, match identifiers, and select the fields or metrics you need.
Choose the refresh schedule and row-reading mode. Enable the sync, run it, and compare a known source row with the record in Cust.