Skip to content
Open source excel or libreoffice and PHP SEO google position SERP checker to track and follow a few website's keywords positions https://dev.piedweb.com
PHP
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
.gitattributes
.gitignore
.scrutinizer.yml
.travis.yml
LICENSE
README.md
composer.json
kw.ods
phpunit.xml.dist
scrap.php

README.md

Open Source Package

Google Spreadsheet Seo Scraper

Latest Version Software License Build Status Quality Score Code Coverage Total Downloads

Open source excel or libreoffice and PHP SEO google position SERP checker to track and follow a few website's keywords positions.

Homepage : https://piedweb.com/seo/serp

Requirements

You need to know how to open execute a command on a CLI.

You need PHP, CURL, composer, unoconv and libreoffice on your computer.

No direct support (maybe by a peer), use it as you can or look my prices.

Install

Via Packagist

$ # create the folder where you will install the soft
$ mkdir gs3 && cd gs3
$ # install the lib via composer
$ composer require piedweb/google-spreadsheet-seo-scraper
$ # create a link to the executable
$ ln -s vendor/piedweb/google-spreadsheet-seo-scraper/scrap.php console && chmod +x console

Usage

$ gs3/console
    --ods path/to/myfile.ods
    --domain host.tld

Facultative args

--proxy ip:port:username:pass (without proxy, you can check between 20 and 50 kw)
--cache /my/cache/folder/for/google/result (plain html)
--num   100 (default, correspond to google num arg)
--page  1 (default, number of results's page to crawl')
--sleep 60 (default, time to wait in seconds between to request on google)
--quiet

Examples

$ php scrap.php --ods "/home/session/project/piedweb.com/seo/kw.ods" --domain piedweb.com

$ php scrap.php --ods "/home/session/project/piedweb.com/seo/kw.ods" --domain piedweb.com,piedweb.fr

$ php scrap.php --ods "/home/session/project/piedweb.com/seo/kw.ods" --domain "you can set it directly in your ods file for each row"

☯ Without proxy, I use it for a dozen of keywords.

About kw.ods

Seule les colonnes jusqu'à J sont importantes. Il est possible d'archiver autant de données que voulues dans les colonnes suivantes à condition de ne pas avoir deux colonnes portant le même nom. le doc peut être agrémenter de plusieurs feuilles à condition que la feuille par défaut reste la première.

L'importance est un indicateur subjectif entre 1 et 10 couplant le volume du mot clef et la capacité estimée de transformer un internaute utilisant ce mot clef. Robin Delattre

Debugging tendance formula

=IF(J6="";"";                   // Si prev_pos est vide alors rien
    IF (J6="FAILED";"";            // Si prev_pos a échoué, alors rien
        IF(H6="FAILED";"";              // Si pos a échoué alors rien
             IF(H6="";"";                   // Si pos est vide alors rien
                IF(H6=-1;"x";                   // si kw n'est pas position, alors x
                    IF (H6=J6;"=";
                        IF(H6<J6;"+";
                            IF(J6=-1;"+";"-")
                        )
                    )
                )
            )
        )
    )
)

Legend for tendance

+ : le site grimpe vers la meilleur position
- : le site descend
x : le site n'est pas possitionnent
  : aucun résultat à analyser

Credits

License

The MIT License (MIT). Please see License File for more information.

Latest Version Software License Build Status Quality Score Code Coverage Total Downloads

You can’t perform that action at this time.