Slide 1
Slide 1 text
How to Speed Up
Content Audits using
ChatGPT
Jonathon Roberts
Fly High Media
linkedin.com/in/jonathon-roberts-seo/
@jonathonrseo
speakerdeck.com/jonathonrobertsseo/
Slide 2
Slide 2 text
Who uses
ChatGPT?
#BrightonSEO @jonathonrseo
Slide 3
Slide 3 text
Who does
Content Audits?
#BrightonSEO @jonathonrseo
Slide 4
Slide 4 text
Who uses ChatGPT
to audit content?
#BrightonSEO @jonathonrseo
Slide 5
Slide 5 text
Tools
Google Sheets ChatGPT 4o
+
#BrightonSEO @jonathonrseo
+
App Scripts
Slide 6
Slide 6 text
#BrightonSEO @jonathonrseo
Slide 7
Slide 7 text
#BrightonSEO @jonathonrseo
Slide 8
Slide 8 text
#BrightonSEO @jonathonrseo
Slide 9
Slide 9 text
#BrightonSEO @jonathonrseo
Slide 10
Slide 10 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 11
Slide 11 text
What are
Google App Scripts?
#BrightonSEO @jonathonrseo
Slide 12
Slide 12 text
#BrightonSEO @jonathonrseo
Slide 13
Slide 13 text
#BrightonSEO @jonathonrseo
Slide 14
Slide 14 text
#BrightonSEO @jonathonrseo
Slide 15
Slide 15 text
What can be
imported?
#BrightonSEO @jonathonrseo
Slide 16
Slide 16 text
Meta Data
#BrightonSEO @jonathonrseo
Slide 17
Slide 17 text
Canonical
Tag
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 18
Slide 18 text
Schema Markup
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 19
Slide 19 text
Published Date
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 20
Slide 20 text
Last Modified Date
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 21
Slide 21 text
Author
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 22
Slide 22 text
Article Tags and
Category
#BrightonSEO @jonathonrseo
Slide 23
Slide 23 text
Headings
(H1, H2, etc.)
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 24
Slide 24 text
Word Count
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 25
Slide 25 text
Internal & External
Links
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 26
Slide 26 text
Blocked by
Robots.txt?
#BrightonSEO @jonathonrseo
Slide 27
Slide 27 text
Tracking Code Present
on Page
#BrightonSEO @jonathonrseo
Slide 28
Slide 28 text
Number of Images
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 29
Slide 29 text
Image File Size
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 30
Slide 30 text
Image Format
(WebP, JPG, PNG,
etc.)
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 31
Slide 31 text
Backlink Data
#BrightonSEO @jonathonrseo
Slide 32
Slide 32 text
Search Console /
Bing Webmaster
Tools Data
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 33
Slide 33 text
GA4 Metrics
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 34
Slide 34 text
Page Speed &
Core Web Vitals
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 35
Slide 35 text
Google Business
Profile API
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 36
Slide 36 text
Other APIs
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 37
Slide 37 text
Why not use other
similar tools?
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 38
Slide 38 text
It’s Slower
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 39
Slide 39 text
It Can Be More
Costly
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 40
Slide 40 text
It’s Less Flexible &
Customisable
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 41
Slide 41 text
Let’s start generating
Google Apps Scripts
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 42
Slide 42 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 43
Slide 43 text
Let’s extract the site
URLs
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 44
Slide 44 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Screaming Frog
Slide 45
Slide 45 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
XML Sitemap URL Extractor
Slide 46
Slide 46 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 47
Slide 47 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 48
Slide 48 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 49
Slide 49 text
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
Slide 50
Slide 50 text
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
Slide 51
Slide 51 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 52
Slide 52 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 53
Slide 53 text
#BrightonSEO @jonathonrseo
CMD + V / CTRL + V
#BrightonSEO @jonathonrseo
Slide 54
Slide 54 text
#BrightonSEO @jonathonrseo
Organise into Files
#BrightonSEO @jonathonrseo
Slide 55
Slide 55 text
Deploy the code
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 56
Slide 56 text
Deploy the code
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 57
Slide 57 text
New deployment
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 58
Slide 58 text
Select Web App
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 59
Slide 59 text
Select Web App
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 60
Slide 60 text
Fill in details
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 61
Slide 61 text
Fill in details
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 62
Slide 62 text
Fill in details
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 63
Slide 63 text
Then click deploy
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 64
Slide 64 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 65
Slide 65 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 66
Slide 66 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 67
Slide 67 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 68
Slide 68 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 69
Slide 69 text
Run the Formula
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 70
Slide 70 text
Paste as Plain Text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Ctrl + Shift + V
CMD + Shift + V
Slide 71
Slide 71 text
#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.
Slide 72
Slide 72 text
Some Issues You May
Come Across
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 73
Slide 73 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 74
Slide 74 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 75
Slide 75 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 76
Slide 76 text
Tell ChatGPT
“I don't want to run the
script I want to create a
formula”
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 77
Slide 77 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 78
Slide 78 text
Incorrect Format
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 79
Slide 79 text
Tell ChatGPT to:
“Split into two columns,
for internal & external
links”
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 80
Slide 80 text
Content not found
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 81
Slide 81 text
Finding Content
sections in HTML
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 82
Slide 82 text
#BrightonSEO @jonathonrseo
#BrightonSEO @jonathonrseo
Slide 83
Slide 83 text
Key Takeaway 1:
#BrightonSEO @jonathonrseo
Boosts Efficiency
#BrightonSEO @jonathonrseo
Slide 84
Slide 84 text
Key Takeaway 2:
#BrightonSEO @jonathonrseo
Improved Accuracy &
Consistency
#BrightonSEO @jonathonrseo
Slide 85
Slide 85 text
Key Takeaway 3:
#BrightonSEO @jonathonrseo
Customisable &
Scalable Solutions
#BrightonSEO @jonathonrseo
Slide 86
Slide 86 text
Key Takeaway 4:
#BrightonSEO @jonathonrseo
Time to focus on other
tasks
#BrightonSEO @jonathonrseo
Slide 87
Slide 87 text
Key Takeaway 5:
#BrightonSEO @jonathonrseo
Easy to use
#BrightonSEO @jonathonrseo
Slide 88
Slide 88 text
Key Takeaway 6:
#BrightonSEO @jonathonrseo
Have a go for yourself!
#BrightonSEO @jonathonrseo
Slide 89
Slide 89 text
Get Access to the Slides
#BrightonSEO @jonathonrseo
speakerdeck.com/jonathonrobertsseo
#BrightonSEO @jonathonrseo
Slide 90
Slide 90 text
Bonus: SOP Document
#BrightonSEO @jonathonrseo
bit.ly/jonathon-brightonseo
#BrightonSEO @jonathonrseo
Slide 91
Slide 91 text
If you have any further
questions?
linkedin.com/in/jonathon-roberts-seo/
@jonathonrseo