TekXYZ Review Coding Summary – Public Version.xlsx

	A	B	C
1	How to Use This Review Coding Summary
2	Public appendix for the article: “Boxing Reflex Ball Benefits: Fun Comes First in 71 Amazon Reviews”
3	Purpose	This workbook shows how 71 public Amazon reviews were coded into recurring positive themes. It is designed to help readers understand how the article’s review-based findings were produced.
4	Important note	This is not a scientific study or statistically representative survey. It is a structured review summary based on a defined sample of recent public reviews.
5	Privacy note	The public version uses review excerpts and coding categories for transparency. It does not aim to reproduce full reviewer profiles or internal working notes.
6	Note on Review Links	The 71 reviews were public Amazon reviews at the time of coding. However, some review links may become unavailable over time if reviewers delete their reviews, change their accounts, or if Amazon removes reviews through moderation. If a link no longer works, readers can still refer to the review excerpt and coding information recorded in this workbook.
7
8	How the Three-Step Coding Method Works
9	Step 1: Open Coding: Break each review into smaller meaning units	Each review was read and broken down into benefit-related or concern-related expressions. For example, a review mentioning “fun for the whole family,” “good quality,” and “great gift idea” could be coded under several separate ideas.
10	Step 2: Axial Coding: Group similar expressions into broader themes	Similar expressions were grouped into themes such as Fun (Personal and Family), Giftability, Appeal to Children, Coordination and Exercise Benefits, Quality, and other recurring categories.
11	Step 3: Selective Coding: Count and compare the main themes	The main themes were then selected and counted to show which benefits or concerns appeared most often. Because one review can mention more than one theme, the total number of theme mentions can exceed 71.
12	Why this method was used	This method was used because Amazon reviews are open-ended and often mention several ideas in one review. The three-step coding process helps turn unstructured review text into clear themes and counts. It makes the findings more transparent by showing how the results were developed from review content rather than from selected examples alone.
13
14	Workbook Guide
15	Sheet	What it contains	How readers can use it
16	How to Use	This introduction page.	Start here to understand the purpose, coding method, limitations, and structure of the public coding summary.
17	Step 1: Open Coding	Review-level coding with original review fields, dates, links, and coded positive expressions.	Use this sheet to see how the 71 reviews were broken into smaller meaning units or benefit/issue expressions. The original review information is shown on the left, while the coded expressions are shown across the row. This lets readers trace each code back to the review it came from.
18	Step 2: Axial Coding	Theme-level grouping and counts for positive categories.	Use this sheet to see how similar expressions were grouped into broader themes. This sheet does not repeat the full reviews; instead, it organizes coded expressions by theme so readers can quickly see what reviewers said about each topic. To check the full review behind an expression, copy the excerpt or review ID and search for it in the Step 1 sheet.
19	Step 3: Selective Coding	Final selected themes and theme counts, showing which benefits or concerns appeared most often in the 71-review sample.	Use this sheet to see the main findings at a glance and compare how often each positive theme was mentioned.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100