PART 1: The Literal Scoring Spreadsheet Structure You will have 3 sheets: Question Mapping Sheet Axis Scoring Engine Sheet Archetype Resolution Sheet You can build this in Airtable, Google Sheets, or export to JSON for your backend. SHEET 1: Question Mapping Columns: | Q_ID | Question | Axis_1 | Axis_1_Direction | Axis_1_Weight | Axis_2 | Axis_2_Direction | Axis_2_Weight | Example Rows: | Q3 | Unread emails | Order | + | 2 | — | — | — | | Q1 | Beverage count | Abundance | + | 2 | Guarded | - | 1 | | Q26 | Unfinished projects | Planner | - | 2 | Novelty | + | 1 | Explanation: Axis_1_Direction: "+" means higher value pushes toward right side of axis "-" means higher value pushes toward left side Weight: 1 = light signal 2 = strong signal 3 = dominant signal (rare) SHEET 2: Answer Normalization Table Each question has a scoring range table. Example: Q3: Unread Emails Answer Range Score 0–10 +2 11–50 +1 51–200 -1 200+ -2 Then backend formula: Normalized Score = (Score × Axis_Weight) If Q3 Axis_1 = Order (+ direction), and answer gives -1: Order Score += -1 × 2 weight = -2 Each axis accumulates total. Final Axis Output Structure Each axis is normalized to -100 → +100. Example Final User Vector: Order: +72 Abundance: +15 Planner: -48 Depth: +63 Control: -12 Novelty: +84 Expressive: +55 External: +21 This vector determines archetype. SHEET 3: Archetype Resolution Logic Column format: | Archetype | Primary Axis | Required Threshold | Secondary Axis | Modifier Logic | Example: Explorer Primary Axis: Novelty Threshold: +60 Secondary Axis: Improviser (> +30) Architect Primary Axis: Order Threshold: +60 Secondary Axis: Planner (> +40) If multiple match: Pick highest absolute primary axis score. If none pass threshold: Fallback archetype = Wildcard. Behavioral Anomaly Detection Add logic: If any axis > +85 or < -85: Flag as Extreme Trait AI prompt includes: “User shows extreme Novelty drive (+91). Emphasize intensity.” That’s how you avoid generic output. PART 2: 7 FULL ARCHETYPE DEEP PROFILES These are your premium IP assets. 1. The Architect Core Axis: High Order + High Planner You build invisible systems everywhere you go. You don’t just organize spaces. You architect outcomes. Your environment likely feels intentional. Controlled. Structured. Strengths: Strategic foresight Long-term thinking Stability creation Reliability under pressure Blind Spots: Difficulty delegating Over-optimization Struggle with ambiguity Low tolerance for chaos Stress Behavior: You tighten control. Growth Edge: Trust flexibility without interpreting it as weakness. In relationships: You provide safety. But you must allow unpredictability. 2. The Explorer Core Axis: High Novelty + Improviser You optimize for aliveness. Routine drains you faster than risk. Your life likely contains: Movement Reinvention Expansion cycles Strengths: Adaptive intelligence Courage under uncertainty Social agility Fast learning Blind Spots: Inconsistency Commitment fatigue Scattered focus Stress Behavior: Escape. Change environment. Growth Edge: Freedom becomes powerful when paired with minimal structure. 3. The Sentinel Core Axis: Stability + Guarded You protect what matters. Your decisions are filtered through: “Will this disrupt security?” Strengths: Loyalty Emotional containment Long-term relationship endurance Crisis steadiness Blind Spots: Resistance to change Emotional suppression Fear-driven decisions Stress Behavior: Withdraw and fortify. Growth Edge: Expansion does not equal danger. 4. The Alchemist Core Axis: Depth + Expressive You metabolize experience into meaning. You don’t skim life. You dive. Strengths: Emotional intelligence Creative synthesis Transformational presence Narrative intelligence Blind Spots: Over-identification with emotions Intensity fatigue Difficulty staying surface-level Stress Behavior: Overprocess internally. Growth Edge: Not every experience requires transformation. 5. The Catalyst Core Axis: External + Novelty You generate momentum. Rooms shift when you enter. Strengths: Social ignition Boldness Initiative Influence Blind Spots: Burnout Impulsivity Attention-seeking loops Stress Behavior: Overcommit. Growth Edge: Sustainable energy management. 6. The Curator Core Axis: Order + Depth You refine reality. You remove excess. You enhance signal. Strengths: Aesthetic precision Discernment High standards Taste leadership Blind Spots: Perfectionism Hyper-criticism Analysis paralysis Stress Behavior: Obsess over details. Growth Edge: Progress over purity. 7. The Nomad Core Axis: Improviser + Low Attachment You don’t anchor easily. Freedom > Ownership. Strengths: Adaptability Independence Low ego attachment Reinvention mastery Blind Spots: Avoidance of roots Difficulty committing Shallow support systems Stress Behavior: Detach further. Growth Edge: Depth does not equal captivity. PART 3: Onboarding + Paywall Flow This is critical. Step 1: Opening Screen Minimal. Headline: “We don’t ask who you are. We observe your patterns.” CTA: Begin Analysis Step 2: Framing Screen Explain briefly: “This assessment uses environmental and behavioral signals — not opinions.” This builds legitimacy. Step 3: Quiz Experience Rules: 25–35 questions randomly pulled Progress bar No backtracking (prevents overthinking) Soft ambient animation Completion time: 3–5 minutes Step 4: Suspense Screen “Analyzing 2,184 behavioral micro-patterns…” Animated loading (5–7 seconds). This dramatically increases perceived sophistication. Step 5: Teaser Results (Free) Show: “You show unusually high Novelty Drive.” “You demonstrate structured environmental control.” Blur archetype name. CTA: Unlock Full Personality Decode – $1.99 Step 6: Paywall Psychology Include: 6-slide preview thumbnails blurred Testimonials (beta quotes) “Shareable Wrapped format” One-time payment 24-hour unlock window Optional urgency: “Your report will expire in 24 hours.” Step 7: Post-Purchase Deliver: Archetype Reveal Trait Map Strengths Blind Spots Stress Pattern Compatibility Growth Edge Final slide: Download share card. Conversion Optimization Strategy To increase purchase rate: Add “Your archetype is rare: top 18%” Add percentile comparison Add micro-personalized sentence in preview Example: “You keep more optionality than 82% of users.” Specificity drives payment. Strategic Reality Check This product wins if: The archetypes feel prestigious. The language feels intelligent. The preview is intriguing but incomplete. The report feels eerily tailored. It loses if: It feels like horoscope-level vagueness. The UX feels cheap. The archetypes feel generic.