# Static / site pages — opportunity list (keywords + data merge)

**Last Updated:** 2026-04-02  
**Purpose:** Portfolio view of candidate keywords (SISTRIX) mapped to registry `page_id`, with GSC path clicks from live API export.

## Data sources

- **Registry:** [`../marketing-pages-registry.json`](../marketing-pages-registry.json)
- **Candidates:** [`../static-pages-candidate-keywords.json`](../static-pages-candidate-keywords.json)
- **SISTRIX (global batch):** [`../static-pages-keyword-sistrix.json`](../static-pages-keyword-sistrix.json) — `php v2/scripts/static-pages/collect-static-pages-keywords-sistrix.php`
- **GSC (live):** [`../static-pages-performance-gsc.json`](../static-pages-performance-gsc.json) — `php v2/scripts/static-pages/collect-static-pages-performance-gsc.php`
- **GA4 (live):** [`../static-pages-performance-ga4.json`](../static-pages-performance-ga4.json) — `php v2/scripts/static-pages/collect-static-pages-performance-ga4.php`
- **Merge table:** `php v2/scripts/static-pages/merge-static-opportunity-data.php`

**Note:** `GSC_clicks` matches the **canonical URL path** for `suggested_page_id` when present in GSC (last 90 days in export below). Keywords sharing the same URL show the same click total.

## Merged table (2026-04-02)

**Merged** from `static-pages-keyword-sistrix.json` + **live** `static-pages-performance-gsc.json` (GSC Search Analytics API, last 90 days).

| Keyword | suggested_page_id | Volume (SISTRIX) | Competition (SISTRIX) | GSC_clicks (path) |
|--------|-------------------|------------------|------------------------|-------------------|
| Personalsoftware | homepage | 250 | 42 | 16534 |
| HR Software Deutschland | homepage | 60 | 27 | 16534 |
| Workforce Management Software | homepage | 400 | 30 | 16534 |
| Personalsoftware Kosten | preise | 0 | 0 | 442 |
| HR Software Preise pro Mitarbeiter | preise | 0 | 0 | 442 |
| Zeiterfassung Software Preis | preise | 0 | 0 | 442 |
| Ordio Kunden | kunden | 0 | 0 | 33 |
| Personalsoftware Referenzen | kunden | 0 | 0 | 33 |
| Gastronomie Software Erfahrungen | kunden | 0 | 0 | 33 |
| Über Ordio | ueber-uns | 0 | 0 | 166 |
| Ordio Unternehmen | ueber-uns | 0 | 0 | 166 |
| HR Software Partnerprogramm | partner | 0 | 0 | 11 |
| Affiliate Partner Personalsoftware | partner | 0 | 0 | 11 |
| Demo Personalsoftware | demo-vereinbaren | 0 | 0 | 7 |
| Produktdemo vereinbaren | demo-vereinbaren | 0 | 0 | 7 |
| Ordio Demo | demo-vereinbaren | 0 | 0 | 7 |

Refresh: run `php v2/scripts/static-pages/merge-static-opportunity-data.php` and replace the table body.