Top 7 SEO Keyword Research Tools For Agencies 

 All successful SEO campaigns rely on accurate, comprehensive data. And that process starts with the right keyword research tools. Sure, you can get away with collecting keyword data manually on your own. But while you may be saving the cost of a premium tool, manual keyword research costs you in ot her ways: Efficiency. Doing keyword research manually is time intensive. How much is an hour of your time worth? Comprehensiveness. Historical and comprehensive data isn’t easy to get on your own. It’s too easy to miss out on vital information that will make your SEO strategy a success. Competition. Keyword research tools allow you to understand not only what users are searching for but also what your competition focuses on. You can quickly identify gaps and find the best path to profitability and success. Knowledge. Long-time SEO experts can craft their own keyword strategies with a careful analysis of the SERPs, but that requires years of practice, trial, and costly errors. Not everyone has that experience. And not everyone has made enough mistakes to avoid the pitfalls. A good SEO keyword research tool eliminates much of the guesswork. Here are seven well-known and time-tested tools for SEO that will get you well on the way to dominating your market. 1. Google Keyword Planner Cost: Free. Google Keyword Planner is a classic favorite. It’s free, but because the information comes directly from the search engine, it’s reliable and trustworthy. It’s also flexible, allowing you to: Identify new keywords. Find related keywords. Estimate the number of searches for each variation. Estimate competition levels. The tool is easy to access and available as a web application and via API, and it costs nothing; it just requires a Google Ads account. You must also be aware of a few things when using this tool. First, these are estimates based on historical data. That means if trends change, it won’t necessarily be reflected here. Google Keyword Planner also can’t tell you much about the SERP itself, such as what features you can capitalize on and how the feature converts. Because it’s part of Google Ads, PPC experience can help you gain more insights. You’ll find trends broadly across a demographic or granular level, like a city, region, or major city. Google Keyword Planner also tends to combine data for similar keywords. So, if you want to know if [keyword near me] is better than [keywords near me], you’ll need a different tool. Lastly, the tool uses broad definitions of words like “competition,” which doesn’t tell you who is ranking for the term, how much they’re investing to hold that ranking, or how likely you are to unseat them from their coveted top 10 rankings. That being said, it’s an excellent tool if you just want to get a quick look or fresh ideas, if you’d like to use an API and create your own tools, or simply prefer to do the other tasks yourself. 2. Keyword.io Cost: Free, $29 per month, and $49 per month. If Google’s Keyword Planner isn’t quite enough, but you’re on a tight budget, Keyword.io may be the alternative you need. It also has different features. Keyword.io uses autocomplete APIs to pull basic data for several sites and search engines, including Google, Amazon, eBay, Bing, Wikipedia, Alibaba, YouTube, Yandex, Fiverr, and Fotolia. This is perfect for niche clients and meeting specific needs. It also has a Question/Intent Generator, an interactive topic explorer, and a topical overview tool. In its user interface (UI), you’ll find an easy-to-use filter system and a chart that includes the competition, search volume, CPC, and a few other details about your chosen keywords. It does have some limits, however. You can run up to 20,000 keywords per seed with a limit of 100 requests per day (five per minute) or 1,000 requests per day (10 per minute) on its paid plans. Its API access, related keywords tool, Google Ad data, and other features are also limited to paid accounts. 3. Semrush Cost: $119.95 to $449.95 per month. In its digital marketing suite, Semrush offers a collection of six keyword tools and four competitive analysis tools with a database of more than 21 billion keywords. You can get a full overview of the keywords you’re watching, including paid and organic search volume, intent, competition, CPC, historical data, SERP analysis, and more. You’ll get related keywords and questions, as well as a ton of guidance, ideas, and suggestions from the Semrush Magic, Position Tracking, and Organic Traffic Insights tools. The Keyword Planner, however, is where much of the magic happens. The organic competitor tab makes it easy to spot content and keyword gaps. Expand them and develop clusters that will help you grab traffic and conversions. You can also see long-tail keyword data and other data to see what Page 1 holds regarding competition, difficulty, and opportunities at a broad or hyperlocal level. The full suite of tools is a huge benefit. Teams can collaborate, share insights, and plan. The seamless integration allows you to integrate your data, meaning teams can easily collaborate, share insights, and strategize. And when you’re done, it can track everything you need for a successful digital marketing strategy. Some of the tools they offer include: On-page SEO tools. Competitive analysis suite. Log file analysis. Site auditing. Content marketing tools. Marketing analysis. Paid advertising tools. Local SEO tools. Rank tracking. Social media management. Link-building tools. Amazon marketing tools. Website monetization tools. Semrush’s best features when it comes to keyword research are its historical information and PPC metrics. You can deep dive into campaigns and keywords to unlock the secrets of the SERPs and provide agency or in-house teams with priceless information they don’t usually access. 4. Moz Keyword Explorer Cost: Free for 10 queries per month. $99-$599 per month. With a database of more than 500 million keywords, Moz Keyword Explorer may be a great option if you’re looking to build a strategy rather than get a quick view of the data for a few keywords. Moz has long been a leader in the SEO space. Constantly updating and improving its Keyword Explorer Tool and its other core services, Moz keeps up with the trends and is well known for providing SEO professionals with the latest tools. And it has done so for more than a decade. Like the Google Keyword Tool, Moz’s keyword planning tool provides information on the difficulty and monthly search volume for terms. It also lets you drill down geographically. When you start, you’ll find the Keyword Overview, which provides monthly search volumes, ranking difficulty, organic click-through opportunities, and an estimated priority level. You can also: Find new relevant keywords you should be targeting but aren’t. Learn how your site performs for keywords. Find areas where you can improve your SEO (including quick wins and larger investments). Prioritize keywords for efficient strategy creation. Top SERP analysis and features. Competitor analysis. Organic click-through rates. Unlike the Google Keyword Tool, however, Moz supplies you with data beyond the basics. Think of it like keyword research and SERP analysis. Moz does tend to have fewer keyword suggestions. And like Google’s Keyword Planner, it provides range estimates for search data rather than a specific number. However, the database is updated frequently, so you can feel confident that you’re keeping up with the constant change in consumer search habits and rankings. Plus, it’s easy to use, so teams can quickly take care of marketing tasks like finding opportunities, tracking performance, identifying problem areas, and gathering page-level details. Moz also offers several other tools to help you get your site on track and ahead of the competition, but we really like it for its keyword research and flexibility. 5. Ahrefs Keyword Explorer Cost: $99-$999 per month. If I had to describe Ahrefs in one word, it would be power. Enter a word into the search box, and you’re presented with multiple panels that can tell you everything you want to know about that keyword. Total search volume, clicks, difficulty, the SERP features, and even a volume-difficulty distribution. And while it may look like a lot, all the information is well-organized and clearly presented. Ahrefs provides terms in a parent-child topic format, providing the terms with context, so you can easily learn more about the terms, such as intent, while identifying overlap and keeping it all easy to find and understand. These topics appear when you search for a related term, including the term’s ranking on the SERP, SERP result type, first-page ranking difficulty scores, and a snapshot of the user-delivered SERP. You can stay broad or narrow it all down by city or language. Ahrefs can get a bit expensive. Agencies may find it difficult to scale if they prefer several user or client accounts, but it’s still one of the best and most reliable keyword research tools on the market. What I really like about Ahrefs is that it’s thorough. It has one of the largest databases of all the tools available (19.2 billion keywords, 10 search engines, and 242 countries at the time of writing), and it’s regularly updated. It makes international SEO strategies a breeze and includes data for everything from Google and Bing to YouTube and Amazon. Plus, they clearly explain their metrics and database. And that level of transparency means trust. Other tools in the suite include: Site Explorer. Site auditing. Rank tracking. Content Explorer. 6. SERanking Cost: $23.52-$239 per month, depending on the ranking check and payment frequency. SERanking shines as a keyword research tool within an all-around SEO toolkit. SERanking helps you keep costs down while offering features that allow agencies to meet clients’ unique needs. One of the first things you’ll notice when you log in is its intuitive user interface. But this tool isn’t just another pretty online tool. Its database is robust. SERanking’s U.S. database includes 887 million keywords, 327 million U.S. domains, and 3 trillion indexed backlinks. And this doesn’t include its expansive European and Asian databases. The overview page provides a solid look at the data, which includes search volume, the CPC, and a difficulty score. SERanking also provides lists of related and low-volume keywords if you need inspiration or suggestions, as well as long-tail keyword suggestions with information about SERP features, competition levels, search volume, and other details you need to know to identify new opportunities. Of course, identifying keywords is only the start of the mystery. How do you turn keywords into conversions? SERanking provides keyword tools that help you answer this question. You can find out who the competition is in the organic results and see who is buying search ads, as well as details like estimated traffic levels and copies of the ads they’re using. This allows you to see what’s working, gain insights into the users searching for those terms, and generate new ideas to try. SERanking offers agency features, such as white labeling, report builders, lead generator, and other features you’ll find helpful. However, one of the features agencies might find most helpful in keyword research is SERanking’s bulk keyword analysis, which lets you run thousands of keywords and download full reports for all the terms that matter. Other tools in the SERanking Suite include: Keyword Rank Tracker. Keyword Grouper. Keyword Suggestions and Search Volume Checker. Index Status checker. Backlink Checker. Backlink monitoring. Competitive research tool. Website auditing tool. On-page SEO Checker. Page Changes Monitor. Social media analytics. Traffic analysis. SERanking is more affordable than some of the other tools out there, but it does come at a cost. It isn’t as robust as some of its competitors and doesn’t get as granular in the same way, but it still provides the features and data you need to create a successful SEO strategy. And with its flexible pricing, this tool is well worth considering. 7. BrightEdge Data Cube Cost: Custom pricing model. If you’re looking for an AI-powered digital marketing tool suite that includes a quality research tool, BrightEdge may be the right option for you. Unlike other tools that focus on supplying you with data and ways to analyze that data, BrightEdge looks to do much of the time-consuming analysis for you. Among its search, content, social, local, and mobile solutions, you’ll find Data Cube – an AI-backed content and keyword tool that uses natural language processing to find related topics and keywords. You’ll also encounter DataMind, an AI that helps you find search trends, changes in consumer behaviors, and important competitor movements you need to know about. The two together make it quick and easy to perform keyword research, build out topics, create content strategies, and strengthen your SEO plans. Once you enter a topic or broad keyword, the tool will provide you with relevant keywords, the search volume, competition levels, keyword value, it’s universal listing, and the number of words in the phrase. Filter the results by a custom set of criteria to narrow the list down and get the necessary information. Once you have a list, select the ones you want to keep and download them or use them with BrightEdge’s other tools to create full strategies and gain more insights. This could include competitor analysis, analyzing SERP features, intent, or other tasks. For agencies that provide local SEO, BrightEdge also offers HyperLocal, which helps you find and track keywords and keyword performance at the local level. When you’re done, give the Opportunity Forecasting and tracking tools a try to monitor your progress and provide clients with the information they care about. Perhaps the nicest feature for agencies is its Storybuilder – a reporting tool that allows you to create rich client reports that provide clients with targeted overviews and the data they’re most interested in. If this sounds like the right tool for you, the company gives demos, but there are a few things you should consider. First, it only updates once per month. And while the company keeps its pricing close to the chest, this digital marketing tool suite is a significant investment. It may not be the best choice if keyword research is the only thing you need. Secondly, while the tools are highly sophisticated and refined, there is a learning curve to get started. You’ll also discover that there are limits on features like keyword tracking, and it can be time-consuming to set up, with some adjustments requiring technical support. Lastly, BrightEdge’s keyword research tool doesn’t let you get too far into the weeds and doesn’t include PPC traffic. That aside, agencies and larger brands will find that it scales easily, has a beautifully designed UI, and makes you look great to clients. The Best Agency SEO Keyword Research Tools This list only contains seven of the many tools available today to help you get your keyword research done to an expert degree. But no matter how many of the tools we share with you or which ones, it’s important to understand that none are flawless. Each tool has its own unique strengths and weaknesses, so selecting a platform is very much dependent on the types of clients that you typically work with and personal preference. In reality, you’ll likely find that you prefer to work between a few tools to accomplish everything you’d like. Google Keyword Planner and Keyword.io are top choices when you want a quick look at the data, or you’d like to export the data to work on elsewhere. You may even want to use this data with the other tools mentioned in this chapter. Ahrefs, Moz, Semrush, and BrightEdge are far more robust and are better suited to agency SEO tasks. While not free (although they offer free plans or a trial period except BrightEdge), they allow you to really dig into the search space, ultimately resulting in higher traffic, more conversions, and stronger SEO strategies. These benefits require more time and often come with a learning curve. By far, the most important keyword research tool you have access to is you. Keyword research is more than simply choosing the keywords with the biggest search volume or the phrase with the lowest Cost Per Click (CPC). It’s your expertise, experience, knowledge, and insights that transform data into digital marketing you can be proud of. Featured Image: Paulo Bobita/Search Engine Journal

