ToolsThatRank / bulk data export

Calculator from Google's published prices

Search Console BigQuery export cost calculator

The bulk data export itself is free: Google states there are no costs associated with Search Console to export the data. What you pay for is the BigQuery side. In the US and EU multi-regions, on-demand queries cost 6.25 dollars per TiB processed with the first 1 TiB per month free, and you pay for active logical storage at 0.02 dollars per GiB per month (0.01 dollars for long-term logical storage, after 90 days without a change) with the first 10 GiB free (prices fetched 2026-10-29). The 10 GiB free tier applies to active and long-term logical storage. Estimate both from those published prices. The free tiers apply per billing account, not per dataset or per table, and all other BigQuery use in that account shares them.

Updated 2026-10-29 · prices fetched 2026-10-29

Enter the GiB of new rows the export appends each day, how many days of daily drops you keep, the dataset location, and how your queries use the data. The calculator splits the dataset at the 90 day mark: partitions younger than 90 days bill at the active logical rate, older ones at the long-term rate, which is about half. Query cost uses the on-demand rate with the first 1 TiB per month free, rounds each query up to the nearest MB and applies the 10 MB minimum per query.

By Michael Lip, an independent full-stack consultant who builds and runs ToolsThatRank.

The prices here are Google's published ones. The export writes daily rows into BigQuery tables such as searchdata_site_impression and searchdata_url_impression, and it leaves out the text of anonymized queries. The eight sources are linked at the bottom of this page. Search Console API row limits, which do not affect the bulk export, are covered by the row limit planner.

Enter the daily GiB, retention days, location and query load, then press Calculate.

Notes from Google's pricing and export pages

The export has no Search Console charge

Google's Search Central blog post with BigQuery efficiency tips for bulk data exports states that there are no costs associated with Search Console to export the data, and to read the BigQuery pricing to understand what you will be billed for.

US and EU on-demand queries cost 6.25 dollars per TiB

BigQuery on-demand pricing charges 6.25 dollars per TiB of data processed, and the first 1 TiB of query data processed per month is free per billing account. Charges are rounded up to the nearest MB, with at least 10 MB per query and at least 10 MB per table that the query references. A LIMIT clause does not reduce the data billed; a WHERE clause that limits the date range of the date-partitioned tables does. On-demand queries in the US and EU multi-regions cost 6.25 dollars per TiB, fetched 2026-10-29.

US and EU active logical storage costs 0.02 dollars per GiB per month

Active logical storage in the US multi-region is 0.02 dollars per GiB per month. After 90 days without modification a partition moves to long-term logical storage at 0.01 dollars per GiB per month in the US multi-region, fetched 2026-10-29. Europe multi-region active logical storage costs 0.02 dollars per GiB per month and long-term 0.01 dollars, fetched 2026-10-29. The pricing page lists the first 10 GiB as free each month on both the active and the long-term logical storage rows. 1 TiB (1,024 GiB) of active logical storage for a full month in the US multi-region is 20.48 dollars before the 10 GiB free tier. Physical storage billing has other prices; this estimate uses the logical rates. Google states that a dataset created without a storage billing model uses logical billing by default.

Anonymized query text is not in the export

Google's table reference states that when is_anonymized_query is true, the query field is a zero-length string. The efficiency post shows how to filter out these rows with WHERE query != ''.

How the estimate is computed

For storage, the calculator takes the GiB of new rows the export appends per day and your retention window in days. Partitions younger than 90 days bill at the active logical rate and older ones at the long-term logical rate, in the location you pick. The first 10 GiB of logical storage is free per month, per billing account. The calculator counts this 10 GiB once per month, as the free usage tier table of the pricing page lists it, and applies it to active storage first and then to long-term storage. The estimate assumes that each daily partition is written once and not changed after that. Google states that Search Console can revise the saved data of a past day, but that this does not happen often. A changed partition bills at the active rate for the next 90 days.

For queries, the calculator multiplies the GiB scanned per query by the number of queries per month, rounds each query up to the nearest MB, applies a 10 MB minimum per query, converts to TiB, and charges the on-demand rate of 6.25 dollars per TiB with the first 1 TiB per month free per billing account. Google also bills at least 10 MB for each table that a query references; the calculator counts one table per query, so for a query that reads both export tables, enter at least 0.0195 GiB, which the calculator rounds up to 20 MB. The page uses 1 GiB = 2^30 bytes and 1 TiB = 1,024 GiB, as the pricing page defines them, and counts 1 MB as 1/1,024 GiB. Both rates are Google's published US and EU multi-region prices, fetched 2026-10-29, and may change; the pricing page linked below is the source of record. Physical storage billing has other prices, and this page covers logical billing only.

Setup check list from Google's rules

  • Search Console charges nothing for the export. BigQuery bills the storage and the queries.
  • The Cloud project must have a valid billing configuration, otherwise the write will fail.
  • Tables and partitions are retained forever by default, unless your Cloud project or organization sets a default. To limit storage, set a partition expiration. Make sure the expiration is 14 days or longer.
  • Do not set an expiration time on the table. A table expiration deletes the entire table.
  • Do not change the table schema. Google states that schema changes will cause the export to fail.

Run this query to see the logical bytes of your own dataset by storage tier. Replace PROJECT_ID with your project ID. searchconsole is the default dataset name; replace it if you chose another name. A partition moves from ACTIVE to LONG_TERM after 90 days without a change.

SELECT storage_tier, SUM(total_logical_bytes) AS logical_bytes
FROM `PROJECT_ID.searchconsole.INFORMATION_SCHEMA.PARTITIONS`
GROUP BY storage_tier;

Google's efficiency post names several ways to control the bill. Among them: set a partition expiration so that old date partitions are deleted automatically; pre-aggregate each daily drop into one or more summary tables and point dashboards at those instead of the raw tables; and restrict the bytes billed per query, so that a query whose estimated bytes are over the limit fails without incurring a charge. The post also says to avoid SELECT *, to limit the date range with a WHERE clause on the date-partitioned tables, and to add known filters early, for example WHERE query != '' to drop anonymized query rows. The pricing page states that on-demand queries are charged for the data processed in the columns you select.

ToolsThatRank sells the pipeline that produced this page.

No ranking, traffic, or revenue outcome is promised, and no cost figure on this page is a quote or a bill.

The prices quoted are Google's published numbers and may change; the Google documentation pages linked below are the source of record.

The example inputs are not data from a real property. Enter your own numbers.

Michael Lip

Made by Michael, one person and a lot of coffee.

If ToolsThatRank has helped you, you can buy me a coffee. It honestly makes my day, and I read every note that comes with one.