Collection of information for the technical specification of articles categories (dictionary, n-grams)
Good day!
There are 16 categories in two languages
General task: it is necessary to select information for writing articles: check the selection of the main keyword, choose competitors from the search results for this keyword, copy their articles and, using services, select the keyword dictionary, the dictionary of competitors' articles, n-grams, and additional topics
The semantic core has already been collected and clustered
Sequence of actions:
1. check the keyword dictionary for the category:
- consolidate the names of clusters into a single type (there is a problem that when the contractor collected the keyword dictionary, the name of the cluster for Ukrainian phrases was made in Ukrainian, and for Russian in Russian. All cluster names need to be in Ukrainian)
- clean up the collected phrases for the main cluster of the category if necessary
- check if the main keyword phrase for the category is correctly selected
2. using the simple-seo-tools service, select the dictionary from the keyword dictionary and insert it into the Excel table
3. check the SERP for the main keyword phrase and select competitors (I will provide a script that automatically copies sites from the search results; you need to enter the keyword phrase in Google, click on the tab with the script, and the results will be automatically copied) - enter the obtained data into the Google table (additionally, it is necessary to remove marketplace sites from this list)
4. open each page and save all articles from competitors' sites in a text document
5. using the voyant / simple-seo-tools service, select n-grams and the dictionary of competitors and write them into the table
6. if there are topics in the articles that we do not typically describe in our articles - write them down in the table
At the output, I want to receive:
1. text files with competitors' articles (just their articles copied in a row)
2. a filled table with the keyword dictionary, the dictionary from competitors' articles, n-grams - additional articles, a list of competitors for the current cluster
3. cleaned keyword dictionary with standardized cluster names
-
Good day!
I can help with the preparation of the technical specifications for articles in the categories: checking and cleaning the SEO, gathering the vocabulary, n-grams, competitors, and content for analysis.
What I will do:
I will check and standardize the names of the clusters (all in Ukrainian)
I will clean up the phrases for the main keyword of the category
I will gather the SEO vocabulary using simple-seo-tools and enter it into a table
… I will check the SERP, identify competitors (excluding marketplaces)
I will copy competitors' articles into text files
I will extract n-grams and vocabulary from competitors into a table
I will highlight additional topics that are not covered in our articles
I am ready to start and discuss the process in detail.
-
240 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.
-
217 Hello 😊 I am ready to help with your project, I already have similar experience. Write to me, we will discuss everything.
-
4610 109 0 Hello
I am interested in your project. I would like to discuss all the details of the collaboration in more depth.
-
169 0 1 I am ready to take on all 16 categories. I understood the algorithm: from the unification of cluster names in Ukrainian to detailed competitor analysis through the specified services (Simple-SEO-Tools, Voyant). I will filter marketplaces, collect clean texts of articles, and generate n-grams and additional topics that are missing in your standards.
-
693 15 0 2 Good day, Oleksandr! I will complete your project according to the specifications! I guarantee accuracy and correctness in execution! I will be happy to help you!
Current freelance projects in the category Content Management
Assistant for working with content (one-time project)
22 USD
I'm looking for an assistant to help with filling an online store. The job involves searching for and preparing photos/videos of products, finding thematic images on stock sites, as well as creating pictures using ChatGPT. The task is designed for a person who is willing to… Content Management, Advertising ∙ 1 day 12 hours back ∙ 34 proposals |
We are looking for an SMM specialist to manage an Instagram page.We are looking for an SMM specialist to manage an Instagram page We need a person who can create and consistently manage the Instagram page of the Ukrainian community "Our People from Khmelnytskyi in the Czech Republic"; "Khmelnytskyi Residents in the Czech Republic" What… Content Management, Social Media Marketing (SMM) ∙ 2 days 10 hours back ∙ 28 proposals |
Deployment of a PBN website network and content generation (PBN CMS + AI)
78 USD
It is necessary to carry out a comprehensive set of works for the technical deployment, configuration, and content filling of websites for English-speaking locations. All necessary instructions, access, and manuals for working with our CMS will be provided. The work is carried… Content Management, Website Maintenance ∙ 2 days 19 hours back ∙ 11 proposals |
Content Manager for WordPress WebsiteUrgently need a content manager to fill the website. Requirements: Experience working as a content manager. Experience with WordPress and Elementor. Basic knowledge of HTML/CSS; Attention to detail. Content Management ∙ 3 days 6 hours back ∙ 48 proposals |
Event Assistant — Women's Club Kyiv
89 USD
Description:A girl is needed to assist at the HER ERA women's club events in Kyiv.What is needed: — To be present at a minimum of 2 events (evenings, ~5:00 PM, Kyiv) — To help with organization: greeting guests, props, atmosphere — Occasionally going to locations for content… Content Management, Customer Support ∙ 3 days 15 hours back ∙ 1 proposal |