Best SEO Software (February 2023) 

If you want your website to rank higher on Google, then consider adding Ahrefs to your tech toolbox. Ahrefs is an all-in-one SEO tool that helps you find keywords your customers are searching for and evaluate keyword volume and difficulty. With Ahrefs, you can also track keyword rankings in search engine results pages (SERPs), monitor website backlinks (sites linking back to your website) and audit your website so you can optimize it for search. Simply put, Ahrefs is one of the most powerful SEO tools on the market. Ahrefs’ extensive suite of features requires a bit of a learning curve to master, but its uncluttered dashboard makes Ahrefs easier to navigate than other advanced SEO tools on the market. If you want to get a taste for how Ahrefs works, you can sign up for a free Ahrefs Webmaster Tools (AWT) account. AWT offers limited access to search traffic and keywords, backlink data and SEO health, but it pales in comparison to what a full Ahrefs plan offers. Ahrefs offers four plans that range from $83 to $833 per month when paid annually. If you prefer to stick with a month-to-month plan, your monthly payment will range from $99 to $999. The Ahrefs Lite plan is often sufficient for small businesses. To tap into Ahref’s full power, you’ll need to go with either a Standard or Advanced plan, which are packed with more features including Site Explorer, Content Explorer, Domain Comparison and the ability to track six months to two years of backlink and ranking data. Ahrefs provides several online resources to help you master the platform and SEO. The online Help Center houses dozens of articles and troubleshooting guides while the Ahrefs Academy features a variety of video tutorials. Customer support is provided via email and online chat, and for the most part, you can expect a timely response to your queries. Phone support is not available. Who should use it: Forbes Advisor considers Ahrefs the best overall SEO tool on the market. With four plans to choose from, Ahrefs is right for all types of users, from beginners to advanced technical users.

