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

Other Decks in Marketing & SEO

See All in Marketing & SEO
勉強会から始まった僕のDevRel~新卒エンジニアがつないだ2年間の軌跡~
Avatar for uutan1108 ohmori_yusuke
1
260
BrightonSEO - Matt Beswick
Avatar for Matthew Beswick bezz1234
0
180
RPO協業プラン「ななごーRPOパートナー」ご紹介資料 / nanago_rpo
Avatar for 株式会社ななごー nanago
0
120
From Search Rankings to Answer Synthesis - How to Weather The AI Storm
Avatar for Dawn Anderson dawnieando
0
250
How to win in AI Search with Ahrefs
Avatar for Andrei andreitit
0
1.3k
Brand Signals Will Decide Your Visibility in AI-Powered Search; Where to Double Down.
Avatar for James Brockbank brockbankjames
PRO
0
200
Humanistic SEO | brightonSEO | Megan Roberts
Avatar for Megan Roberts meganjane
0
320
GEO? AEO? LLMO? What's With All This AI Stuff? - Patrick Stox Ahrefs Evolve 2025
Avatar for Patrick Stox patrickstox
2
3.3k
3つの事例から考える広報 AI活用と勘所 / AI in Public Relations Key Insights from Three Case Studies
Avatar for ShuzoN shuzon
0
400
BrightonSEO San Diego 2025: Upskilling SEOs for Success in the Age of AI
Avatar for Natasha Burtenshaw-deVries natasha_bd
0
300
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
Avatar for Aleyda Solis aleyda
2
8.3k
How Search Happens: Before & After you Click Enter @ SearchAfricon
Avatar for davetheseo davetheseo
0
180

Featured

See All Featured
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
514
110k
Music & Morning Musume
Avatar for Bryan Veloso bryan
46
6.9k
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
55
9.1k
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
1.7k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
185
22k
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
10
890
A better future with KSS
Avatar for Kyle Neath kneath
239
18k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
347
40k
Agile that works and the tools we love
Avatar for Rasmus Luckow-Nielsen rasmusluckow
331
21k
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
280
24k
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
40
2.1k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
5.8k

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