Joao Filipe Pereira - Predicting Core Web Vitals impact using Google Sheets [BrightonSEO April 2025]

Transcript

2. CORE WEB VITALS The first ranking factor that webmasters can measure* *Not technically true
10. https://www.advancedwebranking.com/blog/core-web-vitals-study Only 39% of analysed web pages passed the Core Web Vitals metrics, while the other 61% were below the threshold.
14. “Google says it’s for a better web…” “Core Web Vitals! Core Web Vitals everywhere!”
16. NO CONTENT STRATEGY? THOU SHALL NOT PASS!
19. How does my page’s performance on Google change depending on its Core Web Vitals scores? How does my page’s performance on Google change depending on its Core Web Vitals scores?
21. Phase One: Learning & Testing
22. What Worked What Didn’t Work No visible correlation Inconsistent data I had a chart with lines
23. Refined page groupings to ensure all pages shared a consistent user intent, improving data relevance and accuracy. Validated that pages within each group had overlapping organic competitors, confirming they competed in similar SERPs. Corrected the calculation of the 75th percentile to accurately reflect Core Web Vitals performance across page groups. 3 Actions
24. Phase Two: Testing
25. Phase Two: Testing
27. Exclude Branded Keywords: Including them can introduce noise and skew the analysis. Conduct Weekly Analyses: Weekly tracking provides more reliable insights than a monthly review. Avoid Simplistic Groupings: Do not categorise performance as just “3 greens” vs. “everything else” 3 (More) Actions
28. Phase Three: Insights
32. CWV CTR
33. Tracking Core Web Vitals with Google Sheets Henry Price
34. Step By Step
36. =IF(C6<>"", IF(COUNTIFS(A:A, A6, B:B, B6, E:E, E6, J:J, J6) = COUNTIFS(A:A, A6, B:B, B6, E:E, E6), J6, IF(COUNTIFS(A:A, A6, B:B, B6, E:E, E6, J:J, "RED")>0, "RED", IF(COUNTIFS(A:A, A6, B:B, B6, E:E, E6, J:J, "YELLOW")>0, "YELLOW", "GREEN") ) ), "")
37. Google Search Console Data
39. What’s Next?
41. Links to the Googlesheets • https://tinyurl.com/historyapi • https://tinyurl.com/CWVapiCTR
42. Thank you! Available on Amazon