Using Excel For SEO: 7 Essential Tips & Tricks You Might Not Know 

It may not look like one of the fancy, paid SEO tools you’re used to logging into, but Excel remains one of the most versatile and powerful tools in an SEO professional’s toolbox. You can use Excel to track and analyze key metrics such as rankings, website traffic, and backlinks. Use it to create and update meta tags, track and analyze competitors’ SEO strategies and performance, build automated reports, and take care of many of the data tasks you’ll encounter every day. Combine your Excel knowledge with Python, Tableau, R, and other tools, and there is nothing you can’t do. If you’ve never worked with data before, you’ll find Excel has a bit of a learning curve, but you can use it right from the start. And it’s flexible enough to scale and grow as your site grows. Why Excel For SEO Tasks? While many paid tools can help you do the same tasks, Excel is a fantastic option to enhance, combine, or replace those tools. It’s affordable and comes with a range of tools you already use. There are a ton of resources and courses to help you learn. Easily handles large amounts of data. Sorting and de-duplicating – a feature often missing when you need it. Create and manage databases with simple formulas. Data ports easily to other tools and is available for other tasks. Pivot tables and smart charts. 1. Combine Multiple Data Sources You will often find yourself having to merge data from multiple sources. This is intuitive and quick in Tableau, Python, or R, but you can do the same in Excel using Power Query. There are a few steps to this process, but it’s not as complicated as you might think – even if you are new to working with data or Excel. Power Query has automated and simplified tasks that required a lot of time and skill. And it is probably THE best Excel feature for business and SEO professionals. Seem a bit daunting? Don’t worry. There are several courses and tutorials on YouTube to get you started. What It’s Good For: Building reports. Analytics and sales data. Combining data sources to identify opportunities and gain insights. 2. Data Cleaning Much of your time is lost simply preparing data for analysis. It doesn’t have to be that way. Large lists are often larger than they need to be. Finding and manually removing all the duplicates, however, can be a serious pain. Excel can do this instantly for you. Simply go to the “Data” tab and click “Remove Duplicates.” Unwanted spaces and blank lines tend to cause havoc with many tasks, formulas, and statistics. Excel will remove them for you simply by going to Edit > Find > Go To. Select “Special,” “Blanks,” and tell Excel how it should handle them. “Convert text to columns” can be a lifesaver, especially if you’ve received data where the addresses or names are all in the same cell or you need to extract domains from email addresses. Go to Data > Text to Columns. Then, indicate what to use for Delimiters (comma or space) and preview the results. When you’re ready, click “Next,” choose a destination, and click “Finish.” When To Use It: Data analysis. Data processing. Processing and cleaning lead databases. Working with any data.  3. Power Excel With Add-On Tools Some of the more complex tasks, such as crawling, require a bit of coding knowledge. If you don’t have that in your skillset, however, there are tools you can download, integrate with other tools, and add on. SEOTools offers off and on-page SEO tools, integrations, connectors, spiders, and several other tools that make it easy to customize your Excel and create custom projects. SEOGadget brings the power of Moz, Grepwords, and Majestic to Excel. Analysis ToolPak is for serious data analysis. This add-on improves and automates in-depth statistics, perfect for forecasting, trending, regression analysis, and more complex data analysis tasks you might otherwise perform in R or Python. When To Use It: Reporting. Regular data analysis. Presentations. Integrating and coordinating with other teams. 4. Infographics And Charts Data is useless if you can’t understand it. In fact, data visualization and storytelling are likely some of the most important skills you can have. This is where tools like Power Query and PivotTables come in. Built right into Excel, pivot tables are the other valuable tools you have for this purpose. However, instead of just creating a straight pivot table and a related chart, save yourself some steps by creating a master “template” first that you can then replicate as needed and adjust to suit your needs. In many instances, however, you will need to work with dates or segments of the data. For that, you’ll want to enter splicers and timelines. To splice data into segments: Select the pivot table and go to PivotTable Tools > Analyze > Filter > Insert Slicer. Then, simply input how you would like to segment the content (e.g., by product or topic). To utilize timelines: Click the pivot table’s tools option, go to Analyze > Filter > Insert Timeline. Once there, you can choose what you’d like to use, style it, add captions, and more. If you’ve never used Excel’s PivotTables before, a short tutorial will have you on your way to analyzing data in no time. Still want a little more? Make your reports, social media, and updates even better by upping your data visualization game with add-ons like People Graph. When To Use It: Reporting. Daily updates. Surface data analysis. Team collaboration and integration. 5. Automate Common Tasks With Macros SEO, particularly agency SEO, is full of repetitive tasks like weekly reporting that consume much of your time. Excel’s macros are the answer. And they’re really easy to use. Under the “View” tab, click “Macros” and “Record Macro.” Fill out the details. The macro is now recording. So, simply walk through the steps that you’d like to automate. And when you’re done, go back to the ribbon and stop the recording. When you’re ready to run the automation, go to the macro button in the ribbon, click “View Macros,” and select the desired macro from the list. If you have some macros that you use more often than others, you can add them to the Quick Access Toolbar. When To Use It: Sorting. Calculations. Reformatting data. Setting up new site documents or new pages for reports. 6. Easily Import Feeds And Data Into Excel If you use Google Alerts or publish frequently, automatically importing feeds into Excel can be a huge time saver. To start, simply grab the RSS feed address. (Or, create an alert for Google Alerts and have them delivered as an RSS feed.) Then, go to Google Sheets and use the IMPORTFEED function to bring the updates straight into a spreadsheet. Alternatively, you can add the information to separate columns. From here, you can regularly download and import the data into Excel, combine it with other related data, or integrate it into your custom dashboards. If you need something a little more automatic, use Google Apps Script or one of the add-ons available to automate the process. Want a little more data behind your reports? You can scrape and import Google Search Results into Excel, too. 7. Backlink Analysis To analyze backlinks with Excel, collect backlink data with tools such as Ahrefs, Majestic, or Google Search Console. Then, import it into Excel and use it to analyze your backlinks in a number of ways: Who links to you: Use Excel’s sorting and filtering tools to filter the data and use the IF function: IF(logic, true_value,[false_value]) to sort and identify domains linking to you. What do people link to: Sort and filter to see the anchor text used most often for your backlinks (using frequency/count). When did people link to you: Organize the data by date to see how old your links are and when most of your backlinks were acquired. Find trends or patterns in your backlink profiles with pivot tables, groups, charts, and graphs by combining your backlink and sales or conversion data. Highlight specific data based on certain conditions with conditional formatting. This makes it easy to spot backlinks from high-authority websites or backlinks with specific anchor text. Summary Many people overlook Excel either because they think it’s too basic to be of much use. Or it looks too intimidating or daunting to learn. But those of us who use it understand just how powerful it can be and the unlimited possibilities it provides. Hopefully, these tips will help you craft better strategies, find new opportunities, and tell your story with better reports and dashboards. Featured Image: Paulo Bobita/Search Engine Journal