It is required to gather the most complete semantic core for an online fishing tackle store (rods, reels, lures, lines, and accessories). We sell products in various price segments — from budget to premium. The data is needed for the subsequent automation of creating SEO tags and landing pages through the OpenAI API.
Geo: Ukraine (Google.com.ua).
Languages: Russian and Ukrainian.
What needs to be done:
1. Collect all commercial search queries based on our category list (will provide to the selected performer).
2. Depth of collection: including low-frequency queries (from 10-20 queries per month).
3. Conduct initial cleaning from "garbage" and irrelevant queries.
4. Group (cluster) queries by logical features.
Data format requirements (Excel/CSV):
For each keyword, the following must be specified:
• Keyword (the query itself);
• Volume (frequency per month in Ukraine);
• Keyword Difficulty (difficulty);
• CPC (recommended cost per click — for assessing commercial potential).
What groups to divide the semantics into:
• Brand queries: (based on the list of brands: Favorite, Shimano, Daiwa, Select, etc.).
• By type of fish: (for pike, for zander, for carp, for trout, etc.).
• By characteristics: (rod test, reel size, line diameter).
• By purpose/style: (for jigging, for twitching, for feeder, mormyshing, etc.).
• Price markers: (budget, inexpensive, professional, buy).
Negative keywords (Important!):
Immediately exclude queries: DIY, repair, used, olx, forum, download, video, how to make, free, homemade. Also exclude names of competing stores.
Who we are looking for:
A specialist with access to professional software (Serpstat, Ahrefs, or Semrush). Experience in the fishing theme will be a huge plus.
In your response, please indicate:
1. What tools will you use?
2. The approximate volume of keywords you expect to collect in this niche.
3. The cost for the entire volume of work.
