Hardian Nazief

Making AI Make Sense for Everyday Workflow

The B2B Keyword Mess: How I Cleaned It Manually, and How To Do It Faster with AI Today

It was one of my first major challenges at my previous company, a B2B industrial eCommerce company. Our Google Ads campaigns had a big problem: the Cost Per Acquisition (CPA) was way too high. We were paying for a lot of clicks, but they weren’t turning into customers. After digging into the data, I found the root cause. Our ads, meant for business clients looking to buy industrial parts in bulk, were attracting clicks from regular consumers looking for a single item. We were caught in a B2B versus B2C keyword mess, and it was costing us money every day.

Back then, fixing this meant rolling up my sleeves and diving into spreadsheets. It was a slow, manual process of trying to separate the wheat from the chaff. Today, the game has completely changed. With AI, I could solve that same problem in a fraction of the time and with much greater accuracy. If you’re an aspiring marketer trying to get the most out of your ad budget, understanding how to use AI for keyword analysis is no longer a luxury, it’s essential.

The Grind: My Manual B2B Keyword Separation Process

I remember the painstaking process clearly. It wasn’t just a simple task; it was a multi-layered strategy executed almost entirely by hand, involving both pre-click guesswork and post-click analysis.

The B2B Keyword Mess_ How I Cleaned It Manually, and How To Do It Faster with AI Today - visual selection

First, we had our Pre-Click Strategy, which was our hypothesis about which keywords would work. This involved several manual steps:

  1. Modifier-Based Filtering: I would export our keyword lists from Google Ads into Excel and begin by creating extensive lists of negative keywords. This was our first line of defense to filter out clear consumer traffic using terms like “DIY,” “for home,” “repair,” and “tutorial.”

  2. Semantic Guesswork and Pattern Matching: This was the most challenging part. I made educated guesses based on keyword phrasing. A search for "ball bearing" is broad, but "distributor SKF 6204 bearing" signals a clear B2B intent. We would manually tag these as high-priority and increase our bids.

  3. Specificity Analysis: We operated on the assumption that highly specific, long-tail keywords, even with lower search volume, came from professionals who knew exactly what they needed. We spent hours identifying and prioritizing these high-specificity terms.

  4. Geographic Budgeting: Since we were in Indonesia, we knew our most valuable clients were in major industrial hubs. A key part of our strategy was manually setting our ad campaigns to push the budget more aggressively in cities like Cikarang, Surabaya, and industrial areas around Jakarta.

But my work didn’t stop there. After paying for the click, I had to move on to Post-Click Validation to see if my hypotheses were correct. This is where I lived in Google Analytics, constantly monitoring two key metrics:

  • Bounce Rate: If a specific keyword drove a lot of clicks but had a 80% bounce rate, it was a red flag. It told us the user landed on our B2B page and immediately left, confirming a B2C intent. This data was our trigger to add that term to our negative keyword list.
  • Average Time on Site: A low time on site was another clear signal. An engineer or procurement manager would spend time reviewing specs. A wrong targeted audience would not. This metric helped us confirm the quality of the traffic from our chosen keywords.
The B2B Keyword Mess_ How I Cleaned It Manually, and How To Do It Faster with AI Today - Post Click

This created a laborious, reactive cycle: we’d spend money on clicks, wait for the post-click data to come in, analyze it, and then go back to manually refine our keyword lists and location targeting. It was a constant grind of filtering and validating, and it left very little room for high-level strategic thinking.

While there are many things that I didnt mention here, this was just a snapshot of the constant, manual calibration required, a process that was effective but incredibly time-consuming.

The Game Changer: Re-Analyzing the Problem with an AI Lens

Today, I wouldn’t start with a spreadsheet. I’d start with AI. The difference is that AI doesn’t just match keywords; it understands context and, most importantly, user intent. This is the core principle I’ve discussed before in my post about how AI is changing day-to-day SEO tasks. Instead of just asking “what” a user is searching for, AI helps us understand “why.”

Is the user in research mode? Are they comparing prices? Or are they ready to make a purchase? Answering these questions is the key to separating B2B from B2C traffic effectively. AI tools can analyze thousands of data points from the search engine results page (SERP) to determine this intent, moving us from a keyword-focused approach to a context-focused one.

My AI Toolkit for Keyword Intent Analysis

