MarketingCoffee

How to Save Hours on Your Keyword research Projects

2 mins

If you’re working on SEO or SEA projects, you’re most likely spending hours per week researching and structuring your campaigns’ keywords.

If you’re like me, you typically combine a keyword research tool (I use Mangool’s KWFinder) with Microsoft Excel or Google Sheets to categorize and rank your keywords by relevance.

It’s usually incredibly manual and tiresome.

About six months ago, I had to prepare a business case that involved keyword research for an agency client. As I exported spreadsheets from Google Keyword Planner and Mangool’s KWFinder, I realized that categorizing the client’s keywords would likely take me hours. That’s when I discovered a very niche Google Sheets add-on called The Keyword Clusterizer.

What it does is close to SEA magic.

  • Install the add-on on Google Sheets and upload your keyword spreadsheets.
  • Run the add-on, and your spreadsheet will be automatically categorized into topic clusters.
  • Sort your keywords by relevance into « Hot, » « Maybe, » and « Cold » categories.


Et voilà! You will have organized, ready-to-use ad groups and a negative keyword list in less than two minutes.

 

How I use the keyword clusterizer to organize my keywords

 

  • First, download the Google Sheets add-on on the Keyword Clusterizer website.
  • The add-on appears in your Google Sheet « Extensions » menu.
  • Import your keyword spreadsheets from your favorite keyword research software.
  • Run the add-on by clicking on « Run Clusterizer. »

 

Organize keywords with keyword clusterizer

 

Once you’ve run the Keyword Clusterizer, you will obtain something like the image below.

Using the « Data Master Sheet, » you can label various keyword metrics to your liking and categorize keywords into « Hot, » « Maybe, » and « Cold » tabs.

This works at the category, subcategory, and keyword level, meaning you can opt for broad categorization or a more granular approach, depending on your needs.

 

How to organize keyword clusters

 

And now, over to you!

This workflow is free and doesn’t require any subscription. Here’s a summary of how you can do it yourself and save hours of work each time you do keyword research.

  • Go to The Keyword Clusterizer and download their add-on
  • Upload your keywords lists on Google Sheets
  • Run the add-on and label your metrics
  • Remove any irrelevant keywords or categories
  • Categorize your keywords into « Hot, » « Maybe » and « Cold » tabs
  • Export to set up your SEO/SEA campaign
  • Profit!


That’s it for today. If you found this interesting, consider subscribing to my newsletter.

It’s free – and I will send you 3 new marketing hacks you can use immediately every week.

Share this story with someone :

Email
Twitter
LinkedIn

Related Posts

Understand the biggest drivers of ad profitability

2 mins

What makes ads profitable?

There’s always been a certain mystery about this million-dollar question.

So, I decided to seek the answer.

Back in 2014, Paul Dyson, founder of the econometric consultancy Data2Decisions, conducted an analysis that revealed the drivers of ad profitability.

This analysis identified and ranked the ROI multiplier effects of various different advertising considerations.

However, the media landscape has changed dramatically since these past analyses were carried out in 2014.

Fortunately, Thinkbox commissioned Paul Dyson (now co-founder of Accelero) in 2023 to revisit his analysis, taking into consideration the massive shift towards online search advertising and digital advertising in general.

Searching through hundreds of studies, Accelero collated around 28,000 global campaigns, of which about 7,000 were UK campaigns. This very robust sample was used to identify the variables that most influence ROI.

What are the biggest, predictable drivers of ad profitability?

I was very surprised by the findings of Accelero’s 2023 study.

 

N°1: 👀 BRAND SIZE: UP TO 20x ROI MULTIPLIER

I know, I know. That is not what any of us wanted to hear.

Unfortunately, the study showed that brand size is massively important.

In fact, it’s the most powerful driver of ad profitability.

That’s a pretty solid argument to use in front of « brand awareness » skeptics.

Bigger brands get much better absolute returns on their advertising.

The bigger you are, the more effective your ads, thanks to existing awareness and affinity. Often, you’re just reminding people to buy.

Your existing customer base is also much more likely to buy new products or services – because customers already know and trust you.

Brand size is inextricably linked to brand health, or “power”.

Kantar research has consistently shown that stronger, meaningfully different brands are more likely to grow. In particular, Kantar showed that brands with strong differences are especially likely to see higher advertising returns.


N°2 – 📝 GREAT CREATIVES – UP TO 12x ROI MULTIPLIER

Second only to the size and strength of a brand is the quality of the advertising itself. There can be dramatic differences between the efficacy of the best and worst ads. Many award-winning ads are not easily linked to the brand, and others have a shock factor but fail to trigger the right emotional response. The best ads manage to combine being both creative AND effective.

The magic doesn’t come from button pressing and knob twisting in an ads dashboard.

