<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Mohammad</title>
    <description>The latest articles on DEV Community by Mohammad (@shoplocalnotes).</description>
    <link>https://dev.to/shoplocalnotes</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4205164%2F9546641b-bee3-4e8d-b551-5046860a3408.png</url>
      <title>DEV Community: Mohammad</title>
      <link>https://dev.to/shoplocalnotes</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/shoplocalnotes"/>
    <language>en</language>
    <item>
      <title>One Product, Two Addresses: What Search Console Showed Us About Duplicate Product URLs</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Tue, 10 Nov 2026 03:43:16 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/one-product-two-addresses-what-search-console-showed-us-about-duplicate-product-urls-2n7n</link>
      <guid>https://dev.to/shoplocalnotes/one-product-two-addresses-what-search-console-showed-us-about-duplicate-product-urls-2n7n</guid>
      <description>&lt;p&gt;I help out with &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ&lt;/a&gt;, a marketplace where shoppers find local clothing shops nearby and shop owners list their stock for free. Our Search Console export for 28 Sep to 27 Oct 2026 shows 6,886 impressions and 86 clicks across the site. The most useful finding was not a keyword. It was that the same product could be reached at two addresses, and Google indexed both.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1cc2mndgl6oogp33q2t6.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1cc2mndgl6oogp33q2t6.jpg" alt="One product, two addresses: frq.in/product/X and shop.frq.in/product/X both point at one product, a 301 picks one address, shoppers find nearby shops and shops list stock free" width="800" height="384"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  The setup
&lt;/h2&gt;

&lt;p&gt;Each product has a page on the main domain, &lt;code&gt;frq.in/product/X&lt;/code&gt;, and a page on the shop's own subdomain, &lt;code&gt;&amp;lt;shop&amp;gt;.frq.in/product/X&lt;/code&gt;. The main page already set its canonical tag to the subdomain, so the design was sound on paper. A canonical tag is only a hint, though, and Google does not always follow it.&lt;/p&gt;

&lt;h2&gt;
  
  
  What the export showed
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Page type&lt;/th&gt;
&lt;th&gt;URLs&lt;/th&gt;
&lt;th&gt;Clicks&lt;/th&gt;
&lt;th&gt;Impressions&lt;/th&gt;
&lt;th&gt;CTR&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Product pages on the main domain&lt;/td&gt;
&lt;td&gt;220&lt;/td&gt;
&lt;td&gt;5&lt;/td&gt;
&lt;td&gt;839&lt;/td&gt;
&lt;td&gt;0.6%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Product pages on shop subdomains&lt;/td&gt;
&lt;td&gt;123&lt;/td&gt;
&lt;td&gt;2&lt;/td&gt;
&lt;td&gt;293&lt;/td&gt;
&lt;td&gt;0.7%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Between them, 343 of the 528 indexed URLs are product pages. They got 1,132 impressions and 7 clicks. The blog posts, by comparison, had 5,945 impressions and 55 clicks, so the product pages were taking space in the results without earning visits.&lt;/p&gt;

&lt;p&gt;One product page was reachable at three addresses: the main domain, a shop subdomain and the www host.&lt;/p&gt;

&lt;p&gt;Product snippets were rare but telling: 24 impressions, at an average position of 16.5. The pages were there, but the snippet was not doing much.&lt;/p&gt;

&lt;h2&gt;
  
  
  Other things the export turned up
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Fourteen test URLs were indexed (test shops, test products, a /store/test page). Those need &lt;code&gt;noindex&lt;/code&gt; or deletion, because they compete with real pages.&lt;/li&gt;
&lt;li&gt;Mobile averaged position 7.1 and desktop 13.4. A page that looks fine on a laptop can still be hard to use on a phone, and 87% of our impressions are on mobile.&lt;/li&gt;
&lt;li&gt;Google showed 1,927 'translated results' (28% of impressions) at a 0.5% CTR. Hindi searchers were seeing machine-translated pages, not ours.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  The fix we are asking for
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Pick one address per product. Either &lt;code&gt;frq.in/product/X&lt;/code&gt; or &lt;code&gt;&amp;lt;shop&amp;gt;.frq.in/product/X&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;Send the other address to the chosen one with a 301, which is a stronger signal than a canonical hint.&lt;/li&gt;
&lt;li&gt;Add Product schema with price and availability, so a snippet has something real to show.&lt;/li&gt;
&lt;li&gt;Remove the city from the product description template. It was repeated on every product page.&lt;/li&gt;
&lt;li&gt;Submit the sitemap again, and request indexing for the edited pages.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Why this matters beyond our site
&lt;/h2&gt;

&lt;p&gt;A marketplace grows by adding sellers, and each seller brings a subdomain. If your product URL depends on the seller's subdomain, every new seller creates a new duplicate, and search engines split the signal between them. Decide the canonical address before the first hundred sellers, not after.&lt;/p&gt;

&lt;p&gt;Our numbers are small, so treat them as a pattern to check rather than a benchmark. The Search Console export is the thing to look at on your own site: the page-type table takes about ten minutes to build.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;(I help out with FRQ.)&lt;/em&gt;&lt;/p&gt;

</description>
      <category>seo</category>
      <category>webdev</category>
      <category>ecommerce</category>
      <category>data</category>
    </item>
    <item>
      <title>Our Brand Search Gets 9% Clicks, Our Festival Query Gets 0.2%: Reading a Search Console Export for Titles</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Sat, 07 Nov 2026 03:37:18 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/our-brand-search-gets-9-clicks-our-festival-query-gets-02-reading-a-search-console-export-for-lo0</link>
      <guid>https://dev.to/shoplocalnotes/our-brand-search-gets-9-clicks-our-festival-query-gets-02-reading-a-search-console-export-for-lo0</guid>
      <description>&lt;p&gt;I help out with &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ&lt;/a&gt;, a marketplace where shoppers find local clothing shops nearby and shop owners list for free. Our Search Console export for 28 Sep to 27 Oct 2026 shows 6,886 impressions and 86 clicks across the site. Most of what we learned sits in one row and one group of queries.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fagidqf7mm6dqdcui8w4a.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fagidqf7mm6dqdcui8w4a.jpg" alt="FRQ shoppers find nearby clothing shops, shops list their stock free: three steps and a free listing line" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Three numbers
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Query group&lt;/th&gt;
&lt;th&gt;Impressions&lt;/th&gt;
&lt;th&gt;Clicks&lt;/th&gt;
&lt;th&gt;CTR&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Brand: queries containing "frq" (8 queries)&lt;/td&gt;
&lt;td&gt;108&lt;/td&gt;
&lt;td&gt;9&lt;/td&gt;
&lt;td&gt;8.3%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Karwa Chauth: queries containing karwa, karva or करवा (129 queries)&lt;/td&gt;
&lt;td&gt;1,556&lt;/td&gt;
&lt;td&gt;10&lt;/td&gt;
&lt;td&gt;0.6%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;The whole Queries sheet (333 queries)&lt;/td&gt;
&lt;td&gt;2,340&lt;/td&gt;
&lt;td&gt;21&lt;/td&gt;
&lt;td&gt;0.9%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;The Queries sheet is a partial export. It covers 2,340 of the 6,886 impressions, so read the last row as a sample, not a total.&lt;/p&gt;

&lt;p&gt;The row that stands out is "karwa chauth 2026 shopping". It had 452 impressions, an average position of 6.6, and one click. Position 6.6 is near the top of page one. People saw the page and mostly did not click it. Ranking is not the whole story; the title and the snippet decide the click.&lt;/p&gt;

&lt;h2&gt;
  
  
  Pull the numbers yourself
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;

&lt;span class="n"&gt;q&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;read_excel&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;frq_search_console_2026-10-29.xlsx&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;sheet_name&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Queries&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;ctr_pct&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="mi"&gt;100&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;round&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="n"&gt;brand&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Top queries&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;contains&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;\bfrq\b&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;case&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;na&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)]&lt;/span&gt;
&lt;span class="n"&gt;karwa&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Top queries&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;contains&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;karwa|karva|करवा&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;case&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;na&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)]&lt;/span&gt;

&lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;g&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="p"&gt;[(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;brand&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;brand&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;karwa chauth&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;karwa&lt;/span&gt;&lt;span class="p"&gt;)]:&lt;/span&gt;
    &lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="nf"&gt;len&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;g&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt; &lt;span class="n"&gt;g&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(),&lt;/span&gt; &lt;span class="n"&gt;g&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(),&lt;/span&gt;
          &lt;span class="nf"&gt;round&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;g&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt; &lt;span class="n"&gt;g&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="mi"&gt;100&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Output on our export: &lt;code&gt;brand 8 108 9 8.3&lt;/code&gt; and &lt;code&gt;karwa chauth 129 1556 10 0.6&lt;/code&gt;. The regex grouping is a judgment call. A query like "frq contact" counts as brand, and "karwa" catches both spellings.&lt;/p&gt;

&lt;h2&gt;
  
  
  What I would test first
&lt;/h2&gt;

&lt;p&gt;Searching for our name converts. Searching for the festival barely does, and the festival search is where the shoppers are. So the job for the page is to look like the answer before someone clicks:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Put the item and the date in the title, the way the query is typed.&lt;/li&gt;
&lt;li&gt;Say in the first line of the description that local shops are listed, not only that the guide exists.&lt;/li&gt;
&lt;li&gt;Keep the same queries and compare CTR 28 days later, using the same export.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Caveats
&lt;/h2&gt;

&lt;p&gt;This is one month, one partial export, and no control group. The average position is an average over the impressions, and the grouping is my own. I would treat this as a lead to test, not a finding. Shaadi season runs into 2027, so the same check can run again in December.&lt;/p&gt;

&lt;p&gt;If you have seen a title change move CTR on a seasonal query, I would like to hear what you changed.&lt;/p&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

</description>
      <category>webdev</category>
    </item>
    <item>
      <title>Google Was Translating 28% of Our Search Impressions: hreflang for English, Hindi and Hinglish in 2027</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Wed, 04 Nov 2026 03:51:07 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/google-was-translating-28-of-our-search-impressions-hreflang-for-english-hindi-and-hinglish-in-2ail</link>
      <guid>https://dev.to/shoplocalnotes/google-was-translating-28-of-our-search-impressions-hreflang-for-english-hindi-and-hinglish-in-2ail</guid>
      <description>&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;&lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ&lt;/a&gt; is a small hyperlocal marketplace: shoppers find clothing shops near them, and shop owners list for free. Its audience writes in three ways: English, Hindi in Devanagari, and Hinglish (Hindi typed in Latin letters, like "shopping kab kare"). Until now the site only had English pages.&lt;/p&gt;

&lt;p&gt;The Search Console export for 26 Sep – 27 Oct 2026 showed what that costs. This post walks through the numbers, the pandas code that found them, and the hreflang setup we are shipping for the 2027 season. It is a plan with a measurement attached, not a success story yet.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. The number that started it
&lt;/h2&gt;

&lt;p&gt;Search Console → Performance → Search appearance has a row called &lt;strong&gt;Translated results&lt;/strong&gt;. Google shows it when it machine-translates your title and snippet into the searcher's language because it found nothing good in that language.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Segment&lt;/th&gt;
&lt;th&gt;Impressions&lt;/th&gt;
&lt;th&gt;Clicks&lt;/th&gt;
&lt;th&gt;CTR&lt;/th&gt;
&lt;th&gt;Avg. position&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;All searches&lt;/td&gt;
&lt;td&gt;6,886&lt;/td&gt;
&lt;td&gt;86&lt;/td&gt;
&lt;td&gt;1.25%&lt;/td&gt;
&lt;td&gt;~7.6&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Translated results&lt;/td&gt;
&lt;td&gt;1,927 (28%)&lt;/td&gt;
&lt;td&gt;10&lt;/td&gt;
&lt;td&gt;0.52%&lt;/td&gt;
&lt;td&gt;7.72&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Everything else&lt;/td&gt;
&lt;td&gt;4,959&lt;/td&gt;
&lt;td&gt;76&lt;/td&gt;
&lt;td&gt;1.53%&lt;/td&gt;
&lt;td&gt;–&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Same position, about a third of the click-through rate. Over a quarter of the site's visibility was going to people who saw a translated snippet of an English page and mostly didn't click.&lt;/p&gt;

&lt;h2&gt;
  
  
  2. Reading it with pandas
&lt;/h2&gt;

&lt;p&gt;The export is one &lt;code&gt;.xlsx&lt;/code&gt; with one sheet per report.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;

&lt;span class="n"&gt;x&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;ExcelFile&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;search_console_export.xlsx&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;appearance&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Search appearance&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;chart&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Chart&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="n"&gt;total_impr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;chart&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt;
&lt;span class="n"&gt;total_clicks&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;chart&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;()&lt;/span&gt;

&lt;span class="n"&gt;tr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;appearance&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="n"&gt;appearance&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Search Appearance&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Translated results&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="n"&gt;iloc&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;rest_impr&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;total_impr&lt;/span&gt; &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="n"&gt;tr&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;rest_clicks&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;total_clicks&lt;/span&gt; &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="n"&gt;tr&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;

&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;translated share: &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;tr&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt; &lt;span class="n"&gt;total_impr&lt;/span&gt;&lt;span class="si"&gt;:&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="o"&gt;%&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;translated CTR:   &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;tr&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt; &lt;span class="n"&gt;tr&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="si"&gt;:&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="o"&gt;%&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;other CTR:        &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;rest_clicks&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt; &lt;span class="n"&gt;rest_impr&lt;/span&gt;&lt;span class="si"&gt;:&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="o"&gt;%&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;translated share: 28%
translated CTR:   0.52%
other CTR:        1.53%
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  3. Splitting queries by script
&lt;/h2&gt;

&lt;p&gt;The Queries sheet only lists queries Google is willing to show (here 333 queries covering 2,340 of the 6,886 impressions; the rest are anonymized). Even that slice shows the three audiences.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;

&lt;span class="n"&gt;q&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Queries&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;columns&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;ctr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;position&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;

&lt;span class="n"&gt;DEVANAGARI&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;compile&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;[\u0900-\u097F]&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="c1"&gt;# a small, hand-made list of Hindi function words typed in Latin letters
&lt;/span&gt;&lt;span class="n"&gt;HINGLISH&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;compile&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;\b(kab|kya|kaise|kitne|ki|ke|kare|karen|kahan|par|aur|wala|mein|hai|hain|kharide|kapde|dukan)\b&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;
&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;script&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;s&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;-&amp;gt;&lt;/span&gt; &lt;span class="nb"&gt;str&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;DEVANAGARI&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;search&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;s&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
        &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;hindi_devanagari&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;
    &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;HINGLISH&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;search&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;s&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
        &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;hinglish&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;english_or_brand&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;

