Upgrade to Pro — share decks privately, control downloads, hide ads and more …

BrightonSEO October 2024 - How to Speed Up Cont...

Avatar for Jonathon Roberts Jonathon Roberts
October 02, 2024
Marketing & SEO
3
830

BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT

Avatar for Jonathon Roberts

Jonathon Roberts

October 02, 2024
Tweet

More Decks by Jonathon Roberts

See All by Jonathon Roberts
How to Use AI to harness Google APIs
Avatar for Jonathon Roberts jonathonrobertsseo
0
800
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
Avatar for Jonathon Roberts jonathonrobertsseo
0
55

Other Decks in Marketing & SEO

See All in Marketing & SEO
会社説明資料｜株式会社トライバルメディアハウス
Avatar for 株式会社トライバルメディアハウス tribal
0
3.5k
Spotlight: CTRL+C CTRL+V ≠ Trust: Scaling SEO for international success
Avatar for Linda Hogenes lindahogenes
0
910
0-Click SEO. How to optimize for visibility, awareness and memorability.
Avatar for gianluca fiorelli gfiorelli1
0
240
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
1
1.4k
Stop paying twice: how to eliminate search cannibalisation and maximise ROI - BrightonSEO x Hero Conf UK - April 2025
Avatar for Chris Ridley c_j_ridley
1
410
Sitekwaliteit is dé nr. 1 ranking factor - Eduard Blacquière - SEO Benelux meetup (mei 2025)
Avatar for SEO Pro Academy seoproacademy
0
170
「発表する登壇」から「伝わる登壇」へ ─ 思いやりの「テクニック489」とは？
Avatar for wataru yamazaki (DevRel) wyamazak_devrel
3
670
SEO Benelux Conf - Automating Technical SEO on a low budget
Avatar for Jan Caerels jancaerels
0
150
It's ALL AI search: Building a unified view for growth
Avatar for Ray Grieselhuber raygrieselhuber
PRO
0
560
How to win in AI Search with Ahrefs
Avatar for Andrei andreitit
0
1.3k
How to build an LLM SEO readiness audit: a practical framework
Avatar for Nick Samuel nmsamuel
1
530
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
Avatar for Akash Hashmi akashhashmi
0
160

Featured

See All Featured
Code Review Best Practice
Avatar for Trisha Gee trishagee
72
19k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
37
2.6k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
127
54k
BBQ
Avatar for Matthew Crist matthewcrist
89
9.9k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
54
7.9k
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
220k
[RailsConf 2023 Opening Keynote] The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
31
9.7k
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
49
3.1k
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
302
51k
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
52
5.7k
A designer walks into a library…
Avatar for Paul Jervis Heath pauljervisheath
209
24k
Distributed Sagas: A Protocol for Coordinating Microservices
Avatar for Caitie McCaffrey caitiem20
333
22k

