The B2B SaaS Benchmark Report is here — see how your KPIs measure up to industry benchmarks.
See How You Rank

Integrate BigQuery & Mosaic

DATA WAREHOUSE

BigQuery

BigQuery is a central hub for business data generated by numerous software systems across an organization. Sync this data into Mosaic to drive deeper analysis and more comprehensive business modeling.
Start using BigQuery with Mosaic today

Overview

Automatically sync operational data directly from BigQuery and use it to build custom metrics, analyze performance drivers, and create detailed operational plans.

Tap into an extensive library of operational data

Access vast networks of business data in a one-stop-shop fashion, rather than connecting to dozens of systems individually.

Combine financial and ops data to see the bigger picture

Go beyond your core financial systems to build a complete, connected view of all the business activities that drive financial results.

Turn tables of raw data into deep financial context

Use Mosaic to transform BigQuery’s vast operational datasets into the financial structure and logic that unlock insights important to finance.

Plan for growth by connecting every piece of the puzzle

Leverage datasets from BigQuery to power more expansive financial models, metrics, and analyses across the Mosaic platform.

Key Features

Mosaic has all the tools you need to transform your raw BigQuery data into contextualized financial and operational insights that drive financial success.

DETAILS

1-click data connection to BigQuery

Intelligent data mapping

150+ prebuilt financial and business metrics

35+ report and dashboard templates

Out-of-the-box financial and business metric dashboards

Metric Builder to build custom metrics

Custom report builder

Automated BigQuery actuals in reports, dashboards, and models

Automated forecast vs. actual reporting

BigQuery transaction-level drilldown

Role-based user access

Key Metrics

Mosaic makes it easy to report, forecast, and share key business metrics that drive your financial and operational success — from pipeline and bookings, to revenue and collection schedules, product usage, and customer health. Combine BigQuery data with the rest of your financials for a complete view of business performance.

1 / 4

How It Works

Data integration shouldn’t be hard. At Mosaic, we make it easy. Get connected and start analyzing your data in minutes with these four simple steps.

STEPS

1

Enter your BigQuery account credentials directly within Mosaic

2

Sync your source data in Mosaic in just a few clicks

3

Map BigQuery data to Mosaic with intelligent mapping tools

4

Start building metrics, analyzing, and modeling

Shared Data

Marketing Funnel Metrics
Custom Billing Schedules
Product Usage & Consumption
Revenue & Collection Schedules
Customer Support Tickets
Gross Merchandise Volume

More Resources

Videos

Build a Customer LTV:CAC Metric

Sales Pipeline to Cash Scenario Planning

Build a Rolling Forecast

Vendor Forecasting and BVA Reporting

Blogs

Operational Finance: Blending the Operational CFO and Strategic CFO

FAQs

What kind of data can I bring in from BigQuery?

Any data table or view that exists in BigQuery can be brought into Mosaic. If you have over 1 million data records, please let your account executive know so we can help set up your connection for optimal performance.

What is BigQuery best used for?

What is Mosaic best used for?

Are there any best-practices once I connect my data to Mosaic?

Own the 
of your business.