# Data Exports Summary: International Expansion Research (2026-03-08)

## Overview

All research data has been compiled and exported for Notion upload. This document lists all available data files, reports, and exports.

---

## CSV Exports (Ready for Notion Upload)

### Traffic Data
- **`gsc-traffic-by-country.csv`** - GSC traffic data for all non-DACH countries
  - Columns: Country Code, Country Name, Clicks, Impressions, CTR
  - Sorted by clicks (descending)
  - Includes top 20+ countries

### Keyword Research
- **`keywords-all-markets.csv`** - All keyword research data across all markets
  - Columns: Market, Keyword, Monthly Volume, Difficulty, CPC, Competition
  - Includes UK, Netherlands, and France keywords
  - Combined from all keyword research files

---

## JSON Data Files (Available for Notion Upload)

### Traffic Data
- **`gsc-by-country.json`** - Complete GSC traffic data by country (rolling `--days`; `exported_at` + paginated `country` dimension)
- **`ga4-by-country.json`** - GA4 sessions and screen page views by country (90 days; aggregated from pagePath×country API rows; see `_collection` in file)

### Keyword Research
- **`keywords-gb.json`** - UK keyword research (25 keywords)
- **`keywords-nl.json`** - Netherlands keyword research (25 keywords)
- **`keywords-fr.json`** - France keyword research (25 keywords)
- **`long-tail-keywords-gb.json`** - UK long-tail keyword research (0 results - API limitation)
- **`long-tail-keywords-nl.json`** - Netherlands long-tail keyword research (0 results - API limitation)
- **`long-tail-keywords-fr.json`** - France long-tail keyword research (0 results - API limitation)

### Competitor Analysis
- **`competitor-keywords-gb-deputy-com.json`** - Deputy keyword rankings analysis (UK)
- **`competitor-keywords-nl-roosterplaats-nl.json`** - Roosterplaats keyword rankings analysis (Netherlands)
- **`competitor-keywords-fr-skello-io.json`** - Skello keyword rankings analysis (France)

### Other Data
- **`sistrix-credits-log.json`** - SISTRIX API credits usage log
- **`hubspot-contacts-by-country.json`** - HubSpot contact analysis framework

---

## Markdown Reports (Ready for Notion)

### Analysis Reports
1. **`TRAFFIC_ANALYSIS.md`** - Expanded traffic analysis (top 20+ countries, CTR patterns, growth signals)
2. **`KEYWORD_RESEARCH_REPORT.md`** - Initial keyword research findings
3. **`COMPREHENSIVE_KEYWORD_REPORT.md`** - Complete keyword research compilation (primary + expanded)
4. **`SERP_ANALYSIS.md`** - Original SERP competition analysis
5. **`SERP_PAA_ANALYSIS.md`** - SERP and PAA analysis (15 queries across 3 markets)
6. **`COMPETITOR_INTELLIGENCE_REPORT.md`** - Complete competitor intelligence (Personio, Factorial, Planday, TimeTac)
7. **`MARKET_PRIORITIZATION.md`** - Data-driven market prioritization recommendation
8. **`LONG_TAIL_KEYWORD_RESEARCH.md`** - Long-tail keyword research findings and limitations
9. **`HUBSPOT_ANALYSIS.md`** - HubSpot contact analysis framework

---

## Research Scripts Created

1. **`fetch-international-traffic-data.php`** - Collects GSC/GA4 data by country
2. **`research-keywords-sistrix.php`** - Keyword research with country parameter support
3. **`research-long-tail-keywords-sistrix.php`** - Long-tail keyword research using marketplace.keyword.search.ideas
4. **`analyze-competitor-keywords-sistrix.php`** - Competitor keyword ranking analysis
5. **`analyze-hubspot-contacts-by-country.php`** - HubSpot contact analysis by country

---

## Notion Upload Instructions

### Recommended Structure

**Main Page:**
- Upload strategic plan document (already formatted for Notion)
- Include key data tables directly in plan

**Sub-Pages:**

1. **Traffic Analysis**
   - Upload: `TRAFFIC_ANALYSIS.md`
   - Attach: `gsc-traffic-by-country.csv`

2. **Keyword Research**
   - Upload: `COMPREHENSIVE_KEYWORD_REPORT.md`
   - Attach: `keywords-all-markets.csv`
   - Upload: `LONG_TAIL_KEYWORD_RESEARCH.md` (for context on limitations)

3. **SERP & Competition**
   - Upload: `SERP_PAA_ANALYSIS.md`
   - Upload: `COMPETITOR_INTELLIGENCE_REPORT.md`

4. **Market Prioritization**
   - Upload: `MARKET_PRIORITIZATION.md`

5. **Data Files (Optional)**
   - Attach JSON files if detailed data review needed
   - Most data is summarized in reports

---

## Key Findings Summary

### Traffic
- **Total non-DACH traffic:** 1,656 clicks (2.1% of total)
- **Top markets:** Netherlands (154), Spain (147), France (131), UK (101)
- **UK opportunity:** 48,301 impressions but only 0.21% CTR - massive opportunity

### Keywords
- **UK:** ~2,780 monthly searches (highest volume)
- **Netherlands:** ~2,440 monthly searches (very high CPCs)
- **France:** ~320 monthly searches (data limitations)

### Market Prioritization
1. **UK/Ireland** (Priority 1) - Largest market, language advantage
2. **Netherlands** (Priority 2) - Strong existing traffic, high CPCs
3. **France** (Priority 3) - High CTR, needs additional research

---

**Last Updated:** 2026-03-15
**All Research Tasks:** Complete