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.
Geo-Targeting content is simple and beneficial to most websites, advertisers and publishers, as well anyone using PPC campaigns or SEO. Not only does it enable you to match the most relevant content to your visitor, Geo Targeting also serves as an excellent basis for experimenting with traffic to optimize your funnels. Some ideas were presented here that may be tested, but the options are virtually limitless.

Geo-targeting (sometimes spelled geotargeting or geo targeting) involves detecting a user’s location, and serving them communications based on that location. Those communications might be ads or other content, like an email or geo-targeted push notification. Geo-targeted communications are delivered most commonly through text or push, and might also come when you open a certain app or social media site. The benefit of geo-targeting services are simple: enhanced personalization.
A quick and easy way to compare your product or service with similar ones on the market is to make a competition grid. Down the left side of a piece of paper, write the names of four or five products or services that compete with yours. To help you generate this list, think of what your customers would buy if they didn't buy your product or service.
In this example, competitor #1 is rated higher than competitor #2 on product innovation ability (7 out of 10, compared to 4 out of 10) and distribution networks (6 out of 10), but competitor #2 is rated higher on customer focus (5 out of 10). Overall, competitor #1 is rated slightly higher than competitor #2 (20 out of 40 compared to 15 out of 40). When the success factors are weighted according to their importance, competitor #1 gets a far better rating (4.9 compared to 3.7).
Geography can also be used to predict desirable demographics and information about users in that area. Neighborhoods can often be delineated by residents’ income bracket, age, ethnicity, education, and many other demographics or interests. Politicians often draw district boundaries into areas of common political constituencies that also predict demographics or common values.
John Lincoln is CEO of Ignite Visibility, one of the top digital marketing agencies in the nation and the number 698 fastest growing company in the USA in the 2017 Inc. 5000. As a digital marketing expert and in-demand public speaker, Lincoln is consistently named one of the top influencers in the industry. In 2017, he was the recipient of the Search Engine Land "Search Marketer of the Year" award. Ignite Visibility crafts custom digital marketing strategies for clients, including services in SEO, social media, paid media, email marketing, Amazon and more.
John Lincoln is CEO of Ignite Visibility, one of the top digital marketing agencies in the nation and the number 698 fastest growing company in the USA in the 2017 Inc. 5000. As a digital marketing expert and in-demand public speaker, Lincoln is consistently named one of the top influencers in the industry. In 2017, he was the recipient of the Search Engine Land "Search Marketer of the Year" award. Ignite Visibility crafts custom digital marketing strategies for clients, including services in SEO, social media, paid media, email marketing, Amazon and more.
But while many marketers understand the value of geotargeting, not many are ‎likely to understand how the technology behind it works.  Having a firm grasp on ‎the technology though is actually critical in this case, as different solutions take ‎different approaches to the problem of determining the physical location of a ‎consumer, and the simplest solution is usually the least accurate.  Just as traditional ‎strategies don’t always translate well to digital, many desktop strategies don’t ‎translate well to mobile.  ‎
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. 
It can be easy to go down a deep rabbit hole with this process. There are thousands of blog posts with helpful hints (you’re reading one right now), and hundreds of tools that can potentially improve or otherwise streamline the process of researching keywords and devising a smart keyword strategy. That’s why we advise you keep things simple for starters. You can always layer on complexity as you gain experience. More than anything, good SEO efforts revolve around creating content experiments, measuring them, then doing more of what works and less of what doesn’t. Simpler is often better, especially if you are resource constrained. A good content governance strategy should dictate that you take on only as much as your resources allow.
Ad text plays an important role in the success of your ads. It is the form of marketing communication that advertisers can use to promote their product or service on search platforms. An effective ad text consists at least one of your core keyword, attractive discounts and promotion and a call to action. The quality score of your ad depends on multiple factors and your ad text is one of them. Your ad text should be unique and appealing. Include discount amount in your ad copy and also add a strong call to action that can compel searchers to click on your ads. Use action words like buy now, order now, resister today or sign up here. Include one of your keyword in your ad text and match your ad to your landing page.
It is a common misconception that sprinkling your chosen keyword randomly throughout your site is enough to improve SEO for B2B marketing. Unfortunately, doing so can actually result in a serious loss of business. Creating a strong keyword strategy is one of the most important things you can do to improve SEO. It is equally important to know how to do it right, as well as understand why it’s so necessary. This post will explain why a keyword strategy is important for SEO and B2B marketing, as well as explain how to create one that will draw in business.
You’ll often find your hottest leads among people who have already encountered your business once. Depending on your industry, it may be unlikely for people to purchase your product the first time they visit. If you’re an e-commerce operation selling lower-ticket items, you may be able to send people directly to a sales page with excellent results. But if you’re like the dishwasher store we invented above, visiting your PPC landing page may be one step in a larger research process for your customers.
Whether you’ve heard a little about PPC marketing and are curious to learn more, or you already know that you want to use PPC to market your business, but aren’t sure where to start, you’ve come to the right place! This is the first lesson in PPC University, a set of three guided courses that will teach you everything you need to know about PPC and how to make it work for you.
Katey Ferenzi has lived and breathed ecommerce for +10 years. In the mid-2000s, she and her husband started their own online business and successfully exited so they may come to Bigcommerce to teach other SMBs how to do the same. Currently, she's consulting for Jasper PIM, a Product Information Management (PIM) solution focused on unifying back-office operations with front-end shopping experiences for mid-market and enterprise businesses looking to scale.
In writing the summary and the presentation for the competitive analysis that I did for this collaborative note-taking app, the competitive analysis matrix helped me a lot. I drafted a document with all of the high-level takeaways from this analysis and answered all of the questions that were set as goals. For the presentation, I shared the document with the client, which helped both the client and me to finalize the features, the flows and the end requirements for the product.
How do current customers rate the following features of your business compared to your competition.Rate the following as: fair, good or excellent. Our Company / Competition ___________ /__________ Price ___________ /__________ Quality ___________ /__________ Durability ___________ /__________ Image/style ___________ /__________ Value ___________ /__________ Name Recognition ___________ /__________ Customer Service ___________ /__________ Customer Relations ___________ /__________ Location ___________ /__________ Convenience ___________ /__________ Other
Using the same keyword phrase over and over within a web page or blog post can actually hurt your ranking score in Google, which can perceive it as spammy. That wasn't your intention, but maybe you just couldn't think of a better word to use in its place. The Latent Semantic Indexing (LSI) Keyword Generator is like a thesaurus for SEO-minded content marketers. It offers keyword suggestions that are semantically linked to your main keyword, meaning they would naturally come up in conversation. Incorporating these keywords into your post allows you to add variety while still retaining SEO power. 
Be sure to re-evaluate these keywords every few months -- once a quarter is a good benchmark, but some businesses like to do it even more often than that. As you gain even more authority in the SERPs, you'll find that you can add more and more keywords to your lists to tackle as you work on maintaining your current presence, and then growing in new areas on top of that.

