<?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: Public Rows</title>
    <description>The latest articles on DEV Community by Public Rows (@publicrows).</description>
    <link>https://dev.to/publicrows</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%2F4254373%2Fdbd6a38f-ce8a-4250-9271-1c9f5977da3e.png</url>
      <title>DEV Community: Public Rows</title>
      <link>https://dev.to/publicrows</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/publicrows"/>
    <language>en</language>
    <item>
      <title>Google Trends for 1,000 keywords in one run, without getting blocked</title>
      <dc:creator>Public Rows</dc:creator>
      <pubDate>Thu, 19 Nov 2026 19:10:45 +0000</pubDate>
      <link>https://dev.to/publicrows/google-trends-for-1000-keywords-in-one-run-without-getting-blocked-1oob</link>
      <guid>https://dev.to/publicrows/google-trends-for-1000-keywords-in-one-run-without-getting-blocked-1oob</guid>
      <description>&lt;p&gt;Google Trends has no official API, the page takes five terms at a time, and every scraper of it spends half its life on 429 errors. This is the way I know to get the Trends numbers for a whole keyword list, as a CSV, from licensed data that does not break.&lt;/p&gt;

&lt;p&gt;Disclosure: I built the actor this uses. The data comes from Google Trends through the DataForSEO Keywords Data API under licence on every run; nothing is scraped.&lt;/p&gt;

&lt;h3&gt;
  
  
  What you get
&lt;/h3&gt;

&lt;p&gt;One row per keyword with the full interest-over-time series as JSON, plus &lt;code&gt;average_interest&lt;/code&gt;, &lt;code&gt;latest_interest&lt;/code&gt;, &lt;code&gt;peak_interest&lt;/code&gt; and &lt;code&gt;peak_date&lt;/code&gt;, a &lt;code&gt;trend_last_quarter_pct&lt;/code&gt; figure (the last quarter of the period against the rest) so a long list sorts without parsing the series, &lt;code&gt;interest_by_region&lt;/code&gt;, Google's related topics and related queries (top and rising), and the &lt;code&gt;google_trends_url&lt;/code&gt; that opens the same chart on Google.&lt;/p&gt;

&lt;p&gt;A real row from a live run (United States, web search, past 12 months):&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="nl"&gt;"keyword"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"air fryer"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"average_interest"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;66.15&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"latest_interest"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;55&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"peak_interest"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;100&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"peak_date"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"2026-04-12"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"trend_last_quarter_pct"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;-15.5&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"data_points"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;54&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Top regions for that row: Wyoming 100, New Hampshire 36, South Dakota 35. Top related queries: air fryer chicken 100, air fryer oven 70, air fryer ninja 64.&lt;/p&gt;

&lt;h3&gt;
  
  
  What it costs
&lt;/h3&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Item&lt;/th&gt;
&lt;th&gt;Price&lt;/th&gt;
&lt;th&gt;1,000 keywords&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Keywords&lt;/td&gt;
&lt;td&gt;$0.025 per keyword&lt;/td&gt;
&lt;td&gt;$25.00&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;First 3 keywords&lt;/td&gt;
&lt;td&gt;free&lt;/td&gt;
&lt;td&gt;−$0.08&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Total&lt;/td&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;about $25&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Billing happens on your Apify account. Apify's free plan includes $5 of monthly credit, which covers a first test of about 200 keywords; a three-keyword check costs nothing.&lt;/p&gt;

&lt;h3&gt;
  
  
  Steps
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;Open &lt;a href="https://apify.com/publicrows/google-trends-bulk" rel="noopener noreferrer"&gt;Google Trends Bulk&lt;/a&gt; on Apify and sign in or create a free Apify account.&lt;/li&gt;
&lt;li&gt;Paste your keywords into &lt;code&gt;keywords&lt;/code&gt;, one per line (commas work too), up to 1,000 per run. Duplicates are removed before anything is sent.&lt;/li&gt;
&lt;li&gt;Pick &lt;code&gt;location&lt;/code&gt; (a country, or Worldwide), &lt;code&gt;searchType&lt;/code&gt; (web, news, YouTube, images or Shopping) and &lt;code&gt;timeRange&lt;/code&gt; (7 days to since 2004).&lt;/li&gt;
&lt;li&gt;Leave &lt;code&gt;compare&lt;/code&gt; off to screen a list: every keyword is scaled on its own, so its best week is 100. Turn it on to compare up to five terms on one shared scale, exactly like adding terms on the Trends page.&lt;/li&gt;
&lt;li&gt;Press Start. Each keyword is one request to the supplier at about 100 a minute, so 1,000 keywords take about ten minutes.&lt;/li&gt;
&lt;li&gt;Download CSV, Excel or JSON from the Dataset tab, or schedule it weekly with the same list. It is also an MCP tool through mcp.apify.com if an agent should call it.&lt;/li&gt;
&lt;/ol&gt;

&lt;h3&gt;
  
  
  Things worth knowing
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Trends values are relative, 0 to 100, never absolute search counts. To size a keyword, pair this with search volume; to see where it is heading, use the trend and peak fields here.&lt;/li&gt;
&lt;li&gt;A rising query value of 5000 means +5,000% against the previous period. Google's rising lists are breakout terms and often look unrelated; the top lists are the dependable ones.&lt;/li&gt;
&lt;li&gt;Hourly points come back for the 7-day range, daily for 30 and 90 days, weekly for 12 months and 5 years, monthly since 2004 (web search only).&lt;/li&gt;
&lt;li&gt;If the supplier is unreachable the run waits and retries for several minutes; if it still gets nothing, it fails with the reason and you are not charged.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you try it and something feels off, open an issue on the actor page; I read them.&lt;/p&gt;

