My HR Website Project Story

How does Personal SEO Dashboard work?

The Google Search Console (formerly called Google Webmasters) is an excellent tool that shows pretty accurately how the web works in terms of Google search. What keywords are showing up in the search results, what keywords were also clicked on, what they were ranked for, and lots of other useful information.

Unfortunately, it’s a bit hard to work with, so I wrote a Personal SEO Dashboard to get the data in a form that suits me perfectly. I like to keep everything under control, but I’m not a control freak after all. I just like to own my data.

I like to be able to look at data across keywords, across pages, or combine it in different ways. I’m happy to be advised on what pages and words I should be looking at to take me one step further towards my goal.

It’s actually a pretty simple idea, I’ve just enriched Google’s original suggestion a bit with a few small tweaks of my own:

  1. For each keyword, text and image searches are side by side
  2. I calculate the ranking for the keyword so I know immediately which weighting category it belongs to
  3. I don’t limit the export to 1,000 lines
  4. I primarily look at data across days, keywords and pages
  5. I add a few reports to discover promising keywords and pages
  6. I compare the present and the past to see if I’m moving forward
  7. With a little SQL, I can handle anything when I need to

The principle is simple:

  1. The server runs a PHP application that downloads the latest available data once a day.
  2. It creates a list of pages and new keywords
  3. Calculates statistics for all available keywords
  4. Calculates traffic for the last day, last week, last four weeks and last year
  5. And you can browse all this in the browser
  6. And if there is more interest, just click and the table is exported to Microsoft Excel

What is needed?

  1. A computer that can run a web server (Linux, MacOS, Windows)
  2. A Google Search Console account and allow the application to access it (it’s easy)
  3. Apache, MariaDB and PHP (version 8 is best)
  4. Know how to do a bit with a terminal
  5. Know how to set up a cron table
  6. A little time to debug
  7. And then just wait for the first calculations (it takes a while to process 90 days)