$30 off During Our Annual Pro Sale. View Details »

Creating your own SEO tools & SEO automations - Tevfik Mert Azizoglu - International Search Summit - Barcelona

Creating your own SEO tools & SEO automations - Tevfik Mert Azizoglu - International Search Summit - Barcelona

In this session, Mert will talk about how you can create mini SEO tools and SEO automation that include complex functionalities like crawling, data extraction, and building reports automatically by using those outputs.

Tevfik Mert Azizoglu

November 24, 2022
Tweet

Other Decks in Marketing & SEO

Transcript

  1. Barcelona International Search Summit Tevfik Mert Azizoğlu SEO Sherpa Creating

    your own SEO tools & SEO automations #IntSS @mertazizoglu slideshare.net/TevfikMertAzizolu
  2. T. Mert Azizoğlu #IntSS @mertazizoglu crawlt.com 📍 Istanbul & Dubai

    🌴 🎓 Computer Engineer 🔎 Sr. Tech. SEO @SEO Sherpa 🔎 ex: SEO Director @Zeo ⚡ SEO Automation Geek 󰞨 SEO Lecturer
  3. Sometimes we need automations, #IntSS @mertazizoglu crawlt.com but not like

    this.
  4. Tools Zapier G-Sheets XPath What we will cover today? #IntSS

    @mertazizoglu crawlt.com
  5. Tools Zapier G-Sheets XPath Let’s start! #IntSS @mertazizoglu crawlt.com

  6. What is XPath? //div[@class="seo-content"] #IntSS @mertazizoglu crawlt.com XPath is a

    syntax for defining parts of an XML document. - w3schools
  7. node • all page elements Example: a, p, h3, div,

    li XPath Syntax #IntSS @mertazizoglu crawlt.com
  8. // • points to all relevant nodes on the page

    Example: //h3 XPath Syntax #IntSS @mertazizoglu crawlt.com
  9. attribute • specifies the property of the node Example: class,

    id, href XPath Syntax #IntSS @mertazizoglu crawlt.com
  10. @ • indicates the attribute property Example: //div[@class="mert"] XPath Syntax

    #IntSS @mertazizoglu crawlt.com
  11. XPath Overview #IntSS @mertazizoglu crawlt.com

  12. count(XPath) count(//node[@attribute="attribute_name"]/a) count(//div[@class="seo-content"]/a) #IntSS @mertazizoglu crawlt.com

  13. Element Validation 02 Writing XPath 03 01 What Data Do

    We Need? XPath Lifecycle
  14. #IntSS @mertazizoglu crawlt.com What Data Do We Need? 01

  15. #IntSS @mertazizoglu crawlt.com Element Validation 02

  16. #IntSS @mertazizoglu crawlt.com Is The Same Element Valid For All

    Pages? 02
  17. #IntSS @mertazizoglu crawlt.com Writing XPath 03 //div[@class="bui-panel"] <div class="bui-panel">

  18. XPath Helper Chrome Extension Testing w/ XPath Helper

  19. XPath Helper Chrome Extension Testing w/ XPath Helper

  20. 500 URLs (Free) “custom extraction not included” #IntSS @mertazizoglu crawlt.com

    Custom Extraction w/ Screaming Frog
  21. #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ XPath

  22. //div[@class="lp-faq__content"]//ul//li//h3 #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ XPath

  23. #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ Screaming Frog

  24. #IntSS @mertazizoglu crawlt.com FAQ Extraction w/ Screaming Frog

  25. #IntSS @mertazizoglu crawlt.com Results!

  26. #IntSS @mertazizoglu crawlt.com Chrome > DevTools > Copy > Copy

    XPath
  27. Scraper Chrome Extension Finding XPath w/ Scraper

  28. Tools Zapier G-Sheets XPath #IntSS @mertazizoglu crawlt.com

  29. * Web-based Excel from Google! ❏ Free ❏ Cloud-based ❏

    Easy integrations, Add-ons ❏ Apps Script & JS ❏ Accessibility #IntSS @mertazizoglu crawlt.com Google Sheets
  30. =IMPORTXML("url";"xpath") Gif #IntSS @mertazizoglu crawlt.com IMPORTXML Formula (The Best Assistant!)

  31. None
  32. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com Apps Script =getStatusCode("url") Gif

  33. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com

  34. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com Triggers in Apps Script

  35. developers.google.com/apps-script/guides/sheets #IntSS @mertazizoglu crawlt.com Triggers in Apps Script

  36. Tools Zapier G-Sheets XPath #IntSS @mertazizoglu crawlt.com

  37. #IntSS @mertazizoglu crawlt.com What is Zapier ?

  38. #IntSS @mertazizoglu crawlt.com zapier.com/explore Plenty of Integrations!

  39. #IntSS @mertazizoglu crawlt.com zapier.com/explore Quick Workflows / Zaps

  40. #IntSS @mertazizoglu crawlt.com SEO Sheets Zaps

  41. Tools I. On-Page SEO Health Checker II. Sitemap Watcher III.

    Internal Link Catcher * Bonus Zapier G-Sheets What we’ve learnt so far! XPath #IntSS @mertazizoglu crawlt.com
  42. #IntSS @mertazizoglu crawlt.com On-Page SEO Health Checker Tools #1 On-Page

    SEO Health Checker
  43. #IntSS @mertazizoglu crawlt.com On-Page SEO Health Checker Tools #1 On-Page

    SEO Health Checker
  44. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Sheets //*[local-name()='url']/*[local-name()='loc']

  45. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Zapier

  46. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Zapier //*[local-name()='url']/*[local-name()='loc']

  47. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Zapier

  48. #IntSS @mertazizoglu crawlt.com Tools #2 Sitemap Watcher / Gmail

  49. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher XPath Sitemap

  50. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher

  51. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher

  52. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher

  53. #IntSS @mertazizoglu crawlt.com Tools #3 XPath Helper Chrome Extension //div[@class="div_name"]//a[c

    ontains(translate(.,'ABCÇDEF GĞHIİJKLMNOÖPQRSŞTUÜV WXYZ','abcçdefgğhıijklmnoöp qrsştuüvwxyz'), 'keyword')]//@href = '/url_name'
  54. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher

  55. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher

  56. #IntSS @mertazizoglu crawlt.com Tools #3

  57. #IntSS @mertazizoglu crawlt.com Tools #3 Internal Link Catcher

  58. #IntSS @mertazizoglu bit.ly/content-brief-generator Bonus #1 Content Brief Generator +

  59. #IntSS @mertazizoglu n8n.io Bonus #2 n8n.io

  60. #IntSS @mertazizoglu seonocode.com Bonus #2 Message When Content Changes n8n.io/workflows/1471

  61. #IntSS @mertazizoglu crawlt.com Bonus #3 Robomotion.io Robomotion - Content Checker

  62. #IntSS @mertazizoglu //div[@class="thank"]/you //twitter/@mertazizoglu crawlt.com seonocode.com