# WriteAIBook KDP Catalog Study

**540 Amazon KDP titles. €30,702 lifetime royalties. €33.62 median per title. One publisher account, de-identified.**

This is the full dataset behind WriteAIBook's 350-book case study, extended to the complete catalog through **19 April 2026**. It contains 540 book-level rows, 16 months of revenue, 23 publication cohorts, and a finding that contradicts the usual "publish more" advice: revenue per catalog book fell 75% as the catalog grew.

- **Rows:** 540 titles (524 AI-era releases from March 2025 onward; 16 legacy titles from 2019–2022)
- **Lifetime royalties:** €30,702.00
- **Last 90 days:** €6,251.85
- **Median lifetime per title:** €33.62 (mean €56.86)
- **Winners:** 34 titles (6.3%) earned more than €30 in the last 90 days
- **Dead:** 121 titles (22.4%) earned less than €2 in the last 90 days
- **Concentration:** the top 25 titles produced 20.9% of last-90-day revenue
- **Cohort decline:** median first-month revenue fell from €13.80 (July 2025) to €4.10–€5.70 (November 2025–March 2026). Lifetime hit rate above €50 is 66.7% for July 2025 vs 6.7% for November 2025–April 2026 as of the cut; the later cohorts are younger, so the first-month median is the fair comparison
- **Efficiency:** €16.51 revenue per catalog book in July 2025, €4.14 in March 2026

**This is not a random sample of Amazon KDP.** It is one publisher's catalog, primarily Amazon.de. Do not use it to estimate the average KDP author's earnings.

## Files

| File | Rows | What it contains |
|---|---:|---|
| `catalog_books.csv` | 540 | One row per de-identified title: anonymous book and pen IDs, era, cohort, status, lifetime and last-90-day revenue |
| `monthly.csv` | 16 | Monthly royalties, active books, catalog size and revenue per catalog book, 2025-01 to 2026-04 |
| `cohorts.csv` | 23 | Books, lifetime revenue, median revenue, first-month median and hit rates by publication month |
| `pennames.csv` | 8 | Anonymous pen-name clusters; no names |
| `status.csv` | 5 | Status definitions and counts |
| `revenue_bands.csv` | 6 | Distribution of titles by lifetime revenue band |
| `summary.json` | 1 object | Recomputed headline metrics, including the corrections |
| `datapackage.json` | 1 object | Machine-readable schema, license and resource list |
| `checksums.sha256` | 12 lines | SHA-256 hashes for every data and documentation file |
| `METHODOLOGY.md` | — | Source, definitions, reconciliation and limitations |
| `DATA_DICTIONARY.md` | — | Field-by-field documentation |
| `LICENSE.md` | — | CC BY 4.0 terms and attribution |

The ZIP bundle contains all of the above.

## What is not in the data

Titles, ASINs and pen names are **not** included. Book IDs are assigned after sorting by cohort, pen and ASIN; the mapping is not published. Pen-name Unicode variants are merged and replaced with anonymous IDs. The private source workbook is not redistributed.

Genre, ad spend, production cost, page reads by title, and profit are not included. Revenue is gross royalties, not profit.

## Reproduce the public files

The builder reads the private `KDP_Analysis.xlsx` workbook and refuses to write if the totals do not reconcile. It requires `openpyxl`; the DSH bundled Python has it.

```bash
python research/kdp_book_study/build_dataset.py \
  --source "$HOME/Downloads/KDP_Analysis.xlsx" \
  --data-dir src/static/data/kdp-book-study \
  --page src/static/research/kdp-book-study.html
```

Do **not** commit `KDP_Analysis.xlsx`, `source/`, or any file containing titles, ASINs or pen names. The public builder writes only de-identified outputs.

## Publishing

These are static files; a normal reviewed release ships them. No database or runtime job is involved. After a deploy, verify:

- `https://writeaibook.com/research/kdp-book-study` returns 200 and the canonical URL.
- `/data/kdp-book-study/catalog_books.csv` and the ZIP download with the expected size.
- `python research/kdp_book_study/verify_live.py` returns zero errors (page, downloads, schema, sitemap, hashes).
- `summary.json`, `datapackage.json`, `METHODOLOGY.md`, `DATA_DICTIONARY.md` and `LICENSE.md` all return 200.
- The sitemap contains the study URL and `scripts/refresh_sitemap.py --check` passes.
- The page is indexable (no `noindex`) and the Dataset/FAQ JSON-LD parses.

Do not deploy until the release has been reviewed. The dataset page is customer-facing and the raw source workbook must never be included in the release.

## License and citation

Data: [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/). Credit WriteAIBook and link to <https://writeaibook.com/research/kdp-book-study>.

```text
WriteAIBook. (2026). WriteAIBook KDP Catalog Study: 540 Titles From an AI-Assisted Catalog
[Data set]. https://writeaibook.com/research/kdp-book-study. CC BY 4.0.
```

## Corrections

This release supersedes earlier posts that cited 350 books and roughly €18,000 for the first six months. Those were mid-experiment snapshots. A summary-sheet peak of €3,825 for September 2025 is inconsistent with the monthly table's €3,671; this release uses €3,671. See `METHODOLOGY.md` for the reconciliation.

## Contact

Corrections, questions or reuse: <support@writeaibook.com>.
