Every aggregate table behind the Speak Better Spanish research series, in one place. Copy any of it, chart it, quote it. The only thing we ask is attribution to Speak Better Spanish and a link to the study it came from.
Each table below carries the source system and the window it covers. The raw comma separated version sits underneath each table, ready to paste into a spreadsheet. Nothing here is gated and there is no form.
Back to the research hub.
Click-through rate by query shape
95,086 Google queries sorted into five shapes, with impressions, clicks, click-through rate and median position.
| query shape | queries | impressions | clicks | ctr pct | median position |
|---|---|---|---|---|---|
| comparison | 2153 | 150566 | 1276 | 0.847 | 5.55 |
| meaning | 10468 | 1310033 | 2005 | 0.153 | 2.86 |
| question | 16932 | 1021268 | 1495 | 0.146 | 4.0 |
| other | 49342 | 2328116 | 3282 | 0.141 | 2.33 |
| translation | 16187 | 2214930 | 2701 | 0.122 | 3 |
Speak Better Spanish original data, speakbetterspanish.com. Google Search Console, February 4 2026 to September 18 2026. Free to reuse with attribution and a link to https://speakbetterspanish.com/research/
Raw CSV
query_shape,queries,impressions,clicks,ctr_pct,median_position comparison,2153,150566,1276,0.847,5.55 meaning,10468,1310033,2005,0.153,2.86 question,16932,1021268,1495,0.146,4.0 other,49342,2328116,3282,0.141,2.33 translation,16187,2214930,2701,0.122,3
Click-through rate by average position
The same query set grouped by the average position we held, from the top three down.
| position band | queries | impressions | clicks | ctr pct |
|---|---|---|---|---|
| 1.0 to 3.0 | 46512 | 628901 | 3187 | 0.507 |
| 3.0 to 5.0 | 12928 | 855628 | 3110 | 0.363 |
| 5.0 to 10.0 | 15163 | 4858866 | 4243 | 0.087 |
| 10.0 to 20.0 | 10327 | 582347 | 203 | 0.035 |
| 20.0 and lower | 10156 | 99589 | 49 | 0.049 |
Speak Better Spanish original data, speakbetterspanish.com. Google Search Console, February 4 2026 to September 18 2026. Free to reuse with attribution and a link to https://speakbetterspanish.com/research/
Raw CSV
position_band,queries,impressions,clicks,ctr_pct 1.0 to 3.0,46512,628901,3187,0.507 3.0 to 5.0,12928,855628,3110,0.363 5.0 to 10.0,15163,4858866,4243,0.087 10.0 to 20.0,10327,582347,203,0.035 20.0 and lower,10156,99589,49,0.049
The biggest zero-click queries
Every query above 10,000 impressions whose click-through rate came in under 0.1%.
| query | impressions | clicks | ctr pct | average position | shape |
|---|---|---|---|---|---|
| now in spanish | 156307 | 45 | 0.029 | 5.2 | translation |
| right in spanish | 111646 | 17 | 0.015 | 9.5 | translation |
| morning in spanish | 101686 | 13 | 0.013 | 9.2 | translation |
| nada meaning | 99794 | 8 | 0.008 | 9.8 | meaning |
| me gusta | 94596 | 29 | 0.031 | 8.5 | other |
| family in spanish | 90059 | 31 | 0.034 | 8.6 | translation |
| me gusta meaning | 81814 | 18 | 0.022 | 7.1 | meaning |
| no problem in spanish | 74577 | 11 | 0.015 | 9.0 | translation |
| nothing in spanish | 65213 | 12 | 0.018 | 6.7 | translation |
| i know in spanish | 59043 | 27 | 0.046 | 8.1 | translation |
| derecha in english | 49899 | 15 | 0.03 | 5.8 | other |
| tomorrow in spanish | 47842 | 3 | 0.006 | 9.6 | translation |
| andale meaning | 44681 | 23 | 0.051 | 6.2 | meaning |
| su | 36957 | 5 | 0.014 | 3.6 | other |
| nada in english | 34988 | 1 | 0.003 | 7.5 | other |
| to watch in spanish | 30676 | 17 | 0.055 | 7.5 | translation |
| derecha | 30199 | 7 | 0.023 | 8.1 | other |
| left and right in spanish | 29150 | 8 | 0.027 | 9.8 | translation |
| happy easter in spanish | 28983 | 7 | 0.024 | 2.4 | translation |
| no mames in english | 27370 | 25 | 0.091 | 4.6 | other |
Speak Better Spanish original data, speakbetterspanish.com. Google Search Console, February 4 2026 to September 18 2026. Free to reuse with attribution and a link to https://speakbetterspanish.com/research/
Raw CSV
query,impressions,clicks,ctr_pct,average_position,shape now in spanish,156307,45,0.029,5.2,translation right in spanish,111646,17,0.015,9.5,translation morning in spanish,101686,13,0.013,9.2,translation nada meaning,99794,8,0.008,9.8,meaning me gusta,94596,29,0.031,8.5,other family in spanish,90059,31,0.034,8.6,translation me gusta meaning,81814,18,0.022,7.1,meaning no problem in spanish,74577,11,0.015,9.0,translation nothing in spanish,65213,12,0.018,6.7,translation i know in spanish,59043,27,0.046,8.1,translation derecha in english,49899,15,0.03,5.8,other tomorrow in spanish,47842,3,0.006,9.6,translation andale meaning,44681,23,0.051,6.2,meaning su,36957,5,0.014,3.6,other nada in english,34988,1,0.003,7.5,other to watch in spanish,30676,17,0.055,7.5,translation derecha,30199,7,0.023,8.1,other left and right in spanish,29150,8,0.027,9.8,translation happy easter in spanish,28983,7,0.024,2.4,translation no mames in english,27370,25,0.091,4.6,other
Class continuation rates
Of the students who reached each class number, the share who took the next one.
| class number | students reaching | continued to next | continuation rate pct |
|---|---|---|---|
| 1 | 67 | 58 | 86.6 |
| 2 | 58 | 55 | 94.8 |
| 3 | 55 | 53 | 96.4 |
| 4 | 53 | 48 | 90.6 |
| 5 | 48 | 44 | 91.7 |
| 6 | 44 | 43 | 97.7 |
| 7 | 43 | 40 | 93.0 |
| 8 | 40 | 38 | 95.0 |
| 9 | 38 | 37 | 97.4 |
| 10 | 37 | 34 | 91.9 |
| 11 | 34 | 34 | 100.0 |
| 12 | 34 | 33 | 97.1 |
| 13 | 33 | 33 | 100.0 |
| 14 | 33 | 31 | 93.9 |
| 15 | 31 | 30 | 96.8 |
| 16 | 30 | 29 | 96.7 |
| 17 | 29 | 29 | 100.0 |
| 18 | 29 | 28 | 96.6 |
| 19 | 28 | 27 | 96.4 |
| 20 | 27 | 25 | 92.6 |
Speak Better Spanish class ledger, January 6 2020 to July 24 2026.
Raw CSV
class_number,students_reaching,continued_to_next,continuation_rate_pct 1,67,58,86.6 2,58,55,94.8 3,55,53,96.4 4,53,48,90.6 5,48,44,91.7 6,44,43,97.7 7,43,40,93.0 8,40,38,95.0 9,38,37,97.4 10,37,34,91.9 11,34,34,100.0 12,34,33,97.1 13,33,33,100.0 14,33,31,93.9 15,31,30,96.8 16,30,29,96.7 17,29,29,100.0 18,29,28,96.6 19,28,27,96.4 20,27,25,92.6
Students by classes taken
How our 67 students distribute across class counts.
| classes taken | students |
|---|---|
| 100+ | 3 |
| 50-99 | 8 |
| 20-49 | 16 |
| 10-19 | 10 |
| 5-9 | 11 |
| 2-4 | 10 |
| 1 | 9 |
Speak Better Spanish class ledger, January 6 2020 to July 24 2026, 67 students, 1,896 classes. Attribution: https://speakbetterspanish.com/research/
Raw CSV
classes_taken,students 100+,3 50-99,8 20-49,16 10-19,10 5-9,11 2-4,10 1,9
Learner sticking points
27 topics coded across 113 one-to-one class sessions with 16 adult learners.
| topic | sessions | pct of sessions | distinct students | sessions with a confusion marker |
|---|---|---|---|---|
| Mexican and regional usage | 52 | 46.0 | 15 | 52 |
| conversation confidence | 42 | 37.2 | 11 | 42 |
| pronunciation and accents | 80 | 70.8 | 10 | 79 |
| listening speed | 40 | 35.4 | 10 | 40 |
| vocabulary gaps (how do you say) | 54 | 47.8 | 9 | 54 |
| preterite vs imperfect | 28 | 24.8 | 8 | 27 |
| stem changing verbs | 26 | 23.0 | 7 | 26 |
| reflexive verbs | 21 | 18.6 | 7 | 20 |
| medical and workplace Spanish | 67 | 59.3 | 6 | 67 |
| numbers and telling time | 51 | 45.1 | 5 | 51 |
| subjunctive | 28 | 24.8 | 5 | 28 |
| ser vs estar | 13 | 11.5 | 5 | 13 |
| tener idioms | 11 | 9.7 | 5 | 11 |
| gender and agreement | 30 | 26.5 | 4 | 30 |
| commands and imperative | 10 | 8.8 | 4 | 10 |
| false friends and lookalikes | 9 | 8.0 | 4 | 9 |
| future and ir a | 9 | 8.0 | 4 | 9 |
| haber and hay | 8 | 7.1 | 4 | 8 |
| tu vs usted (formality) | 16 | 14.2 | 3 | 16 |
| object pronouns (le, lo, se) | 12 | 10.6 | 3 | 11 |
| prepositions | 12 | 10.6 | 3 | 12 |
| gustar-type verbs | 8 | 7.1 | 3 | 7 |
| question words | 6 | 5.3 | 3 | 6 |
| por vs para | 3 | 2.7 | 2 | 3 |
| present perfect | 3 | 2.7 | 2 | 3 |
| saber vs conocer | 2 | 1.8 | 2 | 2 |
| adjective placement | 3 | 2.7 | 1 | 3 |
Speak Better Spanish class summary corpus, 113 one to one sessions, 23 adult learners, January 2025 to September 2026.
Raw CSV
topic,sessions,pct_of_sessions,distinct_students,sessions_with_a_confusion_marker Mexican and regional usage,52,46.0,15,52 conversation confidence,42,37.2,11,42 pronunciation and accents,80,70.8,10,79 listening speed,40,35.4,10,40 vocabulary gaps (how do you say),54,47.8,9,54 preterite vs imperfect,28,24.8,8,27 stem changing verbs,26,23.0,7,26 reflexive verbs,21,18.6,7,20 medical and workplace Spanish,67,59.3,6,67 numbers and telling time,51,45.1,5,51 subjunctive,28,24.8,5,28 ser vs estar,13,11.5,5,13 tener idioms,11,9.7,5,11 gender and agreement,30,26.5,4,30 commands and imperative,10,8.8,4,10 false friends and lookalikes,9,8.0,4,9 future and ir a,9,8.0,4,9 haber and hay,8,7.1,4,8 tu vs usted (formality),16,14.2,3,16 "object pronouns (le, lo, se)",12,10.6,3,11 prepositions,12,10.6,3,12 gustar-type verbs,8,7.1,3,7 question words,6,5.3,3,6 por vs para,3,2.7,2,3 present perfect,3,2.7,2,3 saber vs conocer,2,1.8,2,2 adjective placement,3,2.7,1,3
YouTube comment types
437 viewer comments tallied into eight keyword buckets.
| bucket | comments | pct of viewer comments |
|---|---|---|
| question | 62 | 14.2 |
| asks_how_to_say | 5 | 1.1 |
| comparison_or_confusion | 25 | 5.7 |
| regional_variation | 28 | 6.4 |
| native_or_correction | 20 | 4.6 |
| praise | 148 | 33.9 |
| request_for_content | 5 | 1.1 |
| learner_context | 18 | 4.1 |
| pronunciation | 21 | 4.8 |
Speak Better Spanish YouTube channel, 437 viewer comments across 157 public videos, pulled September 20 2026.
Raw CSV
bucket,comments,pct_of_viewer_comments question,62,14.2 asks_how_to_say,5,1.1 comparison_or_confusion,25,5.7 regional_variation,28,6.4 native_or_correction,20,4.6 praise,148,33.9 request_for_content,5,1.1 learner_context,18,4.1 pronunciation,21,4.8
Recent Comments