Skip to main content

​
Connect BigQuery with Statisfy

The BigQuery integration allows you to import data from your Google BigQuery data warehouse into Statisfy. Sync custom fields, product usage metrics, and customer data from your analytics infrastructure. Prerequisites:
  • Admin access to Statisfy
  • Google Cloud project with BigQuery enabled
  • Service account with BigQuery read access

​
What You Can Import

Data TypeDescriptionUse Case
Product UsageUsage metrics and adoption dataTrack MAU, API calls, feature usage
Custom FieldsAccount-level attributesSync industry, segment, scores from BI
CRM DataRenewal dates, ARRKeep CRM fields in sync
Contact DataContact-level attributesEnrich people records

​
Steps to Connect

  1. Log in to Statisfy.
  2. Navigate to: Integrations → Admin Apps → BigQuery → Connect
  3. Upload your Google Cloud service account JSON file:
    • Create a service account in Google Cloud Console
    • Grant the roles/bigquery.dataViewer role
    • Download the JSON key file
    • Upload to Statisfy
  4. After successful authentication, BigQuery will appear as Connected.
  5. Contact support@statisfy.com to configure your data mappings.

​
Configuration

BigQuery integration requires configuration of which tables to sync and how fields map to Statisfy. Configuration includes:
  • Dataset and Table: Which BigQuery table to query
  • Account Identifier: Column that matches to Statisfy accounts (CRM ID, domain)
  • Field Mappings: Which columns map to which Statisfy fields
  • Sync Schedule: How often to pull data
Configuration is handled by the Statisfy team during setup. Contact support to modify mappings.

​
Product Usage Import

Import usage metrics to track customer product adoption: Supported Metrics:
  • Monthly or weekly snapshots
  • Numeric values (counts, amounts)
  • Aggregation options (sum, average, max, min)
Example Use Cases:
  • Monthly Active Users (MAU)
  • API request counts
  • Feature adoption rates
  • Storage consumption

​
Custom Field Sync

Sync calculated fields from your data warehouse: What you can sync:
  • Health scores calculated in BI tools
  • Customer segments
  • Industry classifications
  • Any account-level attributes
Field Type Support:
  • Text, numbers, dates
  • URLs
  • Boolean values

​
Data Matching

Rows in BigQuery are matched to Statisfy accounts using:
Match MethodDescription
CRM Account IDUnique identifier from Salesforce, HubSpot, etc.
DomainCompany website domain
Custom FieldAny unique identifier field
Rows that don’t match an existing account are skipped. Ensure your identifier column matches values in Statisfy.

​
Sync Behavior

Scheduled Jobs:
  • Data is pulled on a configured schedule (daily, weekly)
  • Only new or changed data is processed
Error Handling:
  • Invalid rows are logged and skipped
  • Successful rows are processed normally
  • Errors don’t stop the entire sync

​
Troubleshooting

Check service account permissions:
  • Verify the service account has roles/bigquery.dataViewer role
  • Ensure access to the specific dataset and table
Check sync schedule:
  • Contact support to verify when syncs are scheduled
  • Verify the identifier column contains the expected values
  • Check that accounts exist in Statisfy with matching identifiers
  • Review the match method (CRM ID vs. domain)
  • Verify the source BigQuery table contains expected data
  • Check field mappings are configured correctly
  • Contact support to review sync configuration

​
Need Help?

BigQuery integration requires custom configuration. Contact support@statisfy.com for:
  • Initial setup and configuration
  • Adding new tables or field mappings
  • Troubleshooting sync issues