<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Razvan Antonescu on Medium]]></title>
        <description><![CDATA[Stories by Razvan Antonescu on Medium]]></description>
        <link>https://medium.com/@razvanantonescu?source=rss-d02a9e24883d------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*piqz35v0f7AZnUrCPmxhIw.jpeg</url>
            <title>Stories by Razvan Antonescu on Medium</title>
            <link>https://medium.com/@razvanantonescu?source=rss-d02a9e24883d------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 18:20:24 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@razvanantonescu/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Using Google Antigravity SKILLS for SEO]]></title>
            <link>https://medium.com/@razvanantonescu/using-google-antigravity-skills-for-seo-8cd7538a5a1b?source=rss-d02a9e24883d------2</link>
            <guid isPermaLink="false">https://medium.com/p/8cd7538a5a1b</guid>
            <category><![CDATA[google-antigravity]]></category>
            <category><![CDATA[seo-with-ai]]></category>
            <category><![CDATA[gemini-cli]]></category>
            <dc:creator><![CDATA[Razvan Antonescu]]></dc:creator>
            <pubDate>Wed, 14 Jan 2026 08:10:09 GMT</pubDate>
            <atom:updated>2026-01-14T08:10:09.121Z</atom:updated>
            <content:encoded><![CDATA[<p>Let’s cut through the marketing noise. If we look past the buzzwords, the latest Google Antigravity update fundamentally changes how we define “instructions” for AI.</p><p>Why this matters (The SEO Context) In Technical SEO, we spend hours writing static documentation: audit procedures, migration checklists, and content briefs. Until now, those were just digital paper for humans to read.</p><p>As of today, your procedures are code.</p><p>- The Update: Antigravity Skills Google has introduced an open standard to extend agent capabilities using a simple file structure.<br>- The Format: A standard <a href="http://skill.md/">SKILL.md</a> file with YAML frontmatter.<br>- The Logic: You define the “When” (triggers) and the “How” (execution steps).<br>- The Location: .agent/skills/ (project-specific) or global.</p><p>Technical Clarification (App vs. Tool) Let’s be precise: Google Antigravity is the Application (IDE) you work in, not a browser replacement. However, the agent inside now has standardized access to a “Browser Subagent”.</p><p>This means you can write a skill that commands the agent to spin up a headless Chrome instance, render JS, and visually inspect a page — exactly like a user.</p><p>The Gemini CLI Connection (The Real Opportunity). This same “Skills” implementation was spotted in the latest Gemini CLI preview this week. This implies total portability. A “Log File Analysis” skill written for the Cloud IDE will work identically in your local terminal.</p><p>Your Options<br>Status Quo: Continue manually pasting 50-line prompts into chat windows.</p><p>AI-grounded SEO : Port your SOPs into <a href="http://skill.md/">SKILL.md</a> files.<br>- Build a Schema Validation skill.<br>- Build a Core Web Vitals Check skill (leveraging the browser subagent).</p><p>The Directive: Don’t wait for the tool to mature. The syntax is simple, and it is here now.<br>Docs: <a href="https://antigravity.google/docs/skills">https://antigravity.google/docs/skills</a><br>Task: Turn your most repetitive SEO task into a Global Skill this week.</p><p><a href="https://www.linkedin.com/search/results/all/?keywords=%23technicalseo&amp;origin=HASH_TAG_FROM_FEED">#TechnicalSEO</a> <a href="https://www.linkedin.com/search/results/all/?keywords=%23googleantigravity&amp;origin=HASH_TAG_FROM_FEED">#GoogleAntigravity</a> <a href="https://www.linkedin.com/search/results/all/?keywords=%23geminicli&amp;origin=HASH_TAG_FROM_FEED">#GeminiCLI</a> <a href="https://www.linkedin.com/search/results/all/?keywords=%23automation&amp;origin=HASH_TAG_FROM_FEED">#Automation</a> <a href="https://www.linkedin.com/search/results/all/?keywords=%23agentseo&amp;origin=HASH_TAG_FROM_FEED">#AgentSEO</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8cd7538a5a1b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Real Estate SEO Dasboard]]></title>
            <link>https://medium.com/@razvanantonescu/real-estate-seo-dasboard-8658331dc5e?source=rss-d02a9e24883d------2</link>
            <guid isPermaLink="false">https://medium.com/p/8658331dc5e</guid>
            <category><![CDATA[search-engine-optimizati]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[real-estate]]></category>
            <category><![CDATA[real-estate-seo]]></category>
            <dc:creator><![CDATA[Razvan Antonescu]]></dc:creator>
            <pubDate>Mon, 06 Apr 2020 07:19:24 GMT</pubDate>
            <atom:updated>2020-04-17T18:46:42.527Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Pqri6zQbnwV0EgtQ.png" /></figure><p>As I mentioned in the <a href="https://razvan-antonescu.info/seo-dashboard-google-data-studio.html">previous article on Data Studio SEO Dashboard</a>, one advantage of Data Studio is that it allows you to <strong>personalize your existing data with custom dimensions and segment the data based on them</strong>. This is where the real power of Data Studio starts to show.</p><p>The inspiration for this model is this <a href="https://helpfullee.com/google-search-console-data-studio-1/">great article</a> by <a href="https://twitter.com/helpfullee?lang=en">Lee Hurst</a> (in fact, this is the article that has shown me the beauty and flexibility of Data Studio and motivated me on creating my own SEO Dashboards). Because for almost a decade my <a href="https://linkedin.com/in/razvanantonescu">freelancing practice</a> had a major part of <strong>Real Estate SEO</strong> (United States/ Canada/ Dubai /Romania), this was the vertical where I first saw the opportunity to use this model of query segmentation in my <a href="https://razvan-antonescu.info/tag/seo-reporting">SEO reporting</a> process.</p><h3>Data Studio Dashboard for Real Estate SEO</h3><p>The Real Estate SEO Data Studio Dashboard included in this article pulls anonymized data from a real estate client. I have cleaned up the queries in order to increase the anonymization and here is the description of the case:</p><blockquote><em>“Data comes from a real estate agency that deals with both rental and property sales. They operate in an area with 3 neighborhoods and the properties they are handling are apartments, villas, and townhouses.”</em></blockquote><blockquote><a href="https://datastudio.google.com/reporting/18cO7bqVQ7rnpUb45XzSXq1NGhPjzUlfu"><em>See the interactive dashboard here</em></a></blockquote><h3>How to create this Real Estate SEO Dashboard</h3><p>The data we are going to use in this dashboard is from Search Console (Site). Based on our case characteristics, we need 3 custom dimensions (and an optional one):</p><ul><li>Property Type</li><li>Transaction Type</li><li>Area Type</li><li>(optional) Number of Keywords</li></ul><h4>Property Type Code</h4><pre>Case When REGEXP_MATCH( Query, &quot;.*apart.*&quot;) then &quot;Apartaments&quot; When REGEXP_MATCH( Query, &quot;.*villa.*&quot;) then &quot;Villas&quot; When REGEXP_MATCH( Query, &quot;.*townhouse.*&quot;) then &quot;Townhouses&quot; Else &quot;Other&quot; END</pre><p>Personalize this code by adding after line 4 as many properties types you have on your site.</p><h4>Transaction Type Code</h4><pre>Case When REGEXP_MATCH( Query, &quot;.*rent.*&quot;) then &quot;To Rent&quot; When REGEXP_MATCH( Query, &quot;.*sale.*&quot;) then &quot;To Sale&quot; Else &quot;Other&quot; END</pre><p>Paste this as it is as there are only 2 types of transactions.</p><h4>Area Type Code</h4><pre>Case When REGEXP_MATCH( Query, &quot;.*XXX.*&quot;) then &quot;area 1&quot; When REGEXP_MATCH( Query, &quot;.*YYY.*&quot;) then &quot;area 2&quot; When REGEXP_MATCH( Query, &quot;.*ZZZ*&quot;) then &quot;area 3&quot; Else &quot;Other&quot; END</pre><p>Personalize this by adding all the areas you cover on your website</p><h4>Number of words Code</h4><pre>Case When REGEXP_MATCH( Query, &quot;^[^ *]+$&quot;) then &quot;1 Word&quot; When REGEXP_MATCH( Query, &quot;^([^ .]+[ ][^ .]+)$&quot;) then &quot;2 Words&quot; When REGEXP_MATCH( Query, &quot;^([^\\s.]+ [^\\s.]+ [^\\s.]+)$&quot;) then &quot;3 Words&quot; When REGEXP_MATCH( Query, &quot;^([^\\s.]+ [^\\s.]+ [^\\s.]+ .+)$&quot;) then &quot;4 Words+&quot; Else &quot;Other&quot; END</pre><p>Paste this as it is. Code has been kindly provided by <a href="https://www.linkedin.com/in/sergiu-paraschiv-6694658b/">Sergiu</a>.</p><h4>Real Estate SEO Dashboard implementation</h4><p>Now, for the final step, we need to add these newly created dimensions to our report. For the best results, I do the following:</p><ol><li>Add a <strong>bar chart </strong>for each dimension</li><li>Use <strong>impressions </strong>as the main metric (to sort the chart by your market visibility no matter what metric is selected)</li><li>In the style tab of the chart, for Left Y-Axis <strong>check “Show axis title”. </strong>This way, when other optional metrics are selected you always know what you are looking at.</li><li><strong>Turn on optional metrics</strong> and add the remaining metrics (clicks/average position/CTR). This allows for in-depth SEP performance audit</li><li><strong>Sort: Impressions.</strong> This shows by default your market visibility but also when other metrics are selected you can quickly identify potential issues or opportunities. That means that when, for example, clicks are selected and the bigger bars are on the right side, you have growth potential for the left side bars.</li><li>For each bar chart, create a<strong> filter to exclude “Other”</strong>. Keep in mind that each bar chart shows only a percent of the total queries/impressions and showing “Other” will decrease the visibility of the important bars.</li><li>In the date range section, I always choose the<strong> last month </strong>option (after all this is part of a larger monthly SEO Report)</li><li>In the interactions sections, check <strong>“Apply filter”</strong></li></ol><p>Now you are all set and ready to get both SEO and Business insights provided for free by Google Search Console</p><h3>How to use this Real Estate SEO Dashboard</h3><p>Using this analysis model, we will be able to answer simple questions without any interaction with the bar charts:</p><ul><li>Which type of transaction drives more traffic?</li><li>What is the order of the property type by volume of impressions?</li><li>Which area is the most popular?</li></ul><p>Using multiple selects we can answer complex questions like:</p><ul><li>Which area is the most important for apartment sales?</li><li>In which area is the highest interest for villas?</li><li>In Area 3, what transactions are the most searched?</li></ul><p>Each of the above examples can be further segmented using the number of words in a query (1, 2, 3, and more than 4).</p><p>Each selection (single or multiple) also outputs on the right side (not included in the demo) the keywords that belong to that selection for further analysis or sharing with other marketing channels.</p><p>After we do our desired segmentation, we can also see the graphic trends of the four Search Console metrics (clicks/impressions/average position and site CTR) for the past 15 months.</p><h3>Other Applications of Search Console Queries Segmentation</h3><h3>Real Estate Keyword Research</h3><p>This applies to sites with some history (more than 12 months, optimally more than 24 months). Assuming that you have done your job well from an SEO point of view, you should have a better market overview than any other keyword tool can offer. <strong>One aspect that is not often talked about is the fact that once you are on the first-page*, the number of impressions is as accurate as you can get. </strong>This is demonstrated by the fact that 2 sites on the first page, for the same query, will have the exact number of impressions.</p><p>I always use this model to identify keywords to track for ranking. I usually use 3 sets of keywords based on intent (Sale/Rent/Generic), each one with 50 keywords. Generic keywords are those with no clear intent (real estate agency/apartments [area] etc.)</p><p>* <em>Being on the first page doesn’t mean only a rank from 1 to 10. You need to have a large number of impressions, too. This is to make sure that you are not counting personalized results.</em></p><h3>Identify Real Estate SEO Weaknesses</h3><p>A general overview of the metrics will easily bury your weaknesses. This analysis model allows you to quickly spot clusters (single or multiple selects) that require your attention. I recommend for real estate SEO an audit of the most important segments at least once every 4 months.</p><h3>Identify granular seasonality in Real Estate</h3><p>Making any selection (single or combined) will give you a historical overview of the selection. This allows you, as a Real Estate Business, to schedule internal resources based on upcoming highs and lows</p><h3>Give data to other Marketing Channels</h3><p>Outputs from the above 2 applications of the model can be shared with other marketing departments/specialists:</p><ul><li>Identified low position keywords can be compensated with Google Search Ads</li><li>Identified seasonality can be used in scheduling Facebook Ads</li><li>Specific seasonalities can be used on content marketing calendars</li></ul><h3>Real-life example</h3><p>This kind of analysis is not exclusively for SEO purposes. It also can be used for business analysis. One example that stuck in my mind: The first time I have shown the model to a client, he observed a high volume of impressions (high interest) in an area that he neglected for prospecting. As such, more real estate agents were allocated to that area to identify more properties.</p><h3>Other usages</h3><h3>Other industries</h3><p>Real Estate is a vertical where this analysis model is perfectly suitable, and with little effort, a high percentage of the keywords can be easily classified.</p><p>Other industries that use the same model (personalized with proper categories) are for example:</p><ul><li>Fashion (segment by gender/clothing type/season/discounts)</li><li>Travel (segment by destinations/hospitality type)</li><li>Niche eCommerce (not generalist). This usually implies a limited number of categories/subcategories</li></ul><p>As a negative example (a vertical where this model has limited value) could be a general news website or a personal blog. In those cases, the semantic is way too fluid and complex to be classified in fixed clusters</p><h3>Reduce “Others”</h3><p>Whenever I start a new project, I start by creating its associated SEO Dashboards (Spreadsheet/Data Studio). On the queries segmentation sheet, my workflow is as follows:</p><ul><li>Start with zero clusters (obviously)</li><li>Sort keywords by impressions and try to identify patterns among the first 100 results</li><li>Once a pattern and its associated root sequence are identified, the next step is their validation. For that, I use the search element to find all the keywords containing the root.</li><li>A set of questions is used to see if the pattern is valid or not:</li><li>Are the numbers large enough? (over 5–10%)</li><li>Are the extracted keywords connected? For example, on one tech company that produces software for the automotive industry, I used “auto” as root. This was far from optimal as the company also offered software testing and “automated testing” keywords also were caught. As such, the root changed from “auto” to “automo”</li><li>Can the identified pattern be grouped with another to form a mixed cluster? In the above example, “automo” and “car” are used together in the Automotive group</li><li>Each time I consider a pattern valid I add it immediately. This allows me to go back to the “Other” keywords and try to reduce them furthermore. If the sites semantic is somehow well structured, the volume of “Other” Keywords should be below 20% in the end.</li></ul><h3>Identify questions from the users</h3><p>As I mentioned at the beginning of the article, <a href="https://helpfullee.com/google-search-console-data-studio-1/">this is the article</a> if you want to find out more about this topic (it also includes a step by step video)</p><h3>Final conclusions</h3><p>While based on a particular vertical (Real Estate), this analysis model can be easily used in most verticals to guide both your SEO activities but also to give you business insights. If you apply it in other verticals, let me know what insights you got and if you see further improvements to the model.</p><p><em>Originally published at </em><a href="https://razvan-antonescu.info/real-estate-seo-dashboard.html"><em>https://razvan-antonescu.info</em></a><em> on April 6, 2020.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8658331dc5e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Advanced SEO Dashboard in Google Data Studio]]></title>
            <link>https://medium.com/@razvanantonescu/advanced-seo-dashboard-in-google-data-studio-2f56514eba77?source=rss-d02a9e24883d------2</link>
            <guid isPermaLink="false">https://medium.com/p/2f56514eba77</guid>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Razvan Antonescu]]></dc:creator>
            <pubDate>Tue, 31 Mar 2020 09:33:14 GMT</pubDate>
            <atom:updated>2020-04-17T18:42:16.822Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*AcIpKwAJslHfmSyM.png" /></figure><p>From the start, this is not an entry-level article on how to create an <strong>SEO Dashboard using Data Studio</strong>. There are already a few well-organized guides to get you started with it (that helped me A LOT in the early days), and here are a few to get you started:</p><p>This is an article meant to give inspiration for medium to advanced professionals but also for business owners/marketers looking for an advanced <a href="https://razvan-antonescu.info/tag/seo-dashboard">SEO Dashboard</a> to add to their <a href="https://razvan-antonescu.info/tag/seo-reporting">SEO reporting</a> model.</p><p>For more than 10 years, I have used (and I’m still using for reasons that will be highlighted at the end) Google Spreadsheets for creating custom SEO Dashboards for my clients. This was the first big step from amateur SEO services to professional services. Over the years, my model evolved and became more and more complex. As such, from my point of view, here are a few attributes that make an SEO Dashboard a good one:</p><ul><li>Provide <strong>context</strong> for information</li><li>Give more information or a <strong>different view</strong> of data from Google Analytics (GA) and Search Console (SC)</li><li>Make it <strong>simple enough</strong> so any client can understand the information</li><li>Use <strong>standardized and free data</strong> (Google Analytics/ Search Console)</li><li>A good SEO Dashboard should be both<strong> a reporting document and an analysis tool</strong> for ongoing SEO strategy</li><li>A good SEO Dashboard can be used in the <strong>onboarding process</strong> to quickly analyze the history of a site, to have an idea of the current status</li></ul><p>When Google launched <a href="https://datastudio.google.com/">Data Studio</a>, I saw the opportunity of creating even more complex and dynamic reports. I’m more of a hunter type, so the first step was to look for available templates shared by the SEO community and find a suitable one that I could adapt to my workflow. By analyzing a lot of the existing models, I couldn’t find any to be used as a base model, so the need for a new template arose. Current templates have the following limitations:</p><ul><li>Limited data</li><li>Just regular data views available in SC and GA put in a simple interface</li><li>Information overload without a plan in mind</li><li><strong>No context for the data</strong></li><li>Ugly 🙂</li></ul><h3>Data Studio SEO Dashboard Details</h3><h3>General Overview</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KUJKqBvRdHTAgLkKqIzUtw.png" /></figure><p>The goal of the first sheet is to give a <strong>helicopter view</strong> of what’s happening on the website, to put the data in a context so it’s understandable and the responsible parties could easily make a forecast of future evolutions</p><p><strong>All traffic (GA): </strong>data is presented in two ways:</p><ul><li>Visual evolution of all the traffic for the past 13 months compared to the previous period. Usually, this kind of visualization has only 12 months, but for me, it is easier to see on the same line the comparison between last month compared to the previous year. This pattern applies to all the “yearly” graphs.</li><li>Numeric values for the most important metrics: Users, Sessions, Bounce Rate, Pages/Session. There are 2 data sets:</li><li>The first is for the last full month. This data is compared Year Over Year</li><li>The second data set represents the past 12 months compared to the previous year</li><li>This is structured like this in order to better understand the last month data. Is it below or above the yearly values?</li></ul><p><strong>Organic Traffic (GA): </strong>this is an SEO Dashboard, after all, so organic traffic plays an important role. The data and the graphic follow the same rules as the “All traffic” section</p><p><strong>Historic organic data (GA):</strong> This is a long graph showing a larger time frame (4 years — if available). The goal is to quickly spot the <strong>overall traffic pattern </strong>and to see if there are any problematic periods of time (redesigns/ migrations/ penalties)</p><p><strong>Channel overview (GA): </strong>this is the first dynamic element, as on a simple click, it changes the “All traffic” and “User Data” to show only values for the current selection</p><p><strong>User data (GA):</strong> This section contains 3 dynamic graphic elements that allow you to further segment (single or multiple selections) the data on the left side:</p><ul><li>Gender/Age Distribution</li><li>Gender Distribution</li><li>Device Distribution</li></ul><p>On the right side of the sheet is a quick overview pulled from the Search Console:</p><ul><li>All Traffic/ Desktop Traffic/ Mobile Traffic with values for <strong>Clicks, Impressions, and Average Position</strong>. The data is from the last full month compared YoY</li><li><strong>Top Querie</strong>s (last month compared to YoY). On custom dashboards, I use only nonbranded keywords in order to highlight SEO efforts better</li></ul><h3>Search Console Analysis</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rkPWqzQBXH9GcTgSHi2TVg.png" /></figure><p>Data on this sheet is pulled exclusively from Search Console.</p><p><strong>Page distribution segmentation (SC):</strong> How keywords are distributed among 3 large segments <em>(first SERP page, second page, all the other pages)</em>. For SEO, the <strong>low hanging fruits are keywords sitting on the second page</strong>. So, sorting by the number of impressions<em> (default sort)</em>, you can quickly identify optimization opportunities. On personalized dashboards, I have another separate segment for branded queries. This layout also allows me to record on the Spreadsheet SEO Dashboard the numbers of keywords/ segment.</p><p><strong>Two segmenting tools:</strong></p><ol><li>By Device <em>(the pie chart has sessions as the metric)</em></li><li>A query finder selector. This allows a quick overview of clustered keywords <em>(keywords sharing the same root-using the contain option)</em></li></ol><p>The right side of the sheet shows numeric values <em>(on top, similar to the ones available on the first sheet)</em> and also a visual representation for the past 13 months. I always hated the combined view on Search Console, and this allows you to see clear trends for all the 4 available metrics. The graphs also have a <a href="https://bettersolutions.com/excel/charts/trendlines-polynomial.htm">polynomial trendline</a>.</p><h3>Search Console Health Check</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KtSrvnu3FG408pJZWg8z8Q.png" /></figure><p>While this sheet gives useful information each month, it is most useful when analyzing a new website. The goal is to<strong> see at a glance the keyword volume per page for the last 3 months compared with the same 3 months from the previous year</strong>. Again, there are graphical representations for SC metrics and also a keyword filtering tool allowing keyword cluster analysis.</p><h3>Speed Performance</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vMqZHEx5A7W9sUt6NgcrpA.png" /></figure><p>This sheet has the role of providing fast insights into 2 metrics pulled from Google Analytics: Avg. Document Interactive Time and Avg. Page Load Time. The left side shows an overview of the pages while the right side shows average site values for the desktop and mobile segments. On custom dashboards, I also use data pulled from <a href="https://developers.google.com/web/tools/chrome-user-experience-report">Chrome User Experience Report</a>.</p><h3>Queries Segmentation</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ccGiEXFXVCCJvUBjuXHORg.png" /></figure><p>This, again, is based on data pulled from the Search Console. In the DEMO version, this is not very useful as it repeats values from previous sheets. In the personalized version, this allows <strong>quick segmentation based on keyword clusters</strong>. On personalized reports, there is also the advantage of editing the SC data source and automatically grouping of keywords. An example of queries segmentation for a real estate website can be seen <a href="https://razvan-antonescu.info/real-estate-seo-dashboard.html">here</a>.</p><h3>Site Explorer</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OES8UdATdL1_qUorfQdIYQ.png" /></figure><p>This is <strong>more of a tool rather than a report</strong>. Based on Search Console data it offers insights into two important SEO activities</p><ol><li><strong>Cannibalization</strong>: clicking on any keyword from the bottom table, it shows on the top table pages appearing for that query. This way you can quickly see if the proper landing page receives the most impressions and clicks and how many other pages are competing for that query</li><li><strong>Internal link building</strong>: using the above method or using the search on the right side you can identify the main page quickly for a semantic root and how many pages appear for it. This allows you to have a strategy for placing links on the right pages for maximum results</li></ol><p>In addition, there is a device segmentation element and graphical representations for 13 months for any selection done.</p><h3>Model Limitations</h3><p>While Google Data Studio is a powerful report AND tool, some limitations require advanced processes and a complimentary SEO spreadsheet. A few of these limitations are:</p><ul><li>Search Console data storage: while the current Search Console offers 16 months of data allowing YoY comparisons, for long term projects this is not enough</li><li>There are custom metrics that cannot be used:</li><li>Keyword volume and period comparisons</li><li>The number of pages. For example, the number of organic landing pages is a metric that I monitor as KPI</li><li>I couldn’t find a way (yet) to show YoY trends</li></ul><p>This kind of data can be saved in a Spreadsheet SEO Dashboard and after that pulled in personalized Data Studio dashboards</p><h3>Free Data Studio SEO Dashboard DEMO</h3><p>Now that the introductions have been made, feel free to analyze your website using the <a href="https://datastudio.google.com/reporting/d2433cc1-ea37-4d9f-aad2-ba2fec089b92">FREE DEMO</a>. By default, the demo uses sample data provided by Google. In order to analyze your website, make sure that you are logged in on Google with the right account and select your site on BOTH Google Analytics and Search Console. Keep in mind that by using the demo version, I don’t have access to any of your data.</p><p><em>Originally published at </em><a href="https://razvan-antonescu.info/seo-dashboard-google-data-studio.html"><em>https://razvan-antonescu.info</em></a><em> on March 31, 2020.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2f56514eba77" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>