Scouting report: opponent offense
An interactive scouting report with top tells, filters, formation tendencies, a field position chart and a play log.
Read the full prompt
You're a data analyst for a high school football defensive staff. I've attached a Hudl playlist export (Excel) of [OPPONENT]'s offense. Build me an interactive scouting report as a single HTML artifact. STEP 1: CLEAN AND CHECK THE DATA FIRST - Look at every column before doing anything. Tell me in the report's Notes which columns exist and which are missing (gain/loss, personnel, run direction, motion, etc.). - Use only offensive clips. Split games in the order they appear in the export and label them G1, G2, G3... - Exclude timeouts and pre-snap / no-play penalties. Keep plays with a penalty on the play in all run/pass splits. - If there's no gain/loss column, estimate each play's yards from the change in ball spot to the next snap of the same drive, checked against the next down and distance. Touchdowns count the distance to the goal line. Incompletions and interceptions count zero. Plays with a penalty, fumble, or no next snap get no yardage. Report how many snaps couldn't be measured. - Flag anything that looks inconsistent, such as one game using different formation names (possibly a different tagging staff), untagged formations, or odd plays like possible fakes. STEP 2: HEADER Opponent name, number of games, total snaps (runs and passes), offensive TDs, and the export file name and date. STEP 3: TOP TELLS 6 to 8 cards for the strongest tendencies across all games. Each card has: - A short label (e.g. "Red zone", "Formation", "Sequence") - One big stat (e.g. "89% run inside the 20") - The raw count behind it (e.g. "25 of 28") plus one or two sentences of context - A one-line "Defend it" coaching point telling my defense what to do Cover at minimum: overall run/pass, red zone, formation strength to the field vs. boundary, the most run-heavy formation, the most pass-heavy formation, 2nd-down call after a 1st-down run vs. after a 1st-down pass, shot plays/verticals, and 4th-down behavior. Then a "More keys" list of 6 to 10 shorter one-line findings (screens, rollouts, explosive plays, how they react to blitzes, how they open games, where turnovers happen, 3rd and long runs, etc.). STEP 4: SITUATIONAL FILTERS Filter buttons for: Game (All/G1/G2...), Down, Yards to go (1-3, 4-6, 7+), Hash (L/M/R), Play type (Run/Pass), Field position (backed up own 1-20, own 21-50, plus territory opp 49-21, red zone opp 20-goal), and Formation. Show a live snap count and a Reset button. Every table and chart below must re-count from the filtered plays. STEP 5: SECTIONS (each one responds to the filters) - Down & distance: run/pass split by situation, with the formations and pass calls they lean on in each. - Formations: every formation exactly as tagged, snaps, run %, pass %, % of strength set to the field (only counting snaps off a hash), and a G1/G2/G3... column showing usage by game. - Field position: a chart of every snap at the yard line it was run from, offense driving left to right, one lane per down, run and pass in different colors. Hover or tap a dot to see the play. Nudge dots so they don't overlap. - Hash & strength: run/pass by hash, and by strength side (field vs. boundary). The field is the wide side of the hash. - Pass game: pass calls grouped by concept, the routes tagged most (share of pass calls that include each route), and repeat calls. - 3rd & 4th down: 3rd down by yards to go with conversion rate, and a table of every 4th-down snap. - Play log: every snap matching the filters, sortable by clicking column headers. STEP 6: NOTES - How yards were estimated and how many snaps have no yardage - Definitions: Success = 40% of needed yards on 1st, 60% on 2nd, a conversion on 3rd or 4th. Explosive = run of 10+ or pass of 15+. Yards per dropback includes sacks and scrambles. - What was included and excluded, with counts - What this data can't show (e.g. run direction, schemes, personnel, if untagged) - Things to double-check on film RULES - Every number in the report must be checkable with the filters. Show raw counts next to percentages. - Label any tendency based on fewer than 8 plays as a small sample. - Plain coaching language. No filler. - Clean, readable design with a tab or jump menu for the sections, and it should work on a phone.
Sunday Night Film