Developer built 8,664 SEO pages, got 9 clicks in a month despite Google indexing them

·1 views

A developer running a tech interview prep site programmatically generated 8,664 individual pages, only to receive just 9 clicks over 28 days despite Google indexing 1,575 of them. Search Console data showed 6,511 impressions but a median ranking position of 58, effectively placing the pages on page six of search results where almost no users venture. The developer confirmed technical factors were not to blame, as pages were properly server-rendered, crawlable, canonicalised, and supported by valid sitemaps and structured data. The core issue identified was domain authority: pages targeting well-established terms were consistently outranked, while comparatively niche or unusual queries performed relatively better. The developer concluded that programmatic SEO on a new domain faces an authority ceiling that technical optimisation alone cannot overcome.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Three methods to automate prepaid API balance monitoring for fintech platforms

A developer working on a platform dependent on prepaid APIs — including SMS gateways and identity verification services — built three solutions after their manager requested balance checks three times daily. The options range from a manually updated Excel spreadsheet to a Python script with a cron job for full automation, and a semi-automated approach using Office Scripts combined with Power Automate. The article highlights common spreadsheet design mistakes, such as storing multiple balances in one cell or using wide column layouts, and recommends a structured row-per-service format with plain numeric values. Rather than fixed low-balance thresholds, the author suggests tracking days of remaining runway based on average daily spend. The guide uses African fintech APIs — Termii, Dojah, and Africa's Talking — as examples, but notes the approach applies to any service with a balance endpoint.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Automate Code Formatting at the Repository Level

Inconsistent code formatting across teams often stems from relying on individual developer IDE settings, which vary by editor, platform, and personal preference. A practical solution begins with locking down line endings using a .gitattributes file, preventing cross-platform issues that can corrupt commit histories or break scripts. Universal style rules can then be enforced project-wide through an .editorconfig file, ensuring the repository dictates formatting rather than each developer's local environment. Automated pre-commit hooks add a final enforcement layer, either fixing or rejecting non-compliant code before it ever reaches the shared codebase. The overall goal is to make formatting automatic and invisible, reducing team friction while maintaining a measurable baseline of code quality.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

HackCanton Season 2 Draws 360 Builders, Awards $10K Cash and 100K CC in Rewards

HackCanton Season 2 attracted over 360 builders from more than 60 countries, with 75-plus teams participating across the program's entry funnel. Of those, 30 projects advanced to judging and 18 teams pitched live at the Grand Final. The hackathon distributed $10,000 in cash, $25,200 in NaaS credits, and 100,000 CC through ecosystem challenges sponsored by BitSafe and OnRails. Winning submissions demonstrated substantive use of Canton's privacy, authorization, and settlement capabilities rather than superficial blockchain integration. The event generated a library of reusable Canton development patterns spanning institutional trading desks, tokenized funds, RWA products, and developer tooling.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

ARIMA, SARIMA, and Prophet Tested for Predicting CPU and Infrastructure Spikes

A developer built a predictive health check layer for infrastructure monitoring by testing three time-series forecasting models — ARIMA, SARIMA, and Facebook Prophet — against five real-world CPU and memory usage patterns. Prophet performed best at detecting gradual trends like slow memory leaks, while SARIMA excelled at forecasting predictable daily workday spikes when given proper seasonal configuration. All three models failed to reliably predict monthly spikes unless trained on years of historical data, as too few occurrences made it impossible to distinguish a pattern from a random anomaly. Completely random traffic bursts also defeated every model, with ARIMA and SARIMA prone to misreading sudden spikes as the start of a sustained upward trend. The findings suggest that no single model fits all infrastructure scenarios, and selecting the right forecasting tool depends heavily on the specific usage pattern being monitored.

0 comments Read more at DEV Community