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.
What is PPC (pay-per-click) marketing? Pay-per-click marketing is a way of using search engine advertising to generate clicks to your website, rather than “earning” those clicks organically. You know those sponsored ads you often see at the top of Google’s search results page, marked with a yellow label? That’s pay-per-click advertising (specifically Google AdWords PPC, which we’ll talk about below).
CTAs match user intent inferred from content. Here is where you’ll evaluate whether the CTAs match the user intent from the content as well as the CTA language. For instance, if a CTA prompts a user to click “for more information,” and takes them to a subscription page, the visitor will most likely be confused or irritated (and, in reality, will probably leave the site).
We at Moz custom-built the Keyword Explorer tool from the ground up to help streamline and improve how you discover and prioritize keywords. Keyword Explorer provides accurate monthly search volume data, an idea of how difficult it will be to rank for your keyword, estimated click-through rate, and a score representing your potential to rank. It also suggests related keywords for you to research. Because it cuts out a great deal of manual work and is free to try, we recommend starting there.

Website. What’s the first thing visitors see in your competitor’s website? Is there much text on the website, and if there is, what does it emphasize about your competitor’s business? Do they have customer reviews and testimonials? Make note of the design as well. Is their website static and minimalist, or does it have animation and other interactive features? Apart from judging the copy, design, and features of the site itself, does the site rank well for relevant search terms that you think your potential customers could use? If you’re selling handmade leather wallets, try doing a Google search for “handmade leather tool wallets” and see if any of your competitors are in the first few pages.

There are some general negative keywords that should be added to almost any campaign, such as “free”, “jobs” “training”, as people searching for these terms are not likely to be looking to buy your product. Keywords like “review” and “opinions” can also be useful, as they will reduce the number of window shoppers who aren’t necessarily looking to buy now. But you’ll also want to research negative keywords specific to your business or audience. For example, if you are an optometrist, you’ll want to use words like “wine”, as you aren’t looking for customers in search of “wine glasses.

A competitor's capabilities can be analyzed according to its strengths and weaknesses in various functional areas, as is done in a SWOT analysis. The competitor's strengths define its capabilities. The analysis can be taken further to evaluate the competitor's ability to increase its capabilities in certain areas. A financial analysis can be performed to reveal its sustainable growth rate.
Lastly, if you have the opportunity, maintain the competitor review and analysis every 6 months. It provides you with an external perspective. Competitive analysis needs to be integrated with other product management and marketing activities. Overly concentrating on what competitors are doing can distract you from remaining focused on your customers.
Why make the same mistakes your competitors have made when you can learn from them? As its name implies, SpyFu is a great way to spy on the competition so you can learn from their failures and more importantly, their successes. When you type in a competitor's URL, you'll be able to see how many keywords they are ranking for organically and even the ad value of those keywords. It also offers good analytics on backlinks driving the most traffic to your competitors' sites so you can see where you might want to  publish guest blogs or be listed. If they are running any paid advertising campaigns, you can even see what campaigns they're running and how much they're spending.  
Without machine learning reducing the cost of PPC for small businesses, it’s true that they typically aren’t willing to spend the necessary budget to see results. Traditionally (are you sitting down?), —anything under $500 a month is not worth it. In fact (take a deep breath), you probably won’t see great results with a budget of less than $1000 a month.
This emphasis on competition is related to the advent of game theory in the mid 20th century around the same time. The problem is that game theory is one mental model of many to help make decisions, not the only one (Ben Thompson from Stratechery has a good post on the Prisoner’s Dilemma that is a fundamental one). Even researchers are starting to point to the fact that there are no perfect solutions (such as a Nash equilibrium) to most situations.
You need a keen understanding of your ideal customer and the market so that when you launch, your product is positioned correctly in the ecosystem of all products and services. Since competition can come from anywhere, you need to catalog your strengths and weaknesses relative to both direct and indirect category leaders (i.e., those adjacent to your core business).
Use the search intent of a keyword to help determine what sort of page it should be used on. Informational keywords should be used on pages optimized for a branding campaign with content such as how to guides or product comparison articles. Avoid using these pages to target more specific in-market keywords. Those searchers have no use for a how-to guide or product comparisons. Use those to target your product pages that include specs, reviews, options and, most importantly, price and the "buy now" button. Of course, the “buy now” button could also be the email sign-up page or contact information form, depending on the type of goals you’re targeting.
Putting each competitor in the right list is a very important part of competitive analysis because the features and functionality in your competitors’ apps are based on exactly what users of those apps want. Let’s assume you put one indirect competitor, XYZ, under the “direct competitors” list and start doing your analysis. While doing the research, you might find some impressive feature in XYZ’s app and decide to add a similar feature in your own app; then, later it turns out that the feature you added is not useful for the users you are targeting. You might end up wasting a lot of energy, time and money building something that is not at all useful. So, be careful when sorting your competitors.
Along with understanding how your potential customers are searching for your company and/or product online, you also need to decide what part of the sales process you want to target. Are you looking to start a prospecting campaign that attracts users at the very beginning of the process, and then convert them later via email marketing or retargeting? Or do you want your website to be shown in front of in-market searchers who are looking to buy right away?

