Google PageSpeed Insights connector

Set up the Google PageSpeed Insights connector in Kaivo: authentication, configuration, the 1 BigQuery tables it syncs, and answers to common questions.

Written By Lauri Raivio

Last updated 16 days ago

Kaivo is a fully managed data platform that syncs your Google PageSpeed Insights data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your data from Google PageSpeed Insights instead of moving it.

What is the Google PageSpeed Insights connector

Sync your Google PageSpeed Insights data into BigQuery with Kaivo to track site performance over time.

Category	Tech
Authentication	API key
Setup	Self-service

Getting started with the Google PageSpeed Insights connector

Sign up for Kaivo and create a workspace.
Connect your Google PageSpeed Insights account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Google PageSpeed Insights

Authenticate with your API Key.

Field	Description
API Key	Optional Google PageSpeed API key. See here. Without a key the API is heavily rate limited, so providing one is recommended. The key is case sensitive.

Configuring the Google PageSpeed Insights connector

When you set up the connector, you provide:

Field	Description
URLs to Analyse	The URLs to retrieve PageSpeed reports for. Format: https://(www.)url.domain
Lighthouse Categories	Which Lighthouse categories to run. Select one or more.
Analysis Strategies	Which analysis strategies to run. Select one or more.

Tables and columns synced from Google PageSpeed Insights

Kaivo syncs 1 table from Google PageSpeed Insights into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

