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
43
Other Decks in Marketing & SEO
See All in Marketing & SEO
How AI ‘’reads’’ content for real (for newbies and not so newbies)
gfiorelli1
0
120
SERP Conf. Vienna - Web Accessibility: Optimizing for Inclusivity and SEO
sarafernandezseo
1
1.2k
JAWS-UGとは -JAWS-UG茨城支部#0勉強会-
awsjcpm
0
130
BrightonSEO April 2025: XML Sitemaps + Hreflang For E-Commerce
nmsamuel
1
160
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
aleyda
2
6.2k
Search Marketing Connect - SXO: Cos’è la Search Experience Optimization? - #SMConnect
sarafernandezseo
0
100
Evidence-Based Management in SEO: Improving Value Delivery Under Uncertainty
rubenremy
0
250
Google Tag Manager tips that will elevate your analytics game
krmdigitaluk
1
290
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
akashhashmi
0
130
Unlocking SEO wins with Cloudflare workers: no devs required!
chrisleverseo
1
350
Smarter Search Strategies: Diversifying Ad Platforms in the Age of AI
yourppcdoc
1
130
企業がより良い取引のためにImmediate Edgeーションを活用するには?
davidmurray
0
140
Featured
See All Featured
Site-Speed That Sticks
csswizardry
10
680
Speed Design
sergeychernyshev
32
1k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.4k
Stop Working from a Prison Cell
hatefulcrawdad
270
21k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
950
Rails Girls Zürich Keynote
gr2m
94
14k
How to train your dragon (web standard)
notwaldorf
94
6.1k
Measuring & Analyzing Core Web Vitals
bluesmoon
7
510
Rebuilding a faster, lazier Slack
samanthasiow
82
9.1k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.4k
Build your cross-platform service in a week with App Engine
jlugia
231
18k
Documentation Writing (for coders)
carmenintech
72
4.9k
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