The school owner

From digital brochure to growth engine

Spark Academy — a Peoria, IL preschool that needed more than a 4-page website. I built a 26-page SEO site with a blog and a custom real-time lead tracking dashboard so the owner can see her pipeline from every source.

26Pages shipped

6 liveKPIs tracked

full buildBrand + strategy

$25KProject price

Before

A small preschool was losing leads because their 4-page 'digital brochure' site couldn't show parents what they actually offered. Google barely knew the school existed. The owner had no idea which pages were driving tours or where visitors were bailing.

What I built

A full 26-page SEO-driven site with a blog, plus a custom real-time tracking dashboard. The dashboard shows exactly where every parent came from, which pages they read, where they bounced, and which KPIs they hit — tour scheduling, program registration, phone calls, contact form submissions, directions requests, and social profile visits.

After

She runs the school. The dashboard runs her pipeline. Leads show up in real time with full context on how they got there. The site ranks for local childcare keywords she couldn't touch before, and every ad dollar is now trackable all the way to a booked tour.

Tech stack

The tools that shipped this.

Next.jsCloudflare PagesCustom analytics pipelineSEOEleventy

Dig into the numbers

Every hour, every role, every session — logged.

Scroll down for the full MasterLog breakdown on this project.

See the MasterLog ↓

MasterLog

Spark Academy

105 deliverables · 1,728 hrs

Project Overview

Full-service digital build for Spark Academy, a Peoria IL preschool and childcare center. Covered brand strategy, website development, SEO, content marketing, and enrollment funnel design — from initial research through a production Eleventy static site.

Goal

Establish Spark Academy's online presence, drive organic enrollment leads, and build a content engine that positions the school as the top local authority in early childhood education.

Started

February 21, 2026

Days Active

47 days

Client

Spark Academy (Peoria, IL)

Status

Active

Key Highlights

•76 deliverables across 11 specialist roles
•Full brand strategy with messaging frameworks and customer personas
•12-month content roadmap with cornerstone blog posts
•Eleventy static site with dual enrollment funnels

Expertise Delivered

Complexity

Moderate

Complex

Routine

Architectural

Work Types

Feature

Strategy

Bug Fix

Docs

Design

DevOps

Project Timeline— Started Feb 21, 2026

Feb 21, 2026

24 hrs1 session

10:37 AMStrategyComplex

Spark Academy

-Created 20-page Master Project Plan document with 60+ tasks across 6 phases

-Defined milestone gates, dependencies, and estimated timelines

-Built non-technical Companion Guide for Dr. Peterson explaining website strategy

-Created 11-slide PowerPoint presentation deck for client onboarding

-Established Claude Projects workflow strategy for multi-phase execution

strategydocspresentationproject-management

24 hrs of Marketing Strategist work

Feb 22, 2026

69 hrs5 sessions

4:24 PMStrategyRoutine

Spark Academy

-Analyzed domain acquisition decision (sparkacademymorton.com vs sparkacademy.com)

-Discovered sparkacademy.com owned by active EdTech company

-Assessed SEO implications of location-specific domain

-Recommended staying with current domain with clear rationale

seodomain-strategy

3 hrs of SEO Specialist work

2:53 PMStrategyModerate

Spark Academy

-Designed exit intent survey strategy (Hotjar) and thank-you page surveys (Tally)

-Specified implementation details, tool selection, and monthly review processes

-Updated project instructions with survey specs as Phase 5 tasks

-Consulted on project instructions length/structure optimization

analyticsconversionstrategy

6 hrs of Marketing Strategist work

1:23 PMFeatureModerate

Spark Academy

-Condensed 5 website audits into 8-page one-page-per-school brief

-Built drag-and-drop DOCX-to-HTML converter using mammoth.js

-Built custom Python converter preserving document design system

-Set up GitHub Pages at steveo8998.github.io/Spark-Academy/ for mobile deliverables

frontendautomationdevopspython

8 hrs of Senior Developer work

11:43 AMStrategyComplex

Spark Academy

-Audited 5 premium preschool websites (Pool A: philosophy/prestige leaders)

-Completed IPS Manhattan case study as cautionary 'squandered assets' example

-Synthesized Pool A + Pool B into executive brief for Dr. Peterson

-Created Research & Discovery Summary Brief with page-by-page content strategy

-Defined 6 governing rules for premium preschool websites

-Crafted text message introduction for presenting brief to client

competitive-analysisresearchdocsstrategy

24 hrs of Brand Strategist work

8:35 PMStrategyComplex

Spark Academy

-Developed 100-point competitive audit rubric across 5 weighted categories

-Audited 6 national preschool websites (Pool B: NYC + Chicago markets)

-Live SERP research and site crawling for each competitor

-Produced 20+ page professional DOCX audit report with color-coded scorecards

-Identified universal CTA gap and 6 strategic priorities for Spark rebuild

competitive-analysisresearchdocs

28 hrs of Brand Strategist work

Feb 23, 2026

28 hrs3 sessions

9:14 PMDocsModerate

Spark Academy

-Reviewed enrollment packet and mapped confirmed program information

-Identified 4 core programs with tuition, schedules, age requirements

-Created replacement text for project instructions warning blocks

-Flagged date inconsistencies in Michelle's packet

-Updated project instructions to Version 2 incorporating all research findings

docsproject-management

6 hrs of Project Manager work

7:41 PMStrategyComplex

Spark Academy

-Conducted full GBP competitive audit: Spark Academy vs Cadence Academy

-14-step analysis covering Map Pack, reviews, citations, conversion paths

-Identified 22 specific gaps (10 HIGH, 9 MEDIUM, 3 LOW impact)

-Created 3-6 month action plan (Foundation → Build → Authority)

-Produced 20+ page professional DOCX report

seocompetitive-analysisgbpdocs

16 hrs of SEO Specialist work

6:03 PMDocsModerate

Spark Academy

-Created reusable 14-step local SEO competitor audit template (DOCX)

-Designed for free tools only with prioritized gap analysis output

-Built for repeated use across 5 planned competitor audits

seocompetitive-analysisdocstemplate

6 hrs of SEO Specialist work

Feb 24, 2026

68 hrs3 sessions

4:29 PMDesignModerate

Spark Academy

-Extracted exact color values from Adobe Illustrator PDF source files

