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
810
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
740
TechSEO North Feb 2025 - How To Implement Schema to Custom CMSs
jonathonrobertsseo
0
48
Other Decks in Marketing & SEO
See All in Marketing & SEO
CMO's Guide to Winning in AI Search with Ahrefs
andreitit
0
1.2k
Smarter Search Strategies: Diversifying Ad Platforms in the Age of AI
yourppcdoc
1
150
Туризм Івано-Франківської області'2024
iftourism
0
220
会社説明資料|株式会社トライバルメディアハウス
tribal
0
2.4k
Despegando en Google Discover: 14 horas de vuelo para vender unos auriculares
clarasoteras
1
210
Stop guessing, start winning: predicting winning products with PMax & Search
inders
1
110
BrightonSEO April 2025: XML Sitemaps + Hreflang For E-Commerce
nmsamuel
1
190
Improve your SEO with video games and Google exploits - Mark Williams-Cook - BrightonSEO April 2025
markwilliamscook
2
500
Save months of work using programmatic SEO to create landing pages
vroscow
0
220
From Search Rankings to Answer Synthesis - How to Weather The AI Storm
dawnieando
0
250
Scaling AI on a budget - responsibly!
eminadw
3
480
Momentum: how publishing and updating frequency impact SEO - BrightonSEO April 2025
pontusvippelius
0
270
Featured
See All Featured
Being A Developer After 40
akosma
90
590k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
32
1.6k
Code Review Best Practice
trishagee
71
19k
Thoughts on Productivity
jonyablonski
70
4.8k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Docker and Python
trallard
46
3.6k
Imperfection Machines: The Place of Print at Facebook
scottboms
268
13k
Building Applications with DynamoDB
mza
96
6.6k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
26
3k
Music & Morning Musume
bryan
46
6.8k
Building a Modern Day E-commerce SEO Strategy
aleyda
43
7.6k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.5k
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