The Planhat BigQuery integration allows for seamless data synchronization between Planhat and Google BigQuery. It enables users to sync static CRM data bi-directionally and fetch time-series Metrics data in near real-time. Static CRM data is pushed to BigQuery hourly, while Metrics data can be fetched at intervals ranging from every 5 minutes to once a day, depending on data volume and configuration. The integration supports custom mapping and data transformation, with detailed guidance available in the Help Center. Configuration requires authorized Planhat users to connect their BigQuery instance via the Integrate tab, necessitating appropriate GCP access permissions.

Features & Benefits

• Bi-directional CRM Data Sync: Synchronizes static CRM data between Planhat and BigQuery in both directions.
• Near Real-time Metrics Data Fetch: Retrieves time-series Metrics data from Planhat to BigQuery with flexible frequency options.
• Custom Mapping and Transformation: Allows users to define custom data mappings and transformations for tailored analysis.
• Structured Data Backup: Ensures all Planhat data is backed up and structured within BigQuery for robust analysis.