Skip to content
Book a demoStart free
Connectors

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.

Google PageSpeed Insights connector pricing, tier and credits on kaivo.io

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

Section titled “What is the Google PageSpeed Insights connector”

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

CategoryTech
AuthenticationAPI key
SetupSelf-service

Getting started with the Google PageSpeed Insights connector

Section titled “Getting started with the Google PageSpeed Insights connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Google PageSpeed Insights account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

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

Section titled “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

Section titled “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

Section titled “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

Section titled “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_experience__metrics__cumulative_layout_shift_score__distributions

Section titled “Subtable: pagespeed__loading_experience__metrics__cumulative_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_experience__metrics__experimental_interaction_to_next_paint__distributions

Section titled “Subtable: pagespeed__loading_experience__metrics__experimental_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_experience__metrics__experimental_time_to_first_byte__distributions

Section titled “Subtable: pagespeed__loading_experience__metrics__experimental_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_experience__metrics__first_contentful_paint_ms__distributions

Section titled “Subtable: pagespeed__loading_experience__metrics__first_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_experience__metrics__first_input_delay_ms__distributions

Section titled “Subtable: pagespeed__loading_experience__metrics__first_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_experience__metrics__largest_contentful_paint_ms__distributions

Section titled “Subtable: pagespeed__loading_experience__metrics__largest_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_experience__metrics__cumulative_layout_shift_score__distributions

Section titled “Subtable: pagespeed__origin_loading_experience__metrics__cumulative_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_experience__metrics__experimental_interaction_to_next_paint__distributions

Section titled “Subtable: pagespeed__origin_loading_experience__metrics__experimental_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_experience__metrics__experimental_time_to_first_byte__distributions

Section titled “Subtable: pagespeed__origin_loading_experience__metrics__experimental_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_experience__metrics__first_contentful_paint_ms__distributions

Section titled “Subtable: pagespeed__origin_loading_experience__metrics__first_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_experience__metrics__first_input_delay_ms__distributions

Section titled “Subtable: pagespeed__origin_loading_experience__metrics__first_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_experience__metrics__largest_contentful_paint_ms__distributions

Section titled “Subtable: pagespeed__origin_loading_experience__metrics__largest_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

Section titled “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.

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

Section titled “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.

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?

Section titled “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.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

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

Section titled “Common use cases for Google PageSpeed Insights data”

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

Watch pagespeed scores to catch slowdowns after releases.

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

Use Google PageSpeed Insights data in your AI and BI tools

Section titled “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.

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

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

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

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

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

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

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.