It comes from great ads that are noticeable and memorable and cause an emotional response that drives action.

 

N°3 – 💵 BUDGET SETTING (ACROSS GEOGRAPHIES): UP TO 5x ROI MULTIPLIER

Optimizing budgets can be a highly effective means of delivering a higher ROI multiplier.

Some countries are simply more profitable than others, and media prices vary by geography, as do distribution channels, profit margins, and product consideration.

Brand size can also vary significantly. Allocating budgets across geographies in an optimum way can increase media profitability by up to a factor of 5.


4 – 💰 BUDGET SETTING (ACROSS PORTFOLIOS): UP TO 3x ROI MULTIPLIER

Different brands within a given portfolio will have different ROI potential.

Bigger brands will deliver a higher ROI simply because they have wider distribution (physical availability) or awareness (mental availability).

Therefore, prioritizing the bigger brands in a portfolio will lead to a higher ROI for your budget. This can provide a x3 multiplier on ROI.

N°5 – 📺 MEDIA MIX: UP TO 2.5x ROI MULTIPLIER

It’s well documented that campaigns using more than one media channel benefit from media multiplier effects – the evidence Accelero found is no different, suggesting that simply by using a multimedia strategy, there’s a potential ROI multiplier of 2.5.

Optimizing the media mix can pay major dividends, both in terms of how much brands invest in individual media channels (e.g., TV vs. OOH vs. online) and how much is invested in specific formats and placements (e.g., online display vs. online video, Facebook vs. YouTube, etc.).

However, the relative opportunity to improve profitability through mix optimization is smaller than ensuring you have invested money in brands with high potential returns and ads that work.

6-10 🙌 AND THE REST… (<2x ROI MULTIPLIER)

As you can see in the table below, marketers generally tend to overestimate the relative importance of media mix allocation, balancing brand vs. performance marketing and targeting, while they tend to underestimate the importance of brand size, creative quality, and budget setting across geographies and portfolios.

But this is not to supersede the role of media planning.

The majority of the elements on the chart all belong to the world of planning and strategy and collectively deliver the potential for huge ROI multipliers.

If you’re not optimizing budgets, brand/performance ratios, or buying the most cost-effective audience, then you’re missing out on low-hanging profit multipliers.

 

The analysis showed that in today’s media landscape, expertise and talent are crucial.

A strong creative strategy combined with an optimized media plan is the most effective path to profitable growth.

Instead of focusing solely on cost, we should prioritize value.

That’s it for today. If you found this interesting, consider subscribing to the newsletter.

Join 250+ marketers learning growth marketing with practical tactics and proven tools.

It’s free – and marketers receive 1 growth tactic, 1 tool & 1 news recap every week.

Share this story with someone :

Email
Twitter
LinkedIn
2 mins

Copywriting tips to increase conversion

2 mins

We know that people don’t read online; they scan.

You only have a few seconds to capture their attention.

This means that your copy matters even more.

Today, I’m sharing 8 copywriting tips to help you increase conversion.

👋 Make it about them

Too many websites brag about their products and services.

Features. Awards. New features. New awards.

Good, but what’s in for me? What’s in for potential customers?

Instead, you should talk about how you solve problems for clients.

How do you address their pain points?

What’s the « before » situation? What’s the « after » situation?

That’s how you write a hero section.


✂️ Cut the fluff

People are busy.

They don’t have the patience to read long paragraphs.

Cut them short. Remove words that don’t add value.

Hook them as quickly as possible.

Take a sentence. Remove adjectives. Remove adverbs.

Make it punchier.


🔎 Break long paragraphs into digestible chunks

Readability is key. Especially on mobile devices where space is restrained.

Instead of writing long, descriptive paragraphs, aim for punchier, shorter bits of text that convey value efficiently.


🙏 Deliver maximum value

What’s in for your clients?

Your website should address your clients’ pain points.

Focus your copy on solving problems.


✋ Handle objections

What are the top 5 objections that your customers will most likely raise?

Use them in your copy. Anticipate objections.

And watch your conversion rate increase.

🙌 Make it very relatable

Relate your product to something your customers can relate to.

This can be done using analogies, metaphors, and comparisons.

You can also refer to everyday situations that your users experience.


🥊 Make it (super) punchy

Steal concepts from poetry. Add rhythm. Give your copy a voice.

Make it fun and easy to understand.


🎯 Don’t be vague; be specific

Some businesses require more hard proof than others.

If you have great numbers to share, use them.

That’s it for today. If you found this interesting, consider subscribing to the newsletter.

Join 250+ marketers learning growth marketing with practical tactics and proven tools.

It’s free – and marketers receive 1 growth tactic, 1 tool & 1 news recap every week.

Share this story with someone :

Email
Twitter
LinkedIn
4 mins

Protect and grow your SEO in the AI era

