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.
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.
This is within the GA4 analytics project.
There are 2 partitioned tables: searchdata_site_impression and searchdata_url_impression.
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 |