pagespeed (49 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`analysis_utc_timestamp`	`STRING`	The timestamp of when the analysis was performed in UTC.
`captcha_result`	`STRING`	Result of captcha check during analysis.
`id`	`STRING`	Unique identifier for the analyzed page.
`kind`	`STRING`	A string indicating the object type.
`lighthouse_result__config_settings__channel`	`STRING`	Channel used for analysis.
`lighthouse_result__config_settings__emulated_form_factor`	`STRING`	Emulated form factor used for analysis.
`lighthouse_result__config_settings__form_factor`	`STRING`	Form factor used for analysis.
`lighthouse_result__config_settings__locale`	`STRING`	Locale used for analysis.
`lighthouse_result__environment__benchmark_index`	`FLOAT64`	Benchmark value used for comparison.
`lighthouse_result__environment__host_user_agent`	`STRING`	Host user agent used for analysis.
`lighthouse_result__environment__network_user_agent`	`STRING`	Network user agent used for analysis.
`lighthouse_result__fetch_time`	`STRING`	Time taken to fetch the analyzed page.
`lighthouse_result__final_url`	`STRING`	The final URL of the analyzed page.
`lighthouse_result__lighthouse_version`	`STRING`	Version of Lighthouse used for the analysis.
`lighthouse_result__requested_url`	`STRING`	The URL requested for analysis.
`lighthouse_result__user_agent`	`STRING`	User agent used for analysis.
`loading_experience__id`	`STRING`	Unique identifier for the loading experience data.
`loading_experience__initial_url`	`STRING`	Initial URL used for loading experience analysis.
`loading_experience__metrics__cumulative_layout_shift_score__category`	`STRING`	Category of cumulative layout shift score.
`loading_experience__metrics__cumulative_layout_shift_score__percentile`	`FLOAT64`	Percentile value for cumulative layout shift score.
`loading_experience__metrics__experimental_interaction_to_next_paint__category`	`STRING`	Category of experimental interaction to next paint.
`loading_experience__metrics__experimental_interaction_to_next_paint__percentile`	`FLOAT64`	Percentile value for experimental interaction to next paint.
`loading_experience__metrics__experimental_time_to_first_byte__category`	`STRING`	Category of experimental time to first byte.
`loading_experience__metrics__experimental_time_to_first_byte__percentile`	`FLOAT64`	Percentile value for experimental time to first byte.
`loading_experience__metrics__first_contentful_paint_ms__category`	`STRING`	Category of first contentful paint latency.
`loading_experience__metrics__first_contentful_paint_ms__percentile`	`FLOAT64`	Percentile value for first contentful paint latency.
`loading_experience__metrics__first_input_delay_ms__category`	`STRING`	Category of first input delay latency.
`loading_experience__metrics__first_input_delay_ms__percentile`	`FLOAT64`	Percentile value for first input delay latency.
`loading_experience__metrics__largest_contentful_paint_ms__category`	`STRING`	Category of largest contentful paint latency.
`loading_experience__metrics__largest_contentful_paint_ms__percentile`	`FLOAT64`	Percentile value for largest contentful paint latency.
`loading_experience__overall_category`	`STRING`	Overall category performance of loading experience.
`origin_loading_experience__id`	`STRING`	Unique identifier for the origin loading experience data.
`origin_loading_experience__initial_url`	`STRING`	Initial URL of the origin site for loading experience analysis.
`origin_loading_experience__metrics__cumulative_layout_shift_score__category`	`STRING`	Category of cumulative layout shift score for origin site.
`origin_loading_experience__metrics__cumulative_layout_shift_score__percentile`	`FLOAT64`	Percentile value for cumulative layout shift score of origin site.
`origin_loading_experience__metrics__experimental_interaction_to_next_paint__category`	`STRING`	Category of experimental interaction to next paint for origin site.
`origin_loading_experience__metrics__experimental_interaction_to_next_paint__percentile`	`FLOAT64`	Percentile value for experimental interaction to next paint of origin site.
`origin_loading_experience__metrics__experimental_time_to_first_byte__category`	`STRING`	Category of experimental time to first byte for origin site.
`origin_loading_experience__metrics__experimental_time_to_first_byte__percentile`	`FLOAT64`	Percentile value for experimental time to first byte of origin site.
`origin_loading_experience__metrics__first_contentful_paint_ms__category`	`STRING`	Category of first contentful paint latency for origin site.
`origin_loading_experience__metrics__first_contentful_paint_ms__percentile`	`FLOAT64`	Percentile value for first contentful paint latency of origin site.
`origin_loading_experience__metrics__first_input_delay_ms__category`	`STRING`	Category of first input delay latency for origin site.
`origin_loading_experience__metrics__first_input_delay_ms__percentile`	`FLOAT64`	Percentile value for first input delay latency of origin site.
`origin_loading_experience__metrics__largest_contentful_paint_ms__category`	`STRING`	Category of largest contentful paint latency for origin site.
`origin_loading_experience__metrics__largest_contentful_paint_ms__percentile`	`FLOAT64`	Percentile value for largest contentful paint latency of origin site.
`origin_loading_experience__overall_category`	`STRING`	Overall category performance of loading experience for origin site.
`strategy`	`STRING`	Strategy used for page analysis.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__lighthouse_result__config_settings__only_categories

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`value`	`STRING`	Category included in the analysis.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__lighthouse_result__run_warnings

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`value`	`JSON`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__loading_experiencemetricscumulative_layout_shift_score__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__loading_experiencemetricsexperimental_interaction_to_next_paint__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__loading_experiencemetricsexperimental_time_to_first_byte__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__loading_experiencemetricsfirst_contentful_paint_ms__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__loading_experiencemetricsfirst_input_delay_ms__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__loading_experiencemetricslargest_contentful_paint_ms__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__origin_loading_experiencemetricscumulative_layout_shift_score__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__origin_loading_experiencemetricsexperimental_interaction_to_next_paint__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__origin_loading_experiencemetricsexperimental_time_to_first_byte__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__origin_loading_experiencemetricsfirst_contentful_paint_ms__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__origin_loading_experiencemetricsfirst_input_delay_ms__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: pagespeed__origin_loading_experiencemetricslargest_contentful_paint_ms__distributions

Column	Type	Description
`_kaivo_parent_id`	`STRING`	Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`max`	`FLOAT64`	Maximum value in the distribution.
`min`	`FLOAT64`	Minimum value in the distribution.
`proportion`	`FLOAT64`	Proportion of the distribution.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Google PageSpeed Insights sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Google PageSpeed Insights supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won't get duplicate rows.

Frequently asked questions

How long does the initial sync take for Google PageSpeed Insights?

It depends on how much history is in your Google PageSpeed Insights account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they're much faster.

Can I sync only some tables or columns?

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don't select are never copied to your warehouse.

What happens when Google PageSpeed Insights's schema changes?

New fields are never added automatically. You choose which fields to sync, so data you haven't selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table's sync mode: full-refresh tables always match what's currently in Google PageSpeed Insights, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Google PageSpeed Insights instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Google PageSpeed Insights connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Google PageSpeed Insights data

Performance trends

Use pagespeed to track Core Web Vitals and performance scores over time.

Regression detection

Watch pagespeed scores to catch slowdowns after releases.

SEO context

Join performance data with your traffic data to connect speed to engagement.

Use Google PageSpeed Insights data in your AI and BI tools

Once Google PageSpeed Insights data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here's how the most common destinations work with Google PageSpeed Insights data.

Claude

Use Kaivo's MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft's BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query's BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Google PageSpeed Insights connector pricing and plan details.

Adform: Sync Adform to BigQuery.
Amplitude: Sync Amplitude to BigQuery.
Auth0: Sync Auth0 to BigQuery.
Convex: Sync Convex to BigQuery.
GitHub: Sync GitHub to BigQuery.
GitLab: Sync GitLab to BigQuery.

Was this helpful?

Still need help? Share an idea