&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;script&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;map&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;script&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;groupby&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;script&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)[[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;())&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Script&lt;/th&gt;
&lt;th&gt;Queries&lt;/th&gt;
&lt;th&gt;Impressions&lt;/th&gt;
&lt;th&gt;Clicks&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Hinglish (word-list heuristic)&lt;/td&gt;
&lt;td&gt;71&lt;/td&gt;
&lt;td&gt;629&lt;/td&gt;
&lt;td&gt;3&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Hindi (Devanagari)&lt;/td&gt;
&lt;td&gt;22&lt;/td&gt;
&lt;td&gt;130&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;English / brand / product&lt;/td&gt;
&lt;td&gt;240&lt;/td&gt;
&lt;td&gt;1,581&lt;/td&gt;
&lt;td&gt;17&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;The word list is crude (it will miss some Hinglish and could catch an odd English query), but the shape is clear: a real share of searchers type in Hindi or Hinglish, and almost none of them click an English page. Queries like "karwa chauth ki shopping kab kare" sat around position 6–9 with zero clicks.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. The hreflang setup
&lt;/h2&gt;

&lt;p&gt;The fix we are shipping: publish real Hinglish (and later Devanagari) versions of the guides that win, as &lt;strong&gt;separate URLs&lt;/strong&gt;, and tell Google they are alternates of each other.&lt;/p&gt;

&lt;p&gt;Each page in a set lists every version, including itself:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight html"&gt;&lt;code&gt;&lt;span class="c"&gt;&amp;lt;!-- on BOTH pages --&amp;gt;&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"canonical"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-en"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;  &lt;span class="c"&gt;&amp;lt;!-- each page canonicals to ITSELF --&amp;gt;&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"en-IN"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-en"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"hi-IN"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-hinglish"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"x-default"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-en"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Or in the sitemap, which is easier to keep consistent on a growing blog:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight xml"&gt;&lt;code&gt;&lt;span class="nt"&gt;&amp;lt;urlset&lt;/span&gt; &lt;span class="na"&gt;xmlns=&lt;/span&gt;&lt;span class="s"&gt;"http://www.sitemaps.org/schemas/sitemap/0.9"&lt;/span&gt;
        &lt;span class="na"&gt;xmlns:xhtml=&lt;/span&gt;&lt;span class="s"&gt;"http://www.w3.org/1999/xhtml"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
  &lt;span class="nt"&gt;&amp;lt;url&amp;gt;&lt;/span&gt;
    &lt;span class="nt"&gt;&amp;lt;loc&amp;gt;&lt;/span&gt;https://frq.in/blog/guide-en&lt;span class="nt"&gt;&amp;lt;/loc&amp;gt;&lt;/span&gt;
    &lt;span class="nt"&gt;&amp;lt;xhtml:link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"en-IN"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-en"&lt;/span&gt;&lt;span class="nt"&gt;/&amp;gt;&lt;/span&gt;
    &lt;span class="nt"&gt;&amp;lt;xhtml:link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"hi-IN"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-hinglish"&lt;/span&gt;&lt;span class="nt"&gt;/&amp;gt;&lt;/span&gt;
  &lt;span class="nt"&gt;&amp;lt;/url&amp;gt;&lt;/span&gt;
  &lt;span class="nt"&gt;&amp;lt;url&amp;gt;&lt;/span&gt;
    &lt;span class="nt"&gt;&amp;lt;loc&amp;gt;&lt;/span&gt;https://frq.in/blog/guide-hinglish&lt;span class="nt"&gt;&amp;lt;/loc&amp;gt;&lt;/span&gt;
    &lt;span class="nt"&gt;&amp;lt;xhtml:link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"en-IN"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-en"&lt;/span&gt;&lt;span class="nt"&gt;/&amp;gt;&lt;/span&gt;
    &lt;span class="nt"&gt;&amp;lt;xhtml:link&lt;/span&gt; &lt;span class="na"&gt;rel=&lt;/span&gt;&lt;span class="s"&gt;"alternate"&lt;/span&gt; &lt;span class="na"&gt;hreflang=&lt;/span&gt;&lt;span class="s"&gt;"hi-IN"&lt;/span&gt; &lt;span class="na"&gt;href=&lt;/span&gt;&lt;span class="s"&gt;"https://frq.in/blog/guide-hinglish"&lt;/span&gt;&lt;span class="nt"&gt;/&amp;gt;&lt;/span&gt;
  &lt;span class="nt"&gt;&amp;lt;/url&amp;gt;&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;/urlset&amp;gt;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Rules that bite small sites:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Return links.&lt;/strong&gt; If page A points to B but B does not point back, Google ignores the pair.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Canonical to self.&lt;/strong&gt; A Hinglish page that canonicals to the English page tells Google "ignore me".&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;No auto-redirect by location or browser language.&lt;/strong&gt; Googlebot mostly crawls from one place; let people choose.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Translate the whole page&lt;/strong&gt;, not just the title. A Hinglish H1 on English body text is the same thin page.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  5. Which code is "Hinglish"?
&lt;/h2&gt;

&lt;p&gt;There is no ISO language code for Hinglish. Google's hreflang documentation allows a script subtag from ISO 15924 (its examples are &lt;code&gt;zh-Hant&lt;/code&gt; and &lt;code&gt;zh-Hans&lt;/code&gt;), so &lt;code&gt;hi-Latn&lt;/code&gt; (Hindi, Latin script) is valid syntax. What I could not find is any statement that Google groups Hinglish searches under it.&lt;/p&gt;

&lt;p&gt;So for now: Hinglish pages get &lt;code&gt;hi-IN&lt;/code&gt;, because the queries are Hindi words and there is no Devanagari page competing for that slot yet. When a Devanagari version exists, the plan is &lt;code&gt;hi-IN&lt;/code&gt; for Devanagari and a test of &lt;code&gt;hi-Latn&lt;/code&gt; for Hinglish on a few pages. That is a judgment call, and the export will tell us if it was wrong.&lt;/p&gt;

&lt;h2&gt;
  
  
  6. A ten-line checker
&lt;/h2&gt;

&lt;p&gt;Return links break quietly when someone edits one page. This runs in CI or by hand:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;alternates&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
    &lt;span class="n"&gt;html&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;url&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;timeout&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="n"&gt;text&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="nf"&gt;dict&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;findall&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;'&lt;/span&gt;&lt;span class="s"&gt;hreflang=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;([^&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;]+)&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;\s+href=&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;([^&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;]+)&lt;/span&gt;&lt;span class="sh"&gt;"'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;html&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;check&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;urls&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
    &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;u&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="n"&gt;urls&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;lang&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;alt&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="nf"&gt;alternates&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;u&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;items&lt;/span&gt;&lt;span class="p"&gt;():&lt;/span&gt;
            &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;alt&lt;/span&gt; &lt;span class="o"&gt;!=&lt;/span&gt; &lt;span class="n"&gt;u&lt;/span&gt; &lt;span class="ow"&gt;and&lt;/span&gt; &lt;span class="n"&gt;u&lt;/span&gt; &lt;span class="ow"&gt;not&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="nf"&gt;alternates&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;alt&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;values&lt;/span&gt;&lt;span class="p"&gt;():&lt;/span&gt;
                &lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sa"&gt;f&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;missing return link: &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;alt&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt; does not point back to &lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;u&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt; (&lt;/span&gt;&lt;span class="si"&gt;{&lt;/span&gt;&lt;span class="n"&gt;lang&lt;/span&gt;&lt;span class="si"&gt;}&lt;/span&gt;&lt;span class="s"&gt;)&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="nf"&gt;check&lt;/span&gt;&lt;span class="p"&gt;([&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;https://frq.in/blog/guide-en&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;https://frq.in/blog/guide-hinglish&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;])&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;(The regex assumes &lt;code&gt;hreflang&lt;/code&gt; comes before &lt;code&gt;href&lt;/code&gt; in the tag; use an HTML parser if your templates vary.)&lt;/p&gt;

&lt;h2&gt;
  
  
  7. How we will know
&lt;/h2&gt;

&lt;p&gt;Same export, 28 days after the first pairs go live, three numbers:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Translated results share&lt;/strong&gt; of impressions (now 28%): should fall if Google starts showing the Hinglish page instead of translating the English one.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;CTR on Hinglish and Devanagari queries&lt;/strong&gt; (now 4 clicks on 759 impressions): should rise.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;CTR on "everything else"&lt;/strong&gt; (now 1.53%): should not drop. If it does, the alternates are cannibalising.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If the first number does not move, hreflang was not the bottleneck and the next suspect is the pages themselves. Either way the 2027 festival calendar (Karwa Chauth, Diwali, the wedding season) gets written in the language people actually search in.&lt;/p&gt;

&lt;p&gt;If you run a site for a bilingual audience, I'd like to hear what you saw. FRQ itself is at &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;; shoppers can browse nearby shops at &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;market.frq.in&lt;/a&gt;, and clothing shop owners can list for free at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;(I help out with FRQ.)&lt;/em&gt;&lt;/p&gt;

</description>
      <category>seo</category>
      <category>webdev</category>
      <category>python</category>
      <category>i18n</category>
    </item>
    <item>
      <title>Your Search Console Export Hides Two-Thirds of Your Queries: A pandas Festival Calendar for 2027</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Sun, 01 Nov 2026 03:44:40 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/your-search-console-export-hides-two-thirds-of-your-queries-a-pandas-festival-calendar-for-2027-30hb</link>
      <guid>https://dev.to/shoplocalnotes/your-search-console-export-hides-two-thirds-of-your-queries-a-pandas-festival-calendar-for-2027-30hb</guid>
      <description>&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;&lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ&lt;/a&gt; is a small hyperlocal marketplace: shoppers find clothing shops near them, and shop owners list for free. Like most small sites, it has no analytics team. What it does have is a Google Search Console export: one &lt;code&gt;.xlsx&lt;/code&gt; file with the last 30 days to 27 October 2026.&lt;/p&gt;

&lt;p&gt;This post is the notebook I used to turn that one file into a content calendar for the 2026-27 festival and wedding season. All numbers below come from that export. The code works on any site's export.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Load the export
&lt;/h2&gt;

&lt;p&gt;Search Console → Performance → Export → Excel gives you one workbook with a sheet per tab.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;

&lt;span class="n"&gt;x&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;ExcelFile&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;search_console_export.xlsx&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;sheet_names&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="c1"&gt;# ['Chart', 'Queries', 'Pages', 'Countries', 'Devices', 'Search appearance', 'Filters']
&lt;/span&gt;
&lt;span class="n"&gt;q&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Queries&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;  &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;columns&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;ctr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;pos&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;p&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Pages&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;    &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;columns&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;page&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;ctr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;pos&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="n"&gt;chart&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Chart&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  2. Gotcha: the Queries sheet is not your traffic
&lt;/h2&gt;

&lt;p&gt;The first thing I did was add up the Queries sheet. It did not match the total.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;chart&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(),&lt;/span&gt; &lt;span class="n"&gt;chart&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;())&lt;/span&gt;   &lt;span class="c1"&gt;# 6886 86
&lt;/span&gt;&lt;span class="nf"&gt;print&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(),&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;())&lt;/span&gt;                  &lt;span class="c1"&gt;# 2340 21
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The 333 query rows cover &lt;strong&gt;2,340 of 6,886 impressions (34%)&lt;/strong&gt; and &lt;strong&gt;21 of 86 clicks (24%)&lt;/strong&gt;. Google leaves out rare queries for privacy, and on a small, young site most queries are rare. If you plan content only from the Queries sheet, you plan from a third of the picture.&lt;/p&gt;

