Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Jonathon_Roberts_-_How_to_speed_up_content_audi...

Jonathon Roberts
October 02, 2024
Business
3
640

 Jonathon_Roberts_-_How_to_speed_up_content_audits_using_ChatGPT__3_.pdf

Jonathon Roberts

October 02, 2024
Tweet

Other Decks in Business

See All in Business
Cobe Associe: Who we are? /コンサル・市場調査・人材紹介のCobe Associe
nozomi
6
19k
株式会社ナレッジラボ_Culture Book
knowledgelabo_saiyo
0
480
5分でわかる松鶴建設 | Shokaku Recruit
shokaku_recruit
0
400
リンクアンドモチベーション 営業コンサルタント向け紹介資料 / Introduction to Link and Motivation for Sales and Consultants
lmi
0
110k
セーフィー株式会社（Safie Inc.） 会社紹介資料
safie_recruit
6
310k
意見交換での思いやり 〜会議ファシリテーションその前に〜 / Consideration in the exchange of opinions
pauli
0
240
【全ポジション共通】㈱エグゼクション/会社紹介資料
exe_recruit
1
1k
アッテル会社紹介資料/culture deck
attelu
10
14k
Atlassian Community Event Tokyo #69/ Confluence/JSM 全社導入展開 ナレッジマネジメント成功の秘訣
yo_freee
0
460
BeBiz_recruit
bebiz
0
120
SHIFT ASIA 会社説明資料 V2.1
shiftasiarec
0
120
第3回関東Kaggler会 LT Kaggleはうつ病患者の役に立つ
utm529f
2
140

Featured

See All Featured
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
28
9.3k
Bash Introduction
62gerente
610
210k
Code Reviewing Like a Champion
maltzj
521
39k
Unsuck your backbone
ammeep
669
57k
A Philosophy of Restraint
colly
203
16k
Designing on Purpose - Digital PM Summit 2013
jponch
117
7.1k
Building a Modern Day 
E-commerce SEO Strategy
aleyda
38
7.1k
Typedesign – Prime Four
hannesfritz
40
2.5k
Fireside Chat
paigeccino
34
3.2k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
31
2.1k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
59k
Practical Orchestrator
shlominoach
186
10k

Transcript

  1. How to Speed Up Content Audits using ChatGPT Jonathon Roberts

    Fly High Media linkedin.com/in/jonathon-roberts-seo/ @jonathonrseo speakerdeck.com/jonathonrobertsseo/

  2. Who uses ChatGPT? #BrightonSEO @jonathonrseo

  3. Who does Content Audits? #BrightonSEO @jonathonrseo

  4. Who uses ChatGPT to audit content? #BrightonSEO @jonathonrseo

  5. Tools Google Sheets ChatGPT 4o + #BrightonSEO @jonathonrseo + App

    Scripts

  6. #BrightonSEO @jonathonrseo

  7. #BrightonSEO @jonathonrseo

  8. #BrightonSEO @jonathonrseo

  9. #BrightonSEO @jonathonrseo

  10. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  11. What are Google App Scripts? #BrightonSEO @jonathonrseo

  12. #BrightonSEO @jonathonrseo

  13. #BrightonSEO @jonathonrseo

  14. #BrightonSEO @jonathonrseo

  15. What can be imported? #BrightonSEO @jonathonrseo

  16. Meta Data #BrightonSEO @jonathonrseo

  17. Canonical Tag #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  18. Schema Markup #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  19. Published Date #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  20. Last Modified Date #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  21. Author #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  22. Article Tags and Category #BrightonSEO @jonathonrseo

  23. Headings (H1, H2, etc.) #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  24. Word Count #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  25. Internal & External Links #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  26. Blocked by Robots.txt? #BrightonSEO @jonathonrseo

  27. Tracking Code Present on Page #BrightonSEO @jonathonrseo

  28. Number of Images #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  29. Image File Size #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  30. Image Format (WebP, JPG, PNG, etc.) #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  31. Backlink Data #BrightonSEO @jonathonrseo

  32. Search Console / Bing Webmaster Tools Data #BrightonSEO @jonathonrseo #BrightonSEO

    @jonathonrseo

  33. GA4 Metrics #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  34. Page Speed & Core Web Vitals #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  35. Google Business Profile API #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  36. Other APIs #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  37. Why not use other similar tools? #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  38. It’s Slower #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  39. It Can Be More Costly #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  40. It’s Less Flexible & Customisable #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  41. Let’s start generating Google Apps Scripts #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  42. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  43. Let’s extract the site URLs #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  44. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Screaming Frog

  45. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo XML Sitemap URL Extractor

  46. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  47. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  48. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  49. 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

  50. 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

  51. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  52. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  53. #BrightonSEO @jonathonrseo CMD + V / CTRL + V #BrightonSEO

    @jonathonrseo

  54. #BrightonSEO @jonathonrseo Organise into Files #BrightonSEO @jonathonrseo

  55. Deploy the code #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  56. Deploy the code #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  57. New deployment #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  58. Select Web App #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  59. Select Web App #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  60. Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  61. Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  62. Fill in details #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  63. Then click deploy #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  64. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  65. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  66. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  67. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  68. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  69. Run the Formula #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  70. Paste as Plain Text #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo Ctrl +

    Shift + V CMD + Shift + V

  71. #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.

  72. Some Issues You May Come Across #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  73. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  74. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  75. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  76. Tell ChatGPT “I don't want to run the script I

    want to create a formula” #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  77. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  78. Incorrect Format #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  79. Tell ChatGPT to: “Split into two columns, for internal &

    external links” #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  80. Content not found #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  81. Finding Content sections in HTML #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  82. #BrightonSEO @jonathonrseo #BrightonSEO @jonathonrseo

  83. Key Takeaway 1: #BrightonSEO @jonathonrseo Boosts Efficiency #BrightonSEO @jonathonrseo

  84. Key Takeaway 2: #BrightonSEO @jonathonrseo Improved Accuracy & Consistency #BrightonSEO

    @jonathonrseo

  85. Key Takeaway 3: #BrightonSEO @jonathonrseo Customisable & Scalable Solutions #BrightonSEO

    @jonathonrseo

  86. Key Takeaway 4: #BrightonSEO @jonathonrseo Time to focus on other

    tasks #BrightonSEO @jonathonrseo

  87. Key Takeaway 5: #BrightonSEO @jonathonrseo Easy to use #BrightonSEO @jonathonrseo

  88. Key Takeaway 6: #BrightonSEO @jonathonrseo Have a go for yourself!

    #BrightonSEO @jonathonrseo

  89. Get Access to the Slides #BrightonSEO @jonathonrseo speakerdeck.com/jonathonrobertsseo #BrightonSEO @jonathonrseo

  90. Bonus: SOP Document #BrightonSEO @jonathonrseo bit.ly/jonathon-brightonseo #BrightonSEO @jonathonrseo

  91. If you have any further questions? linkedin.com/in/jonathon-roberts-seo/ @jonathonrseo