Good day!
There are 16 categories (in two languages + some may have additional clusters)
General task: it is necessary to select information for writing articles: check the choice of the main keyword, select 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:
- unify the names of the clusters to 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 of competitors' articles, n-grams-additional articles, a list of competitors for the current cluster
3. cleaned keyword dictionary with standardized cluster names
