# Branchen — opportunity list (keywords + data merge)

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

## Data sources

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

**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 `branchen-keyword-sistrix.json` + **live** `branchen-performance-gsc.json` (GSC Search Analytics API, last 90 days).

| Keyword | suggested_page_id | Volume (SISTRIX) | Competition (SISTRIX) | GSC_clicks (path) |
|--------|-------------------|------------------|------------------------|-------------------|
| Personalmanagement Software Branchen | branchen | 0 | 0 | 6 |
| Schichtplanung Gastronomie | gastronomie | 20 | 0 | 92 |
| Zeiterfassung Gastronomie | gastronomie | 70 | 27 | 92 |
| Personalmanagement Einzelhandel | einzelhandel | 0 | 0 | 3 |
| Schichtplanung Einzelhandel | einzelhandel | 0 | 0 | 3 |
| Schichtplanung Pflege | gesundheitswesen | 0 | 0 | 7 |
| Dienstplan Pflege | gesundheitswesen | 90 | 0 | 7 |
| Zeiterfassung Gesundheitswesen | gesundheitswesen | 10 | 0 | 7 |
| Schichtplanung Handwerk | handwerk-industrie | 0 | 0 | 0 |
| Zeiterfassung Industrie | handwerk-industrie | 20 | 24 | 0 |
| Personalplanung Veranstaltung | freizeit-kultur | 100 | 0 | 3 |
| Schichtplanung Event | freizeit-kultur | 0 | 0 | 3 |
| Schichtplanung Gastronomie Software | gastronomie | 0 | 0 | 92 |
| Dienstplan Software Restaurant | gastronomie | 0 | 0 | 92 |
| Lohnabrechnung Gastronomie Software | gastronomie | 0 | 0 | 92 |
| Abwesenheiten verwalten Einzelhandel | einzelhandel | 0 | 0 | 3 |

**Observations (90-day GSC snapshot):** `/branchen/gastronomie` leads portfolio clicks; `/branchen/einzelhandel` has weak position (~20) despite clicks; `/branchen/handwerk-industrie` has impressions but **0** clicks. Gastronomie live page: **`branchen_gastronomie_neu.php`**; **`/branchen/gastronomie-neu`** 301s to **`/branchen/gastronomie`** — kein separates `page_id`; Attribution weiterhin **`gastronomie`**.

## Related

- [BRANCHEN_SEO_IMPROVEMENT_BACKLOG.md](BRANCHEN_SEO_IMPROVEMENT_BACKLOG.md)  
- [DATA_COLLECTION_BRANCHEN.md](DATA_COLLECTION_BRANCHEN.md)