How do I export my Nozzle data?

Nozzle stores all of its data in Google BigQuery — the same data that powers the Nozzle UI. There are several ways to get that data out for your own analysis, dashboards, or systems. This guide is an overview of your options and which one fits which use case.

Quick decision: which method should I use?

Each of these methods is described in detail below.

UI exports

The simplest option. From any dashboard or report inside app.nozzle.io, you can export the data you're looking at as a CSV. Best for one-off questions, ad-hoc sharing, and cases where you don't need a recurring data feed.

For details on exporting from dashboards, see the dashboards guide.

BigQuery direct

The most powerful option, and the one most customers eventually graduate to. Nozzle's BigQuery integration gives you direct query access to the same tables that power the Nozzle UI — every keyword, every SERP, every metric, no copying required.

How it works at a glance:

• Nozzle stores the data. All your tracking data lives in Nozzle-managed Google Cloud projects under the nozzledata dataset. You don't need to copy it anywhere.
• You query it in place. Once Nozzle grants your account access, you query directly against nozzledata.<workspace_slug>_<project_slug> using your own GCP project as the billing target.
• Storage is free for you. Nozzle covers all storage costs. The only cost on your side is for query compute, and Google BigQuery's free tier covers 1 TiB of querying per month per billing account — enough for many customers.

For setup instructions, see How do I access my data in BigQuery?

For an overview of the tables and schema, see the BigQuery section of the help center.

Looker Studio & Google Sheets templates

For customers who want polished dashboards or spreadsheet-based reporting without writing SQL from scratch, Nozzle maintains pre-built templates:

• Looker Studio templates — visual dashboards connected directly to your BigQuery dataset. Browse the templates at the BigQuery help section under "Looker Studio Templates and Queries."
• Google Sheets / Excel templates — spreadsheets with pre-written queries that pull live or scheduled data from BigQuery. Same page, under "Google Sheets/Excel Templates and Queries."

For step-by-step setup of Looker Studio against your Nozzle data, see How do I use my BigQuery data in Google Data Studio (Looker Studio)?

Cost note for live dashboards: Looker Studio re-runs its underlying queries every time someone opens a report. Connecting it directly to raw Nozzle tables can scan a lot of data on every page load, which adds up. The cost-conscious pattern is to set up a scheduled query that builds a smaller summary table once a day, then point Looker Studio at the summary table. Nozzle's templates follow this pattern, but if you build your own dashboards, keep this in mind.

The API

If you're building a programmatic integration — an internal tool, a custom workflow, or syncing data with another system — the Nozzle API is the right entry point. See:

• How do I authenticate with the Nozzle API?
• Admin API — for managing projects, keyword sources, and other configuration
• Reporting API — for fetching metrics and rankings

The API is best for transactional, point-in-time queries (e.g., "what are the latest rankings for these 50 keywords?"). For large-volume historical analysis, BigQuery is more efficient.

Custom export pipeline

For customers who need data delivered into their own infrastructure on a schedule — for example, daily exports to an S3 bucket, Snowflake, or an internal data warehouse — Nozzle can set up a custom export pipeline.

How it works: Nozzle defines a query against your data, runs it on the schedule you need, and pushes the results to a destination you control (cloud storage bucket, message queue, etc.). The destination can match your existing data engineering patterns.

This is useful when:

• Your team prefers consuming data through your existing pipelines rather than connecting new tools
• You have corporate restrictions on granting individual users BigQuery access
• You need a specific output schema that maps to a downstream system

To discuss a custom export pipeline, contact us with a description of what you need delivered and where.

Choosing between methods

Most customers end up using more than one. A common combination:

• UI exports for ad-hoc questions and one-off sharing
• Looker Studio templates for shared dashboards the whole team checks
• BigQuery direct for deeper analysis and custom reports
• API for any automated integrations

Pick whichever method matches the task in front of you. There's no commitment to one path — you can mix and match as your needs evolve.

A note on cost

UI exports, the API, and custom export pipelines are included with your Nozzle subscription at no additional cost.

BigQuery direct access (and any tool connected to BigQuery — Looker Studio, Google Sheets, Tableau, etc.) uses Google's pricing: the first 1 TiB of querying per month per billing account is free, and beyond that Google charges per TiB scanned. Storage is always free for Nozzle data because Nozzle covers it.

If you're new to BigQuery and worried about costs, we recommend setting custom quotas on your GCP project as a safety net. Most customers stay well within the free tier with reasonable query practices.

Need help?

If you're not sure which method fits your use case, or you want to talk through what to set up first, reach out. We've helped customers of every size figure out what works for their team and infrastructure.