&lt;p&gt;The Pages sheet goes the other way: it sums to 8,165 impressions, more than the total, because Search Console counts a page-level impression for every URL shown, and one search can show two of your pages. So:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;use &lt;strong&gt;Chart&lt;/strong&gt; for totals,&lt;/li&gt;
&lt;li&gt;use &lt;strong&gt;Pages&lt;/strong&gt; to judge pages,&lt;/li&gt;
&lt;li&gt;use &lt;strong&gt;Queries&lt;/strong&gt; for the wording people type, not for volume.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  3. Bucket queries by intent (Hinglish and Hindi included)
&lt;/h2&gt;

&lt;p&gt;FRQ's audience types in English, Hinglish and Hindi script, so the patterns have to cover all three. A plain regex table was enough:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;

&lt;span class="n"&gt;buckets&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;seller&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;      &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;business|online store|sell|dukan online|apni dukan&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;when&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;        &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;\bkab\b|\bkb\b|date|muhurat|tithi|\btime\b|\btak\b|कब|मुहूर्त&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;price&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;       &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;price|kitne ka|cost|\brate\b|sasta|budget&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;what_to_buy&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;kya kharid|kya le|\blist\b|ideas|outfit|saman|सामान&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;where&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;       &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;near me|kahan|nearby|पास&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;how_to&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;      &lt;span class="sa"&gt;r&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;how to|kaise|कैसे&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;bucket&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;query&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
    &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;pattern&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="n"&gt;buckets&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;items&lt;/span&gt;&lt;span class="p"&gt;():&lt;/span&gt;
        &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;search&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;pattern&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;query&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;I&lt;/span&gt;&lt;span class="p"&gt;):&lt;/span&gt;
            &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;other&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;

&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;bucket&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;].&lt;/span&gt;&lt;span class="nf"&gt;apply&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;bucket&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;q&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;groupby&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;bucket&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;agg&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;queries&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;query&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;count&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
                        &lt;span class="n"&gt;impressions&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sum&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
                        &lt;span class="n"&gt;clicks&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;sum&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)).&lt;/span&gt;&lt;span class="nf"&gt;sort_values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impressions&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;ascending&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;bucket&lt;/th&gt;
&lt;th&gt;queries&lt;/th&gt;
&lt;th&gt;impressions&lt;/th&gt;
&lt;th&gt;clicks&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;other&lt;/td&gt;
&lt;td&gt;163&lt;/td&gt;
&lt;td&gt;1,131&lt;/td&gt;
&lt;td&gt;13&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;when&lt;/td&gt;
&lt;td&gt;97&lt;/td&gt;
&lt;td&gt;918&lt;/td&gt;
&lt;td&gt;7&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;what_to_buy&lt;/td&gt;
&lt;td&gt;16&lt;/td&gt;
&lt;td&gt;114&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;seller&lt;/td&gt;
&lt;td&gt;37&lt;/td&gt;
&lt;td&gt;91&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;how_to&lt;/td&gt;
&lt;td&gt;13&lt;/td&gt;
&lt;td&gt;58&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;price&lt;/td&gt;
&lt;td&gt;6&lt;/td&gt;
&lt;td&gt;27&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;where&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Two things jumped out:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;"When" beats "where".&lt;/strong&gt; 97 different queries asked &lt;em&gt;when&lt;/em&gt; to shop ("karwa chauth ki shopping kab kare", "kb kre", "muhurat", the same question in Devanagari). Exactly one query had "near me" in it. For a "near me" product that is humbling, and useful: people plan festival shopping by the calendar first and pick the shop second.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Spelling variety is the long tail.&lt;/strong&gt; The same question showed up as karwa, karva, karwachauth and करवा चौथ. One page that answers the question well collects all of them; the regex table is how you see that they are one question.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  4. Find pages Google shows but nobody clicks
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;zero&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;[(&lt;/span&gt;&lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;&amp;gt;=&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;&amp;amp;&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;p&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;clicks&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;)].&lt;/span&gt;&lt;span class="nf"&gt;sort_values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;impr&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;ascending&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="bp"&gt;False&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="nf"&gt;len&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;zero&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;   &lt;span class="c1"&gt;# 27
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;27 pages had 20 or more impressions and zero clicks. These are the cheapest wins on the site: Google already ranks them (several sit at average position 6 to 10), so a better title and a direct answer in the first two lines can turn impressions into visits without a new URL. On FRQ that list included a wedding-season guide (47 impressions, position 6.4), a men's kurta measurement guide (45 impressions) and a saree packing guide (68 impressions).&lt;/p&gt;

&lt;h2&gt;
  
  
  5. Check the device split before you design anything
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="n"&gt;x&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;parse&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Devices&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;device&lt;/th&gt;
&lt;th&gt;clicks&lt;/th&gt;
&lt;th&gt;impressions&lt;/th&gt;
&lt;th&gt;position&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Mobile&lt;/td&gt;
&lt;td&gt;69&lt;/td&gt;
&lt;td&gt;5,977&lt;/td&gt;
&lt;td&gt;7.08&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Desktop&lt;/td&gt;
&lt;td&gt;17&lt;/td&gt;
&lt;td&gt;878&lt;/td&gt;
&lt;td&gt;13.39&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Tablet&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;td&gt;31&lt;/td&gt;
&lt;td&gt;6.87&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;87% of impressions were on mobile, and mobile ranked about six places higher than desktop. Every page gets tested on a phone first.&lt;/p&gt;

&lt;h2&gt;
  
  
  6. Turn it into a calendar
&lt;/h2&gt;

&lt;p&gt;The pattern in the data: festival guides with the year and a Hinglish question in the title win, and the impressions arrive before the festival. Karwa Chauth fell on 29 October 2026 (Drik Panchang); in the 14 days up to 27 October FRQ had 5,271 impressions, against 1,615 in the 18 days before that, and the Karwa Chauth 2026 guide alone collected 3,537 impressions and 28 clicks. So the calendar is a list of peaks, with a publish-by date about 10 days earlier:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="kn"&gt;from&lt;/span&gt; &lt;span class="n"&gt;datetime&lt;/span&gt; &lt;span class="kn"&gt;import&lt;/span&gt; &lt;span class="n"&gt;date&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;timedelta&lt;/span&gt;

