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
830
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
780
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
jonathonrobertsseo
0
54
Other Decks in Marketing & SEO
See All in Marketing & SEO
The Practical Guide to Content that Dominates AI Search
samanyougarg
1
270
What Being in a Rock Band Can Teach Us About Real World SEO
427marketing
0
120
What the f**k is alt-text, and how do you write it?
liamcumber
0
410
Tracking User Journey for SEO in GA4
bngsrc
0
1.1k
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
aleyda
0
1.5k
Content Marketing Strategies for B2B SaaS Success
carib
1
220
Scaling AI on a budget - responsibly!
eminadw
3
540
What the f*ck is the GA4 data model?
nathanless
PRO
1
180
Google's AI Overviews - The New Search
badams
0
820
AI OVERVIEWS: KONEC KLIKÁNÍ V SEO?
pavelungr
0
430
マーケティング研修サービス なぞるLearning
nazoru
PRO
0
260
Momentum: how publishing and updating frequency impact SEO - BrightonSEO April 2025
pontusvippelius
0
290
Featured
See All Featured
XXLCSS - How to scale CSS and keep your sanity
sugarenia
249
1.3M
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
234
17k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
32
1.7k
Speed Design
sergeychernyshev
32
1.2k
Stop Working from a Prison Cell
hatefulcrawdad
272
21k
A designer walks into a library…
pauljervisheath
209
24k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
253
22k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
34
2.5k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
367
27k
Designing for Performance
lara
610
69k
Why Our Code Smells
bkeepers
PRO
340
57k
How to Think Like a Performance Engineer
csswizardry
27
2.1k
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