If I were tasked with that same challenge today, here’s the toolkit I would use to get it done faster and better.

1. AI-Powered SEO Platforms (Ahrefs, Semrush)

Modern SEO tools have already integrated AI to help with this exact problem. Instead of guessing, you can use their built-in features to filter keywords by user intent (Informational, Navigational, Commercial, Transactional). This allows you to immediately see which keywords are signaling a “ready to buy” mentality, which is often where B2B clients live. You can quickly identify and focus on the keywords that lead to conversions.

2. Using LLMs as Your Personal Data Analyst (ChatGPT, Gemini, Claude)

This is one of the most powerful and accessible methods. You can take a list of your keywords, paste them into a Large Language Model (LLM) like ChatGPT or Gemini, and ask it to analyze them for you.

Here is a prompt you can use:

“I am running a Google Ads campaign for a B2B company that sells industrial machine parts in bulk. I need to separate my keywords between those with B2B intent (e.g., procurement managers, engineers) and B2C intent (e.g., hobbyists, DIY users). Please analyze the following list of keywords and categorize them into ‘Likely B2B’, ‘Likely B2C’, and ‘Ambiguous’. For each keyword, briefly explain your reasoning.”

This turns the AI into a junior analyst who can do the heavy lifting in seconds, not days.

3. Learning Directly from the SERP

The best source of truth for user intent is Google itself. Tools like Clearscope or SurferSEO analyze the top-ranking pages for a given keyword. Are the top results blog posts and guides? The intent is likely informational (B2C or early-stage B2B). Are they product pages and pricing lists from major distributors? The intent is likely transactional and commercial (prime B2B territory). Analyzing the SERP is crucial as we continue the shift from keywords to context in Google’s AI-powered search.

The Strategy Still the Same but Amplified by AI

Looking back at my time manually sorting keywords, the goal was always to spend our budget more effectively. That hasn’t changed. What has changed are the tools at our disposal. The manual grind taught me the fundamentals of keyword analysis, but AI provides the speed and sophistication to apply those fundamentals at scale.

AI doesn’t replace the strategist. It augmented you. By handing off the tedious, manual tasks to AI, you free up your time to focus on what truly matters: understanding your customer, crafting a compelling message, and making high-level decisions that drive growth. It’s the difference between being a mechanic and being an engineer, and it’s how modern marketers will succeed.


Key Takeaways

  • High Cost Per Acquisition (CPA) in B2B marketing is often caused by attracting B2C clicks with the wrong keywords.
  • The manual process of separating B2B and B2C keywords is slow, inefficient, and relies on guesswork.
  • AI changes the game by analyzing user intent and semantics, not just keyword strings.
  • You can use AI-powered SEO tools like Ahrefs or an LLM like ChatGPT to categorize keywords by intent quickly.
  • Analyzing the Search Engine Results Page (SERP) gives clear signals about whether user intent is informational or transactional.

Frequently Asked Questions (FAQ)

Q: Can AI completely replace human oversight for keyword research? A: No. AI is a powerful tool for analysis and categorization, but a human strategist is still needed to understand the business context, the nuances of the target audience, and to make the final strategic decisions.

Q: Can AI completely replace keyword research tools like Ahrefs? A: No, not at all. Think of AI models like ChatGPT or Gemini as powerful analysts, but they don’t have the live pipeline of search data that tools like Ahrefs and Semrush do. The best workflow uses both: the SEO platform to get the raw data and initial clusters, and the LLM for deeper, more nuanced analysis of your lists.

Q: Is it expensive to use AI for keyword analysis? A: Not necessarily. While premium SEO platforms have a cost, using LLMs like the free versions of ChatGPT or Gemini can provide powerful analysis for a list of keywords at no cost.

Q: How do I know if a keyword has B2B or B2C intent? A: Look for signals. B2B keywords often include terms like “bulk,” “supplier,” “distributor,” “enterprise,” or specific model numbers. B2C keywords might include “DIY,” “how-to,” “for home,” or “cheap.” AI can help you spot these patterns much faster.

Q: How can I trust the AI’s B2B/B2C classification? A: Always use it as a powerful assistant, not a final decider. The prompt I provided gives the AI a clear role and criteria, which leads to highly accurate results. However, you should always do a final review. You know your business and customer better than anyone, and your final strategic oversight is what makes the process work.