&lt;span class="n"&gt;peaks&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Diwali outfits and shopping list&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;      &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;11&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;8&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Shaadi season opens (Dev Uthani Ekadashi)&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;11&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Wedding guest outfits (Feb weddings)&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;  &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2027&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;Christmas and New Year party wear&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;     &lt;span class="nf"&gt;date&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2026&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;12&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;25&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="n"&gt;cal&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;DataFrame&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="p"&gt;[(&lt;/span&gt;&lt;span class="n"&gt;topic&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;peak&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;peak&lt;/span&gt; &lt;span class="o"&gt;-&lt;/span&gt; &lt;span class="nf"&gt;timedelta&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;days&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;10&lt;/span&gt;&lt;span class="p"&gt;))&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;topic&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;peak&lt;/span&gt; &lt;span class="ow"&gt;in&lt;/span&gt; &lt;span class="n"&gt;peaks&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;items&lt;/span&gt;&lt;span class="p"&gt;()],&lt;/span&gt;
    &lt;span class="n"&gt;columns&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;topic&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;peak&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;publish_by&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;
&lt;span class="p"&gt;).&lt;/span&gt;&lt;span class="nf"&gt;sort_values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="s"&gt;publish_by&lt;/span&gt;&lt;span class="sh"&gt;"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;topic&lt;/th&gt;
&lt;th&gt;peak&lt;/th&gt;
&lt;th&gt;publish by&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Diwali outfits and shopping list&lt;/td&gt;
&lt;td&gt;8 Nov 2026&lt;/td&gt;
&lt;td&gt;29 Oct 2026&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Shaadi season opens&lt;/td&gt;
&lt;td&gt;20 Nov 2026&lt;/td&gt;
&lt;td&gt;10 Nov 2026&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Christmas and New Year party wear&lt;/td&gt;
&lt;td&gt;25 Dec 2026&lt;/td&gt;
&lt;td&gt;15 Dec 2026&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Wedding guest outfits (Feb weddings)&lt;/td&gt;
&lt;td&gt;2 Feb 2027&lt;/td&gt;
&lt;td&gt;23 Jan 2027&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Festival dates come from a panchang, not from the data. Dev Uthani Ekadashi on 20 November 2026 and the first February 2027 wedding date are from Drik Panchang's calendars; Diwali on 8 November is from FRQ's own Diwali guide. Ten days is the lead time we chose to test, not something the export proves.&lt;/p&gt;

&lt;h2&gt;
  
  
  What we're doing with it
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Writing festival and wedding-season guides on &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;'s own blog first, in English and Hinglish, because the site's own pages are where the clicks are.&lt;/li&gt;
&lt;li&gt;Answering the "when" question in the first two lines of every guide.&lt;/li&gt;
&lt;li&gt;Rewriting the titles of the 27 zero-click pages before writing anything new.&lt;/li&gt;
&lt;li&gt;Re-running this notebook every month through the wedding season into 2027.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you run a local shop and want to try it: listing on FRQ is free at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;, and shoppers can browse local markets at &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;market.frq.in&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

</description>
      <category>python</category>
      <category>seo</category>
      <category>datascience</category>
      <category>ecommerce</category>
    </item>
    <item>
      <title>How a Hyperlocal Fashion Marketplace Works: List Free, Get Found (2027 Guide)</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Thu, 29 Oct 2026 14:25:17 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/how-a-hyperlocal-fashion-marketplace-works-list-free-get-found-2027-guide-43c3</link>
      <guid>https://dev.to/shoplocalnotes/how-a-hyperlocal-fashion-marketplace-works-list-free-get-found-2027-guide-43c3</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Funu60oz8k1neb86jk9cb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Funu60oz8k1neb86jk9cb.png" alt="FRQ business model: local clothing shops each with a map pin, linked to the same pins on a phone showing frq.in, shoppers walking between the shops" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Every Diwali the same thing happens. A shopper types "kurta shop near me" or "saree shop near me with price" a few days before Dhanteras, gets a list of big brands and directory pages, and the small clothing shop two streets away, with exactly the outfit they wanted, never shows up.&lt;/p&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;This post explains, in plain terms, how a &lt;strong&gt;hyperlocal fashion marketplace&lt;/strong&gt; closes that gap, using &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ (Find Retailers Quickly)&lt;/a&gt; as the worked example, and ends with a short checklist a shop owner can finish before Dhanteras (6 November 2026).&lt;/p&gt;

&lt;h2&gt;
  
  
  The problem: online discovery, offline purchase
&lt;/h2&gt;

&lt;p&gt;Most Indian shoppers still want to touch the fabric, try the fit and pay at a counter they trust, especially for festive and wedding wear. But the &lt;em&gt;search&lt;/em&gt; now starts on the phone. If a shop has no page with its products and prices, it is invisible at the exact moment the shopper decides where to go.&lt;/p&gt;

&lt;p&gt;Big marketplaces solve discovery by shipping the product to you. A hyperlocal marketplace solves it differently: it sends &lt;strong&gt;you to the shop&lt;/strong&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How the model works, step by step
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;1. The shop lists for free.&lt;/strong&gt; A clothing shop owner signs up at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;, adds the shop's details and uploads products with photos and prices. FRQ's own FAQ describes a free Starter plan (up to 50 products, 0% commission), so a small shop can start without paying anything.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;2. Each shop gets its own page and link.&lt;/strong&gt; The shop's catalogue lives on its own address on frq.in, which the owner can share on WhatsApp, print as a QR code at the counter, or put in a social bio. The same page is what search engines can find.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;3. Shoppers search by what and where.&lt;/strong&gt; On &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt; and &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;market.frq.in&lt;/a&gt; a shopper browses categories and nearby markets, compares a few local shops' products and prices, and picks one, all before leaving home.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;4. The sale happens in the shop.&lt;/strong&gt; The shopper visits, tries it on and pays at the counter. Where the shop offers it, the shopper can reserve a piece first and try it in the shop. No courier, no return shipping, no commission on the sale for the shop.&lt;/p&gt;

&lt;p&gt;That loop, &lt;em&gt;list free → get found on the map → shopper walks in&lt;/em&gt;, is the whole business model, and it is why it suits clothing so well: fit and fabric matter, and local shops already have the stock.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why this works better for festivals than a generic directory
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Prices are visible.&lt;/strong&gt; "Near me with price" searches are common because shoppers hate walking in blind. A product page with a price answers that question; a directory listing with only a phone number does not.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Stock changes weekly in festive season.&lt;/strong&gt; A shop page the owner updates from the phone keeps up with new Diwali and wedding stock.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;It is clothing only.&lt;/strong&gt; A focused marketplace is easier for a shopper to trust for "lehenga" or "kurta set" than a list that mixes clothes with plumbers and caterers.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  A pre-Dhanteras checklist for clothing shop owners
&lt;/h2&gt;

&lt;p&gt;If you run a small clothing shop, this takes about an hour and can be done today:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;List the shop&lt;/strong&gt; on &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt; with correct timings and contact details.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Add your 10–20 best festive pieces&lt;/strong&gt; with clear phone photos in daylight and a real price on each. "Price on request" loses most shoppers.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Write one honest line per product&lt;/strong&gt;: fabric, sizes available, and whether it can be altered.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Share your shop link&lt;/strong&gt; on WhatsApp status and with your regular customers, and print it as a QR code for the counter.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Update it twice a week&lt;/strong&gt; until Diwali (8 November) and keep doing it through the 2026–2027 wedding season. Fresh stock is the reason shoppers come back.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  For developers reading this
&lt;/h2&gt;

