If your team stores marketing data in Google BigQuery - whether it's CRM exports, offline conversions, internal dashboards, or data piped in from other tools - you can connect that data to Whatagraph and report on it just like any other source.
Once connected, your BigQuery tables appear as a source you can add to any report, combine with other channels, and visualize using the same widgets you use everywhere else.
Note: BigQuery works both as a source (pulling data into Whatagraph reports) and as a destination (sending data from Whatagraph into BigQuery via Data Destination). This article covers using BigQuery as a source. For Data Destinations, see the Data Destination FAQ.
How Whatagraph reads your BigQuery data
Whatagraph doesn't know in advance how your BigQuery tables are structured - that's up to you. Before connecting, make sure your table is formatted in a way Whatagraph can interpret:
Date column: Your table needs at least one date column so that date ranges work correctly. The widgets first look for a column named exactly Date. If that doesn't exist, it picks the first column with a type of Date, Datetime, or Timestamp.
Metrics: Any column with a numeric type - Integer, Float, Numeric, or Bignumeric — is treated as a metric, unless its name is
idor ends in_id.
Dimensions: Everything else is treated as a dimension.
Here's an example of a table structure that works well:
Note: Because your table structure is entirely your own, Whatagraph won't auto-configure your widgets. You'll need to manually select a metric when adding a widget to your report.
Connecting BigQuery as a source
Step 1. Go to Data Sources available in the left sidebar in the "Data" section and click "Connect new source".
Step 2. Search for BigQuery and select it from the list, and click on "Add new account"
Step 3. Authorize your Google account. If you see a permissions error from Google, your Google Workspace admin needs to grant Whatagraph access first - see Adding BigQuery as a source for the exact steps.
Step 4. Select the Project, Dataset, and Table you want to connect, then click "Setup selected source".
Using BigQuery source in a report
Step 1. Open the Sources drawer on the right side of the editor and add your BigQuery source.
Step 2. Drag a widget onto the report canvas from the Widgets section.
Step 3. In the widget's Data settings, choose a metric and any dimensions you want to display.