In the figure below, you can see I have set up a keyword rating spreadsheet. I first gathered keyword data from a keyword tool to populate the orange columns. In this example, I used the Google AdWords Keyword Tool. From there I began looking at each keyword and gave each one a score from one to 10. For some I built a formula to automate the process, which comes in handy with larger keyword lists.
Geo-targeting refers to the ability for advertisers to place their marketing materials in a specific region or locale. In digital advertising specifically, geo-targeting is just one of many tweaks that an advertiser can make to ensure that its messages and ad campaigns reach a particular customer in a particular market. In addition to geo-targeting, online ads can be targeted by additional demographic information like age, gender, hobbies and so on.
As a manager, this may take the form of believing that people with less experience but lots of initiative tend to outperform experts. It may mean looking past the traditional resume. As an entrepreneur, this may be a conviction that some social stigma, like sleeping in someone else’s home (Airbnb), wearing someone else’s dress (Rent the Runway) or persistently sharing your location with all your friends (FourSquare), will lessen over time and eventually disappear.

ClickBank is the retailer of products on this site. CLICKBANK® is a registered trademark of Click Sales, Inc., a Delaware corporation located at 917 S. Lusk Street, Suite 200, Boise Idaho, 83706, USA and used by permission. ClickBank's role as retailer does not constitute an endorsement, approval or review of these products or any claim, statement or opinion used in promotion of these products.
In the Google Sheets Template, I've provided you with the data points that we'll be collecting, the tools you'll need to do so, and then bucketed the metrics based on similar themes. The data we're trying to collect relates to SEO metrics like domain authority, how much traffic the competition is getting, which keywords are driving that traffic, and the depth of competitors’ backlink profiles. I have built in a few heatmaps for key metrics to help you visualize who's the strongest at a glance.
You can search for these types of competitors online (by doing a simple web search), or you can directly ask your current and potential customers what they are using already. You can also look for your direct and indirect competitors on websites such as Crunchbase and Product Hunt, and you can search for them in the Google Play and the iOS App Store.
Now as searchers start to gather information, they begin to refine their search and start using more specific terms. Then finally they begin to use very specific terms. They have switched from information gathering to a transactional mode. If someone searches on the term “canon eos mark III,” what does that suggest about their intent? That they have done their research and are ready to buy. So do you send them to your home page? Absolutely not. You need to send them to your product page that has the product, its features, maybe related products, the price, and most importantly the “buy now” button. They don’t need more information; they’re probably price shopping and are looking for a trusted source with the best price.

7. Use a keyword research brief to share for unified messaging. The final tip is to attempt to break down the silos that are typical in medium to large organizations and share with them enough keyword data so they can be encouraged to use your targeted keywords in their respective messaging. One way to do this is to develop what I call a keyword research brief. This is simply a document that is like an executive summary of keyword research for your top keywords. This document should be no more than one to two pages. It should be a quick read. See an example of this below.
Your CompetitorsYou probably see the owner of a rival organization at trade shows, association meetings, and perhaps even socially. You can garner a great deal of information through a simple, friendly conversation. People like to talk about themselves and share their success stories and concerns with business associates. Assign someone to check the competitions' Web sites regularly for pertinent changes and news. (And take a good look at your own: Do you say anything there that you'd just as soon not have your competitors see?)  
The Java program is fairly intuitive, with easy-to-navigate tabs. Additionally, you can export any or all of the data into Excel for further analysis. So say you're using Optify, Moz, or RavenSEO to monitor your links or rankings for specific keywords -- you could simply create a .csv file from your spreadsheet, make a few adjustments for the proper formatting, and upload it to those tools.