Export the weighted list back to your spreadsheet and combine it with the others in Excel. Then use the data tools to sort the list by ‘Priority’ – this is a score based on the difficulty, traffic, opportunity and your score. This tells you which keywords you should be targeting in descending order of attractiveness. Suddenly, you’ve turned more than 1,000 keywords into a usable list of a few dozen. Using the same example for wines:
Your Sales ForceYour sales staff probably has more access to competitive information than anyone else in your organization. Customers often show salespeople sales literature, contracts, price quotes, and other information from competitors. Part of a salesperson's job is to get customers to discuss problems they have with a competitor's product. Customers will also reveal your competition's product benefits, strengths, and customer service programs. Instruct your sales force to ask for copies of any competitive literature if and when that's possible. Your entire sales staff should keep a record of all competitive information they discover — even if it's just a rumor or gossip. Devote a regular portion of each sales meeting to a discussion of the competition.
Set priorities. Once goals are established, it’s important to determine key priorities. For instance, if the primary goal is revenue growth, the priority should be executing initiatives that drive conversions, such as keyword or audience expansion. On the other hand, if the primary goal is driving profit, then the priority should be focused on initiatives such as search query report (SQR) mining for negative keywords and other forms of optimization.
HubSpot's marketing automation software has several tools just for this purpose. The first is the HubSpot keyword tool, which allows you to keep track of keywords you're targeting. Once you've done your research and know which keywords are most likely to perform well, you can import those keywords into the tool. The tool will show you how you're currently ranking for those terms and whether your ranking is moving up or down over time.
Unfortunately, I can’t answer all of these questions for you. But I will offer up one solution, and that’s the valuable question of where to begin. Segmenting out an audience is often one of the most important and daunting tasks for a marketer. But the work is worth it. Segmenting visitors into audiences is going to make conversion marketing campaigns more relevant and effective. An easier way to segment is by using something called geo-targeting.
When using the Keyword Explorer, Ahrefs will also produce the "parent topic" of the keyword you looked up, as you can see in the screenshot above, underneath the Keyword Difficulty meter. A keyword's parent topic is a broader keyword with higher search volume than your intended keyword, but likely has the same audience and ranking potential -- giving you more a valuable SEO opportunity when optimizing a particular blog post or webpage.