&lt;p&gt;If you build sites for local shops, the same principles apply on any stack: one canonical page per shop, one page per product with a visible price, a mobile-first layout (most "near me" searches are on phones), and &lt;code&gt;ClothingStore&lt;/code&gt; plus &lt;code&gt;Product&lt;/code&gt; structured data. I wrote a copy-paste version of that markup earlier: &lt;a href="https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa"&gt;structured data for a small clothing shop&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;What is a hyperlocal fashion marketplace?&lt;/strong&gt;&lt;br&gt;
An app or site that shows clothing from shops near you, so you can compare online and then buy in person at the shop.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Is listing a clothing shop on FRQ free?&lt;/strong&gt;&lt;br&gt;
Yes. FRQ's FAQ lists a free Starter plan with up to 50 products and 0% commission.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Do shoppers pay anything to use frq.in?&lt;/strong&gt;&lt;br&gt;
No. Browsing local shops and their products on frq.in is free.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Can I reserve clothes online and try them in the shop?&lt;/strong&gt;&lt;br&gt;
Where the shop offers it, yes. Here is a longer guide: &lt;a href="https://dev.to/shoplocalnotes/can-i-reserve-clothes-online-and-try-them-in-store-a-2027-guide-to-reserve-and-try-at-local-shops-1cnf"&gt;reserve online, try in the shop&lt;/a&gt;.&lt;/p&gt;




&lt;p&gt;Shopping for Diwali? Find local clothing shops near you on &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;. Running a shop? List it free on &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;shop.frq.in&lt;/a&gt;. (I help out with FRQ.)&lt;/p&gt;

</description>
      <category>ecommerce</category>
      <category>smallbusiness</category>
      <category>seo</category>
      <category>india</category>
    </item>
    <item>
      <title>Can I Reserve Clothes Online and Try Them in Store? A 2027 Guide to Reserve-and-Try at Local Shops</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Tue, 27 Oct 2026 17:38:02 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/can-i-reserve-clothes-online-and-try-them-in-store-a-2027-guide-to-reserve-and-try-at-local-shops-1cnf</link>
      <guid>https://dev.to/shoplocalnotes/can-i-reserve-clothes-online-and-try-them-in-store-a-2027-guide-to-reserve-and-try-at-local-shops-1cnf</guid>
      <description>&lt;p&gt;&lt;strong&gt;Yes, you can reserve clothes online and try them in store.&lt;/strong&gt; Many local clothing shops now put their stock online, and on a marketplace like FRQ (frq.in) you can reserve a piece free for 48 hours, walk into the shop, try it on and pay at the counter only if you like it. No card, no booking fee, no delivery. (I help out with FRQ.)&lt;/p&gt;

&lt;p&gt;This guide explains how reserve-and-try works, what it costs, what to check before you leave home and where it beats both pure online shopping and walking from shop to shop. It is written for the 2027 wedding and festive season, when most of us are buying a kurta, a saree or a lehenga and do not want to guess.&lt;/p&gt;

&lt;h2&gt;
  
  
  What "reserve online, try in store" actually means
&lt;/h2&gt;

&lt;p&gt;There are three common ways to buy clothes today:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Buy online, get it delivered.&lt;/strong&gt; You pay first, wait for delivery, and if the size or colour is wrong you start a return.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Walk in cold.&lt;/strong&gt; You go to the market, move from counter to counter, and hope the piece you want is in stock in your size.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Reserve online, try in store.&lt;/strong&gt; You look at real stock and real prices from shops near you on your phone, ask one shop to keep a piece aside, then go and try it.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The third option is sometimes called "buy online, pick up in store" or "click and collect". The difference with reserve-and-try is that you do not pay online at all. You only pay after you have touched the fabric and checked the fit.&lt;/p&gt;

&lt;h2&gt;
  
  
  How reserve-and-try works on frq.in, step by step
&lt;/h2&gt;

&lt;p&gt;Here is the flow on FRQ (Find Retailers Quickly), as it works on the site today:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Pick your market.&lt;/strong&gt; Open &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;https://frq.in/&lt;/a&gt; in your phone's browser. There is no app to install.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Search or browse.&lt;/strong&gt; Type what you want, such as "silk saree" or "kurta set", and see which shops have it, with photos and the price next to each one.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Reserve it free.&lt;/strong&gt; Ask the shop to keep it aside. The reservation is held for 48 hours. There is nothing to pay and no card to enter.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Walk in, try, pay.&lt;/strong&gt; The same page shows the shop's address, opening hours and directions. Try the piece on. If it is right, pay the shopkeeper at the counter. If it is not, you simply do not buy it.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The shopkeeper confirms the stock and the final price, so it is worth one quick look at your reservation before you leave home.&lt;/p&gt;

&lt;h2&gt;
  
  
  What does it cost?
&lt;/h2&gt;

&lt;p&gt;For shoppers, nothing extra. Browsing, comparing prices and reserving are free, and you pay the shop its own price at the counter with no fee added on top.&lt;/p&gt;

&lt;p&gt;To give you a feel for real prices, this is what a search on frq.in showed on 27 October 2026:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Kurtas:&lt;/strong&gt; from ₹539&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Sarees:&lt;/strong&gt; ₹919 to ₹4,229&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Women's lehengas:&lt;/strong&gt; ₹3,389 to ₹7,819&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Prices change as shops update their stock, so treat these as a snapshot, not a promise. The point is that you see the number before you go, instead of discovering it at the counter.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why reserve-and-try beats the other two options
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Versus ordering online:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;You see the true colour in daylight, not on a screen.&lt;/li&gt;
&lt;li&gt;You feel the fabric. A "silk blend" can mean many things.&lt;/li&gt;
&lt;li&gt;You check the fit on your body, not on a size chart.&lt;/li&gt;
&lt;li&gt;There is no return to arrange. If it does not suit you, you leave it at the shop.&lt;/li&gt;
&lt;li&gt;You can wear it the same evening if you need to.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Versus walking in cold:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;You know the piece is there before you put your shoes on.&lt;/li&gt;
&lt;li&gt;You can compare the same item across several shops first.&lt;/li&gt;
&lt;li&gt;You avoid the "come back tomorrow, new stock is coming" trip.&lt;/li&gt;
&lt;li&gt;You spend your time in one shop, trying, not in five shops, asking.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Reserve karke shop par try karna: kab sabse kaam aata hai
&lt;/h2&gt;

&lt;p&gt;Reserve-and-try is most useful when:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;The outfit is for a function.&lt;/strong&gt; A lehenga or saree for a wedding has to fit and photograph well. Reserve two options in two shops and try both on the same day.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;You are buying for someone else.&lt;/strong&gt; Reserve, then take them along to try.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Sizes are tricky.&lt;/strong&gt; Kurtas and blouses vary a lot between makers. Trying beats measuring.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Time is short.&lt;/strong&gt; A reservation in the morning can be on you by the evening.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Budget matters.&lt;/strong&gt; Seeing prices across shops first stops you from overpaying at the first counter you walk into.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What to check before you reserve
&lt;/h2&gt;

&lt;p&gt;A reservation is only as good as the details behind it. Before you tap reserve:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Photos:&lt;/strong&gt; Are they of the actual piece, from more than one angle?&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Price:&lt;/strong&gt; Is it the final price, or "starting from"? Ask if unsure.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Size and colour:&lt;/strong&gt; Pick the exact one you want to try.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Opening hours:&lt;/strong&gt; Make sure the shop is open when you plan to go.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Return or exchange terms:&lt;/strong&gt; These are set by each shop. Ask before you pay, and keep your bill.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What happens if you can't make it in 48 hours?
&lt;/h2&gt;

&lt;p&gt;The reservation is held for 48 hours. After that, the shop can sell the piece to someone else. If your plans change, it is fair to the shopkeeper to cancel or simply not go. If you still want it, check the listing again. It may still be in stock, and you can reserve it once more.&lt;/p&gt;

&lt;p&gt;A good habit: reserve only what you genuinely plan to try. Shopkeepers set the piece aside for you, so a reservation is a small promise on both sides.&lt;/p&gt;

&lt;h2&gt;
  
  
  Tips for trying clothes in the shop
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Go in daylight&lt;/strong&gt; if colour matters. Shop lights can change how a shade looks.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Wear or carry the right undergarments and footwear&lt;/strong&gt; for a lehenga or saree trial.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Check the stitching&lt;/strong&gt; at the seams, hem and zip, not just the front.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Move in it.&lt;/strong&gt; Sit, raise your arms and walk. A wedding outfit has to work for hours.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Ask about alterations.&lt;/strong&gt; Many local shops can adjust the fit for you.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  For shop owners: why this matters to you
&lt;/h2&gt;

