BigQuery

​

Example table schema

CREATE TABLE `my-project.analytics.daily_active_users` (
  usage_date DATE,
  product STRING,
  active_users INT64
);

• Product analytics: daily or monthly active users, sessions, sign-ups
• Business KPIs: revenue, orders, customers, emails sent
• Application usage: API calls, background jobs, feature usage counts
• Data platform activity: query counts, bytes processed, or slot hours per team or project

​

Table requirements

​

Query after you connect

1

Open Advanced Explorer

Click Explore your data, then switch Classic to Advanced. Classic greys out non-cost metrics.

2

Add the BigQuery metric

Click + Add Metric. Use the integrations chip, then pick BigQuery. Helper text describes it as a live external usage metric.

3

Choose a table and columns

Pick a table from the picker, then set Date field, Value column, Aggregate (SUM), Gap fill (FORWARD FILL, ZERO, or LINEAR), and optional Group by.

4

Fix an empty chart

If the chart is empty, pick a different table and change Period. Options include Custom dates, Trailing 7 / 30 / 45 / 90 Days, MTD, QTD, YTD, Last Week, Last Month, Last 3 / 6 / 12 months, and Last Invoice Month.

In the demo workspace, demo_raw.artifact_* tables stayed empty at every range. demo_raw.raw_v2 with Trailing 90 Days rendered using date billing_period_end, value billed_cost, SUM, and FORWARD FILL.

5

Add cost or a formula

Optionally click + Add Metric for Cost, then + Add Formula such as b / a.

​

Metric configuration

​

Troubleshooting