Most stores stitch reporting together from exports, app dashboards, and CSV dumps. UltraCart skips that entirely. Your commerce data flows into BigQuery automatically, within a minute or two of every change, ready for SQL, BI tools, dashboards, and AI reporting.
Marketing joins ad spend to real revenue. Ops tracks shipping and subscription health. Finance reconciles orders against the ledger. Everyone queries the same live data set instead of emailing spreadsheets.
Because UltraCart owns the pipeline end to end, the data model stays in sync with the platform. When we ship a new field, your warehouse gets it automatically.
Working with a large historical data set across all our UltraCart accounts, the UltraCart integration with Google BigQuery allows us complete freedom to design complex reporting using virtually any modern BI tool. Because BigQuery is designed as a massive scale data warehouse our monthly costs are less than $15 when working with records across all our UltraCart accounts.
Chris G. – Meliorra Brands
Other platforms hand you a CSV export and call it analytics.
UltraCart hands you an enterprise-grade warehouse that updates itself.
Changes stream into BigQuery within 1–2 minutes. Dashboards reflect reality, not yesterday’s snapshot.
Four access tiers protect customer PII, affiliate tax IDs, and wholesale data. SHA-256 hashes let analysts join without seeing raw PII.
Linked accounts roll up into a single parent data set. Report across every brand and storefront from one query.
Ask for a report in plain English. UltraCart’s AI generates the SQL, runs it against BigQuery, and saves the result to your account.
Looker, Power BI, Tableau, Google Sheets, Looker Studio, DBT, Hightouch, Make.com. If it talks to BigQuery, it works with UltraCart.
No add-on fees. UltraCart covers the first dollar of BigQuery storage. Most merchants pay a few dollars a month, not hundreds.
UltraCart watches every change to your data and streams the update into BigQuery over a secure connection to your Google Cloud project. Typical latency is 1 to 2 minutes from the moment an order ships or a subscription renews.
Your data warehouse shouldn’t be an all-or-nothing vault. UltraCart uses Google Cloud IAM plus BigQuery column-level security to split data into four tiers, so you can give a marketing analyst access to revenue data without exposing customer PII or affiliate tax IDs.
ultracart_dw
All tables, no sensitive fields. Safe for general analytics and BI.
ultracart_dw_low
Adds affiliate detail (excluding tax IDs and software activation codes).
ultracart_dw_medium
Adds customer PII (names, emails, addresses) for CRM and support work.
ultracart_dw_high
Adds affiliate tax IDs and wholesale customer data. Typically finance and owner only.
When a column is restricted, a SHA-256 hash of the value is still available in a parallel column. Analysts can join, group, and segment on the hash without ever touching the underlying PII.
Running multiple StoreFronts or a portfolio of brands on linked UltraCart accounts? The parent account automatically gets a second set of data sets (ultracart_dw_linked and its tiered siblings) that consolidate data across every linked child account.
You shouldn’t need a SQL engineer to answer a question about your own business. UltraCart’s AI Report Builder lets you describe the report you want in plain English. It generates the BigQuery SQL, runs it against your warehouse, and saves the result as a reusable report inside your UltraCart account.
UltraCart ships an official Claude Code skill that wires your AI coding assistant directly into your BigQuery data warehouse.
Install the UltraCart Claude Code skill and ask for any report you can imagine in plain English. Claude writes the BigQuery SQL, runs it against your warehouse, and hands you the results. No SQL experience required, no engineer in the loop.
Read the walkthroughNo premium tier required, no separate export API. These tables are always streaming for every UltraCart plan.
Order header and detail, line items, cost breakdown, shipments, refunds, and recurring auto-order state.
SKUs, descriptions, pricing tiers, variations, and inventory.
Identity, addresses, order history, pricing tiers, LTV, and marketing attributes.
Affiliate accounts, click attribution, and commission ledger.
StoreFront configuration, A/B test experiments, upsell paths, and per-offer performance events.
Transaction gateway history, rotation events, and processing volume by method.
Recording metadata for every captured StoreFront session, ready to join against order and conversion data.
Appended household, demographic, and interest data to enrich customer records for modeling and segmentation.
BigQuery is the connective tissue. Every modern BI, ETL, and data tool talks to it natively.
Click any integration below for step-by-step setup tailored to UltraCart’s data model.
Native BigQuery connector. Build shareable dashboards on live UltraCart data with zero extra cost.
Query the UltraCart warehouse with the built-in BigQuery connector and ship pixel-perfect reports to your team.
Drag-and-drop analytics on live BigQuery tables. Perfect for deep exploratory work and exec dashboards.
Pull live UltraCart data straight into a spreadsheet with Connected Sheets. No export jobs, no stale data.
Model UltraCart commerce data in LookML and deliver governed metrics across the business.
Associative analytics and self-service discovery on top of your unified commerce data.
Transform UltraCart tables into clean, tested data models. Version-controlled SQL your analytics team can trust.
Sync modeled segments from BigQuery back into ad platforms, email, and CRM tools. Turn data into action.
Merge UltraCart commerce data with ad spend, ERP, and finance sources inside BigQuery for true cross-source reporting.
Trigger workflows on BigQuery query results. Route UltraCart events into Slack, Airtable, Notion, and 1,000+ other apps.
Unify ad spend from Google, Meta, TikTok, and more into BigQuery alongside UltraCart orders. Real ROAS, no spreadsheet glue.
The warehouse itself. Start here for provisioning, security tiers, schema, and sample queries.
bq)Run queries, export results, and script jobs from any terminal or CI pipeline.
First-party clients for Python, Node.js, Go, Java, Ruby, PHP, and .NET. Authenticate with a service account and query away.
Create a service account in your own Google project, add it to UltraCart as a user with data warehouse permissions, and run scheduled jobs programmatically.
Query UltraCart-hosted tables alongside your own BigQuery project. Joins just work when your account has access to both.
Join UltraCart order data with Google Ads and Meta spend in BigQuery. See real gross-margin ROAS per campaign, not vanity revenue.
Build cohort curves on real subscription and reorder data. Measure payback period per acquisition channel and product line.
Roll up every StoreFront into a single Looker Studio or Power BI view for leadership, with drill-downs per brand.
Monitor active subscribers, rebill success, involuntary churn, and AR retry outcomes in real time.
Inventory reorder triggers, fulfillment SLAs, refund trends, and carrier performance. All self-serve SQL.
Push modeled segments from BigQuery back into email, SMS, and ad platforms with Hightouch or Make.com.
Most merchants spend a few dollars per month on their data warehouse. That’s the whole story.
Everything you need to provision the warehouse, grant access, and start querying.
How the BigQuery integration works, what data is included, and how streaming keeps your warehouse in sync.
Read the overviewSpin up a Google Cloud project, enable BigQuery, configure storage, and create a service account user for UltraCart.
Set up Google CloudConnect UltraCart to your Google project and grant per-user access across the four PII security tiers.
Configure UltraCartReady-to-run SQL for LTV, rebill counts, revenue per item, UTC-to-local time conversion, and more.
Browse sample SQLPricing, data freshness, schema evolution, linked accounts, cross-project joins, and supported tools.
See the FAQInstall the official UltraCart Claude Code skill and ask for any report you can imagine in plain English.
Read the walkthroughUltraCart tracks every change to your data (orders, customers, subscriptions, upsells, affiliates, and more) and streams those changes into BigQuery tables in your own Google Cloud project. The raw mutation stream lives in ultracart_dw_streaming, and clean consistent views sit in ultracart_dw and its tiered siblings. Always query the views, never the raw stream.
Changes typically appear in your BigQuery tables within 1 to 2 minutes of the underlying event. That includes new orders, subscription rebills, upsell events, and customer updates.
All of them. The data warehouse is a standard feature on every UltraCart plan with no add-on fees. UltraCart covers the first $1.00 of BigQuery cost each month, which is enough to cover storage and streaming for most stores.
Yes. As long as your Google user or service account has permission to both projects, you can write a single query that joins UltraCart-hosted tables against your own data. This is how merchants blend UltraCart orders with Google Ads or Meta spend to get true ROAS.
UltraCart uses Google Cloud IAM plus BigQuery column-level security to enforce four data access tiers. The account owner decides which tier each user can see. When a column is restricted, a SHA-256 hash of the value is available in a parallel column so analysts can still join and group without reading raw PII.
Yes. Create a service account in your own Google project, add it to UltraCart as a user with the appropriate data warehouse permissions, and the BigQuery project will grant access within about five minutes. From there, use the BigQuery CLI, any official SDK, or any BI tool that supports service account auth.
UltraCart automatically updates the BigQuery schema when the data model evolves. You don’t rebuild pipelines or reconfigure tables. Any views or saved queries you’ve built on top keep working.
Today the native integration targets BigQuery. From BigQuery, reverse-ETL tools like Hightouch or Fivetran can mirror data into Snowflake, Redshift, Databricks, or any other warehouse if your stack requires it.
Get started with UltraCart in just a few simple steps—no long commitments, no complicated setup. Just a streamlined experience designed to get your store live and making sales.
Transparent pricing that grows with your business—no hidden fees, just the tools you need to succeed.
Pricing and PlansFriendly support ready to help you launch, grow, and answer any questions along the way.
Contact Support