Collection and clustering of the semantic core (Ukrainian and Russian languages)

Task Description:

It is necessary to compile a complete relevant semantic core for a website providing IT services. Keywords should be in Ukrainian and Russian. Queries must be structured by content, cleaned of irrelevant and non-commercial queries, grouped by topic considering the subsequent formation of the website structure and content writing.

Output data to be provided to the contractor:

1. Export from Google Search Console for the current pages of the website.

2. Current semantic core.

3. List of main competitors.

4. List of new services to be included in the core.
   
   

Expected from the contractor:

• Search and processing of keywords in Ukrainian and Russian, focusing on commercial and informational queries.

• Complete cleaning of the core from garbage, duplicated, and irrelevant queries.

• Clustering of keywords by content (logical groups).

• Highlighting clusters for articles (blog) with corresponding keywords.

• For each cluster, data should be prepared for providing to a writer with columns:

  • Recommended headings H1, H2,

  • List of keywords to use in the text

  • List of LSI words to use in the text

  • At least 4 FAQ questions with formulations.
    
    

Ultimately, the following should be delivered:

1. A table (Google Sheets or Excel) with:
   
   

   • Collected keywords,

   • Frequency,

   • Distribution by clusters and purposes (service / blog),.

2. A separate tab or file with the website structure based on clustering.

3. A separate block (or combined with item 1) for each cluster — a technical task for writing texts, including H1/H2, keywords, and FAQ.
   
   

What is appreciated:

It is important that the contractor has real experience working with semantic cores — especially for websites in the B2B or IT services sector. Having ready-made cases, examples of tables or structures already used in practice is welcomed.