</description>
      <category>seo</category>
      <category>data</category>
      <category>tutorial</category>
      <category>apify</category>
    </item>
    <item>
      <title>Google search volume for 10,000 keywords for about $31.50, no code</title>
      <dc:creator>Public Rows</dc:creator>
      <pubDate>Thu, 19 Nov 2026 19:09:13 +0000</pubDate>
      <link>https://dev.to/publicrows/google-search-volume-for-10000-keywords-for-about-3150-no-code-2fl3</link>
      <guid>https://dev.to/publicrows/google-search-volume-for-10000-keywords-for-about-3150-no-code-2fl3</guid>
      <description>&lt;p&gt;Keyword Planner shows ranges unless you spend on ads, and most keyword tools cap exports. This is the fastest way I know to turn a long keyword list into exact Google Ads monthly volumes, CPC and competition, as a CSV, without writing code or opening a supplier account.&lt;/p&gt;

&lt;p&gt;Disclosure: I built the actor this uses. The data is Google Ads Keyword Planner data licensed from DataForSEO on every run; nothing is scraped.&lt;/p&gt;

&lt;h3&gt;
  
  
  What you get
&lt;/h3&gt;

&lt;p&gt;One row per keyword: &lt;code&gt;search_volume&lt;/code&gt; (monthly average), &lt;code&gt;cpc_usd&lt;/code&gt;, &lt;code&gt;competition&lt;/code&gt; and its 0–100 index, low and high top-of-page bids, the latest month's volume, the volume twelve months ago, and the full twelve-month history as JSON.&lt;/p&gt;

&lt;p&gt;A real row from a live run (United States, English):&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="nl"&gt;"keyword"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"gaming laptop"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"search_volume"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;301000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"cpc_usd"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;0.97&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"competition"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"HIGH"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"competition_index"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;100&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"low_top_of_page_bid_usd"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;0.37&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"high_top_of_page_bid_usd"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mf"&gt;2.09&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="nl"&gt;"latest_month"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"2026-08"&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  What it costs
&lt;/h3&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Item&lt;/th&gt;
&lt;th&gt;Price&lt;/th&gt;
&lt;th&gt;10,000 keywords&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Rows&lt;/td&gt;
&lt;td&gt;$0.003 per keyword&lt;/td&gt;
&lt;td&gt;$30.00&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Lookups (one per 1,000 keywords)&lt;/td&gt;
&lt;td&gt;$0.15 each&lt;/td&gt;
&lt;td&gt;$1.50&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;First 20 rows&lt;/td&gt;
&lt;td&gt;free&lt;/td&gt;
&lt;td&gt;−$0.06&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Total&lt;/td&gt;
&lt;td&gt;&lt;/td&gt;
&lt;td&gt;about $31.50&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Billing happens on your Apify account. Apify's free plan includes $5 of monthly credit, which covers a first test of about 1,600 keywords.&lt;/p&gt;

&lt;h3&gt;
  
  
  Steps
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;Open &lt;a href="https://apify.com/publicrows/keyword-search-volume" rel="noopener noreferrer"&gt;Keyword Search Volume &amp;amp; CPC&lt;/a&gt; on Apify and sign in or create a free Apify account.&lt;/li&gt;
&lt;li&gt;Paste your keywords into &lt;code&gt;keywords&lt;/code&gt;, one per line (commas work too). Up to 100,000 per run. Duplicates are removed before anything is sent.&lt;/li&gt;
&lt;li&gt;Pick &lt;code&gt;location&lt;/code&gt; (country) and &lt;code&gt;language&lt;/code&gt;. Volumes differ a lot by country: "laptop deals" is 60,500 a month in the United States and a different number in India.&lt;/li&gt;
&lt;li&gt;Leave &lt;code&gt;searchPartners&lt;/code&gt; off unless you want Google's partner network included.&lt;/li&gt;
&lt;li&gt;Set &lt;code&gt;maxItems&lt;/code&gt; to your list size and press Start. 10,000 keywords take a few minutes; the actor sends 1,000 per request and waits politely between them.&lt;/li&gt;
&lt;li&gt;When the run finishes, open the Dataset tab and download CSV, Excel or JSON. Or call it from code: the run URL and an API snippet are on the actor page, and it is also an MCP tool through mcp.apify.com if an agent should call it.&lt;/li&gt;
&lt;/ol&gt;

&lt;h3&gt;
  
  
  Things worth knowing
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Google returns null CPC and bids where nobody advertises on a keyword. The volume is still there.&lt;/li&gt;
&lt;li&gt;Keywords longer than 80 characters are dropped before sending because Google rejects them and would fail the whole batch.&lt;/li&gt;
&lt;li&gt;If the supplier is unreachable the run waits and retries for several minutes; if it still gets nothing, it fails with the reason and you are not charged.&lt;/li&gt;
&lt;li&gt;You can bring your own DataForSEO credentials in the two optional inputs if you prefer the supplier charge on your own account; the row price stays the same.&lt;/li&gt;
&lt;li&gt;The output is gated before you see it (row volume, required fields, duplicates), and a live canary runs the actor every night.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you try it and something feels off, open an issue on the actor page; I read them.&lt;/p&gt;

</description>
      <category>seo</category>
      <category>tutorial</category>
      <category>data</category>
      <category>apify</category>
    </item>
  </channel>
</rss>
