Member Avatar for KirovEli

Can someone help me with the script that will do such a thing?

  • 9 Contributors
  • 11 Replies
  • 375 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Arun_47
miller_4 commented: We have already bunch of tools to check SEO status +0

Dani AI

Generated

“SEO stats” covers a lot of different signals — backlinks and link authority, organic keywords and SERP positions, search impressions and clicks, site traffic and engagement, plus technical checks such as page speed and index coverage. Define the exact metrics required before coding. Several posters already raised the key tradeoffs: and noted that full backlink indexes (Ahrefs/SEMrush) are large commercial systems, and rightly observed that free, end‑to‑end scripts are uncommon.

Practical, phased blueprint to get useful results without rebuilding a vendor:

  1. Pick a minimal metric set to start (examples: Search Console impressions/clicks/avg position; Analytics sessions/pageviews; PageSpeed score; optional backlink count from a paid API).
  2. Confirm available data sources and API access (Google Search Console API, Google Analytics Data API/GA4, PageSpeed Insights API; vendor backlink APIs if needed).
  3. Implement an ETL in PHP: scheduled fetchers (cron), URL normalization, time‑stamped storage in a relational DB, daily aggregates and simple caching for the dashboard.

Implementation tips and common pitfalls: use OAuth 2.0 for Google APIs, respect API quotas with exponential backoff, be mindful of GA sampling on large queries, normalize canonical URLs to avoid duplicates, and honor robots.txt/robots meta if adding crawlers. Include cookie/consent handling to meet GDPR/CCPA. Reproducing an Ahrefs‑scale backlink graph requires enormous crawling infrastructure; for most projects, consuming vendor APIs is the pragmatic approach.

A realistic MVP is to wire Search Console + PageSpeed + Analytics for a 30‑day rolling view, surface top pages/queries and click/impression trends, flag major speed regressions, then add backlink depth later if needed. Echoing , document the manual steps first, then automate; and echoing , prefer proven APIs over reinventing the wheel for traffic metrics.

Recommended Answers

All 11 Replies

Member Avatar for Dani

What “seo stats” are you referring to? There are already sites such as Ahrefs that measure backlinks and sites like that are not simple scripts.

Member Avatar for nextsmm

There are many sites that you can use to check SEO, but I think there isn't free scripts for this case

commented: I am doing this for my uni. project +0
Member Avatar for rproffitt

Before you or anyone writes a script, you would describe in detail what said script would do. Or you would perform the work manually then automate it. Do you have the steps documented that you would then cast into code?

Member Avatar for Dani

Are you referring to Google’s API to get the stats? Please explain what stats you’re referring to. Keep in mind Google Pagerank is no longer a thing, and hasn’t been for many, many, many years.

Member Avatar for bijutoha

I'm using Ahrefs – it is a powerful but easy to check SEO stats for my site. They are doing such good things.

You can optimize your website, Analyze your competitors, Study what your customers are searching for, Learn from your industry's top-performing content, Track your ranking progress, and so on.

commented: They have a powerful free version too +36
Member Avatar for wwwalker

This is just analysis of statistics of hits on Website by page. Use any tool like Webalizer that does this.

From those statistical graphs or tables, person can see if SEO is achieving goal or not.

Member Avatar for Dani

What is just an analysis of traffic? Ahrefs? Ahrefs crawls the entire web to build a graph of backlinks to each page. It’s completely unrelated to traffic.

Member Avatar for Biiim

If I was doing it I would use Google Analytics but if you really need to do it manually for your project you basically have to set up a database with a programming language - like PHP - that writes into the database when a user does a specific action on the site. I used to do it a long time ago but there is no need with Google Analytics and such around now, safer as well due to GDPR and such things now.

Could be as simple as on each page put in the query "INSERT INTO page_opens (url,datetime) VALUES('index.php',NOW())"

You can even use Javascript to do even more specialised tracking, like image clicks or length of time on the page etc.

but like I said Google Analytics have done all this for you, why re-invent the wheel when they're offering a jet plane?

Member Avatar for miller_4

We have already a bunch of tools to check SEO status then what is the main purpose to build such a website

Member Avatar for Dani

Some of the existing tools have free APIs you can tap into. I would recommend writing an app that is fed in data from one of the existing APIs, interprets it, and spits out some conclusions.

Member Avatar for Arun_47

Hi,

To check SEO status, you can find a lot of Online free tools as well as Premiums Version as Such AHREFS or SEMRUSH. About script you mention, if you describe it better it will be really helpful to understand and reply back.

commented: Nice +0
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.