Budget: 2000 UAH Deadline: 7 days
Hello, Alexander!
The task is clear. 16 categories in two languages × complete pipeline of specifications — I will do it.
Plan for one category (in sequence for each of the 16):
1. Cleaning the keyword set:
— Consolidating cluster names into a single language (Ukrainian).
— Removing irrelevant and duplicate phrases.
— Checking frequency in Google KW Planner / Serpstat (where available).
2. Checking the main keyword:
— Analyzing SERP for the main keyword (Ukrainian + Russian).
— Checking intent (informational / commercial / navigational).
— If the intent does not match the category — I suggest a replacement key.
3. Competitors from TOP-10:
— Collecting 5–7 competitive articles from the results for the main keyword.
— I copy the text into a separate document for further analysis.
4. Dictionary of competitors' articles + n-grams:
— Using services (TextOptimizer / NeuronWriter / custom script in Python with NLTK) to highlight the top-100 terms and top-50 n-grams (2- and 3-grams).
— Separately — topics that are repeated among competitors but are absent in your content.
5. Gathering additional topics:
— "People Also Ask" from SERP, topics from "Related searches," LSI from Google Trends.
6. Deliverable: Google Sheets / Excel with tabs per category, everything standardized.
Cost estimate: 2,000 UAH for all 16 categories × 2 languages (formula 60–70 UAH per category in each language). Deadline: 5–7 working days.
In the comments, please send: a link to the Google Doc with the current keyword set + an example of a "well-done specification" for format calibration.
