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
700
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
110
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
jonathonrobertsseo
0
32
Other Decks in Marketing & SEO
See All in Marketing & SEO
Cómo alcanzar el éxito en Ecommerce SEO - #MarketingxValencia
aleyda
0
110
Beyond Borders: Essential Steps for WordPress Multilingual Success
chiaki_kouno
0
120
How to cluster content to enhance your relevance
pablolopezm
0
180
BrightonSEO San Diego: How to Update Content to Increase Traffic and Revenue
alyssacorso12
0
200
Google Tag Manager tips that will elevate your analytics game
krmdigitaluk
1
170
企業がより良い取引のためにImmediate Edgeーションを活用するには?
davidmurray
0
120
Tactics vs strategy: why SEO’s shouldn’t focus on industries
petervz
0
230
Туризм Івано-Франківської області'2024
iftourism
0
150
What the f**k is alt-text, and how do you write it?
liamcumber
0
210
Ecommerce SEO: The Keys for Success Now & Beyond - #SERPConf2024
aleyda
1
1.4k
The untapped power of vector embeddings
frankvandijk
0
560
Using Python to create 1000 GSC properties in 3 seconds! BrightonSEO Oct. 2024
saji
2
320
Featured
See All Featured
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
5
530
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
47
5.3k
The Pragmatic Product Professional
lauravandoore
33
6.5k
Building Applications with DynamoDB
mza
94
6.3k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.7k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
507
140k
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
Statistics for Hackers
jakevdp
798
220k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
RailsConf 2023
tenderlove
30
1.1k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.4k
BBQ
matthewcrist
88
9.6k
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