organic-search-analytics
organic-search-analytics copied to clipboard
Import organic search analytics from Google Search Analytics (Google Webmaster Tools) and save to a MySQL database
Google Search Console offers a way to compare performance over 2 time periods, and this can be very useful for measuring the impact of SEO campaigns. The main issue with...
I run the data capture daily on a cPanel/LiteSpeed/PHP7.1 server. For each domain, I see these two warnings in error_log: [12-Jun-2017 14:00:50 UTC] PHP Notice: Undefined index: DOCUMENT_ROOT in /inc/code/globalIncludes.php...
Once zero had been saved for some dates, the data capture script tries to retrieve them over and over again. Even for the dates older than 90 days. Those data...
Specially important for handling large amounts of rows in `search_analytics`. Definitely index for `date`, maybe another combined for `date`, `domain` and `search_engine` for queries such as (`inc/code/dataCapture.php`): ``` $query =...
Add data filters to allow for viewing only important/actionable data using greater than, less than, equals operators. Example: - Impressions > 100 - CTR < 20%
The upgrade script is very error prone: https://github.com/PromInc/organic-search-analytics/blob/master/organic-search-analytics/upgrade.php as it always returns: ``` $alert = array("type"=>"success", "message"=>"Upgrade performed succesfully."); ``` even when error was encountered in the MySQL query. This...
After upgrading both the codebase and the database (step after step from 2.4.3), the saved quick links reports don't work. They just show "No records found". Also, any other tries...
All domains show 0 imported records for each day, eve that I know it was importing correctly before upgrade to 2.5.0 / 2.5.1 and that data exists (as verified in...
GoogleAPI startRow/paging support: GoogleAPI supports startRow to page through >5000 results. Thats implemented and can be configered in config/config.php Class Config const downloadGoogleMaxPages = 99; Data capture via CLI/Cronjob was...
Offer CSV (or others, but CSV is generally acceptable) an export of the data shown in the report to download