2 mins

OK let’s face it: SEO is at serious risk.

Not only do you have to compete with floods of AI-generated content, but Google itself (and other search engines will follow) now uses AI in search results, further removing the need to visit any website.

According to Adweek, Google’s AI Overviews alone could result in declines ranging from 20-60% of total organic traffic for publishers.

People also use ChatGPT, Gemini, or Perplexity to search for information online, which oftentimes means that they don’t visit a single website in the process.

So, what do you do?

My first advice is to create content that’s deeper than what AI can do.

🧠 Part 1: The « deep content » strategy

Not all content or queries are at risk of being stolen by AI.

We need to differentiate between two types of topics:

  • « Shallow » topics are easily answered by AI
  • « Deep » topics aren’t easily answered by AI


« Shallow » topics are questions and queries that any LLM-based chatbot can answer. A good example of that is « How do I reset my iPhone? ».

Such topics make it hard for marketers to deliver any value that ChatGPT wouldn’t be able to communicate instantaneously.

That’s the kind of topic and traffic that AI will easily steal away.

« Deep » topics, on the other hand, cannot quickly be answered by AI chatbots.

They require more profound expertise and first-hand experience.

They call for detailed, nuanced answers.

They can’t be summarized in 10 lines.

Here are some examples of « deep topics »:

  • Proven customer service strategies in the banking sector
  • How to run a video content audit
  • Create a self-sufficient garden


These are examples of topics where marketers can really add value.

Such topics can benefit from real-life experience and expert advice.

They don’t have a single, 5-line, pre-determined answer to them.

These are the kinds of topics you should prioritize in your content and SEO roadmap.

Because such topics require higher-quality answers and content, your company is more likely to rank for these keywords and be quoted by AI chatbots and voice assistants, further increasing traffic.

Becoming the industry reference on « deep » topics is one way to futureproof your online presence and traffic.

Let’s move on to strategy number two.


🏘️ Part 2: Grow with community-led content

AI chatbots provide answers based on training data and information available online. They usually rephrase or reuse someone else’s content.

Do you know what AI cannot do (at least, yet)?

Interview people. Gather their thoughts. Collect expert points of view.

Make your content community-driven.

Invite experts, customers, locals… Have them empower your content.

Make them the center of your content strategy and you’ll have one excellent reason why people should visit your website.

Community-powered content cannot be easily replicated.

This type of content relies on tangible social proof.

Look at this example from Shopify.

There are many women looking to start a business as a mom.

Did Shopify write a generic article to answer that?
No, they relied heavily on their community.

Here are some examples of community-led content:

  • (Gardening company)

15 farmers share how to become self-sufficient in a year

  • (Sportswear company)

Pro runners’ advice for running your first marathon

  • (Beauty company)

Summer 2024: our customers’ best morning routines for a glowing skin


👀 Part 3: Build authority and a following

Search engines prioritize authority.

It’s central to Google’s E-E-A-T guidelines.

Content that integrates expert points of view gets rewarded.

Content produced or written by experts wins search results.

  • Health? Doctors.
  • Sales? Salesmen.
  • Marketing? Marketers.
  • Real estate? Agents.
  • Entrepreneurship? Entrepreneurs.


It’s not always easy to find « experts » in your field, but you get the idea.

The more credibility and authority your content creators have, the better.

Shopify does this really well with their « founder stories ».

Instead of publishing generic content about how to create a business around toys, Shopify published an actual interview of how this entrepreneur found success in this business.

 

🎥 Part 4: Don’t play fair, make videos

Did you know that YouTube is the world’s second-largest search engine?

It boasts 2.5 billion logged-in monthly users.

Do you know what ChatGPT and others cannot do?

Answer questions with videos. They can’t. At least for now.

AI chatbots beat you on written content? Create video content.

Video content is hard to imitate. It’s a great way to distinguish yourself from what other companies and AI chatbots do.

Videos also perform well on Google’s search results. They create a deeper connection with your audience.

Video marketing is a solid strategy to fight AI on search results.


That’s it for today. If you found this interesting, consider subscribing to the newsletter.

Join 250+ marketers learning growth marketing with practical tactics and proven tools.

It’s free – and marketers receive 1 growth tactic, 1 tool & 1 news recap every week.

Share this story with someone :

Email
Twitter
LinkedIn
5 mins

Get your weekly dose of marketing hacks

« Useful, concise and packed with actionnable tips. »

Your weekly marketing expresso

Hey, I’m Paul.

I share actionable marketing tactics and tools from my experience as a digital marketer over the past 8 years.

Your time is short, so my weekly email goes straight to the point:

  • 1 tactic for better campaign results
  • 1 tool  to get ahead of the competition
  • 1 news recap for staying up-to-date


Sounds good? You’ll become a better marketer, guaranteed.