On the positive side, you can have personalized ads appear for every search query, and improve account performance by increasing CTR and quality scores. On the other hand, if not set up correctly DKI ads can hurt your account if you don’t take into account plurals, misspellings or any other grammatical errors that can occur. Like any strategy, DKI ads require time, testing and good organization to be most effective.
If your account is currently achieving a return on ad spend (ROAS) of 5, and your goal is to achieve a ROAS of 6, your strategy should focus on efficiency optimizations to improve ROAS. If your account is achieving a ROAS of 5 and your goal is to increase revenue as long as your ROAS is at or above 4 (and you have additional budget to spend), then your strategy will need to focus on growth initiatives.
The secondary and tertiary groups are both your indirect competition.Their products may not be the same as yours, but could satisfy the same need or solve the same problem. You should primarily focus on your direct competitors, but you should watch your indirect competitors. These businesses may move into another group as your business, or theirs, grows and expand product offerings.
They differ in many aspects, from gender to age; from organic to paid; from 1024×768 to 320×480 and onwards. More significantly though, people arrive to your site from across the world: from different countries and languages, different currencies and climates, and a whole assortment of cultural expectations. Hence, even if you have a “.com” English only site, you may very well be an international business by default.
IT is more cost-effective to target already existing demand to increase your market share for more qualified leads. For more tips on how to prioritize your keyword strategy and your comprehensive search campaigns, check out Directive’s Complete Guide to B2B Marketing and Demand Generation. And be sure to subscribe to our blog for weekly updates on the most innovative industry-leading tactics!
Evaluate your competitor's price. Just because you have the same products as other businesses, doesn't mean everyone has the same price. Your own production costs greatly impact your pricing. If your price for a similar product is higher than your competitor's, then your market position is weaker; and if it's lower, then your competitive position is better.A temporary price decrease by a competitor might indicate nothing more serious than a transient need to move excess inventory. However, a trend of lowered prices may indicate that your competition is doing it to gain market share and improve production costs. It could also mean your rival is in financial trouble and has been forced to lower prices. It's in this type of situation that rumors and gossip become helpful. If there are rumors that a company is in financial trouble and you discover price fluctuations, it's more likely that there are problems. Be sure your analysis includes product/service charges added to the purchase price, such as installation or additional equipment required.
Your entire PPC campaign is built around keywords, and the most successful AdWords advertisers continuously grow and refine their PPC keyword list (ideally, using a variety of tools, not just Keyword Planner). If you only do keyword research once, when you create your first campaign, you are probably missing out on hundreds of thousands of valuable, long-tail, low-cost and highly relevant keywords that could be driving traffic to your site.

