Google Search Console
Google Search Console (GSC) provides data on searches that result in a page from www.gov.uk being displayed as part of the Google search results.
Search Console also allows you to remove content items from external search results and clear caches. These features are used by Technical 2nd line.
The Search Console instance for www.gov.uk is owned by the Analytics team.
Information on how to use the GOV.UK Search Console data can be found in the Analysis section.
Access
Direct access to Search Console is limited to Search Console admins.
Access to query the data stored in BigQuery is automatically granted to everyone with access to the GOV.UK GA4 data. More information can be found in our GA access policy.
Location
GSC data for the www.gov.uk site is located in BigQuery in the ga4-analytics-352613.searchconsole_wwwgovuk dataset, within the GA4 analytics project.
There are two partitioned tables: searchdata_site_impression and searchdata_url_impression.
The searchdata_site_impression table contains performance data for our GOV.UK property aggregated at the site/property level.
The searchdata_url_impression table contains performance data for aggregated by URL.
More information on Search Console data can be found in Google’s documentation.
For more information on the Google Cloud Platform projects, see our GCP Project Documentation.
Schema
Site Impressions
| field name | type | mode |
|---|---|---|
| data_date | DATE | YES |
| site_url | STRING | YES |
| query | STRING | YES |
| is_anonymized_query | BOOL | YES |
| country | STRING | YES |
| search_type | STRING | YES |
| device | STRING | YES |
| impressions | INT64 | YES |
| clicks | INT64 | YES |
| sum_top_position | INT64 | YES |
URL Impressions
| field name | type | mode |
|---|---|---|
| data_date | DATE | YES |
| site_url | STRING | YES |
| url | STRING | YES |
| query | STRING | YES |
| is_anonymized_query | BOOL | YES |
| is_anonymized_discover | BOOL | YES |
| country | STRING | YES |
| search_type | STRING | YES |
| device | STRING | YES |
| is_amp_top_stories | BOOL | YES |
| is_amp_blue_link | BOOL | YES |
| is_job_listing | BOOL | YES |
| is_job_details | BOOL | YES |
| is_tpf_qa | BOOL | YES |
| is_tpf_faq | BOOL | YES |
| is_tpf_howto | BOOL | YES |
| is_weblite | BOOL | YES |
| is_action | BOOL | YES |
| is_events_listing | BOOL | YES |
| is_events_details | BOOL | YES |
| is_search_appearance_android_app | BOOL | YES |
| is_amp_story | BOOL | YES |
| is_amp_image_result | BOOL | YES |
| is_video | BOOL | YES |
| is_organic_shopping | BOOL | YES |
| is_review_snippet | BOOL | YES |
| is_special_announcement | BOOL | YES |
| is_recipe_feature | BOOL | YES |
| is_recipe_rich_snippet | BOOL | YES |
| is_subscribed_content | BOOL | YES |
| is_page_experience | BOOL | YES |
| is_practice_problems | BOOL | YES |
| is_math_solvers | BOOL | YES |
| is_translated_result | BOOL | YES |
| is_edu_q_and_a | BOOL | YES |
| is_product_snippets | BOOL | YES |
| is_merchant_listings | BOOL | YES |
| is_learning_videos | BOOL | YES |
| impressions | INT64 | YES |
| clicks | INT64 | YES |
| sum_position | INT64 | YES |