&lt;p&gt;If you run a clothing shop, reserve-and-try brings you shoppers who already know what they came for. They have seen your price and chosen your shop, and the sale still happens at your counter. On FRQ's Starter plan a shop can list products at ₹0 a month with 0% commission, and there is no delivery or online payment to manage. You can read more on &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;https://shop.frq.in/&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Quick FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Can I reserve clothes online and try them in store?&lt;/strong&gt;&lt;br&gt;
Yes. On frq.in you reserve a piece free, it is held for 48 hours, and you try it in the shop before paying.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Do I pay online to reserve?&lt;/strong&gt;&lt;br&gt;
No. You pay the shopkeeper directly at the counter, after you have tried the item.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Is there a fee for reserving?&lt;/strong&gt;&lt;br&gt;
No. Reserving is free for shoppers, and no fee is added to the shop's price.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Do I need an app?&lt;/strong&gt;&lt;br&gt;
No. FRQ works in the browser on any phone.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Who handles returns or exchanges?&lt;/strong&gt;&lt;br&gt;
The shop you bought from, under its own terms. Keep your bill.&lt;/p&gt;

&lt;h2&gt;
  
  
  Further reading
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;What FRQ is, in 17 short questions and answers: &lt;a href="https://shoplocalnotes.wordpress.com/2026/10/25/what-is-frq-frq-in-questions-and-answers-about-indias-local-fashion-marketplace/" rel="noopener noreferrer"&gt;https://shoplocalnotes.wordpress.com/2026/10/25/what-is-frq-frq-in-questions-and-answers-about-indias-local-fashion-marketplace/&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;The shopper guide to finding local shops online: &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;https://market.frq.in/&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Browse shops and reserve: &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;https://frq.in/&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;em&gt;Prices quoted were checked on frq.in on 27 October 2026. (I help out with FRQ.)&lt;/em&gt;&lt;/p&gt;

</description>
      <category>ecommerce</category>
      <category>smallbusiness</category>
      <category>beginners</category>
      <category>productivity</category>
    </item>
    <item>
      <title>Shop ko Google par kaise dale? A free 2027 guide for small clothing shops</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Tue, 27 Oct 2026 12:05:57 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/shop-ko-google-par-kaise-dale-a-free-2027-guide-for-small-clothing-shops-3gm3</link>
      <guid>https://dev.to/shoplocalnotes/shop-ko-google-par-kaise-dale-a-free-2027-guide-for-small-clothing-shops-3gm3</guid>
      <description>&lt;p&gt;&lt;strong&gt;Shop ko Google par kaise dale? Short answer: create a free Google Business Profile for your shop, verify it, and give Google a web page that lists what you sell with prices.&lt;/strong&gt; That is the whole job. Everything below is the detail, written for a small clothing shop owner who has a phone, a counter and no developer.&lt;/p&gt;

&lt;p&gt;I wrote this because "shop ko google par kaise dale" is one of the most common questions shop owners type into Google, and most answers stop at step one. Step one gets you on the map. The steps after it decide whether anyone actually walks in. (I help out with FRQ.)&lt;/p&gt;

&lt;h2&gt;
  
  
  Why being on Google matters for a clothing shop
&lt;/h2&gt;

&lt;p&gt;People now search before they step out. They type things like "saree shop near me with price" or "kurta shop near me". If your shop is not on Google, you are not in that list, even if you have the best stock in the market. If you are on Google but show no products and no prices, the shop next to you that does show them usually gets the visit.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 1: Make a free Google Business Profile
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Search "Google Business Profile" and open Google's own page for it.&lt;/li&gt;
&lt;li&gt;Sign in with a Google account (make one just for the shop if you can).&lt;/li&gt;
&lt;li&gt;Add the shop name exactly as it is written on your board.&lt;/li&gt;
&lt;li&gt;Pick a category. For most of us that is "Clothing store", "Saree store" or "Women's clothing store".&lt;/li&gt;
&lt;li&gt;Add the address, phone number and opening hours.&lt;/li&gt;
&lt;li&gt;Google will ask you to prove you own the shop. The options it gives differ from shop to shop (a short video, a code by phone or email, or a postcard). Follow what it shows you on the screen.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;A Business Profile is free. Nobody needs to be paid to "put your shop on Google".&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 2: Fill the profile like a shop window
&lt;/h2&gt;

&lt;p&gt;An empty profile is like a shutter that is half down. Add:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;10 or more clear photos: the board outside, the counter, the racks, and a few best-selling pieces.&lt;/li&gt;
&lt;li&gt;Your real opening hours, including the weekly off day.&lt;/li&gt;
&lt;li&gt;A short description: what you sell, for whom, and the price range.&lt;/li&gt;
&lt;li&gt;Updates when new stock comes in (the profile lets you post short updates).&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Step 3: Give Google a page with your products and prices
&lt;/h2&gt;

&lt;p&gt;This is the step most shops skip. Google likes to send people to a page that answers their question, and a shopper's question is usually "do they have it, and how much?"&lt;/p&gt;

&lt;p&gt;You have three choices:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Your own website.&lt;/strong&gt; Best if you have time and money for it.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A social media page.&lt;/strong&gt; Better than nothing, but it is hard for Google to read prices from posts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A free shop page on a local marketplace.&lt;/strong&gt; For example, &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;frq.in's free shop website&lt;/a&gt; gives a shop its own address like yourshop.frq.in, a product catalogue and counter billing. Its page says the Starter plan is ₹0 a month and it takes 0% commission (read on 27 Oct 2026). You put that address in the "Website" field of your Google Business Profile.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;On frq.in, shoppers can see your items with prices, reserve one free for 48 hours, and then try it and pay at your counter. So a search turns into a walk-in, not a courier parcel.&lt;/p&gt;

&lt;h2&gt;
  
  
  Google par dukan dikhane ke 3 asaan kadam (jo log bhool jaate hain)
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Naam, pata, phone har jagah ek jaisa rakho.&lt;/strong&gt; Board, Google profile, WhatsApp and your shop page should all show the same name, address and number. Mixed details confuse Google.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Asli customers se review maango.&lt;/strong&gt; After a happy sale, ask the customer to leave a review. Never buy fake reviews; Google removes them and the profile can suffer.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Daam chhupao mat.&lt;/strong&gt; Shoppers search "with price". Show a price, or at least a "from ₹…" range, for your main items.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Step 4 (optional, for the techie in the family): add structured data
&lt;/h2&gt;

&lt;p&gt;If you do have your own website, a small block of JSON-LD tells Google exactly what the page is about. A minimal example:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"@context"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://schema.org"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"@type"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"ClothingStore"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Your Shop Name"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"telephone"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"+91-00000-00000"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"openingHours"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Mo-Sa 10:00-21:00"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"url"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://yourshop.example"&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;I went through the full version, with five common mistakes, in &lt;a href="https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa"&gt;an earlier post on ClothingStore schema&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  How long does it take to show on Google?
&lt;/h2&gt;

