İçeriğe geç
YENİPazar yeri ve ekibin: geliştirdiğini sat; planlar ve değişiklikler sen görmeden önce test edilsin. Yeniliklere bak

Kütüphane / İçerik Yazımı ve Üretimi

İçerik Yazımı ve Üretimi

Search Console verilerinden düşük TKO'lu SEO başlıklarını OpenAI ve WordPress ile yeniden yaz

Haftalık çalışır, Google Search Console'dan düşük performanslı sayfaları çeker ve her sayfanın en iyi sorgularına göre yeni başlık ve meta açıklamaları taslağı hazırlamak için bir LLM kullanır.

Ne yapar

## Find low-CTR pages in Search Console and rewrite their titles with AI ### How it works Every week this workflow pulls page performance from Google Search Console and flags pages whose CTR is well below what their average position should earn (a position-based CTR benchmark). Pages are ranked by missed clicks (impressions × CTR gap). For each page it fetches the top search queries for that page and the live title, meta description and H1, then an LLM writes a new SEO title, an alternative title and a meta description aimed at those real queries. Every suggestion lands in Google Sheets as pending with a length check. Review the sheet, edit if you like, and set status to approved. If write-back is enabled, the hourly run updates the post's SEO title and meta description in WordPress (Yoast or Rank Math). Otherwise approved rows are marked manual so you can paste them yourself. ### Setup steps - Search Console: create a Google OAuth2 API credential with scope https://www.googleapis.com/auth/webmasters.readonly and select it in the three Search Console HTTP nodes. - Google Sheets: create a tab named SEO Log with this header row: page_url | wp_id | wp_type | impressions | clicks | ctr | position | expected_ctr | missed_clicks | top_queries | current_title | current_description | new_title | alt_title | new_description | rationale | length_check | status | updated_at - AI model: add OpenAI credentials, or swap the chat model for Claude, Gemini or another model. - WordPress: create an Application Password and a WordPress API credential for the lookup and write-back nodes. - Config: set gsc_property (e.g. sc-domain:example.com or https://example.com/), wp_base_url, sheet_id and language. - Run On-Demand Activation once with max_per_run = 3 and check the sheet. ### Optional: write back to Yoast / Rank Math Set seo_plugin to yoast or rank_math and add this snippet as a must-use plugin, so the SEO fields become writable through the REST API: php true, 'single' => true, 'type' => 'string', 'auth_callback' => fn() => current_user_can('edit_posts'), ]); } } }); Test on a staging site first and confirm the new title appears in the page source. ### Customization - min_impressions, max_position and ctr_ratio control which pages count as underperforming. - For Japanese, Chinese or Korean sites, lower max_title_length to about 32 and max_description_length to about

Adımlar

  1. Weekly Trigger at 6 AM
  2. On-Demand Activation
  3. Hourly Trigger
  4. Configure Workflow Settings
  5. Check Hourly Execution
  6. Read SEO Log From Sheets
  7. Post Performance Data from GSC
  8. Calculate Underperformance Score
  9. Retrieve WordPress Posts by Slug
  10. Retrieve WordPress Pages by Slug
  11. Match WordPress Page IDs
  12. Post Top Search Queries
  13. Get Live Page HTML
  14. Extract HTML Title and Meta

Toplam 24 adım.

Benzer otomasyonlar