# malyna.top  SEO Blog by Roman Malyna

> malyna.top is a personal SEO blog and consulting website by Roman Malyna, an SEO specialist with 7+ years of experience (upmotion.agency). The site publishes practical, technical articles on search engine optimization: crawling, indexing, Google Analytics, Google Search Console, Screaming Frog, automation with Google Sheets and Python. The blog is available in English, Ukrainian, and Polish.

## About

- **Author:** Roman Malyna SEO consultant with 7+ years of experience
- **Contact:** malyna.top@gmail.com
- **Agency:** [upmotion.agency](https://upmotion.agency/)
- **Social:** [LinkedIn](https://www.linkedin.com/in/r-malyna/) · [X/Twitter](https://twitter.com/malynatop) · [Facebook](https://www.facebook.com/r.malyna)

## SEO Services Offered

- Competitor Analysis
- SEO Audit
- Technical SEO
- Keyword Research
- On-Page SEO
- Off-Page SEO

## Blog

Full blog: https://malyna.top/seoblog/

### Analytics

- [How to Track AI Traffic in Google Analytics (ChatGPT, Perplexity, Claude, Gemini)](https://malyna.top/analyzing-ai-traffic-in-google-analytics/)
  Step-by-step guide to creating a custom GA4 channel group for AI referral traffic. Includes a regex pattern covering chatgpt.com, perplexity.ai, claude.ai, gemini.google.com, deepseek.com and others. Explains channel priority setup so AI traffic is not misclassified as Referral or Direct.

- [How to get queries in Google Search Console using regular expressions](https://malyna.top/how-to-regex-gsc/)
  Using regex filters in GSC to extract and segment informational queries.

### Technical SEO

- [40 Types of SEO Search Optimization Strategies](https://malyna.top/40-types-of-seo/)
  A comprehensive overview of SEO types: technical, on-page, off-page, local, international, and others.

- [How to Check URL Indexing in Google Using Google Sheets](https://malyna.top/how-to-check-url-indexing-in-google/)
  Automating URL indexing checks via Google Sheets without third-party tools.

- [How to check HTTP response codes for URLs in Google Sheets](https://malyna.top/check-url-page-response-code-google-sheets/)
  Formula-based method to bulk-check page response codes directly in a spreadsheet.

- [How to Identify Dead Code on a Web Page Using Chrome DevTools](https://malyna.top/how-to-identify-dead-code-webpage/)
  Using the Coverage tab in Chrome Developer Tools to find unused CSS and JavaScript.

- [How to crawl large websites with Screaming Frog SEO Spider](https://malyna.top/crawl-large-websites-screaming-frog/)
  Configuration tips for crawling large sites: database mode, custom extraction, crawl limits.

- [Parsing meta tags and other data from websites using Google Sheets](https://malyna.top/parsing-meta-tags-google-sheets/)
  Using IMPORTXML and custom functions to extract meta titles, descriptions, and other data at scale.

- [How to highlight duplicate values: Formula for Google Spreadsheet](https://malyna.top/duplicate-keywords-formula-google-spreadsheet/)
  Conditional formatting and formula approach for identifying duplicate keywords in keyword lists.

- [Google search operators for SEO](https://malyna.top/search-operators-for-seo/)
  Practical guide to advanced Google search operators used in SEO audits and competitor research.

- [Step-by-step guide to using the Google Indexing API with Python](https://malyna.top/using-the-google-indexing-api-with-python/)
  How to authenticate and submit URLs for indexing via Google Indexing API using Python scripts.

### On-Page SEO

- [What are E-E-A-T factors in Google and how to improve them](https://malyna.top/what-eeat-factors/)
  Explanation of Experience, Expertise, Authoritativeness, and Trustworthiness signals and how to strengthen them.

## Blog Categories

- [All posts](https://malyna.top/seoblog/)
- [Technical SEO](https://malyna.top/technicalseo/)
- [On-Page SEO](https://malyna.top/onpage-seo/)
- [Analytics](https://malyna.top/analytics/)

## Languages

- English: https://malyna.top/
- Ukrainian: https://malyna.top/uk/
- Polish: https://malyna.top/pl/

## Optional

- [Sitemap](https://malyna.top/sitemap_index.xml)