Transcript

  1. How to Speed Up Content Audits using ChatGPT Jonathon Roberts

    Fly High Media linkedin.com/in/jonathon-roberts-seo/ @jonathonrseo speakerdeck.com/jonathonrobertsseo/

  2. Who uses ChatGPT? #BrightonSEO @jonathonrseo

  3. Who does Content Audits? #BrightonSEO @jonathonrseo

  4. Who uses ChatGPT to audit content? #BrightonSEO @jonathonrseo

  5. Tools Google Sheets ChatGPT 4o + #BrightonSEO @jonathonrseo + App

    Scripts

  6. #BrightonSEO @jonathonrseo

  7. #BrightonSEO @jonathonrseo

  8. #BrightonSEO @jonathonrseo

  9. #BrightonSEO @jonathonrseo

  10. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  11. What are Google App Scripts? #BrightonSEO @jonathonrseo

  12. #BrightonSEO @jonathonrseo

  13. #BrightonSEO @jonathonrseo

  14. #BrightonSEO @jonathonrseo

  15. What can be imported? #BrightonSEO @jonathonrseo

  16. Meta Data #BrightonSEO @jonathonrseo

  17. Canonical Tag #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  18. Schema Markup #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  19. Published Date #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  20. Last Modified Date #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  21. Author #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  22. Article Tags and Category #BrightonSEO @jonathonrseo

  23. Headings (H1, H2, etc.) #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  24. Word Count #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  25. Internal & External Links #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  26. Blocked by Robots.txt? #BrightonSEO @jonathonrseo

  27. Tracking Code Present on Page #BrightonSEO @jonathonrseo

  28. Number of Images #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  29. Image File Size #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  30. Image Format (WebP, JPG, PNG, etc.) #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  31. Backlink Data #BrightonSEO @jonathonrseo

  32. Search Console / Bing Webmaster Tools Data #BrightonSEO @jonathonrseo #BrightonSEO

    @jonathonrseo

  33. GA4 Metrics #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  34. Page Speed & Core Web Vitals #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  35. Google Business Profile API #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  36. Other APIs #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  37. Why not use other similar tools? #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  38. It’s Slower #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  39. It Can Be More Costly #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  40. It’s Less Flexible & Customisable #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  41. Let’s start generating Google Apps Scripts #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  42. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  43. Let’s extract the site URLs #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  44. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Screaming Frog

  45. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo XML Sitemap URL Extractor

  46. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  47. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  48. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  49. Create a Google Script formula that extracts the [Insert What

    You Want to Extract] from a URL that is in a cell in Google Sheets #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  50. Create a Google Script formula that extracts the Meta Title

    from a URL that is in a cell in Google Sheets #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  51. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  52. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  53. #BrightonSEO @jonathonrseo CMD + V / CTRL + V #BrightonSEO

    @jonathonrseo

  54. #BrightonSEO @jonathonrseo Organise into Files #BrightonSEO @jonathonrseo

  55. Deploy the code #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  56. Deploy the code #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  57. New deployment #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  58. Select Web App #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  59. Select Web App #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  60. Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  61. Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  62. Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  63. Then click deploy #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  64. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  65. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  66. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  67. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  68. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  69. Run the Formula #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  70. Paste as Plain Text #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Ctrl +

    Shift + V CMD + Shift + V

  71. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Audit Actionables “Summarise the actionables from

    the audit” and let ChatGPT know what actionables can come from the audit and what it needs to look for from the data extracted.

  72. Some Issues You May Come Across #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  73. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  74. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  75. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  76. Tell ChatGPT “I don't want to run the script I

    want to create a formula” #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  77. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  78. Incorrect Format #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  79. Tell ChatGPT to: “Split into two columns, for internal &

    external links” #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  80. Content not found #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  81. Finding Content sections in HTML #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  82. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  83. Key Takeaway 1: #BrightonSEO @jonathonrseo Boosts Efficiency #BrightonSEO @jonathonrseo

  84. Key Takeaway 2: #BrightonSEO @jonathonrseo Improved Accuracy & Consistency #BrightonSEO

    @jonathonrseo

  85. Key Takeaway 3: #BrightonSEO @jonathonrseo Customisable & Scalable Solutions #BrightonSEO

    @jonathonrseo

  86. Key Takeaway 4: #BrightonSEO @jonathonrseo Time to focus on other

    tasks #BrightonSEO @jonathonrseo

  87. Key Takeaway 5: #BrightonSEO @jonathonrseo Easy to use #BrightonSEO @jonathonrseo

  88. Key Takeaway 6: #BrightonSEO @jonathonrseo Have a go for yourself!

    #BrightonSEO @jonathonrseo

  89. Get Access to the Slides #BrightonSEO @jonathonrseo speakerdeck.com/jonathonrobertsseo #BrightonSEO @jonathonrseo

  90. Bonus: SOP Document #BrightonSEO @jonathonrseo bit.ly/jonathon-brightonseo #BrightonSEO @jonathonrseo

  91. If you have any further questions? linkedin.com/in/jonathon-roberts-seo/ @jonathonrseo