RANKING TOOL  -  http://localhost/ranking-tool/ranking-tool_1/

Everything lives in C:\wamp64\www\ranking-tool\ranking-tool_1:
  csv\       month folders to import (sep-2026, oct-2026, ...) -> keywords_permanent
  exports\   exported CSV / Excel files
  logs\      import logs
  storage\   uploaded files

Pages (menu at the top of every page):
  index.php       Home - totals + links
  import.php      Import the csv folder (csv\sep-2026, csv\oct-2026, ...) into keywords_permanent.
                  Upload a new month -> keywords_temporary (the table is emptied on every upload).
  compare.php     Compare the latest data in keywords_temporary with any month of keywords_permanent:
                  per website, or keyword by keyword
                  Declined / Lost / Improved / Same / New / N/A
  manipulate.php  Run page_wise / rank_wise / improvement (all websites or one), see declining websites,
                  edit ranks manually -> stored in export_table
  export.php      Export CSV / Excel (all websites or one) to
                  exports\<Month Year>\Ranking <Month Year>\<site>\<site>.csv|xlsx, and Save to permanent

Tables are created automatically on first visit (database name in config.php).
Tables: keywords_temporary, keywords_permanent, export_table.
keyword_type (all tables): main = keywords above the blank row of the sheet, location = keywords below it.
Exports keep the same layout: main keywords, one blank row, location keywords.

Upload (import.php): drag & drop .csv / .xlsx / .zip. Files are sent in small parts, so the php.ini
upload limit (2M / 8M) does not matter. One csv/xlsx -> asks month + website. Zip -> month/website from folders.
Logs: ranking-tool_1\logs\not_imported_<date>.log lists every file that was NOT imported (and why);
      ranking-tool_1\logs\not_imported_all.log keeps all of them.