-Discovered incorrectly approximated color (Warm Orange: #FF9966 → #F9A054)

-Produced Brand Guide v3 documenting full logo system (14 production files)

-Created 3 font pairing comparison samples with bias-free identical layouts

-Updated Brand Guide to v4 with confirmed typography (Playfair Display + DM Sans)

brandingdesigntypographycolor-system

8 hrs of UX/UI Designer work

2:28 PMStrategyArchitectural

Spark Academy

-Analyzed existing brand guidelines identifying strengths to preserve and strategic gaps

-Created 30-page Brand Voice Guide DOCX (16 sections)

-Established positioning statement: 'The only preschool in Central Illinois founded and led by a doctoral researcher in ECE'

-Defined 5 voice attributes, 5 core values, parent objection matrix

-Built 5-question Spark Personality Test for content validation

-Flagged items for Dr. Peterson's input (origin story, doctoral research, curriculum name)

-Updated Phase 2A instructions with all brand decisions

brandingcontent-strategypositioningdocs

40 hrs of Brand Strategist work

10:11 PMStrategyComplex

Spark Academy

-Developed complete pSEO strategy (65 pages) covering 4 page types

-Created Location × Program template architecture (52 city pages across 6 communities × 4 programs)

-Built master URL list with keyword targets and search intent classifications

-Produced phased rollout plan to avoid Google penalties

-Created unique local content guidelines with community-specific example paragraphs

-Designed interview questions for Dr. Peterson on why families drive to Morton

seopseocontent-strategydocs

20 hrs of SEO Specialist work

Feb 25, 2026

8 hrs3 sessions

10:22 AMDocsRoutine

Spark Academy

-Converted Questions for Michelle markdown to professionally formatted DOCX

-Built with color-coded callout banners, checkbox formatting, section dividers

-12 sections covering business details, programs, credentials, philosophy

docsformatting

3 hrs of Technical Writer work

8:46 PMFeatureRoutine

Spark Academy

-Built experimental website prototype with mobile refinements

-Replaced emoji icons with custom SVG icons styled to brand colors

-Fixed founder credentials 2x2 grid layout for mobile

-Implemented controlled line break solution for badge text wrapping on iPhone

frontendcssresponsivesvg

4 hrs of Junior Developer work

6:41 PMDevOpsRoutine

Spark Academy

-Set up GitHub Pages hosting for project deliverables

-Provided deployment walkthrough for Stephen

devopsgithub-pages

1 hrs of Junior Developer work

Feb 26, 2026

55 hrs4 sessions

4:23 PMStrategyComplex

Spark Academy

-Built Phase 1 synthesis strategic brief (8 sections, ~10 pages DOCX)

-Created companion 11-slide branded presentation deck

-Flagged 5 open decisions for Dr. Peterson

-Established competitive advantages framework

strategydocspresentation

16 hrs of Marketing Strategist work

3:03 PMStrategyModerate

Spark Academy

-Conducted Apple Tree Academy competitive audit (SEO, credentials, conversion, content)

-Identified 'daycare' self-identification as strategic positioning gap

-Recommended daycare keyword interception strategy

competitive-analysisseopositioning

5 hrs of SEO Specialist work

1:07 PMStrategyModerate

Spark Academy

-Analyzed 20 Ahrefs CSV exports (3,349 unique keywords)

-Cross-referenced real volumes against estimated keyword map

-Discovered 'private kindergarten' opportunity (1,900/mo, KD 0)

-Confirmed keyword-first variant strategy via data analysis

-Updated keyword map with validated Ahrefs data

seokeyword-researchdata-analysisspreadsheet

10 hrs of SEO Specialist work

11:45 AMStrategyComplex

Spark Academy

-Ran 8 live keyword research searches across all target clusters

-Built keyword research report DOCX with 6 clusters and competitive landscape

-Created comprehensive keyword map spreadsheet (110+ keywords, 8 categories)

-Covered pSEO, blog, consulting, and competitor gap keywords

-Built Ahrefs step-by-step guide with 12 research tasks and file naming conventions

seokeyword-researchspreadsheetdocs

24 hrs of SEO Specialist work

Feb 27, 2026

78 hrs5 sessions

5:18 PMStrategyComplex

Spark Academy

-Built consulting funnel wireframe (12 sections) + HTML flowchart

-Designed 3-level commitment ladder for professional audience

-Created CTA matrix, form specs, 5-objection educator matrix

-Mapped 3 primary conversion paths

-Designed crossover architecture between parent and consulting funnels

conversionfunnel-designconsultingwireframe

16 hrs of Marketing Strategist work

3:32 PMStrategyComplex

Spark Academy

-Created messaging framework with 3 lenses (Child-Centric, School-Centric, Hybrid)

-Built per-page Decision Matrix specifying lens ratios for every page

-Developed Flip Test for evaluating headlines

-Created 70+ example headlines organized by page and messaging pillar

-Produced 20+ page branded DOCX

messagingcopywritingcontent-strategy

18 hrs of Brand Strategist work

9:17 PMStrategyComplex

Spark Academy

-Built complete parent lead funnel wireframe (11 sections)

-Designed 4-level commitment ladder

-Defined page roles, CTA matrix, form specs, trust signal placement

-Created post-conversion experience (thank-you pages, surveys, auto-emails)

-Specified micro-conversion tracking

-Built HTML visual flowchart companion

-Incorporated social media entry points and funnel optimization updates

conversionfunnel-designwireframedocs

20 hrs of Marketing Strategist work

7:49 PMDocsModerate

Spark Academy

-Created Purposeful Play Framework document in Dr. Peterson's voice (8 pages)

-Covers philosophy, assessment system, daily schedule, enrichment, behavior, K-readiness

-Serves dual purpose: website source content + PDF tour handout

copywritingcurriculumdocs

10 hrs of Content Writer work

6:12 PMStrategyComplex

Spark Academy

-Developed 3 detailed parent personas (15-page DOCX)

-Sarah (Intentional First-Timer), David & Priya (ROI-Conscious), Megan (Values-First)

-Each persona includes demographics, triggers, objections, search behavior, conversion factors

-Built cross-persona strategy matrix mapping personas to pages

personascontent-strategydocs

14 hrs of Marketing Strategist work

Feb 28, 2026

37 hrs3 sessions

11:31 AMStrategyComplex

Spark Academy

-Developed complete Tracking Architecture Document (GA4 + GTM + forms + surveys)

-Specified 15 tags, 13 triggers, 10 variables in 7 GTM folders

-Defined data layer architecture with 5 page-load variables

-Documented form tracking integration for all 3 forms

-Created chunked HTML delivery for developer reference with copyable code blocks

analyticsgtmga4trackingdocs

20 hrs of Marketing Strategist work

9:06 PMStrategyRoutine

Spark Academy

-Assessed DBA vs legal entity naming for Google Business Profile

-Researched current Google guidelines on naming conventions

-Recommended 'Spark Academy' for all customer-facing use

-Confirmed domain strategy stays with sparkacademymorton.com

seogbpnaming

3 hrs of SEO Specialist work

7:25 PMStrategyComplex

Spark Academy

-Created KPI Dashboard Specification (36 metrics across 5 categories)

-Defined strategic rationale and action triggers per metric

-Confirmed technology stack (WordPress + Kadence + WP Engine + RankMath)

-Created 12-item decision document for Dr. Peterson with options and context

analyticskpistrategydocs

14 hrs of Marketing Strategist work

Mar 1, 2026

114 hrs5 sessions

4:25 PMStrategyComplex

Spark Academy

-Analyzed 20 Ahrefs CSVs (3,349 keywords) identifying 12 strategic blog opportunities

-Discovered daycare keywords generate 1.5x more volume than preschool keywords

-Built daycare-to-preschool interception strategy

-Produced 20-page keyword intelligence document

-Updated keyword map with intelligence analysis findings across 4 tabs

seokeyword-researchdata-analysiscontent-strategy

14 hrs of SEO Specialist work

2:49 PMFeatureComplex

Spark Academy

-Analyzed parent keyword CSV datasets for AEO opportunity mapping

-Identified 75% of parent keywords trigger AI Overviews

-Created 'How to Choose a Preschool' blog post copy deck (~3,000 words)

-Created printable 10-question tour checklist companion

-Created 'Is Preschool Tax Deductible' blog post copy deck and FAQ additions

blogcopywritingseoaeo

16 hrs of Content Writer work

1:19 PMStrategyComplex

Spark Academy

-Built AEO (Answer Engine Optimization) strategy document (42 pages, 12 sections)

-Designed JSON-LD schema architecture for AI citation

-Created Answer Hub page concept at /preschool-morton-il/

-Identified LLM citation vacuum in Central Illinois ECE niche

-Specified WordPress/RankMath configuration for AEO

seoaeoschemaai-searchdocs

20 hrs of SEO Specialist work

11:42 AMDocsArchitectural

Spark Academy

-Created step-by-step WP Engine setup guide (10 sections DOCX)

-Created Kadence Theme Pro installation guide (8 steps DOCX)

-Created RankMath Pro setup guide (15 steps DOCX)

-Created GTM setup guide (10 steps, 24 pages DOCX)

-Created GA4 implementation guide (15 sections DOCX)

-Created GBP setup & configuration guide (14 sections DOCX)

-Created Hotjar exit-intent survey setup guide (8 steps DOCX)

-Created Tally surveys implementation guide (10 sections DOCX)

-Created Google Forwarding Number setup guide (7 sections DOCX)

-Each guide standalone with click-by-click instructions and branded styling

devopsdocsseoanalyticsimplementation-guides

48 hrs of Technical Writer work

7:57 PMDocsComplex

Spark Academy

-Created monthly reporting template Excel (8 tabs with auto-calculating formulas)

-Built instructions tab, 5 KPI data tabs, survey responses tab, action items tab

-Produced custom analytics dashboard blueprint (Next.js + Supabase + GA4 API)

-5-table database schema, 4-job data pipeline, 7-tab frontend, 4-phase build plan

analyticsspreadsheetarchitecturedocs

16 hrs of Data Analyst work

Mar 2, 2026

61 hrs6 sessions

4:28 PMDocsModerate

Spark Academy

-Documented Camp Play summer program (confirmed, full details added)

-Documented Discovery Station homeschool enrichment (pricing, classes, instructors)

-Documented After-School Enrichment Programs (confirmed same as School Age Programming)

-Created enrichment terminology disambiguation (3 distinct contexts)

-Added daily schedules for all 4 core programs

-Produced Project Instructions v3 as comprehensive markdown rewrite

docsproject-managementprogram-documentation

8 hrs of Project Manager work

2:19 PMDocsModerate

Spark Academy

-Updated Brand Voice Guide to FINAL status (all 11 items resolved)

-Updated Messaging Framework Headline Bank to FINAL status

-Confirmed tagline: 'Purposeful Play. Exceptional Beginnings.'

-Processed Michelle's completed decision document

-Incorporated all confirmed decisions into project files

-Recommended against fabricated endorsement placeholders

docsproject-managementbranding

6 hrs of Project Manager work

12:08 PMStrategyModerate

Spark Academy

-Identified SEO conflict with 'Ignite Learning Model' name

-Researched 8 brand-neutral AEO-optimized curriculum name alternatives

-Tested each for search conflicts with quoted-phrase web searches

-Produced branded HTML options document for Dr. Peterson

-Renamed curriculum across all project docs (21+ instances in framework doc alone)

-Updated Brand Voice Guide, Messaging Framework, and Project Instructions

brandingseonamingdocs

10 hrs of Brand Strategist work

9:17 PMDocsRoutine

Spark Academy

-Counted pages across 14 DOCX project files (257 total pages produced)

-Established dual-format deliverable workflow (DOCX master + mobile HTML)

-Designed mobile-friendly HTML deliverable system with Spark brand styling

-Set up GitHub Pages hosting workflow for Dr. Peterson review links

docsworkflowproject-management

3 hrs of Project Manager work

7:35 PMStrategyModerate

Spark Academy

-Built pricing analysis document with KPI cards and SWOT analysis

-Compared Spark vs Peoria metro avg vs IL private pre-K avg

-Iterated through multiple revisions on data accuracy and fair comparisons

-Removed church-subsidized schools as unfair comps per Stephen's editorial direction

-Produced HTML + DOCX versions kept in sync

pricingcompetitive-analysisdocs

10 hrs of Business Consultant work

6:05 PMStrategyComplex

Spark Academy

-Built TPT competitive deep-dive analyzing 7 top preschool sellers

-Identified doctoral degree gap in entire TPT preschool market

-Created 14-dimension competitive comparison matrix

-Produced revenue projections and batch-creation timeline

-Created TPT Product Roadmap Sections 1-5 (38-page DOCX)

-Mapped 45 products across 5 strategic market gaps

-Designed 6 core bundles and 5 free lead magnets

-Built week-by-week Summer 2026 launch sequence

ecommercecompetitive-analysisproduct-strategytpt

24 hrs of Business Consultant work

Mar 3, 2026

62 hrs5 sessions

5:42 PMFeatureComplex

Spark Academy

-Planned Phase 3A batching strategy and page sequencing rationale

-Wrote Homepage copy deck (full SEO metadata, section copy, CTAs, schema)

-Wrote Why Spark Academy copy deck

-Produced DOCX master + mobile HTML for each

-Established Dr. Peterson review format (gold/green/red annotation boxes, collapsed sections)

-Converted all project files from DOCX/PDF to Markdown for faster access

-Created reusable Markdown-to-HTML conversion prompt template

copywritingseofrontenddocs

24 hrs of Content Writer work

3:14 PMStrategyComplex

Spark Academy

-Built 18-month Blog Content Roadmap (75 topics across 2 tracks, 12 sections DOCX)

-Organized into 3 phases + seasonal layer + 3 branded series

-Every topic grounded in Ahrefs keyword data and mapped to dual-funnel architecture

-Created mobile-optimized HTML version for Dr. Peterson review

-Included publishing cadence options and 8 decisions requiring Dr. Peterson's input

content-strategyblogseodocs

18 hrs of Marketing Strategist work

12:37 PMDocsModerate

Spark Academy

-Created ChatGPT Project setup for Dr. Peterson

-Built plain text instructions file optimized for ChatGPT

-Created branded DOCX setup guide for non-technical user

-Selected 9 appropriate project files for Michelle's use cases

docsonboardingai-tools

6 hrs of Technical Writer work

8:48 PMStrategyModerate

Spark Academy

-Assessed 5 copywriting frameworks (PASTOR, AIDA, BAB, PPPP, SSS) for Spark

-Mapped each framework to specific page types in the project

-Created comprehensive copywriting reference guide (branded HTML)

-Built 12-page assignment table mapping every Phase 3 page to its framework

copywritingcontent-strategydocs

6 hrs of Content Writer work

6:44 PMDesignModerate

Spark Academy

-Selected Morning Mist brand palette (v5.0) through interactive explorer

-Built mobile-friendly palette explorer HTML for Dr. Peterson

-Produced Brand Guide v5 DOCX with updated colors, accessibility documentation

-CTA button text shifted from dark to white (accessibility-driven)

-Updated all project instructions color references

brandingdesigncolor-systemaccessibility

8 hrs of UX/UI Designer work

Mar 4, 2026

18 hrs1 session

8:20 PMFeatureComplex

Spark Academy

-Wrote Founder Hub / Dr. Michelle Peterson copy deck (origin story, credentials, consulting bridge)

-Wrote Consulting Services copy deck (9 services, educator objections, form spec)

-Built mobile-optimized HTML review files with annotation system

-Implemented expanded-notes-within-collapsed-sections UX pattern

copywritingconsultingfrontend

18 hrs of Content Writer work

Mar 5, 2026

132 hrs4 sessions

5:25 PMFeatureModerate

Spark Academy

-Built interactive photographer checklist (33 shots, 6 tiers) with HTML

-Added localStorage persistence, sticky progress bar, celebration overlay

-Fixed collapse/expand rendering bug (switched from max-height to display toggle)

-Fixed reset button touch target and iOS confirm() issues (two-tap pattern)

-Built and maintained GitHub Pages index.html with categorized file cards

-Updated index across multiple rounds as new files were added

frontendjavascriptmobileinteractive

10 hrs of Junior Developer work

9:27 PMFeatureArchitectural

Spark Academy

-Wrote Purposeful Play Framework curriculum page copy deck (14 sections)

-Wrote Schedule a Tour copy deck (dual-form architecture, exit intent spec)

-Wrote Answer Hub / AEO page copy deck (machine-readable, citation-optimized)

-Resolved keyword cannibalization: Homepage = head term, Answer Hub = long-tail

-Created wayfinding element for humans landing on reference-style page

-Wrote Testimonials page copy deck with scalable structure (2 → 10+)

-Wrote FAQ copy deck (46 Q&As) + 58-question inventory for Dr. Peterson

-Wrote Blog Hub copy deck (category filter, conditional CTAs, branded series)

-Updated Messaging Framework with Blog Hub Decision Matrix row

-Created all mobile HTML versions

copywritingseoaeoconversionfrontend

56 hrs of Content Writer work

8:09 PMFeatureComplex

Spark Academy

-Wrote Discovery Station copy deck (drop-off differentiator, co-op objection, updateable semester block)

-Wrote After-School Enrichment copy deck (experiential not tutoring, flexible content container)

-Wrote Summer Camp copy deck (urgency mechanic via May 30 deadline, per-morning cost reframe)

-Each with phone-only registration CTAs and updateable content blocks

copywritingseo

18 hrs of Content Writer work

6:30 PMFeatureArchitectural

Spark Academy

-Discovered and repositioned Fresh 3's Fridays as standalone gateway program

-Wrote Fresh 3's Fridays copy deck (rolling enrollment differentiator, upgrade path)

-Wrote 3's Preschool copy deck (neural pathways, separation anxiety, bridge option)

-Wrote 4's Preschool copy deck (scheduling decision as SEO hook)

-Wrote Kindergarten Prep copy deck (November 30 cutoff differentiator)

-Wrote Kindergarten copy deck ('why pay when it's free?' objection handling)

-Wrote Programs Overview copy deck (wayfinding hub, tuition comparison table)

-Each includes full metadata, FAQ, schema, internal linking, photo direction

-Created mobile HTML versions for all 6 pages

copywritingseoconversion

48 hrs of Content Writer work

Mar 6, 2026

22 hrs2 sessions

9:11 PMStrategyComplex

Spark Academy

-Integrated all-inclusive tuition messaging (Content Tweaks Queue item #1)

-Established Content Tweaks Queue system in Project Instructions

-Created Open Door Policy Integration Plan (13 touchpoints, 10 pages, 3 tiers)

-Drafted 3 Dr. Peterson open-door quotes in documented voice patterns

-Clarified Discovery Station vs After-School program architecture

-Added enrichment terminology disambiguation to project docs

-Identified homeschool + after-school keyword expansion needed in keyword map

content-strategyconversionproject-management

14 hrs of Marketing Strategist work

7:10 PMFeatureModerate

Spark Academy

-Converted multiple project documents to branded HTML (parent personas, brand guide, etc.)

-Each with Morning Mist palette, responsive layout, navigation pills

frontendhtmlresponsive

8 hrs of Junior Developer work

Mar 7, 2026

46 hrs4 sessions

5:37 PMFeatureComplex

Spark Academy

-Set up complete WordPress staging environment from scratch on WP Engine

-Installed and configured Kadence Theme Pro, Kadence Blocks Pro, RankMath Pro, Solid Mail

-Configured global design system (colors, typography, buttons)

-Created all 20 site pages and built primary navigation menu

-Built Programs Overview page with responsive design system

-Developed 4-breakpoint responsive framework (desktop/tablet/mobile/foldable)

-Created Page Build Prompt Template for consistent page production

wordpressdevopsresponsivedesign-system

20 hrs of Senior Developer work

3:23 PMStrategyModerate

Spark Academy

-Evaluated Kadence Advanced Form vs Fluent Forms (comprehensive feature comparison)

-Confirmed Kadence Advanced Form as replacement (fewer plugins, native styling)

-Produced 8 find-and-replace updates for all Fluent Forms references

-Updated Tracking Architecture for Kadence form integration

-Recommended Solid Mail over WP Mail SMTP for SMTP plugin

wordpressformsanalyticsarchitecture

6 hrs of Senior Developer work

8:41 PMDesignModerate

Spark Academy

-Converted Brand Guide to 17-page Canva-optimized PDF

-Conducted systematic audit against official Brand Guide (caught undersized type scale, missing Tier 3 colors, invented color)

-Embedded all 14 logo assets showing 3 configurations × 4 color variants

-Added brand story, values, and asset usage standards section

-Included WCAG contrast ratio table and Canva quick-reference section

brandingdesignpdfcanva

10 hrs of UX/UI Designer work

6:31 PMDesignModerate

Spark Academy

-Created Midjourney prompt guide (6 prompts) for brand pattern backgrounds

-Redesigned all prompts for grayscale-first workflow when Midjourney ignored colors

-Added Canva recolor instructions per brand palette

-Built Purposeful Play Framework SVG infographic (3 iterations)

-S-curve pathway layout with hand-drawn style icons, confetti accents

-Fixed spacing/overlap issues in pillars 4 and 6

designillustrationsvgmidjourney

10 hrs of UX/UI Designer work

Mar 8, 2026

54 hrs2 sessions

9:52 PMFeatureComplex

Spark Academy

-Built 3's Preschool WordPress HTML blocks (10 blocks)

-Created comparison mockups for enrichment display and tuition cards

-Established content vs design change approval workflow

-Updated Page Build Prompt Template with FAQ accordion, nowrap, CTA escape patterns

frontendcssresponsivewordpress

14 hrs of Senior Developer work

7:47 PMFeatureArchitectural

Spark Academy

-Built Homepage WordPress HTML blocks (11 blocks, 19 tracked CTAs)

-Added tablet breakpoint, program card redesigns, supplemental program cards

-Built Fresh 3's Fridays WordPress HTML blocks (10 blocks, 1,370 lines)

-Performed consultant audit, implemented 6 improvements (FAQ/CTA reorder, mid-page CTA, enrichment restructure)

-Built Why Spark Academy WordPress HTML blocks (9 blocks)

-Added stat callouts, pull quotes, alternating backgrounds, full-width sage extends

-Implemented nowrap heading pattern and tappable link underlines as standards

-Performed consultant audit, implemented 7 improvements (reorder differentiators, remove hero CTAs, add mid-point CTA)

frontendcssresponsivewordpresshtml

40 hrs of Senior Developer work

Mar 9, 2026

8 hrs1 session

9:30 PMBug FixModerate

Spark Academy

-Performed 14-issue consultant review of Homepage HTML

-Fixed truncated blocks, CSS centering, RTL accessibility hack (replaced with CSS order)

-Added GTM data-cta attributes to all 19 clickable elements

-Fixed Cloudflare email obfuscation artifact

-Added skip link, print stylesheet, scroll-margin-top, font-display swap notes

-Removed all inline styles, introduced CSS variable for consistency

-Generated continuation prompt for next-session handoff

frontendaccessibilityquality-assurancecss

8 hrs of Senior Developer work

Mar 11, 2026

138 hrs5 sessions

6:48 PMFeatureModerate

Spark Academy

-Conducted Have a Question UX audit across all 5 built HTML pages

-Identified messaging mismatch (user clicks 'Have a Question' → lands on 'Not Ready to Tour')

-Created comprehensive UX Redesign Spec covering every current and planned page

-Fixed 3's Preschool inline form routing, anchor IDs, and micro-copy

-Established inline embed approach as standard (smooth-scroll, no page navigation)

uxconversionfrontend

8 hrs of UX/UI Designer work

4:05 PMDesignModerate

Spark Academy

-Redesigned program cards with gradient headers + age callouts (Homepage + Programs Overview)

-Locked all card colors to Morning Mist palette after Dr. Peterson feedback

-Assigned program gradient colors: Fresh 3's=Gold, 3's=Teal, 4's=Sage, K-Prep=Deep Teal, K=Warm Teal

-Redesigned Programs Overview bottom CTA to dual-path (Still Exploring? + Have a Question?)

-Reframed phone CTA to set voicemail expectations

frontenddesignuxresponsive

10 hrs of Senior Developer work

10:17 PMFeatureModerate

Spark Academy

-Wrote Thank-You Pages & Confirmation Emails copy deck (6 copy elements across both funnels)

-Wrote Consulting Thank-You copy deck with professional register

-Applied Vocabulary Firewall across all post-conversion touchpoints

-Resolved /thank-you/ vs /tour-confirmed/ URL discrepancy

copywritingconversionemail

8 hrs of Content Writer work

8:51 PMFeatureArchitectural

Spark Academy

-Built Consulting Services WordPress HTML blocks (9 blocks, 1,079 lines)

-Built Dr. Peterson Founder Hub WordPress HTML blocks (10 blocks, 1,351 lines)

-Built Blog Hub WordPress HTML blocks (9 blocks, 1,026 lines) with vanilla JS filter logic

-Built Tour Confirmed thank-you page HTML blocks (5 blocks)

-Built Consulting Thank-You page HTML blocks (5 blocks)

-Built FAQ page WordPress HTML blocks (11 blocks, 1,457 lines, 46 Q&As)

-Built Purposeful Play Framework WordPress HTML blocks (15 blocks, 1,801 lines)

-Built Schedule a Tour WordPress HTML blocks (9 blocks, 1,307 lines)

-Built Answer Hub WordPress HTML blocks (14 blocks, 2,419 lines, 11 data tables)

frontendcssresponsivewordpresshtmljavascript

64 hrs of Senior Developer work

7:14 PMFeatureArchitectural

Spark Academy

-Built Kindergarten Prep WordPress HTML blocks (10 blocks)

-Built 4's Preschool WordPress HTML blocks (11 blocks, 1,560 lines)

-Built After-School Enrichment WordPress HTML blocks (10 blocks, 1,269 lines)

-Built Summer Camp WordPress HTML blocks (10 blocks)

-Built Discovery Station WordPress HTML blocks (11 blocks, 1,495 lines)

-Built Kindergarten WordPress HTML blocks (11 blocks, 1,468 lines)

-Each with full responsive breakpoints, GTM tracking, FAQ accordions, updateable content markers

frontendcssresponsivewordpresshtml

48 hrs of Senior Developer work

Mar 12, 2026

2 hrs1 session

9:19 PMDocsRoutine

Spark Academy

-Established photography pipeline (HEIC → WebP via ImageMagick + pillow-heif)

-Walked through Mac photo export workflow for Michelle

-Confirmed JPEG as interim format, WebP as Phase 5 target

photographyimage-processing

2 hrs of Junior Developer work

Mar 16, 2026

10 hrs1 session

1:07 PMStrategyModerate

Spark Academy

-Built Photography Strategy document consolidating 27 unique shots from 15+ copy decks

-Created two-track system (Michelle for candids, professional for hero/portraits)

-Produced iPhone settings guide and Lightroom warm tone correction values

-Built photo reuse map showing which assets serve multiple pages

-Debugged Google Photos vs Google Drive compression pipeline

-Confirmed full-resolution 4032×3024 HEIC pipeline working

-Assessed Michelle's test photos against Brand Guide standards

photographystrategydocsimage-processing

10 hrs of UX/UI Designer work

Mar 17, 2026

20 hrs1 session

11:18 AMFeatureComplex

Spark Academy

-Designed complete enrollment availability tracking system

-Solved M-F enrollment overlap calculation logic across program groups

-Built Google Sheets enrollment tracker (Excel) with 3 tabs and auto-calculating formulas

-Created HTML mockup showing 3 urgency tiers (sage/gold/red) with pulsing animations

-Produced 17-page implementation guide with JavaScript CSV parser

-Documented WordPress integration, GTM tracking, and testing checklist

featurejavascriptspreadsheetfrontenddocs

20 hrs of Senior Developer work

Mar 18, 2026

24 hrs2 sessions

6:52 PMDesignComplex

Spark Academy

-Mapped top 10 parent navigation paths through website

-Built interactive Sankey flow diagram (React) for navigation analysis

-Designed UI color strategy overhaul by funnel zone (5 zones)

-Matched zones to starburst colors from original KJ Creative logo

-Created 21-page color scheme guide with Co-Work implementation scripts

-Discovered and established that short palette-focused Co-Work prompts outperform detailed scripts

uxdesigncolor-systemfrontend

16 hrs of UX/UI Designer work

4:07 PMStrategyModerate

Spark Academy

-Researched and debunked AI content SEO penalty concerns with evidence

-Created AI Writing Tells Reference Guide (12 patterns with Spark-specific examples)

-Built self-contained audit prompt for checking copy against AI writing tells

-Linked each pattern back to Dr. Peterson's documented natural voice

seocontent-strategyquality-assurance

8 hrs of SEO Specialist work

Mar 19, 2026

14 hrs2 sessions

12:21 PMFeatureModerate

Spark Academy

-Processed Dr. Peterson headshot photos (background removal via OpenCV GrabCut)

-Generated 15 responsive WebP files across 3 tiers × 5 breakpoints

-Produced usage guide with srcset/picture element markup and CSS styling

-Rewrote open-door policy copy fixing security messaging ('no locked doors' → entry protocol)

image-processingresponsivepython

6 hrs of Junior Developer work

9:28 PMFeatureModerate

Spark Academy

-Produced multiple copy revisions per Michelle's feedback

-K-Prep: tagline alternatives, building security rewrite, third path for homeschool families

-3's Preschool: corrected upgrade path language throughout

-Summer Camp: revised weekly rate structure across multiple iterations

-Discovery Station: replaced parent-stay invitation with drop-off value copy

-FAQ: rewrote 'Is Spark Academy a daycare?' answer

copywritingrevisionclient-feedback

8 hrs of Content Writer work

Mar 22, 2026

20 hrs1 session

2:20 PMFeatureComplex

Spark Academy

-Initial commit: Spark Academy website - 20 pages, blog system, Eleventy + Cloudflare Pages

-SEO optimization: keyword-targeted meta tags, URL restructure, structured data

-SEO: secondary keywords in body copy + FAQPage schema (43 questions)

-Add form submission system with Cloudflare Workers + Resend

-Remove Workers-specific files (now using Cloudflare Pages)

-Temp: route all form emails to [email protected] for testing

blogdeploymentseostructured-dataformsjavascriptcss

20 hrs of Junior Developer work

Mar 23, 2026

63 hrs1 session

11:30 AMBug FixArchitectural

Spark Academy

-fix: restore page-specific CSS stripped during HTML-to-Eleventy conversion

-feat: complete photo overhaul — 48 SEO-named photos, local hosting, zero duplicates

-feat: replace text logo with SVG wordmark in nav and footer

cssseoimagesnavigationbrandingblog

63 hrs of Junior Developer work

Mar 24, 2026

121 hrs4 sessions

6:57 PMFeatureComplex

Spark Academy

-Wrote 'Daycare vs Preschool' blog post copy deck (cornerstone, 9,000/mo target)

-Wrote 'When Should Child Start Preschool' blog post copy deck (20,000/mo target)

-Wrote 'Play-Based Curriculum Meets Standards' educator copy deck (consulting funnel)

-Wrote 'What Does an ECE Consultant Do' copy deck (consulting funnel anchor)

-Each with full SEO metadata, internal links, voice-appropriate CTAs, open items for Dr. Peterson

blogcopywritingseocontent-strategy

24 hrs of Content Writer work

4:20 PMStrategyComplex

Spark Academy

-Compiled ~6,000-word research document for 'Daycare vs Preschool' blog post

-Compiled ~6,000-word research document for 'When Should Child Start Preschool'

-Compiled deep research for 'Play-Based Curriculum Meets Standards' educator article

-Compiled ~6,000-word research for 'What Does an ECE Consultant Do' article

-Each includes peer-reviewed studies, competitor audit, cost data, parent language analysis

researchblogdata-gatheringcompetitive-analysis

32 hrs of Data Analyst work

1:36 PMBug FixArchitectural

Spark Academy

-feat: dual-funnel blog, SEO titles, reCAPTCHA, go-live prep

-fix: correct site URL to sparkacademymorton.com, lower reCAPTCHA threshold

-fix: add CSP headers to allow reCAPTCHA and Google Analytics

-feat: add GA4 Measurement ID G-4NN5QZCZP3

-fix: remove CSP that was blocking reCAPTCHA on mobile

-fix: first tap on Programs expands dropdown on mobile, second tap navigates

-fix: prevent images from overflowing on mobile, add global box-sizing

-fix: mobile layout improvements — hero ordering, photo overflow, nav button

-fix: mobile nav dropdown, accent dots, remove duplicate nav item

-fix: inline dropdown chevron and fix first-tap bug on mobile nav

-fix: rotate upside-down theater costume photo on afterschool page

-fix: rotate upside-down STEM minerals photo on discovery station page

-fix: remove visible developer note from discovery station page

-fix: replace upside-down discovery station photos with correctly oriented versions

-fix: adjust hero image crop on discovery station to show child's face on desktop

-feat: add default OG share image for iMessage and social link previews

-feat: add Spark S logomark favicon for browser tabs and bookmarks

-feat: implement complete GA4 tracking with 13 custom events

-feat: add register_now_click conversion event for Google Form registration

-fix: standardize bottom section order across Discovery Station, Summer Camp, and After-School

-feat: add Facebook/Instagram to footer, split programs into two columns

-feat: add 301 redirects for old Pixpa URLs

-fix: add missing name attributes to question forms on 3 pages

-perf: add font preconnect hints and compress hero images

seoblogsecurityanalyticsmobilenavigationimagescss

59 hrs of Junior Developer work

10:47 PMDevOpsModerate

Spark Academy

-Created CLAUDE.md context file for Claude Code (3 iterations refining scope)

-Established narrative-focused approach: what/why only, not technical prescriptions

-Selected Web3Forms for static site contact forms

-Adapted project from WordPress/WP Engine to Cloudflare Pages + Eleventy

devopsarchitecturedocs

6 hrs of Senior Developer work

Mar 25, 2026

66 hrs3 sessions

4:11 PMFeatureComplex

Spark Academy

-Diagnosed Cloudflare CDN cache issue preventing site updates after git push\n- Set up Cloudflare API token (cache purge, analytics, DNS, workers) with auto-purge hook that fires 120s after every git push, zone-aware for Spark and Aitheos\n- Updated Storybook Creations description on Discovery Station per Michelle's note\n- Added GA4 Realtime API integration: active users, pages being viewed, devices, realtime conversions with /dashboard/api/realtime endpoint and 60-second client-side auto-refresh\n- Full dashboard visual redesign: CSS custom properties, gradient header, elevated cards with shadows/borders, animated source bars, staggered fade-in, live dot glow ring, typography scale, prefers-reduced-motion support, mobile-first responsive refinements\n- Added Quickest Exits section showing pages with lowest avg engagement time (historical data)\n- Added column headers (Page, Avg. Time, Views) on Most Viewed Pages\n- Removed redundant Where Visitors Land First section\n- Added general_email_click and social_click GA4 tracking events for non-consulting emails and Facebook/Instagram links\n- Reorganized Actions Taken into 3 funnel-grouped sections: High-Value Leads, Engagement, Consulting\n- Updated test offsets for register_now_click

dashboardrealtimega4cloudflarecssdevopsanalytics

33 hrs of Junior Developer work

2:17 PMFeatureModerate

Spark Academy

-Dashboard: subtracted test data offsets so Michelle sees accurate conversion counts\n- Dashboard: added avg engagement time per page to Most Viewed Pages section\n- Dashboard: added address_click GA4 event tracking + Address Lookups card\n- Discovery Station: full Fall 2026 update — tabbed age-group selector (Ages 5&6 / 7&8 / 9-11), 10 new classes with descriptions, Center Stage Players add-on (), Tuesdays & Wednesdays, updated instructors, semester dates\n- Nav: fixed Programs dropdown unresponsive on desktop at narrow widths (touchend vs click handler)\n- Nav: added hide-on-scroll-down / show-on-scroll-up behavior (position fixed + rAF)\n- Mobile: removed excessive hero image padding so photos fill their cards globally\n- Git: committed dashboard worker and wrangler.toml to repo

cloudflare-workerdashboarddiscovery-stationnavmobilega4css

19 hrs of Junior Developer work

9:28 PMDevOpsComplex

Spark Academy

-Created Blog Dual-Funnel Build Brief adapted for Eleventy static site

-Rewrote from client-side JS filter to three separate Eleventy listing pages

-Included collection definitions, shared partial spec, conditional CTA logic

-Built GA4 Tracking Implementation Prompt adapted for static site (no WordPress)

-Specified 13 custom events, page metadata mapping, form tracking for Web3Forms

-Site launched live at sparkacademymorton.com

-Provided cache-clearing instructions for Dr. Peterson (Safari + Chrome, iPhone + MacBook)

devopsanalyticseleventylaunch

14 hrs of Senior Developer work

Mar 26, 2026

71 hrs3 sessions

4:21 PMFeatureComplex

Spark Academy

-Built 9 SEO parent resource pages with full CSS, FAQPage JSON-LD schema, and mobile-responsive design (kindergarten readiness checklist, preschool readiness checklist, is my 3-year-old ready, what is play-based learning, preschool daily schedule, preschool schedule options, play-based vs academic, daycare vs preschool, when to start preschool)

-Converted 2 blog posts (daycare-vs-preschool, when-to-start-preschool) to designed site pages with 301 redirects

-Added Parent Resources dropdown to header nav with 9 links in 3 grouped sections

-Restructured footer: merged Enrichment into Programs column, added new Parent Resources column

-Fixed mobile hero content order (global CSS flex reorder conflict) across all 9 pages

-Implemented mobile trust bar 2x2 grid replacing vertical stack on all 9 pages

-Built jump nav fade gradient scroll indicator with JS scroll-state detection

-Converted 3 comparison/options tables to stacked cards on mobile

-Fixed CTA button styling (white text, no underline) across all 9 pages

-Reduced mobile H1 font sizes and removed white-space:nowrap spans to prevent overflow

-Hidden redundant secondary links on mobile across all 9 pages

-Added 9 friendly page name mappings to Michelle's dashboard worker

-Updated dashboard test offsets for Michelle's test submissions

-Fixed enrichment grid layout from 5-col to 3+2 flexbox on daily schedule page

seointent-pagesmobilenavigationdashboardparent-resources

50 hrs of Junior Developer work

10:46 AMFeatureComplex

Spark Academy

-Cloudflare www→non-www 301 redirect rule created via API (all 4 URL variants now consolidate to https://sparkacademymorton.com)\n- Google Search Console audit: identified URL splitting across 3 homepage variants and old Pixpa URLs still indexed\n- Verified all 8 old Pixpa URL 301 redirects working correctly\n- GSC export data analysis: branded search strong (pos 1.2), zero non-branded discovery traffic — identified need for intent pages\n- Blog vs intent page conflict analysis: dropped 2 planned pages that duplicate existing blog posts\n- Built Kindergarten Readiness Checklist page (/kindergarten-readiness-checklist/) — 3,800/mo keyword, full checklist by developmental domain, FAQ schema, responsive CSS\n- Built Preschool Readiness Checklist page (/preschool-readiness-checklist/) — 500/mo keyword, younger age target, cross-linked to kindergarten page\n- Built Is My 3-Year-Old Ready for Preschool page (/is-my-3-year-old-ready-for-preschool/) — 300/mo keyword, conversational tone, icon cards, potty training section\n- Parallel SEO competitor research via 3 agents covering 5 target keywords\n- Created detailed memory/handoff doc for continuation in next session (4 pages remaining)

seointent-pagescloudflaregoogle-search-consolecontent

21 hrs of Junior Developer work

11:05 PMBug FixRoutine

Spark Academy

-Removed Tuesday-specific language from Discovery Station enrollment section per Kyleigh's feedback (promoted one day over the other)

copydiscovery-stationcontent-fix

0 hrs of Junior Developer work

Mar 27, 2026

65 hrs4 sessions

12:54 PMFeatureComplex

Spark Academy

-Dashboard: bot traffic filtering (datacenter cities + US-only country filter + page view offsets for bot-inflated intent pages)

-Dashboard: added 'Where They're Located' city breakdown section with VPN/Chicago footnote

-Removed cookie consent banner (not required for US-only local business), GA4 now loads directly

-Homepage: redesigned program cards to compact single-column layout (Option A), merged Core Programs + More Ways to Spark into unified section

-Programs Overview: switched to single-column card layout (fixes age filter targeting), normalized Fresh 3's card, removed duplicate pricing table

-CTA funnel overhaul across 27 pages: removed top-of-page Schedule a Tour from all intent, evaluation, program, and supplemental pages; replaced with research-journey CTAs guiding parents deeper into site based on page context

-Updated blog post + listing templates to guide parents to programs instead of tour

-Created Privacy Policy page (/privacy-policy/) covering GA4, reCAPTCHA, form data, Cloudflare hosting

-Added privacy policy link to site footer

-GA4 strategy consultation: location tracking capabilities, cookie consent requirements

dashboardanalyticshomepagecta-funneluxprivacydesignga4

39 hrs of Junior Developer work

11:42 AMFeatureModerate

Spark Academy

-Added bot traffic filtering to dashboard (excludes datacenter cities: Boardman, Singapore, Ashburn, San Jose)

-Added US-only country filter across all historical GA4 dashboard queries

-Built 'Where They're Located' city breakdown section with bar charts (after traffic sources, before top pages)

-Added page view offsets to correct bot-inflated views on intent pages (Preschool Readiness Checklist, Daycare vs Preschool, Kindergarten Readiness Checklist)

-Added VPN/Chicago explanatory footnote on city section for Michelle

dashboardanalyticsga4cloudflare-workerbot-filtering

8 hrs of Junior Developer work

2:32 AMBug FixRoutine

Spark Academy

-Fixed Discovery Station days from Thursday to Wednesday across 7 source files (12 edits): index.njk, programs.njk, afterschool.njk, kindergarten-prep.njk, faq.njk, answer-hub.njk, faqSchema.json\n- Carefully distinguished Discovery Station refs from daily enrichment rotation and preschool T/Th schedules\n- Saved site-wide content check memory to prevent future partial updates

content-fixdiscovery-stationsite-wide-update

2 hrs of Junior Developer work

10:18 PMFeatureModerate

Spark Academy

-Triaged ThirstyAudit website diagnosis (62/100 D grade): identified 7 real issues vs 9 false positives caused by missing 404 page\n- Created custom 404.html page for Cloudflare Pages (eliminates all false-positive security findings)\n- Added HSTS, Content-Security-Policy, and Permissions-Policy security headers\n- Built cookie consent banner that gates GA4 until user accepts/rejects (GDPR-compliant, localStorage-based)\n- Made reCAPTCHA load asynchronously, added lazy loading to footer logo\n- Upgraded schema to dual-type ChildCare + LocalBusiness for richer local search\n- Added AI crawler directives (GPTBot, ClaudeBot, PerplexityBot) to robots.txt\n- Full creative site audit with strategic recommendations: teacher visibility, testimonial strategy, parent objection handling, Developmental Playroom showcase, post-tour funnel, dashboard improvements

securityseolegal-complianceperformancecookie-consentaudit

16 hrs of Junior Developer work

Mar 29, 2026

37 hrs3 sessions

11:57 AMFeatureModerate

Spark Academy

-Tap-to-expand page breakdown on all dashboard metric cards (High-Value Leads, Engagement, Consulting)\n- New GA4 query fetching eventName + pagePath + sessionDefaultChannelGroup in parallel\n- Detail table shows which page and traffic source drove each conversion action\n- Test data offsets applied to detail rows (strips test entries from tail)\n- Callout banner informing Michelle about the new tap-to-expand feature with dismiss button\n- Accordion UX: one card open at a time, chevron indicator, mobile-optimized

dashboardga4cloudflare-workerux

9 hrs of Junior Developer work

11:13 PMFeatureComplex

Spark Academy

-Google Search Console API integration: 3 new dashboard panels (Search Performance summary, What Parents Are Googling top 15, SEO Opportunities)\n- Interactive sortable tables on search queries and most viewed pages (tap column headers to sort)\n- Period-over-period comparison arrows on Quick Glance cards (auto-hides when insufficient data)\n- New vs. Returning Visitors panel with visual bar and percentages\n- When Parents Browse panel showing busiest days and peak hours\n- Bot/spam query filtering: exact blocklist, 8+ word filter, irrelevant location filter\n- Page view offsets updated for Kindergarten Readiness Checklist (-53) and Daycare vs Preschool (-3)\n- Old redirect paths filtered from SEO Opportunities (e.g. /curriculum)\n- Sort hint callouts for Michelle's UX on sortable tables\n- Search Console API enablement + service account permissions debugging

search-consoledashboardseoanalyticsuxcloudflare-workers

22 hrs of Junior Developer work

9:22 PMFeatureModerate

Spark Academy

-Google Search Console API integration with 3 new dashboard panels\n- Search Performance summary cards (clicks, impressions, CTR, avg position)\n- What Parents Are Googling — top 15 search queries with clicks/impressions/rank\n- SEO Opportunities panel — high-impression/low-CTR pages flagged for improvement\n- Search Console API auth (webmasters.readonly scope added to JWT)\n- Graceful fallback when data unavailable\n- Deployed to Cloudflare Workers

search-consoledashboardseocloudflare-workers

6 hrs of Junior Developer work

Mar 30, 2026

55 hrs3 sessions

12:40 AMBug FixRoutine

Spark Academy

-Fixed dashboard test data offsets for 2026-03-31 testing session (added tonight's test clicks to existing offsets so real counts display correctly once GA4 ingests)\n- Added GA4 production-only guard: analytics only fires on sparkacademymorton.com, preventing test data pollution on preview deployments and localhost

dashboardga4stagingdevops

2 hrs of Junior Developer work

12:16 AMFeatureComplex

Spark Academy

-Dashboard redesign: replaced 3x3 grid with compact Today's Activity pills (only show non-zero events, tap for Page/Source/# detail)

-Merged today's KV first-party data into historical GA4 conversion cards with +N today green badges

-Added +N today badges to Visitors/Visits/Pages Viewed/Reached Out quick glance cards

-Added fetchTodayOverview GA4 query for today-only visitor/visit/pageview counts

-Real-time email alert to [email protected] when someone taps to call (page + timestamp)

-Multiple layout iterations: pills between realtime panel and range bar, conversion sections back at bottom

-Descriptive pill labels: Requested a Tour, Asked a Question, Started Registration, Clicked to Call, Got Directions, Sent an Email, Viewed Social

-Fixed unescaped apostrophe in Today's Activity JS string that broke all click handlers

-Fixed pill popover z-index overlapping second row and overflowing page edge

-Updated test data offsets for testing session, preserved 1 real phone call

-Added .dev.vars and .wrangler/ to .gitignore

dashboardrealtimeanalyticscloudflare-workeremail-alertsux

32 hrs of Junior Developer work

10:26 PMFeatureComplex

Spark Academy

-Dashboard auto-refresh: added 5-minute full page reload so historical metrics stay current without manual browser refresh\n- Fixed 'Unassigned' source label on conversion cards — now shows 'Direct / Unknown' for unclassified GA4 traffic\n- Built real-time first-party conversion tracking system bypassing GA4's 24-48hr delay: Cloudflare KV namespace (SPARK_EVENTS), shared trackEvent utility, KV writes in all 3 form handlers (tour/question/consulting), new beacon endpoint (POST /api/event) for client-side clicks, source detection cookie (spark_src) with referrer/UTM classification, sendBeacon calls for 6 click events (phone, email, consulting email, address, social, register), 'Today\'s Activity' dashboard section with tap-to-expand page+source detail, 60-second polling updates, 48-hour auto-expiring KV data\n- Upgraded Cloudflare API token to full account access (Workers, KV, D1, Pages, DNS, Cache) so Claude Code can manage all infrastructure without dashboard login

dashboardanalyticscloudflare-kvreal-time-trackingdevops

20 hrs of Junior Developer work

Mar 31, 2026

16 hrs2 sessions

6:35 PMStrategyComplex

Spark Academy

-Created CLAUDE.md for site/ subdirectory with build commands, architecture, CSS patterns, frontmatter reference

-Fixed homepage blue arrows (undefined --sp-muted) and 'View all programs' link to use brand colors (Misty Sage, Mist Teal)

-Audited Google Search Console: diagnosed 48 not-indexed pages, identified old Pixpa URLs still indexed, explained normal new-site behavior

-Submitted 9 URL removal requests in Search Console for old Pixpa URLs (/menu, /reservations, /curriculum, /about, /come-play, /summer-programs, /homeschool, /school-age1, /store)

-Added /store → homepage 301 redirect in _redirects

-Fixed double 301 redirect issue: created 8 Cloudflare Redirect Rules via API so www old-path URLs redirect directly to final destination in single hop

-Built comprehensive backlink strategy document: 7 priority tiers, 50+ specific link opportunities, 4-week execution timeline, Google Reviews plan

seocloudflarebacklinkssearch-consolecss-fixredirects

13 hrs of Junior Developer work

10:00 PMBug FixRoutine

Spark Academy

-Fixed dashboard test offsets: phone_call_click calibrated to 3, register_now_click calibrated to 4

-Added event-specific page name override system (EVENT_PAGE_OVERRIDES) to correct displayed source pages in conversion detail tables

-Phone Call Taps now shows 'Schedule a Tour' instead of 'Homepage'

-Registration Clicks now shows 'Discovery Station' instead of 'After-School Enrichment'

dashboardanalyticsbugfix

3 hrs of Junior Developer work

Apr 1, 2026

14 hrs1 session

11:00 PMStrategyComplex

Spark Academy

-Created CLAUDE.md for site/ subdirectory with build commands, architecture, CSS patterns, frontmatter reference

-Fixed homepage blue arrows (undefined --sp-muted) and View all programs link to use brand colors

-Audited Google Search Console: diagnosed 48 not-indexed pages, identified old Pixpa URLs still indexed

-Submitted 9 URL removal requests in Search Console for old Pixpa URLs

-Added /store → homepage 301 redirect in _redirects

-Fixed double 301 redirect: created 8 Cloudflare Redirect Rules via API for single-hop www redirects

-Built comprehensive backlink strategy: 7 tiers, 50+ link opportunities, 4-week timeline, Google Reviews plan

-Converted backlink strategy to Word doc, updated parent CLAUDE.md with reference

seocloudflarebacklinkssearch-consolecss-fixredirectsdocs

14 hrs of Junior Developer work

Apr 2, 2026

2 hrs2 sessions

1:20 PMBug FixRoutine

Spark Academy

-Standardized address from 'Avenue' to 'Ave' across all live site files to match Google Business Profile (site.json, footer, answer-hub, index, purposeful-play, schedule-tour — 10 instances including display text, Google Maps URLs, and alt text)

seogoogle-business-profileaddressnap-consistency

1 hrs of Junior Developer work

12:07 AMBug FixRoutine

Spark Academy

-Updated address from '1989 North Morton Avenue' to '1989 N Morton Avenue' across entire site to match Google Business Profile\n- Changed display text, Google Maps URLs, alt attributes, and structured data (site.json) across 6 files\n- Verified Google Maps URLs resolve correctly with abbreviated format

seoaddressgoogle-business-profile

1 hrs of Junior Developer work

Apr 3, 2026

8 hrs2 sessions

11:30 AMFeatureModerate

Spark Academy

-Fixed phone_call_click test offset from 8 to 3 — restored 1 real Phone Call Tap on dashboard\n- Added This Year (ytd) date range with year-over-year comparison arrows\n- Built All Time and Year/Year buttons that auto-reveal after 1 year from launch (March 2027)\n- Extracted date-range logic into workers/dashboard-dates.js for testability\n- Added 13 unit tests (vitest) covering all 6 date ranges + auto-reveal timing\n- Added test script to package.json

dashboardanalyticstestingga4

6 hrs of Junior Developer work

9:24 PMBug FixRoutine

Spark Academy

-Fixed duplicate Facebook entries in dashboard 'Where They Found You' chart — GA4 returns separate rows for m.facebook.com, l.facebook.com, facebook.com, lm.facebook.com; added aggregation step after friendlySource() normalization so they combine into a single entry (83+11+3+1 = 98). Deployed to Cloudflare.

dashboardga4cloudflare-workerbugfix

2 hrs of Junior Developer work

Apr 5, 2026

79 hrs4 sessions

2:35 PMFeatureModerate

Spark Academy

-Live audio notifications via Web Audio API: soft sine-wave chime when new visitor arrives, ascending C-E-G-C arpeggio when reached-out action occurs (tour request, phone call, question, etc.)

-Alert banner UX: tap-to-enable flow with friendly copy, collapses to pulsing 'Live alerts on' pill, tap to disable, localStorage persistence, plays preview chime on activation

-AudioContext lifecycle: unlocks on first tap, silent tone for iOS compatibility, resume prompt on page reload

-Replaced 5-minute auto page reload with manual 'Refresh Stats' button to preserve AudioContext indefinitely

-Realtime AJAX refresh (60s) detects visitor count increases and today's conversion increases to trigger sounds

dashboardaudiouxrealtime

7 hrs of Junior Developer work

1:32 PMFeatureComplex

Spark Academy

-Dashboard UX overhaul: center-aligned filter buttons, moved page selector to own section with title/description, friendly date format (April 6, 2026), renamed tabs Overview→Visitors / Funnel→Page Activity, removed redundant select-a-page text from Funnel Overview and Page Comparison

-Email routing: consolidated all form notifications (tour, question, consulting) to [email protected], updated site.json, visible page links, error fallbacks, analytics tracking (consulting email detection now uses data-cta-type attribute)

-CTA type tracking system: new D1 cta_types column, funnel tracker records per-type breakdown (phone, tour-link, primary, register, form-submit, etc.), API aggregates by type, dashboard Visitor Actions shows specific labels (Clicked to Call, Registration Clicks, etc.)

-Added data-cta-type=social to footer social links, data-cta-type=register to afterschool/discovery-station/summer-camp registration buttons

-Fallback for pre-update sessions: shows generic Button Taps when cta_types JSON is empty

-Funnel data floor: queries exclude test data before April 6, 2026

dashboardemailanalyticsd1funnelux

20 hrs of Junior Developer work

2:32 AMFeatureModerate

Spark Academy

-Fixed TEST_OFFSETS double-subtraction after Chesterfield city filter (recalibrated offsets for non-Chesterfield test data)

-Fixed variable hoisting bug causing funnel tab 500 on auto-refresh + parseInt NaN guard

-Added All Pages vs Single Page view (page-level data on All Pages, section-level on filtered page)

-Added PAGE_SECTIONS mapping for 16 pages — funnel shows full page depth including 0-count stages

-Michelle-friendly UX overhaul: human-readable section names (Welcome Banner not Hero), Visited Page/Reached X labels, simpler column headers (Time Spent, Reached, Left Here), < 1s display, plain English descriptions, friendly scroll labels (Top only, Halfway, Most of page, Entire page)

-Stacked funnel bar layout (label above bar) with delta inside / count outside for alignment

-Changed time filters from 7/14/30 Days to Today/This Week/This Month/All Time

-Hidden session counts from page dropdown, added friendly page names

dashboardfunneluxaccessibility

16 hrs of Junior Developer work

8:37 PMFeatureComplex

Spark Academy

-Built full funnel tracker system: client-side JS (IntersectionObserver + sendBeacon), /api/track endpoint, D1 funnel_sessions table, dashboard Funnel tab with funnel chart, section engagement, dropoff report, page comparison, scroll depth

-Added data-section attributes to 25 page templates across 4 page types

-Orchestrated 4 parallel agents in isolated worktrees with zero file overlap

-Fixed tab persistence across dashboard 5-min auto-refresh via URL hash

-Made page dropdown dynamically sorted by session count (most visitors first)

-Added ?notrack opt-out cookie to exclude owner traffic from funnel data (never-expire)

-Added Chesterfield MO to GA4 city exclusion filter for Overview tab

-Added D1 binding to Cloudflare Pages project via API (production + preview)

-Fixed funnel tab 500 error on auto-refresh (var hoisting bug + NaN guard)

funnel-trackingdashboardd1cloudflareanalyticsparallel-agents

37 hrs of Junior Developer work

Apr 6, 2026

7 hrs1 session

8:29 PMStrategyModerate

Spark Academy

-Apple Business Connect: full setup — company account, location (address, hours, phone, website), about description, logo, cover photo, 8 location photos, domain verification via Cloudflare DNS TXT record, EIN verification, submitted for review

-Bing Places: synced from Google Business Profile — all data imported (22 photos, hours, description, social profiles), pending publish (7-12 days)

-Yelp: account created under [email protected], business found and matched, paused at phone verification (Michelle needs to be at school Monday)

-YP.com: confirmed existing listing with correct NAP — backlink value present without claiming

-GBP updates: uploaded building exterior photo (Spark-building-picture.jpeg), uploaded square logomark (751x751 with white padding)

-Cloudflare DNS: added apple-domain-verification TXT record for sparkacademymorton.com

-Updated backlink strategy doc NAP to USPS standard format (1989 N Morton Ave)

-Saved to memory: business hours, EIN, backlink progress tracker, feedback on exact business naming

backlinkslocal-seodirectory-listingsapple-business-connectbing-placesyelpgoogle-business-profilecitations

7 hrs of Junior Developer work

Apr 7, 2026

13 hrs2 sessions

2:48 PMBug FixModerate

Spark Academy

-Fixed XSS: escapeHtml() on attacker-controlled data.page in email template\n- KV-based login rate limit (10 failed attempts per 15min)\n- Rate limits on all 4 form endpoints (5/15min) and event endpoint (30/min)\n- Input truncation (500 chars) on tracking string fields\n- CORS scoped to sparkacademymorton.com on all 5 API endpoints (was wildcard)\n- Sanitized verbose err.message in 3 dashboard error handlers to generic messages\n- Deployed Pages + Worker to production

securityxssrate-limitingcorsinput-validationerror-handling

7 hrs of Junior Developer work

2:52 AMBug FixModerate

Spark Academy

-Moved Live Alerts sound toggle from top to bottom of dashboard — Michelle checks on phone, banner was taking prime mobile real estate\n- Changed default time range from 30 Days to This Year (ytd)\n- Fixed Search Console overview query missing dataState:'all' — was underreporting clicks/impressions by excluding recent days\n- Fixed search queries table sort: primary by clicks desc, secondary by impressions desc\n- Investigated Reached Out count dropping overnight (12→10) — attempted yesterday KV bridge, audited and found double-counting + card inconsistency bugs, rolled back to correct under-report-with-delay approach\n- Established principle: dashboard must under-report with delay rather than over-report false data

dashboardanalyticsmobile-uxsearch-consoledata-integrity

6 hrs of Junior Developer work