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
770

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
700
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
Avatar for Jonathon Roberts jonathonrobertsseo
0
44

Other Decks in Marketing & SEO

See All in Marketing & SEO
Stop guessing, start winning: predicting winning products with PMax & Search
Avatar for Indi inders
1
100
Momentum: how publishing and updating frequency impact SEO - BrightonSEO April 2025
Avatar for Pontus Vippelius pontusvippelius
0
260
Digital PR's Dirty Little Secret: Most of the Links You're Earning Have No Impact on Metrics That Actually Matter
Avatar for James Brockbank brockbankjames
PRO
0
310
Smarter Search Strategies: Diversifying Ad Platforms in the Age of AI
Avatar for Serge Nguele yourppcdoc
1
140
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
Avatar for Akash Hashmi akashhashmi
0
130
Perfekte Prompts für ChatGPT & Co.: Wie du KI-Tools optimal nutzt
Avatar for Kai Spriestersbach kaispriestersbach
0
160
Return On Time Invested
Avatar for Ian Lurie portentint
PRO
0
190
From Search Rankings to Answer Synthesis - How to Weather The AI Storm
Avatar for Dawn Anderson dawnieando
0
230
0-Click SEO. How to optimize for visibility, awareness and memorability.
Avatar for gianluca fiorelli gfiorelli1
0
220
Scaling AI on a budget - responsibly!
Avatar for Emina Demiri-Watson eminadw
3
460
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
300
CMO's Guide to Winning in AI Search with Ahrefs
Avatar for Andrei andreitit
0
1.1k

Featured

See All Featured
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
110
19k
Balancing Empowerment & Direction
Avatar for Lara Hogan lara
1
510
Reflections from 52 weeks, 52 projects
Avatar for Jefferson Lam jeffersonlam
351
21k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
235
140k
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.2k
Faster Mobile Websites
Avatar for Dean Hume deanohume
308
31k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
30
2.2k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
45
7.5k
Done Done
Avatar for chrislema chrislema
184
16k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
179
9.8k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
10
1k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
35
2.5k

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