--- title: "Content opportunities in Search Console with an AI assistant" description: "A method to find queries that earn impressions but have no page answering them: export, group by intent with an AI assistant, validate by hand and decide." url: "https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/" markdown_url: "https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia.md" lang: "en" date_published: "2026-11-12" author: "Martín Garay" author_url: "https://cookingmetrics.com/about-martin-garay/" publisher: "CookingMetrics" publisher_url: "https://cookingmetrics.com/" keywords: ["Technical SEO"] citation_apa7: "Garay, M. (2026, November 12). *Content opportunities in Search Console with an AI assistant*. CookingMetrics. https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/" references_apa7: - "Google Search Console Help. (n.d.). *Performance report (Search results): Overview and basic setup*. https://support.google.com/webmasters/answer/7576553" - "Google Search Console Help. (n.d.). *Performance report (Search results): Dimensions and data groupings*. https://support.google.com/webmasters/answer/17011259" - "Google Search Console API. (n.d.). *Getting your performance data*. https://developers.google.com/webmaster-tools/v1/how-tos/all-your-data" - "Google Search Console Help. (n.d.). *About the bulk data export*. https://support.google.com/webmasters/answer/12918484" --- # Content opportunities in Search Console with an AI assistant > A method to find queries that earn impressions but have no page answering them: export, group by intent with an AI assistant, validate by hand and decide. - **Author:** [Martín Garay](https://cookingmetrics.com/about-martin-garay/) · Founder of CookingMetrics - **Published:** November 12, 2026 - **Topics:** Technical SEO - **Web version:** https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/ ## How to cite this article (APA, 7th edition) Garay, M. (2026, November 12). *Content opportunities in Search Console with an AI assistant*. CookingMetrics. https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/ In-text citation: (Garay, 2026) ## References - Google Search Console Help. (n.d.). *Performance report (Search results): Overview and basic setup*. https://support.google.com/webmasters/answer/7576553 In-text citation: (Google Search Console Help, n.d.) - Google Search Console Help. (n.d.). *Performance report (Search results): Dimensions and data groupings*. https://support.google.com/webmasters/answer/17011259 In-text citation: (Google Search Console Help, n.d.) - Google Search Console API. (n.d.). *Getting your performance data*. https://developers.google.com/webmaster-tools/v1/how-tos/all-your-data In-text citation: (Google Search Console API, n.d.) - Google Search Console Help. (n.d.). *About the bulk data export*. https://support.google.com/webmasters/answer/12918484 In-text citation: (Google Search Console Help, n.d.) --- **To detect content opportunities, export from Search Console the queries that already generate impressions, group them by intent with an AI assistant, and check manually whether your site has a page that answers each group.** The assistant sorts; it does not measure. Positions and volumes come from Search Console, and a person makes the final decision. This guide is written for the people who decide what content to produce, not only for those who implement it. Technical terms are explained in plain words and the detail appears under the label "For the technical team". [CookingMetrics](https://cookingmetrics.com/) offers audits and support to development teams, and does not sell visibility tools. A warning up front: **CookingMetrics has not tested this method on its own data**. We describe it based on Google's documentation and our own judgment, and we do not promise that it will produce more traffic. ## In summary - The starting point is the queries for which your site already appears on Google (impressions). They are a signal of real demand, although a partial one. - The AI assistant only groups similar queries by intent. It must be forbidden from inventing volumes, positions or clicks. - Each group is validated by hand by looking at Google's results: the intent the assistant assumes may be wrong. - For each group, one of three things is decided: a new page, expanding an existing one or consolidating pages that compete. - Search Console does not show all queries: it omits some for privacy reasons. For medium or large sites it is worth using the API or the BigQuery export. - Before uploading data to an assistant, review its privacy terms. ## What problem it solves Many sites publish by intuition and do not know which questions already reach them without having a page designed for them. Search Console records which queries your site appears for. Cross-checking that list with the pages that exist reveals three situations: queries with no page of their own, pages that only partly answer, and several pages competing for the same thing. An **impression** is an appearance of your page on a results page; it does not mean that anyone saw or read it. A query with many impressions and few clicks may point to an opportunity, or simply to a query that is not very relevant to your business. That distinction is yours, not the assistant's. ## Step 1: export the data In the [Search Console](https://support.google.com/webmasters/answer/7576553) performance report you can see the data by queries, pages, countries, devices, search appearance and dates, and by default it shows the last three months. Export two views: queries and pages, with clicks, impressions and position. Note the date range, because without it the figures cannot be compared later. There is a difference worth knowing: according to Google, data grouped by queries is aggregated by property and data grouped by pages is aggregated by page. That is why the two exports may not add up to the same totals. **For the technical team:** the [data aggregation page](https://support.google.com/webmasters/answer/17011259) states that some queries are omitted from the report to protect privacy (it calls them anonymized) and that the complete list is obtained with the bulk export. Anonymized queries count in the chart totals, unless a query filter is applied. The values "~" or "-" are exported as zero. For large volumes: - The [Search Console API](https://developers.google.com/webmaster-tools/v1/how-tos/all-your-data) offers a maximum of 25,000 rows per request (the example on the page calls it the "current maximum size") and is paginated with `startRow`. The same page mentions a maximum of 50,000 rows per day and per search type, sorted by clicks, and warns that when grouping by page or query the system may drop data. The data is usually available after two or three days. - The [bulk export to BigQuery](https://support.google.com/webmasters/answer/12918484) delivers all of the property's data except anonymized queries, once a day. It is not retroactive: history from before the setup is obtained with the API or with the reports. It requires a Google Cloud project with billing and is subject to storage and query costs, with a free tier. The first export can take up to 48 hours. - The official pages consulted on November 12, 2026 show no update date. The BigQuery documentation says once that `query` is empty and another time that it is null for anonymized queries. [Section for signed-in readers, level C: https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/#bloque-1] ## Step 2: group by intent with an AI assistant Ask the assistant to group the queries that look for the same thing, even if they are worded differently, and to name each group with the question it solves. An example of an instruction, which you can adapt: - Group the queries in the list by search intent. - Name each group with the question it answers. - Use only the data I give you. Do not invent volumes, positions, clicks or new queries. - If a query is ambiguous, leave it in a separate group called "unclassified". The rule against inventing is the central part of the method. An assistant can produce plausible figures that are not in your data; that is why the numbers in the analysis are always calculated in the spreadsheet from the export, not from what the assistant writes. **For the technical team:** if the list is long, split it into batches and ask for the same output format for each batch, so they can be merged. Ask for the result as a CSV table with one row per query and a group column, and calculate clicks, impressions and average position per group in the spreadsheet. Record the model version and the date used: another run may group differently. ## Step 3: validate the intent by hand For each relevant group, search for a representative query on Google and look at what types of pages appear: guides, comparisons, product pages, questions and answers. If the results show a different type of page from the one the assistant assumed, correct the group. This review is part of the method and is not delegated: the assistant can be wrong about what the person wants to find. Results change by country, language, device and moment, and those of another person may differ from yours. Note where and when you are looking. [Section for signed-in readers, level C: https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/#bloque-2] ## Step 4: decide what to do with each group Cross-check the groups with the pages export and assign a decision: - **New page:** the group has no page that answers it and it is relevant to your business. - **Expand a page:** a page exists and appears, but it does not fully answer the question. - **Consolidate:** two or more pages appear for the same group. Decide which one to keep and how to merge or redirect the others. This is a hypothesis, not a certainty: that several pages appear for the same query does not prove that they harm each other. - **Do nothing:** the group is not relevant, or the existing page already covers it. Prioritize by relevance to your business, not only by impressions. A query with few impressions can be far more valuable than one with many. ## How to measure whether the method worked Define before publishing what you will compare and over what period. One possible criterion: for each new or expanded page, compare impressions and clicks for its target queries in the same Search Console report, before and after, with the same date range and without other large changes on the site. With low volume the variations are noise; the method serves to decide what to write, and changes in traffic do not by themselves prove that the decision was a good one. For the measurement baseline see [Search Console, Bing and Clarity](https://cookingmetrics.com/blog/medicion-base-search-console-bing-clarity-cloudflare/). [Section for signed-in readers, level C: https://cookingmetrics.com/blog/oportunidades-contenido-search-console-asistente-ia/#bloque-3] ## Limits and risks - **There is no own data.** CookingMetrics did not run this method on its own site for this guide. If it does, it will publish the anonymized result with its limits. - **Anonymized queries are not in the analysis.** Part of the demand stays outside what Search Console shows. - **Impressions are not equivalent to total demand.** Only appearances on Google count. - **The assistant can get the intent wrong or invent data.** Hence the rule and the manual validation. - **Privacy.** The export contains queries from real people and business data, perhaps a client's. Review the assistant's privacy and retention terms, and exclude what should not leave your organization before uploading it. We do not take a position on any provider. - **The official pages show no update date.** It is worth rereading them before deciding. ## What to do next To expand a validated topic, use [a map of related subqueries](https://cookingmetrics.com/blog/query-fan-out-que-es-como-cubrir-subconsultas/). Choose a single site, a single date range and ten queries to test the method before scaling it. If you would like us to review, together with your team, which queries already reach you and which pages are missing, learn about our [technical SEO service](https://cookingmetrics.com/services/technical-seo/): we audit and support your team, and we do not sell visibility tools. ## Frequently asked questions ### Can I trust an AI assistant to decide what content to create? It can sort and group queries, but it must not supply figures or decide. The numbers come from Search Console and the intent is validated by hand in Google's results. ### Does Search Console show all the queries for my site? No. According to Google's documentation, some queries are omitted from the report to protect privacy. The most complete list is obtained with the bulk export to BigQuery, which also does not include anonymized queries. ### What do I do if my site has many queries? Use the Search Console API, which delivers up to 25,000 rows per request, or the BigQuery export, which requires a Google Cloud project and may have costs. ### Is it safe to upload my Search Console data to an AI assistant? It depends on the assistant's privacy and retention terms and on what the data contains. Review them beforehand and exclude what should not leave your organization. --- ## About the author **[Martín Garay](https://cookingmetrics.com/about-martin-garay/)** — Founder of CookingMetrics I'm Martín Garay, founder and Martech Advisor at CookingMetrics and Chair of the Technology Committee at CACE, Argentina's ecommerce chamber. For more than 20 years I've worked in Analytics, development, technical SEO and ecommerce: I implement measurement, find where it breaks and turn it into information you can act on. ### My work at CACE, Argentina's ecommerce chamber - **Chair of the Technology Committee** (SINCE AUGUST 2025): I set the committee's agenda together with Gabriel Topola, vice-chair. We look at the platforms and tools an online business needs to grow: CMS, integrations, customer service and omnichannel operations. - **Curating the technical forum** (IT CAMP · ECOMMERCE DAY ARGENTINA): With CACE's Events team I put together the IT Camp programme: talks for engineering and development teams on platform architecture, code and good practice, given by speakers who do the implementation work. - **Marketing and Data Analytics committees** (SINCE 2016): I started in the Marketing committee and helped create the Data Analytics committee. I gave Google Analytics webinars, including the migration to GA4, and worked on the Google Analytics implementation for Hot Sale and Cyber Monday. - **Ecommerce metrics dashboard** (FOR MEMBERS): With the Data Analytics committee and the CACE Community team we built a dashboard in Google Analytics and Looker Studio so each member can check the key indicators of their own store. ### Talks - [From SEO to GEO: what it takes for a brand to be cited by an answer engine](https://www.youtube.com/watch?v=mlyjuSBdMzI) — ECOMMERCE DAY ARGENTINA 2026 · IT CAMP · AUGUST 27, 2026 · BUENOS AIRES CONVENTION CENTER - [SEO for AI: how to prepare a brand to show up in ChatGPT and Google's AI overviews](https://www.youtube.com/watch?v=4dI7jqnLg-M) — AI IN LATAM 2025 · BUENOS AIRES · OVER 3,500 ATTENDEES AND 100 SPEAKERS, PER THE ORGANIZERS ### Profiles and links - [Full profile](https://cookingmetrics.com/about-martin-garay/) - [LinkedIn](https://www.linkedin.com/in/seospecialistmartingaray/) - [Instagram](https://www.instagram.com/garaymartin/) - [YouTube](https://www.youtube.com/@MartinGaray) - [martingaray.com.ar](https://www.martingaray.com.ar/) - [Chair of the Technology Committee at CACE, Argentina's ecommerce chamber](https://cace.org.ar/pages/comision-de-tecnologia?utm_source=cookingmetrics.com&utm_medium=referral&utm_campaign=perfil-martin&utm_content=caja-autor) - [Ecommerce metrics dashboard, free for CACE members](https://cace.org.ar/pages/dashboard-de-metricas?utm_source=cookingmetrics.com&utm_medium=referral&utm_campaign=perfil-martin&utm_content=caja-autor) --- ## About CookingMetrics CookingMetrics provides Google Analytics consulting, measurement implementation and SEO. Founder Martín Garay brings more than 20 years of experience in Analytics, development and ecommerce. The work connects data with business decisions. ### Services - **[Google Analytics audit](https://cookingmetrics.com/data-analytics-consulting/)**: Do purchases or revenue differ from your store? We review your measurement and deliver a correction plan in 10 business days. [See the audit scope](https://cookingmetrics.com/data-analytics-consulting/). - **[Google Tag Manager](https://cookingmetrics.com/services/gtm/)**: Did events stop being tracked after a website change? We review tags, triggers and versions to find duplicates or missing data. [Ask about Google Tag Manager audits and implementation](https://cookingmetrics.com/services/gtm/). - **[Server-side measurement](https://cookingmetrics.com/services/cookieless-tracking/)**: We assess how to send data from your server, respect consent and prevent duplication. [What's included in server-side measurement](https://cookingmetrics.com/services/cookieless-tracking/). - **[Technical SEO](https://cookingmetrics.com/services/technical-seo/)**: Have you migrated your site, or are pages missing from Google? We review crawling, indexing, structure and performance. [How we approach technical SEO](https://cookingmetrics.com/services/technical-seo/). - **[SEO for AI search (GEO)](https://cookingmetrics.com/services/seo-ai-geo/)**: We review whether search engines and assistants can access your pages and understand their content. [What we can improve for AI search](https://cookingmetrics.com/services/seo-ai-geo/). ### Solutions - **[Google Analytics self-check](https://cookingmetrics.com/google-analytics-self-check/)** (Status: Available) - **[GA4 Report Generator](https://cookingmetrics.com/product/ga4-report-generator/)** (Status: Beta): A tool in beta that already generates Google Analytics reports. Ask about available features and the scope for your project. [Explore GA4 Report Generator](https://cookingmetrics.com/product/ga4-report-generator/). - **[IndexNow Connect](https://cookingmetrics.com/product/indexnow-connect/)** (Status: Available for Tiendanube): Notifies search engines participating in IndexNow of new, updated or deleted URLs. [How IndexNow Connect works](https://cookingmetrics.com/product/indexnow-connect/). - **[AI SEO Analysis](https://cookingmetrics.com/product/ai-seo-analysis/)** (Status: In development): *Coming soon.* An automated audit of how AI assistants and search engines access and use your content. [Learn about AI SEO Analysis](https://cookingmetrics.com/product/ai-seo-analysis/). **Let's talk about your measurement:** [Book a call](https://cookingmetrics.com/about-martin-garay/) · [CookingMetrics](https://cookingmetrics.com/)