Creating data-driven SEO apps with AI - Brighton SEO

Learn how AI tools like Claude.ai and Deepnote can make developing SEO applications and conducting SEO data analysis more accessible, even if you're not a coder or data scientist. Dive into practical use cases such as creating redirect plans and building calculator tools. Discover how AI tools can automate manual SEO tasks and simplify complex ones for everyone.

Brighton SEO October 2024 talk

Transcript

2. How to combine generative AI and data in your future SEO work? SEO AI DATA #brightonseo
3. “To understand the future, we must first understand the past” #brightonseo
4. 2000: Mainstream internet PRE- INTERNET POST- INTERNET #brightonseo
5. Back in 2001 ICQ status Frames COMIC SANS Font Type #brightonseo
6. Online Game Creator W ORD AR T Flash #brightonseo
7. Your AI adventure - Generative AI #brightonseo Gen AI Tools Learnings Do Use cases
8. 2024: "The Age of Gen AI" PRE-GENERATIVE AI POST-GENERATIVE AI #brightonseo
9. How do you use AI today? #brightonseo
10. AI: your ultimate super-productive, just-a-tad-okay copywriter. #brightonseo
11. With AI by your side, become a productive average designer! #brightonseo
12. Create html/javascript web forms with AI? #brightonseo
13. #brightonseo
14. Data visualisation with AI? #brightonseo
15. AI making a graph on AI #brightonseo
16. Program games with AI? #brightonseo
17. #brightonseo
18. GEN AI Programming 125% productivity increase 50% 0% 100% Customer support Business writing Programming #brightonseo
19. 2 questions #brightonseo
20. 1) Where can I play the games? #brightonseo
21. michaelvdr.be/ games #brightonseo
22. 2. How is this relevant for my SEO job? #brightonseo
23. New Skills & Tools Automation Insights #brightonseo
24. #brightonseo Before having an AI teammate
25. #brightonseo After addition of an AI teammate
26. Your AI adventure - Tools #brightonseo Gen AI Tools Learnings Do Use cases
27. New AI Tools are available now. #brightonseo
28. 3 AI-powered coding tools for SEO data magic Deepnote #brightonseo
29. Write and run python code Share with colleagues (google drive) No setup required #brightonseo
30. Coding in a browser #brightonseo
31. New AI magic trick! #brightonseo
32. Use AI to do data analysis in python Data warehouse / huge excel files Create apps yourself Deepnote #brightonseo
33. Generate code blocks #brightonseo
34. Autocorrect errors #brightonseo
35. Interactive javascript applications Currently outperforms chatgpt on writing and coding Create publishable artifacts #brightonseo
36. Highest capability model (July 24) #brightonseo
37. “build me a zodiac sign calculator” #brightonseo
38. "Create an air hockey game for me." #brightonseo
39. #brightonseo Pro version $20/month $39/month Free
40. #brightonseo With AI tools, you can Let’s put this in practice! Code Analyze data Work together
41. #brightonseo Your AI adventure use cases #brightonseo Gen AI Tools Learnings Do Use cases
42. 3 Practical Data Apps 3 use cases #brightonseo
43. Screaming Frog Exports #brightonseo
44. Google Sheet- Screaming Frog export - 62 columns #brightonseo
45. #brightonseo
46. https://colab.google “ask for the sheet name and then read values” #brightonseo
47. Correct code generated #brightonseo
48. Now create a tab “too short meta titles” #brightonseo
49. #brightonseo Wrong title column selected
50. Human dev AI dev Makes errors Makes errors Needs coffee Does not get tired #brightonseo
51. Let the AI correct it! AI, Be sure to select Title 1 column #brightonseo
52. We've got our short title tab right there in the Google Sheet! #brightonseo Correct titles
53. AI, do some more work Duplicate titles / Missing descriptions / / Duplicate descriptions / No H1 tag / Duplicate H1 #brightonseo
54. But we reached a Google Sheets API quota limit #brightonseo
55. Ask the AI to generate an EXCEL file which downloads automatically #brightonseo
56. 8 actionable tabs, all lined up in a 4- column display! #brightonseo
57. #brightonseo
58. Tax simulation tool #brightonseo
59. #brightonseo
60. belastingen berekenen bijberoep calculate tax side job #brightonseo
61. Search Intent? #brightonseo
62. Jira tickets for dev Join the queue! #brightonseo
63. Create a simple web application that helps self- employed individuals with a secondary occupation in Belgium calculate their net income and tax obligations. Web based application #brightonseo
64. Version 1 Irrelevant fiels, design could improve and ... it may be good if it functioned #brightonseo
65. Version 5 Looking already better But wrong calculation formula: => give AI examples #brightonseo
66. Version 12: optimized form #brightonseo
67. #brightonseo
68. Number 3 position #brightonseo
69. Redirect automation #brightonseo
70. Website migration Make a redirect plan #brightonseo
71. #brightonseo Monkey job? AI job?
72. Upload 2 CSV files in Deepnote Old pages in Google Pages on new website #brightonseo
73. Ask deepnote to open the files Question Question Generated code #brightonseo
74. Extract words out of URL’s #brightonseo Address: https://brightonseo.com/sessions/technical-innovation Words: brightonseo com sessions technical innovation
75. Error #brightonseo
76. Autocorrect Trailing space issue, fixed by ... the AI ... without needing to write a new prompt #brightonseo
77. Ask AI to ignore domain name Keep unique words #brightonseo
78. AI, make some algorithm to match URLs based on common words #brightonseo
79. AI: OK #brightonseo
80. Me: do something more advanced Check meta title words Top 3 matched pages Similarity/Match % #brightonseo
81. AI: easy! #brightonseo
82. Download CSV #brightonseo
83. Create a Deepnote app #brightonseo
84. The redirect app #brightonseo
85. #brightonseo Your AI adventure - learnings #brightonseo Gen AI Tools Learnings Do Use cases
86. What did you learn today?
87. Start simple 1.
88. 2. Embrace Trial and error
89. 3. Use multiple prompts
90. 4. Start with a design document Generated with AI
91. Without design document 24 version, still a bug With design document 8 versions
92. 5. Be a critical human
93. 6. Experiment a lot
94. Assume the AI you are using now is the worst version of AI you are ever going to use
95. #brightonseo Your AI adventure - Do #brightonseo Gen AI Tools Learnings Do Use cases
96. How will you work 1 year from now?
97. The best way to predict the future is to create it Save time New skills
98. Stop talking, Start building! Do you already have any ideas? The tools are available now!
99. www.linkedin.com/in/michaelvdr www.michaelvdr.be michael.vandenreym@thenextimmoscoop.be Let’s connect