&lt;p&gt;Honestly, it varies. The profile can show up once it is verified, and Google's own help pages say a new web page can take from a few days to a few weeks to be crawled. Keep adding photos, products and real reviews in the meantime; an active profile does better than one that was made and forgotten.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Shop ko Google par dalne ka kitna paisa lagta hai?&lt;/strong&gt;&lt;br&gt;
Nothing. Google Business Profile is free. A free shop page (for example on &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;) costs ₹0 on its Starter plan, per its own page on 27 Oct 2026.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Website ke bina Google par shop dikh sakti hai?&lt;/strong&gt;&lt;br&gt;
Yes. The Business Profile works without a website. But a page with your products and prices helps shoppers decide to visit, so it is worth adding one.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Free listing on Google kaise kare?&lt;/strong&gt;&lt;br&gt;
Make a Google Business Profile (Step 1 above). That is Google's own free listing for a shop.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Can shoppers reserve my clothes before visiting?&lt;/strong&gt;&lt;br&gt;
On &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;the frq.in market&lt;/a&gt;, yes: a shopper can reserve an item free for 48 hours and then try it and pay at your counter.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;(I help out with FRQ.) If you run a small clothing shop and try these steps, tell me in the comments what got stuck. I'll add the answer here.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>seo</category>
      <category>smallbusiness</category>
      <category>beginners</category>
      <category>webdev</category>
    </item>
    <item>
      <title>Structured Data for a Small Clothing Shop: a Copy-Paste ClothingStore Schema (and 5 Mistakes to Avoid)</title>
      <dc:creator>Mohammad</dc:creator>
      <pubDate>Sat, 24 Oct 2026 17:08:41 +0000</pubDate>
      <link>https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa</link>
      <guid>https://dev.to/shoplocalnotes/structured-data-for-a-small-clothing-shop-a-copy-paste-clothingstore-schema-and-5-mistakes-to-5epa</guid>
      <description>&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fk176eof4wfp59r2c3udx.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fk176eof4wfp59r2c3udx.png" alt="FRQ (Find Retailers Quickly) poster for clothing shop owners" width="800" height="1000"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fow18e3pf1rytz3s97znl.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fow18e3pf1rytz3s97znl.png" alt="FRQ poster in Hindi for clothing shop owners" width="800" height="1000"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Posters: &lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;FRQ (Find Retailers Quickly)&lt;/a&gt;&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;By Mohammad&lt;/p&gt;

&lt;p&gt;If you've ever built a site for a relative's or neighbour's shop, you know the pattern: the site looks fine, but Google shows the wrong hours, no price range, and the map pin points at the next lane. For small clothing shops in India this matters a lot right now, because wedding and festive shoppers start on their phones.&lt;/p&gt;

&lt;p&gt;Most of that information comes from the shop's Google Business Profile, but the website can help too. A small block of &lt;strong&gt;schema.org structured data&lt;/strong&gt; tells search engines exactly what the shop is, where it is, and when it's open. Here is a copy-paste version for a clothing shop, and the mistakes I keep seeing.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Use the right type: &lt;code&gt;ClothingStore&lt;/code&gt;
&lt;/h2&gt;

&lt;p&gt;schema.org has a specific type for this, &lt;code&gt;ClothingStore&lt;/code&gt;, which is a subtype of &lt;code&gt;Store&lt;/code&gt; → &lt;code&gt;LocalBusiness&lt;/code&gt;. Use it instead of a generic &lt;code&gt;Organization&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight html"&gt;&lt;code&gt;&lt;span class="nt"&gt;&amp;lt;script &lt;/span&gt;&lt;span class="na"&gt;type=&lt;/span&gt;&lt;span class="s"&gt;"application/ld+json"&lt;/span&gt;&lt;span class="nt"&gt;&amp;gt;&lt;/span&gt;
&lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@context&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://schema.org&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;ClothingStore&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;name&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Sharma Garments&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;image&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://example.com/photos/shopfront.jpg&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;url&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://example.com/&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;telephone&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;+91-98xxxxxx10&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;priceRange&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;₹300–₹6000&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;address&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;PostalAddress&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;streetAddress&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Shop 14, Main Bazaar Road&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;addressLocality&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Indore&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;addressRegion&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;MP&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;postalCode&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;452002&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;addressCountry&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;IN&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;
  &lt;span class="p"&gt;},&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;geo&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;GeoCoordinates&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;latitude&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;22.7196&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;longitude&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;75.8577&lt;/span&gt;
  &lt;span class="p"&gt;},&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;openingHoursSpecification&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
    &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;@type&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;OpeningHoursSpecification&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;dayOfWeek&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Monday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Wednesday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Thursday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Friday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Saturday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;Sunday&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;opens&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;10:30&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;closes&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;21:30&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
  &lt;span class="p"&gt;],&lt;/span&gt;
  &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;sameAs&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://www.instagram.com/example&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="dl"&gt;"&lt;/span&gt;&lt;span class="s2"&gt;https://wa.me/9198xxxxxx10&lt;/span&gt;&lt;span class="dl"&gt;"&lt;/span&gt;
  &lt;span class="p"&gt;]&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="nt"&gt;&amp;lt;/script&amp;gt;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  2. The five fields that actually matter for a small shop
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;openingHoursSpecification&lt;/code&gt;&lt;/strong&gt;: many market shops close one weekday (often Tuesday). Leave that day out of &lt;code&gt;dayOfWeek&lt;/code&gt; instead of writing "closed" somewhere in text.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;geo&lt;/code&gt;&lt;/strong&gt;: take the coordinates from the shop's own Google Maps pin, not from the street name. In crowded markets the street-level guess is often 100 metres off.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;priceRange&lt;/code&gt;&lt;/strong&gt;: shoppers filter on budget. A real range ("₹300–₹6000") is more useful than "$$".&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;telephone&lt;/code&gt;&lt;/strong&gt;: use the number the shop actually answers, ideally the WhatsApp Business number, in international format.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;image&lt;/code&gt;&lt;/strong&gt;: a real shopfront photo helps people recognise the shop when they arrive.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  3. Keep it consistent everywhere
&lt;/h2&gt;

&lt;p&gt;Search engines cross-check. The name, address and phone number (NAP) in your JSON-LD should match the Google Business Profile, the signboard, and any marketplace or directory page the shop has, character for character. "Shop 14, Main Bazaar Rd" in one place and "14 Main Bazar" in another is the most common reason a small shop's details look unreliable.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Validate before you ship
&lt;/h2&gt;

&lt;p&gt;Paste the page URL into Google's Rich Results Test and the Schema Markup Validator (validator.schema.org). Fix every error; most are a missing comma or a time written as "10.30" instead of "10:30".&lt;/p&gt;

&lt;h2&gt;
  
  
  5. What if the shop has no website at all?
&lt;/h2&gt;

&lt;p&gt;Plenty of small clothing shops don't, and building one just for schema isn't worth it. The practical options are a complete Google Business Profile plus a free shop page on a local marketplace. One I help with is FRQ, short for Find Retailers Quickly (&lt;a href="https://frq.in/" rel="noopener noreferrer"&gt;frq.in&lt;/a&gt;): a clothing shop can make its own page with products and prices at &lt;a href="https://shop.frq.in/" rel="noopener noreferrer"&gt;https://shop.frq.in/&lt;/a&gt;, and shoppers browse local shops at &lt;a href="https://market.frq.in/" rel="noopener noreferrer"&gt;https://market.frq.in/&lt;/a&gt;. (I help out with FRQ.) Whatever you pick, keep the same name, address and phone number as above.&lt;/p&gt;

&lt;h2&gt;
  
  
  Quick checklist
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;[ ] &lt;code&gt;@type&lt;/code&gt; is &lt;code&gt;ClothingStore&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;[ ] Address matches the signboard and Google Business Profile&lt;/li&gt;
&lt;li&gt;[ ] &lt;code&gt;geo&lt;/code&gt; taken from the real map pin&lt;/li&gt;
&lt;li&gt;[ ] Weekly closed day left out of &lt;code&gt;openingHoursSpecification&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;[ ] Real &lt;code&gt;priceRange&lt;/code&gt; in ₹&lt;/li&gt;
&lt;li&gt;[ ] WhatsApp number in international format&lt;/li&gt;
&lt;li&gt;[ ] Passed the Rich Results Test&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you've done this for a family shop, I'd like to hear which field caused you the most trouble.&lt;/p&gt;

&lt;h2&gt;
  
  
  Further reading (2027)
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://dev.to/shoplocalnotes/shop-ko-google-par-kaise-dale-a-free-2027-guide-for-small-clothing-shops-3gm3"&gt;Shop ko Google par kaise dale? A free 2027 guide for small clothing shops&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://shoplocalnotes.wordpress.com/2026/10/25/what-is-frq-frq-in-questions-and-answers-about-indias-local-fashion-marketplace/" rel="noopener noreferrer"&gt;What is FRQ (frq.in)? 2027 questions and answers about the local fashion marketplace&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;(I help out with FRQ.)&lt;/p&gt;

</description>
      <category>webdev</category>
      <category>seo</category>
      <category>beginners</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
