Substack Trending vs Google Trends live ranks

A Substack vs Google Trends comparison on Trends MCP is two get_top_trends calls: type Substack and type Google Trends. From the August 26, 2026 pull, both boards stamped 2026-08-26T14:01:28 UTC. Substack returned 50 titles at offset 0 and 48 at offset 50, then count 0 at offset 98, for a closed board of 98. Google Trends returned 50 rows at offsets 0, 50, 100, and 150, filling ranks 1 through 200, then count 0 at offset 200. Substack rank 1 was Spencer Pratt. Google Trends rank 1 was dolly parton. Zero exact titles overlapped in 98 versus 200. google search for Spencer Pratt sat at 1.0 on 2026-08-22. Free tier access is 100 requests per month.

What Substack vs Google Trends data shows right now

From the Trends MCP scan of August 26, 2026, Substack and Google Trends both stamped 2026-08-26T14:01:28 UTC, Substack closed at 98 rows, and Google Trends filled 200, so a default limit 25 join misses every Google query after 25 and every Substack title after the first page.

Substack ranks 11 through 20 included @lizleatrice at 11, Matt Calkins at 12, Johanna Bradford at 13, Unhappy Place at 20, and Document Zero at 31. Google Trends ranks 11 through 15 were hawk fire, bitcoin price, xrp price, btc price, and meghan markle. save america sat at Google Trends rank 45 with no matching Substack title in the 98.

Same-stamp Substack by Category splits against overall 98:

Technology 25 had zero titles in overall 98. Sports returned three overall hits in the first 12 Sports rows and missed Eddie Pepperell's Substack at Sports rank 2. News rank 1 and rank 7 were absent from overall 98, and Document Zero at overall 31 did not appear in News 25.

How to pull both boards in one account

Two get_top_trends calls against the same Trends MCP key return Substack and Google Trends as separate ranked lists, and REST mode get_top_trends bills each type and each page as its own request, so paginating Substack to offset 98 plus Google Trends through offset 200 is six requests before any get_growth follow-up.

{"mode": "get_top_trends", "type": "Substack", "limit": 50, "offset": 0}
{"mode": "get_top_trends", "type": "Google Trends", "limit": 50, "offset": 0}

MCP clients send the same fields on get_top_trends. Substack on this stamp filled 50, then 48, then 0. Google Trends filled 50 four times, then 0 at offset 200. The Substack Trending API page documents the 98-row close. The Google Trends Trending Now API page documents the 200-row fill. Offset and limit behavior for both feeds is on get_top_trends pagination.

A third call with type Substack by Category and category set to Technology, Sports, or News is a separate request. Official category names are listed on the data sources page. Do not assume the overall board is a mix of those category leaders. On this stamp it was not.

Which Substack titles match Google queries

Exact lowercase title matching on Substack 98 versus Google Trends 200 returned zero shared strings, and the only token collisions were false friends such as mark, bradford, food, and left, so a production join has to use a newsletter-specific alias table rather than substring matching.

Google Trends rank 1 dolly parton had no Substack counterpart in 98. Substack rank 1 Spencer Pratt had no Google Trends counterpart in 200. save america at Google rank 45 is the same query that joins Pod Save America on the Spotify board; it did not join any Substack title here. crypto daily at Google rank 188 also missed the 98.

google search follow-ups on the same names

get_growth on google search and youtube turns a live rank into a dated 0-100 index, and those indexes on this stamp did not move with Substack rank: Spencer Pratt held Substack 1 at google search 1.0, while Callie Coles at Substack 6 sat at 46.0.

Shared recent_date 2026-08-22:

Spencer Pratt 3M google search sat at 1.0 versus 31.0 on 2026-05-23, a 96.77% drop. The Daily Beast google search carried estimated volume 159,000 on 2026-08-22 versus 156,000 on 2026-08-15. Pirate Wires 30D and Bernie Miklasz 30D both had baseline_value 0.0; the API can emit a 999999.0 percent on that shape, so the page quotes the two indexes instead. The Blue Star Bulletin google search returned data_quality low with over 90% zeros, so that series is omitted.

Where the Substack-Google join stops

Substack rows are newsletter display names with no subscriber counts, and Google Trends rows are search queries with no newsletter identity, so the join is a string match across two different objects, and this stamp shows why a limit 25 client never sees that mismatch.

Substack closed at 98. Google Trends closed at 200. Exact overlap was 0. Technology category leaders such as Marcus on AI, SemiAnalysis, and Pirate Wires sat outside the overall 98 while still returning 25 rows on Substack by Category. News leaders such as The Wright Report and The Daily Beast did the same. A client that only reads overall Substack rank 1 through 25 never sees those category boards and never sees Google Trends ranks 26 through 200, including bitcoin price at 12 (inside 25) versus crypto daily at 188 (outside 25).

get_growth does not accept a live-board type. Follow-ups use keyword sources such as google search or youtube. wikipedia 7D often collapses to one monthly point; this page used google search and youtube instead. Free covers 100 requests per month. Starter is $19 for 1,000. Check current pricing before locking a production budget.