Bulk Keyword Tracking Setup | Workexe

Bulk Keyword Tracking Setup

Guide to adding and tracking hundreds or even thousands of keywords at once. Ideal for large-scale SEO projects. For single-keyword setup use Keyword Tracking; to export data see Export Options, and start with Dashboard for an overview.

Introduction

When is bulk keyword tracking needed?

• 🔹 E-commerce sites (product keywords)
• 🔹 Large content sites (blog keywords)
• 🔹 Multiple locations (local SEO)
• 🔹 Agency work (client projects)

Advantages:

• ⚡ Time saving
• 📊 Comprehensive analysis
• 🎯 Systematic tracking
• 📈 Scalable strategy

Preparation and Planning

Creating Keyword List

Source 1: Google Search Console

1. GSC > Performance > Export
2. Download last 3 months data
3. Get Query column
4. Minimum 10 impression filter

Source 2: Competitor Analysis

Workexe > Competitor Analysis > Export Keywords
- Download competitor keywords
- Remove branded keywords
- Select relevant ones

Source 3: Keyword Research Tools

• Ahrefs keyword list
• SEMrush keyword export
• Ubersuggest data
• Google Keyword Planner

Source 4: Manual List

• Product categories
• Service pages
• Blog titles
• Landing pages

List Cleaning and Filtering

Excel/CSV Cleaning Steps:

1. Duplicate Removal:

Data > Remove Duplicates

2. Remove Branded Keywords:

• Keywords containing your brand name
• Competitor brand names (optional)

3. Filter Irrelevant Keywords:

• Irrelevant keywords
• Spam keywords
• Foreign language (outside target)

4. Search Volume Filter:

• Minimum: 10-50 (for long-tail)
• Medium: 100-1000 (medium competition)
• High: 1000+ (main keywords)

Grouping and Categorization

Group Types:

1. Content-Based:

• Blog keywords
• Product keywords
• Category keywords
• Service keywords

2. Intent-Based:

• Informational (information search)
• Navigational (site search)
• Commercial (research)
• Transactional (purchase)

3. Location-Based:

• Istanbul keywords
• Ankara keywords
• Global keywords

4. Priority-Based:

• High priority (main target)
• Medium priority (medium term)
• Low priority (long term)

Bulk Addition Methods

Method 1: CSV Upload

CSV Format:

keyword,location,device,group
what is seo,Turkey,desktop,blog
seo tools,Turkey,desktop,tools
seo prices,Turkey,mobile,commercial

Upload in Workexe:

Keyword Tracking > Import > CSV Upload
1. Select your CSV file
2. Do column mapping
3. Set import settings
4. Click Import button

Important Notes:

• ✅ Use UTF-8 encoding
• ✅ One keyword per row
• ✅ Maximum 10,000 rows/file
• ✅ First row should be headers

Method 2: Copy-Paste

Simple Text Format:

keyword 1
keyword 2
keyword 3

Usage in Workexe:

Keyword Tracking > Add Keywords > Bulk Add
1. "Paste Keywords" tab
2. Paste list (one keyword per line)
3. Select default settings
4. Click Add button

Limits:

• Free plan: 50 keywords/day
• Pro plan: 500 keywords/day
• Enterprise: Unlimited

Method 3: API Integration

Advanced Usage:

// API endpoint
POST /api/keywords/bulk-add

// Request body
{
  "project_id": "123",
  "keywords": [
    {
      "keyword": "what is seo",
      "location": "tr",
      "device": "desktop",
      "group": "blog"
    }
  ]
}

Use Cases:

• Automatic keyword addition
• CMS integration
• Custom dashboard
• Scheduled imports

Organization and Grouping

Group Management in Workexe

Creating Group:

Keyword Tracking > Groups > Create New Group
- Group name: "Blog - SEO"
- Color: Blue
- Parent group: "Blog" (optional)

Bulk Group Assignment:

1. Select keywords (checkbox)
2. Bulk Actions > Assign to Group
3. Select group
4. Apply

Tag System

Tag Examples:

• #high-priority
• #commercial-intent
• #seasonal
• #local
• #competitor-keyword

Bulk Tag Addition:

1. Filter keywords
2. Select all
3. Bulk Actions > Add Tags
4. Enter tags (comma separated)

Filtering and Segmentation

Saved Filters:

Filter 1: "High Priority Commercial"
- Group: Commercial
- Tags: #high-priority
- Search volume: >1000
- Position: >10

Filter 2: "Quick Wins"
- Position: 11-20
- Difficulty: Easy
- Volume: >100

Tracking Strategy

Tracking Frequency Settings

Recommended Settings:

High Priority (Daily):

• Homepage keywords
• Money-making keywords
• Competitor tracking keywords
• Newly added keywords (first 30 days)

Medium Priority (Weekly):

• Blog keywords
• Category pages
• Medium traffic keywords

Low Priority (Monthly):

• Long-tail keywords
• Low volume keywords
• Informational keywords

Reporting and Analysis

Weekly Report:

Keyword Tracking > Reports > Weekly Summary
- New first page entries
- Dropped keywords
- Notable changes
- SERP feature gains

Monthly Detailed Analysis:

• Group-based performance
• Intent-based analysis
• ROI calculation
• Strategy revision

Optimization Cycle

Monthly Tasks:

1. Performance Evaluation:

• Which groups are successful?
• Which keywords rose?
• Which keywords dropped?

2. Strategy Adjustment:

• Expand successful groups
• Remove unsuccessful keywords
• Add new opportunities

3. Content Planning:

• Identify missing content
• List items needing updates
• New content opportunities

Next Step: Create professional reports with PDF Reports.