Platform Features

Everything your data team needs

TerraBog combines 27 data connectors, an 8-stage enterprise pipeline, 7 BigQuery ML models, Claude AI chat, 40 dbt analytical marts, and 15+ enrichment data sources into a single platform — built for e-commerce teams of every size.

Start free trial View integrations

7 BQML models + Claude AI

40 dbt marts on BigQuery

27 native data connectors

SOC 2, GDPR, HIPAA ready

Analytics & Reporting

Sales Dashboard

Real-time revenue, order volume, and average order value — broken down by day, week, or month with trend analysis.

Customer 360

RFM segmentation groups customers into champions, loyal, at-risk, and hibernating. CLV tiering from platinum to bronze.

Cohort Retention

Monthly cohort heatmaps show customer retention over time. Identify which acquisition channels produce loyal buyers.

Product Performance

Market basket analysis reveals cross-sell opportunities. Track top products, sales velocity, and category performance.

AI & Machine Learning

7 BigQuery ML Models

Churn prediction (boosted tree), customer LTV (boosted tree), demand forecast (ARIMA+), price elasticity (linear reg), revenue forecast (ARIMA+ with FRED regressors), next purchase timing, and fraud detection.

Claude AI Chat & Narratives

Ask questions in plain English and get AI-powered answers. Claude AI transforms raw KPIs into executive-ready summaries with actionable recommendations.

AI Decision Intelligence

Competitive edges, scenario analysis, forecast alerts, and playbook generation — all powered by AI analyzing your data patterns.

15+ Enrichment Data Sources

FRED economic indicators, Census demographics, World Bank data, Bank of Canada rates, FX rates, weather data, holiday calendars, shipping estimates, and industry benchmarks enrich your analytics.

Data Integration

27 Native Connectors

PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery, Redshift, Shopify, Stripe, Salesforce, WooCommerce, Google Analytics, and more.

Smart CSV Upload

Drag-and-drop upload with automatic schema detection, data type inference, and interactive column mapping for 7 dataset types.

Enterprise Data Pipeline

8-stage pipeline: encoding detection, normalization, deep cleaning, deduplication, PII scanning, validation, integrity checks, and quality scoring.

Data Quality & Reverse ETL

Automated quality scores, drift detection, quarantine for bad rows, and resolution workflows. Reverse ETL pushes segments and scores to HubSpot CRM.

Governance & Security

Role-Based Access Control

Four built-in roles — owner, admin, analyst, and viewer — with row-level tenant_id filtering ensuring users only see their organization's data.

Immutable Audit Logging

Every login, data access, configuration change, and export is logged with timestamps, IP addresses, and user agents. Append-only and tamper-evident.

Enterprise SSO, SCIM & MFA

SAML 2.0 / OIDC SSO with Okta, Azure AD, and Google Workspace. SCIM 2.0 directory sync, MFA enforcement, and IP allowlist for enterprise accounts.

PII Detection & Masking

Automated detection of credit cards (Luhn validation), SSNs, bank accounts, and email addresses — with automatic masking before warehouse staging. Data retention policies configurable per plan.

See every feature in a live demo

Our solutions engineers walk through features tailored to your stack and use case. No sales pitch — just a working demo.

Book a demo Start free trial

TerraBog/Features