When setting up conversion experiments that test different page elements, it may be valuable to make a prior segmentation that is location-based. Testing different ideas and approaches when location is taken into account, usually creates very interesting insights. What will work better for your funnel – showing your traffic from Spain pages in Spanish or English? Will you quote Euro or Dollar?
Once you have determined which keywords you should focus on, use them repeatedly in your content. Use an Excel sheet to keep an organized eye on your usage by tracking how many times you use each of your selected terms in your content. Why? The latest Google algorithm update is penalizing pages whose anchor text is over-optimized, and having an updated list of the terms you have already used will help you to vary them smartly.
He goes on to share some examples: “Most commonly, I hear answers like the following: Our educational system is broken and urgently needs to be fixed; America is exceptional; there is no God. These are bad answers. The first and the second statements might be true, but many people already agree with them. The third statement simply takes one side in a familiar debate. A good answer takes the following form: ‘Most people believe in x, but the truth is the opposite of x.'”

Understanding the balance of terms that might be a little more difficult due to competition, versus those terms that are a little more realistic, will help you maintain a similar balance that the mix of long-tail and head terms allows. Remember, the goal is to end up with a list of keywords that provide some quick wins but also helps you make progress toward bigger, more challenging SEO goals.
It’s also best to look for those businesses that are of a similar size as yours. For example, if you’re a solo entrepreneur selling handmade potholders online, big chain grocery stores usually aren’t your direct competitors, even if they might carry handmade potholders in their inventory. Instead, look for other small to medium scale producers of handmade potholders and similar kitchen accessories.
Conversion: This strategy is what most of us are after. We want our keywords to draw traffic to our website or landing page, and then we want that traffic to convert by making a purchase or otherwise doing something specific like filling out a contact form, picking up the phone, or downloading something. In this case, long-tail or more specific keywords will likely work best for you.
Competitive analyses for SEO are not something that should be overlooked when planning a digital marketing strategy. This process can help you strategically build unique and complex SEO campaigns based on readily available data and the demand of your market. This analysis will instantly put you ahead of competitors who are following cookie-cutter SEO programs and not diving deep into their industry. Start implementing this process as soon as you can and adjust it based on what is important to your own business or client’s business.
×