“The sales cycle is an average of 9-12 months. When a qualified lead enters the funnel, the revenue generated from that lead is an unknown variable that will not be fully identified until several months into the cycle. In order to increase the probability of a PPC lead turning into a viable source of revenue we need to generate leads at a ratio of high ratio of sales quality leads to conversions (roughly 65%). We will continue to test new targeting in order to reach our 20% YoY growth goal at a reasonable average CPA in order to continually grow the account and keep the sales funnel full every month.”
Information from an analysis of the competitor's objectives, assumptions, strategy, and capabilities can be compiled into a response profile of possible moves that might be made by the competitor. This profile includes both potential offensive and defensive moves. The specific moves and their expected strength can be estimated using information gleaned from the analysis.
Many people believe that a competitive analysis is unnecessary because they feel that they have a good handle on who their competition is and what they offer. But a competitive analysis can also be used when trying to break into a new market. By conducting a competitive analysis for an environment you are unfamiliar with, you are able to model a new business that included many features that your competitors are likely to offer as well as some unique ones that may drive customers away from their typical company.

Lower Costs: When there is a near-infinite supply of search query impressions each month, your strategy is to lower your cost per click in order to drive more click (and conversion) volume to your website. This generally involves making use of keyword list refinement (match types, negative keywords) and lowering bids while keeping an eye on average position.
More specifically, who gets to appear on the page and where is based on an advertiser’s Ad Rank, a metric calculated by multiplying two key factors – CPC Bid (the highest amount an advertiser is willing to spend) and Quality Score (a value that takes into account your click-through rate, relevance, and landing page quality, among other factors). In turn, your Quality Score affects your actual cost per click, or CPC.
Some publishers and networks have even developed performance-based marketing plans based on geo-targeted ads. Ads and marketing are only placed and paid for when there have been proven results to show that this venture is worth it. It has always been very effective to target a certain demographic based off of their age, gender, or career. This can be taken even further by taking a look at certain locations and what demographics reside there. Website data can be used to determine what geographic locations are most frequently perusing a site and that area can be targeted as well.
Working on common practice tasks such as negative matching, keyword expansion and more are the right things to do for an account, and there’s a proper place and time to do them. Without a policy governing how to manage our PPC accounts, we’re “stringing tactics together,” which creates misalignment between volume of work done versus meaningful work that’s impacting results positively.
There are various platforms available for PPC ads like Google, Yahoo, Bing and social media channels like Facebook. Choose wisely your platform and plan your ad campaign strategy, according to it. Google is the most effective and famous platform for PPC campaigns. Google Adwords is an advertising interface provided by Google, which is used to plan and publish Google ads. Similarly, Bing ads and Facebook ads provide all required interfaces for an effective PPC campaign.
Tertiary Competition: This category includes businesses that are tangentially related to yours, and really comes in handy when you’re looking to expand your product catalog. These could be related products and services that are trending, as well as businesses that may be beneficial to partner with further down the line. For instance, if you sell jewelry, a tertiary competitor may sell gems and stones.
Geofencing mostly uses GPS technology (which communicates with the tiny chip in your phone) to cordon off an area with a virtual fence. When a device moves into (or out of) the space defined by the fence, triggers are sent, and the user will receive a notification, for example a text or push notification (provided they are opted into those channels).

In online environments, ad servers look at a user’s IP address to figure out their ‎location.  Behind the scenes, the ad server maintains a large database that has ‎every IP address already mapped to its country, state, and postal code.  So, when a ‎request comes in, the ad server strips the IP address from the header of the ‎request, queries this table, finds the necessary location data, and then picks an ad ‎that matches that criteria.  ‎
Estimated Costs: Creating content to adequately target specific keywords will require varying amounts of time, money, and effort. In some situations, you might find that targeting a certain keyword also allows you to SEO your landing page at the same time. So be on the lookout for shortcuts that might make ranking for a keyword more cost-efficient than it would otherwise be. That’s how you can find real money-makers!

Every business can benefit from attracting higher value customers. Whether you’re a real estate company looking for high net worth individuals looking to buy property or a B2B SaaS company looking for a higher average revenue per user (ARPU), attracting customers who will pay you more than others is a powerful way to amplify the growth of your business.
Yes, that sounds like it would be awesome. Another great update would be to add a script that populates the spreadsheet automatically from a file structure containing the downloads (organic KWs and Links) to save copying and pasting everything. I’m going to have a chat with a friend in the Analytics space to see if he can help. Will share any successful output.