# Coloring book trends aggregate tables, November 6, 2026 capture compared with October 29

Version 1.0, generated November 12, 2026. Published by ColorBliss with the report [Christmas gains ground on Amazon's coloring-book charts](https://colorbliss.com/research/coloring-book-trends/2026-11-06) (published November 7, 2026).

These tables support ColorBliss's November 6, 2026 report, which compares a November 6 capture of 24 Amazon US lists with the October 29 capture, eight calendar days earlier.

## Files

| File | Contents | Rows |
| --- | --- | --- |
| [lists.csv](lists.csv) | One row per Amazon list per capture (24 lists × 2 dates): positions, prices, price bands, title wording matches and same-list turnover. | 48 |
| [summary.csv](summary.csv) | Edition-level figures for October 29 and November 6: wording matches by scope and counting unit, price bands, median price, list overlap and same-list turnover. | 146 |

Files are UTF-8 CSV with a header row. Blank cells mean not applicable or not available, never zero.

## Dates

- Capture dates: October 29, 2026 and November 6, 2026 (America/New_York).
- Comparison: November 6, 2026 compared with October 29, 2026.
- Report published: November 7, 2026. Cite the publication date; use capture dates when describing what the lists showed.

## What is counted

- A **chart position** (`chart_position`) is one rank on one list on one capture date. A listing on three lists counts as three positions.
- A **distinct listing** (`distinct_listing`) is one Amazon product ID (ASIN), counted once within the stated scope.
- A **distinct credit name** (`distinct_credit_name`) counts displayed author or creator names without disclosing them. These standalone totals have no denominator or share.
- Other counts in summary.csv have their denominator in the same counting unit. Shares are count / denominator.

## Sampling

- Each capture holds the top 30 positions on 24 Amazon.com lists: Best Sellers and Hot New Releases for 12 categories (Children's Coloring Books, Coloring Books for Grown-Ups and 10 of its subcategories). That is 720 positions per capture date.
- Capture dates are America/New_York calendar dates. captured_at_utc in lists.csv gives the exact time of each list; an evening Eastern capture carries the next UTC date.
- Each list is counted as Amazon displayed it. No lists, ranks or listings were dropped or replaced.
- The November 6 lists were captured from about 3:52 to 3:54 p.m. Eastern; the October 29 lists from about 11:14 to 11:16 p.m. Eastern. The captures are eight calendar days apart, not a same-time seven-day panel.

## Methodology

- Wording groups are case-insensitive whole-word regular expressions applied to the displayed title. Related forms are not matched unless listed: "relaxation" does not match the whole word "relax".
- Price bands use displayed prices: under $5.00, $5.00 to $9.99, $10.00 to $14.99, and $15.00 or more.
- Same-list turnover compares each list with the same list at the comparison capture. A position counts as absent when its ASIN was not in that list's earlier top 30. The book may have ranked below 30 or appeared on another list, and absence does not establish a publication date.
- Distinct-listing counts treat an ASIN as matching when its title matches in any observation within the scope.
- This edition's seasonal groups are Christmas or Xmas (whole words) and Halloween (whole word). The October 29 rows here use these rules, so the October 29 Christmas counts can differ from the October 29 report, which matched Christmas only.

## Data dictionary

### lists.csv

| Field | Definition |
| --- | --- |
| `capture_date` | Capture date of this row (YYYY-MM-DD, America/New_York). |
| `capture_role` | edition for this report's capture; comparison for the earlier capture the report compares against. |
| `source_id` | ColorBliss identifier for the Amazon US list: amazon-com-<category node ID>-<list type>. |
| `category` | Amazon category name shown on the list. |
| `list_type` | best-sellers (Amazon Best Sellers) or hot-new-releases (Amazon Hot New Releases). |
| `captured_at_utc` | When ColorBliss captured this list, as an ISO 8601 UTC timestamp. It can fall on the next UTC day after capture_date. |
| `positions_sampled` | Chart positions recorded on this list (the top 30). |
| `distinct_listings` | Distinct Amazon product listings (ASINs) among those positions. |
| `coloring_labelled_positions` | Positions whose listing ColorBliss labels a coloring book because its title contains "color" or "colour". A title rule, not a review of the interior. |
| `paperback_positions` | Positions whose displayed format is Paperback. |
| `priced_positions` | Positions with a displayed price. |
| `unpriced_positions` | Positions with no displayed price. Missing prices are never imputed or treated as zero. |
| `median_displayed_price_usd` | Median displayed price across this list's priced positions, in US dollars. Capture-time displayed price, not a transaction price. |
| `price_under_5_positions` | Priced positions with a displayed price under $5.00. |
| `price_5_to_9_99_positions` | Priced positions with a displayed price from $5 to $9.99. |
| `price_10_to_14_99_positions` | Priced positions with a displayed price from $10 to $14.99. |
| `price_15_and_up_positions` | Priced positions with a displayed price of $15.00 or more. |
| `christmas_xmas_positions` | Positions whose displayed title matches Christmas / Xmas (case-insensitive whole words: /\b(?:christmas\|xmas)\b/i). |
| `halloween_positions` | Positions whose displayed title matches Halloween (case-insensitive whole words: /\bhalloween\b/i). |
| `cozy_cosy_hygge_positions` | Positions whose displayed title matches Cozy / cosy / hygge (case-insensitive whole words: /\b(?:cozy\|cosy\|hygge)\b/i). |
| `cute_cuties_kawaii_positions` | Positions whose displayed title matches Cute / cuties / kawaii (case-insensitive whole words: /\b(?:cute\|cuties\|kawaii)\b/i). |
| `bold_easy_positions` | Positions whose displayed title matches Bold / easy (case-insensitive whole words: /\b(?:bold\|easy)\b/i). |
| `relax_stress_calm_anxiety_mindful_positions` | Positions whose displayed title matches Relax / stress / calm / anxiety / mindful (case-insensitive whole words: /\b(?:relax\|stress\|calm\|anxiety\|mindful(?:ness)?)\b/i). |
| `positions_absent_from_comparison_list` | Positions on this list held by a listing that was not in the same list's top 30 at the comparison capture. Blank on comparison rows. Absence does not mean a book is newly published. |

### summary.csv

| Field | Definition |
| --- | --- |
| `metric` | Machine-readable metric name. The README lists every metric. |
| `capture_date` | Capture date the value describes (YYYY-MM-DD, America/New_York). |
| `comparison_date` | Earlier capture date for change metrics such as same-list turnover. Blank otherwise. |
| `scope` | Which lists, or which subset of positions, the value covers. |
| `counting_unit` | chart_position counts every rank on every list, so a listing on three lists counts three times; distinct_listing counts each Amazon listing (ASIN) once within the scope; distinct_credit_name counts displayed credit names without disclosing them. |
| `group` | Title wording group, price band, list-count bucket, list type or other subgroup. Blank when the metric has no subgroup. |
| `rule` | Matching or inclusion rule for the group, when one applies. |
| `count` | Number of positions, listings or displayed credit names in the group. Blank for medians. |
| `denominator` | Base the count or median is drawn from, in the same counting unit. Blank for standalone credit-name totals. |
| `share_pct` | count / denominator × 100, rounded to one decimal place. Blank when there is no count or denominator. |
| `value` | Value for non-count metrics (medians), unrounded. Reports may round to the cent. |
| `value_unit` | Unit of value, for example usd. Blank when value is blank. |

### summary.csv metrics

| Metric | Meaning |
| --- | --- |
| `positions_sampled` | Chart positions recorded across the 24 lists. |
| `distinct_listings` | Distinct ASINs across the 24 lists. |
| `coloring_labelled_positions` | Positions labelled coloring book by the title rule. |
| `priced_positions` | Positions with a displayed price. |
| `title_wording_matches` | Positions (or distinct listings) whose title matches a wording group, for each scope and counting unit. |
| `price_band_positions` | Priced positions in each displayed-price band. |
| `median_displayed_price` | Median displayed price across priced positions. |
| `listings_by_lists_appeared_on` | Distinct listings that appeared on 1, 2, or 3 or more of the 24 lists. |
| `positions_absent_from_comparison_list` | Positions held by a listing absent from the same list's top 30 at the comparison capture. |

## Where each report finding comes from

| Finding | Source in this dataset |
| --- | --- |
| Christmas/Xmas rose from 72 to 121 of 720 positions; Halloween fell from 49 to 15 | summary.csv, metric title_wording_matches, scope All 24 lists, chart_position. |
| The same shift by list type, by distinct listing, among coloring-labelled positions and in the four headline lists | summary.csv, metric title_wording_matches, other scopes. |
| 555 distinct listings in 720 positions; 85 on two lists, 34 on three or more | summary.csv, metrics distinct_listings and listings_by_lists_appeared_on. |
| Cozy/cosy/hygge in 191 of 720 positions, and the other wording groups | summary.csv, metric title_wording_matches. |
| 429 of 719 priced positions from $5 to $9.99; median $9.99 | summary.csv, metrics price_band_positions and median_displayed_price. |
| 172 of 360 Hot New Releases and 75 of 360 Best Sellers positions absent from the October 29 lists | summary.csv, metric positions_absent_from_comparison_list; per list in lists.csv. |
| Named example books | Withheld: these are row-level listings. |

## Limitations

- Amazon list positions are not sales, revenue, demand or market share. A position says a listing appeared at that rank on that list when the page was captured.
- The 12 categories were selected by ColorBliss and include adjacent activity books, sticker books and study guides, not only coloring books. They are not a random or complete sample of Amazon.
- Title wording rules describe the words in displayed titles, not the contents, covers or quality of a book. Wording groups overlap, so a title can count in several groups.
- Coloring-book labels come from a title rule (the title contains "color" or "colour"), not a manual review.
- Displayed prices are what the list page showed at capture time. They can differ by format or seller, and missing prices are excluded, never imputed.
- A listing is an Amazon product ID (ASIN). Different editions or formats of one book can have separate ASINs.
- Two captures eight days apart cannot establish a recurring seasonal pattern or a sustained trend.

## Withheld data

Row-level Amazon observations (ASINs, titles, author or creator credits, ratings, review counts, product URLs and images) are withheld because permission to redistribute that third-party data has not been verified. Only ColorBliss-derived counts, denominators, shares and medians are published. This is a conservative restriction, not proof of legal permission to redistribute the aggregates. The report itself names some example books; those names and links are not repeated here.

## Version

- 1.0 (2026-11-12): first public release of the aggregate tables. Regenerate with `npm run research:datasets` in `marketing/`. A change to any published value will get a new version number and a note here.

## Suggested citation

ColorBliss. (2026, November 7). Coloring book trends aggregate tables, November 6, 2026 capture compared with October 29 (Version 1.0) [Data set]. From Christmas gains ground on Amazon's coloring-book charts. https://colorbliss.com/research/coloring-book-trends/2026-11-06/data/README.md

## Reuse

ColorBliss requests attribution using the citation above when quoting or charting these tables. No third-party license or legal clearance is asserted: withholding row-level observations is a conservative publication restriction, not verification of redistribution permission for the aggregates. Any reuse remains subject to applicable rights and terms. Amazon, Best Sellers and Hot New Releases are Amazon's names; the underlying list pages are Amazon's content and are not licensed here. Positions and prices describe saved captures, not current Amazon pages.