Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
BrightonSEO October 2024 - How to Speed Up Cont...
Search
Jonathon Roberts
October 02, 2024
Marketing & SEO
3
760
BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT
Jonathon Roberts
October 02, 2024
Tweet
Share
More Decks by Jonathon Roberts
See All by Jonathon Roberts
How to Use AI to harness Google APIs
jonathonrobertsseo
0
670
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
jonathonrobertsseo
0
42
Other Decks in Marketing & SEO
See All in Marketing & SEO
The untapped power of vector embeddings
frankvandijk
0
1k
A Friggin' Sweet Insider Guide to Google Sheets for SEO
greggifford
PRO
2
570
Beyond Algorithms: customer-centric SEO as the key to long-term success
julianhooks
0
200
Tactics vs strategy: why SEO’s shouldn’t focus on industries
petervz
0
250
Product Page Optimization (BrightonSEO April 2025)
gabitroxler
0
400
Data Driven SEO: A Framework Based Approach
knagayama
0
280
GA4 Standard (Free) vs GA4 360 (Enterprise)
kieramonaghan
1
450
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
akashhashmi
0
130
BrightonSEO: Advanced SEO techniques with .htaccess
jancaerels
1
400
企業がより良い取引のためにImmediate Edgeーションを活用するには?
davidmurray
0
140
Manchester DM - How eCommerce Faceted Navigation can either Supercharge or Sabotage SEO
chrisleverseo
0
110
JAWS-UG のご紹介 - JAWS-UG沖縄 AWS 初心者さん、ようこそ! in うるま
awsjcpm
0
110
Featured
See All Featured
Docker and Python
trallard
44
3.5k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
657
60k
Code Reviewing Like a Champion
maltzj
524
40k
Designing for Performance
lara
609
69k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
281
13k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.6k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
357
30k
Typedesign – Prime Four
hannesfritz
42
2.7k
How GitHub (no longer) Works
holman
314
140k
Agile that works and the tools we love
rasmusluckow
329
21k
The World Runs on Bad Software
bkeepers
PRO
69
11k
Transcript
How to Speed Up Content Audits using ChatGPT Jonathon Roberts
Fly High Media linkedin.com/in/jonathon-roberts-seo/ @jonathonrseo speakerdeck.com/jonathonrobertsseo/
Who uses ChatGPT? #BrightonSEO @jonathonrseo
Who does Content Audits? #BrightonSEO @jonathonrseo
Who uses ChatGPT to audit content? #BrightonSEO @jonathonrseo
Tools Google Sheets ChatGPT 4o + #BrightonSEO @jonathonrseo + App
Scripts
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
What are Google App Scripts? #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
What can be imported? #BrightonSEO @jonathonrseo
Meta Data #BrightonSEO @jonathonrseo
Canonical Tag #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Schema Markup #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Published Date #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Last Modified Date #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Author #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Article Tags and Category #BrightonSEO @jonathonrseo
Headings (H1, H2, etc.) #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Word Count #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Internal & External Links #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Blocked by Robots.txt? #BrightonSEO @jonathonrseo
Tracking Code Present on Page #BrightonSEO @jonathonrseo
Number of Images #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Image File Size #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Image Format (WebP, JPG, PNG, etc.) #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Backlink Data #BrightonSEO @jonathonrseo
Search Console / Bing Webmaster Tools Data #BrightonSEO @jonathonrseo #BrightonSEO
@jonathonrseo
GA4 Metrics #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Page Speed & Core Web Vitals #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Google Business Profile API #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Other APIs #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Why not use other similar tools? #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
It’s Slower #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
It Can Be More Costly #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
It’s Less Flexible & Customisable #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Let’s start generating Google Apps Scripts #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Let’s extract the site URLs #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Screaming Frog
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo XML Sitemap URL Extractor
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
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
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
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo CMD + V / CTRL + V #BrightonSEO
@jonathonrseo
#BrightonSEO @jonathonrseo Organise into Files #BrightonSEO @jonathonrseo
Deploy the code #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Deploy the code #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
New deployment #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Select Web App #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Select Web App #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Then click deploy #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Run the Formula #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Paste as Plain Text #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Ctrl +
Shift + V CMD + Shift + V
#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.
Some Issues You May Come Across #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Tell ChatGPT “I don't want to run the script I
want to create a formula” #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Incorrect Format #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Tell ChatGPT to: “Split into two columns, for internal &
external links” #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Content not found #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Finding Content sections in HTML #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo
Key Takeaway 1: #BrightonSEO @jonathonrseo Boosts Efficiency #BrightonSEO @jonathonrseo
Key Takeaway 2: #BrightonSEO @jonathonrseo Improved Accuracy & Consistency #BrightonSEO
@jonathonrseo
Key Takeaway 3: #BrightonSEO @jonathonrseo Customisable & Scalable Solutions #BrightonSEO
@jonathonrseo
Key Takeaway 4: #BrightonSEO @jonathonrseo Time to focus on other
tasks #BrightonSEO @jonathonrseo
Key Takeaway 5: #BrightonSEO @jonathonrseo Easy to use #BrightonSEO @jonathonrseo
Key Takeaway 6: #BrightonSEO @jonathonrseo Have a go for yourself!
#BrightonSEO @jonathonrseo
Get Access to the Slides #BrightonSEO @jonathonrseo speakerdeck.com/jonathonrobertsseo #BrightonSEO @jonathonrseo
Bonus: SOP Document #BrightonSEO @jonathonrseo bit.ly/jonathon-brightonseo #BrightonSEO @jonathonrseo
If you have any further questions? linkedin.com/in/jonathon-roberts-seo/ @jonathonrseo