Serpmax CSV Exporter

Export technical audits from Serpmax.ru to a CSV file that opens correctly in Microsoft Excel.

⚠️ Availability notice: Serpmax is currently available for Russian users only. Payments are processed in RUB via Russian payment systems. API access is available on paid plans. 🌐 English version of the website: serpmax.ru/en

🇷🇺 Документация на русском

---

Requirements

• Python 3.10+
• requests 2.28+
• Serpmax API key — serpmax.ru/en/account-api

---

Installation

cd serpmax_exporter
pip install -r requirements.txt

---

Configuration

Open exporter.py and fill in the settings:

SERPMAX_API_KEY = "YOUR_SERPMAX_API_KEY"
OUTPUT_FILE     = "serpmax_report.csv"

---

Usage

python exporter.py

If your account has more than 100 audits, the script will prompt you:

Found 651 audits (7 pages)

What to export?
  [1] First 100 only (fast)
  [2] All 651 audits (fetches all pages)

Your choice [1/2]:

After completion, serpmax_report.csv will appear in the same folder.

---

CSV Columns

Column	Description
Audit ID	Unique audit identifier
Website URL	Audited URL
Score	Overall score 0–100
TTFB (ms)	Time To First Byte in milliseconds
Response time (ms)	Full server response time
Page size (KB)	Size of the loaded page
Critical issues	Number of major issues
Moderate issues	Number of moderate issues

---

Why It Opens Correctly in Excel

• utf-8-sig encoding adds a BOM marker — Excel auto-detects the encoding and displays Cyrillic correctly
• ; delimiter — standard for Russian locale Excel (unlike English locale which uses ,)

---

Project Structure

serpmax_exporter/
├── exporter.py         # Main export script
├── serpmax_client.py   # Serpmax Python SDK
├── requirements.txt
└── README.md

---

License

MIT