BrightonSEO October 2024 - How to Speed Up Content Audits using ChatGPT

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