{"id":7008,"date":"2024-05-02T15:16:13","date_gmt":"2024-05-02T15:16:13","guid":{"rendered":"https:\/\/www.cueforgood.com\/blog\/?p=7008"},"modified":"2025-11-13T15:56:46","modified_gmt":"2025-11-13T10:26:46","slug":"improving-gsc-performance-report-with-google-data-studio","status":"publish","type":"post","link":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/","title":{"rendered":"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)"},"content":{"rendered":"\n

GSC is one of the go to tools in any SEO’s arsenal. However, it is not without its shortcomings. This post will discuss the limitations of the performance report feature in GSC and how to overcome them using GDS. These limitations include:<\/p>\n\n\n\n

  1. The number of rows you can view and download. <\/li>
  2. The reporting view; you need to open multiple tabs to visualize and match queries and landing pages.<\/li><\/ol>\n\n\n\n

    With Google Data Studio, you can do more than just get rid of these limitations:<\/p>\n\n\n\n

    View and export unlimited number of rows<\/h2>\n\n\n\n

    GSC only lets you see and download data for a maximum of 1000 rows. For large, and even medium websites, the number of rows with useful data easily exceeds this number.<\/p>\n\n\n\n

    One way around is Search Analytics for Sheets<\/a>. The Google Sheets add-on lets you extract all data that resides in the Search Console API.<\/p>\n\n\n\n

    The second way is Google Data Studio<\/a>. To extract all rows, create a new report in GDS and choose GSC as the data source.<\/p>\n\n\n\n

    Next choose the dimension with respect to which you want to see the varying metrics. Then choose the metrics you want to measure – these could be clicks, impressions, CTR, position, or queries too. <\/p>\n\n\n\n

    \"Exporting<\/figure>\n\n\n\n

    View all the metrics in one report<\/h2>\n\n\n\n

    In GSC, you cannot see both queries and landing pages in the same report. <\/p>\n\n\n\n

    GDS lets you see queries against landing pages in one report. You can achieve this via Search Analytics for Sheets too, but GDS is prettier.<\/p>\n\n\n\n

    Set custom filters to exclude unwanted\/irrelevant values <\/h2>\n\n\n\n

    In heaps of rows, it\u2019s quite likely there are some values you don’t want to see in your report. <\/p>\n\n\n\n

    With the help of a filter, you can specify what pattern of values you want to exclude or include in your report. There can be several scenarios where filters can come to your rescue. Here are a few examples:<\/p>\n\n\n\n

    Use case 1: Exclude queries with few impressions<\/h3>\n\n\n\n

    Set up an exclude filter to exclude queries with a few impressions. This would rid your report of many queries which were mistyped, irrelevant or have a very low search volume.<\/p>\n\n\n\n

    Use case 2: Include only long tail keywords<\/h3>\n\n\n\n

    GDS filters allow the convenience of using Regex, IF condition, and CASE statements to refine your data.<\/p>\n\n\n\n

    Using Regex, you can exclude queries with less than 5 words. Use this Regex for it: ^([a-zA-Z0-9]*\\s){5,}.<\/p>\n\n\n\n

    \"Using<\/figure>\n\n\n\n

    Use case 3: Set multiple filters for one metric<\/h3>\n\n\n\n

    GSC doesn\u2019t let you exclude two or more different queries. You can only set one filter per metric. GDS is your savior again. Use the AND and OR operators in filters to get rid of all the values you don\u2019t want to see.<\/p>\n\n\n\n

    Replicate GSC\u2019s Filter Control<\/h2>\n\n\n\n

    GSC filters let you filter landing pages and queries. You can give the same control in report view with GDS\u2019 filter control feature.<\/p>\n\n\n\n

    \"Filter<\/figure>\n\n\n\n

    Final Words<\/h2>\n\n\n\n

    Google Data Studio Report can replicate GSC almost completely and be even more insightful. To replace GSC with its GDS replica completely, you may need one additional step. To see both \u201clanding pages\u201d and \u201cposition\u201d in one report, you\u2019d need to blend data from both site impressions and URL impressions.<\/p>\n\n\n\n

    GDS\u2019 ability to access search console data from its API is fantastic and gives you great insights into your website\u2019s search performance. With the power of Regex, IF, and CASE statements you can use GDS to make your filters and calculated fields more efficient and concise.<\/p>\n","protected":false},"excerpt":{"rendered":"

    GSC is one of the go to tools in any SEO’s arsenal. However, it is not without its shortcomings. This … <\/p>\n

    Continue reading “Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)”<\/span><\/a><\/p>\n","protected":false},"author":82,"featured_media":7014,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[707,14],"tags":[],"class_list":["post-7008","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-search-console","category-seo"],"yoast_head":"\nLevel Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)<\/title>\n<meta name=\"description\" content=\"Google Search Console performance reports are cool. Google Data Studio can make them even cooler with its features. Explore more here!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)\" \/>\n<meta property=\"og:description\" content=\"Google Search Console performance reports are cool. Google Data Studio can make them even cooler with its features. Explore more here!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"CueBlog\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-02T15:16:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T10:26:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png\" \/>\n\t<meta property=\"og:image:width\" content=\"865\" \/>\n\t<meta property=\"og:image:height\" content=\"575\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Harleen Sandhu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harleen Sandhu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/\",\"url\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/\",\"name\":\"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)\",\"isPartOf\":{\"@id\":\"https:\/\/www.cueforgood.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png\",\"datePublished\":\"2024-05-02T15:16:13+00:00\",\"dateModified\":\"2025-11-13T10:26:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.cueforgood.com\/blog\/#\/schema\/person\/07e30f758ffdbe4e3081c6be3abf6ace\"},\"description\":\"Google Search Console performance reports are cool. Google Data Studio can make them even cooler with its features. Explore more here!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#primaryimage\",\"url\":\"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png\",\"contentUrl\":\"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png\",\"width\":865,\"height\":575,\"caption\":\"Replicating Search Console in Data Studio\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.cueforgood.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cueforgood.com\/blog\/#website\",\"url\":\"https:\/\/www.cueforgood.com\/blog\/\",\"name\":\"CueBlog\",\"description\":\"Leveraging eCommerce for Purpose\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cueforgood.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cueforgood.com\/blog\/#\/schema\/person\/07e30f758ffdbe4e3081c6be3abf6ace\",\"name\":\"Harleen Sandhu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.cueforgood.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/06\/cueb-100x100.png\",\"contentUrl\":\"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/06\/cueb-100x100.png\",\"caption\":\"Harleen Sandhu\"},\"description\":\"I'm a part of CueForGood's SEO team. I like traveling, reading, and experimenting with new ways in SEO to get the best results.\",\"url\":\"https:\/\/www.cueforgood.com\/blog\/author\/harleen-sandhu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)","description":"Google Search Console performance reports are cool. Google Data Studio can make them even cooler with its features. Explore more here!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/","og_locale":"en_US","og_type":"article","og_title":"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)","og_description":"Google Search Console performance reports are cool. Google Data Studio can make them even cooler with its features. Explore more here!","og_url":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/","og_site_name":"CueBlog","article_published_time":"2024-05-02T15:16:13+00:00","article_modified_time":"2025-11-13T10:26:46+00:00","og_image":[{"width":865,"height":575,"url":"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png","type":"image\/png"}],"author":"Harleen Sandhu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harleen Sandhu","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/","url":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/","name":"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)","isPartOf":{"@id":"https:\/\/www.cueforgood.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#primaryimage"},"image":{"@id":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png","datePublished":"2024-05-02T15:16:13+00:00","dateModified":"2025-11-13T10:26:46+00:00","author":{"@id":"https:\/\/www.cueforgood.com\/blog\/#\/schema\/person\/07e30f758ffdbe4e3081c6be3abf6ace"},"description":"Google Search Console performance reports are cool. Google Data Studio can make them even cooler with its features. Explore more here!","breadcrumb":{"@id":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#primaryimage","url":"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png","contentUrl":"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/05\/search-console-datastudio.png","width":865,"height":575,"caption":"Replicating Search Console in Data Studio"},{"@type":"BreadcrumbList","@id":"https:\/\/www.cueforgood.com\/blog\/improving-gsc-performance-report-with-google-data-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.cueforgood.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Level Up Google Search Console\u2019s(GSC) Performance Report with Google Data Studio(GDS)"}]},{"@type":"WebSite","@id":"https:\/\/www.cueforgood.com\/blog\/#website","url":"https:\/\/www.cueforgood.com\/blog\/","name":"CueBlog","description":"Leveraging eCommerce for Purpose","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cueforgood.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.cueforgood.com\/blog\/#\/schema\/person\/07e30f758ffdbe4e3081c6be3abf6ace","name":"Harleen Sandhu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cueforgood.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/06\/cueb-100x100.png","contentUrl":"https:\/\/www.cueforgood.com\/blog\/wp-content\/uploads\/2021\/06\/cueb-100x100.png","caption":"Harleen Sandhu"},"description":"I'm a part of CueForGood's SEO team. I like traveling, reading, and experimenting with new ways in SEO to get the best results.","url":"https:\/\/www.cueforgood.com\/blog\/author\/harleen-sandhu\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/posts\/7008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/comments?post=7008"}],"version-history":[{"count":5,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/posts\/7008\/revisions"}],"predecessor-version":[{"id":7017,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/posts\/7008\/revisions\/7017"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/media\/7014"}],"wp:attachment":[{"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/media?parent=7008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/categories?post=7008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cueforgood.com\/blog\/wp-json\/wp\/v2\/tags?post=7008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}