Great question. You could adjust the formulas but I find it easier to highlight the full report (after it is populated with your data) then copy it and paste "values only" this way none of the formulas break. Then go into the navigation of google sheets and select "Data" then "Filter". You will now have filtering options on all of the headings. Then you can simple select your website and uncheck "Yes" so you only see the domains that do not link to you. Give that a shot and let me know if it works for you.
Geographic targeting allows your ads to appear in the locations that you choose: country, city, areas within a country or city, a radius around a location, or location groups. Geo targeting helps you focus your ad campaign on the locations where you’ll find the right customers, and restrict it in locations where you don’t, which could help increase your ROI. Right geographic region can significantly help you optimize your campaign for better results. Identify countries, states, regions, or areas where your ad campaign can perform well.
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?
That said, if you’ve never had to come up with a keyword strategy before, it might seem a bit daunting to generate a list of terms that will drive qualified search traffic to your website. Not to worry. Creating an effective keyword strategy—figuring out which terms you should create content for—isn’t hard. It just involves a little bit of reverse engineering and some research.
Shakeups. As you analyze your competitive information be on the look out for broad management changes or changes in ownership. This is an indication that major policies and marketing shifts are on the horizon and you should anticipate changes. It may be a good opportunity to court your competitor's star employees. People often change jobs during management shakeups.
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.
Your conclusion should be presented to other business stakeholders especially when you’ve decided the next steps. For example, you may alter your Product Roadmap as a result of the competitor analysis. Sales and marketing teams may benefit from summaries that contrast your product with key competitors and emphasise your product’s strengths so that they can take this message to market.
Reason: When a visitor sticks around on your site for a minute or less, you can consider their stay to be negligible. When a visit exceeds that amount of time, the visitor has more potential for becoming a client and an increased chance of converting on your calls-to-action. If a visitor spends a considerable amount of time on your website, they are likely to come back or to take action on conversion areas you have included in your site (call-to-actions, downloads, contact forms, etc.).
Take advantage of location extensions and call extensions to make it as easy as possible for local prospects to contact and reach you. When location extensions are enabled for your search ads, prospects in your specified, targeted areas will see your street address. A call extension, alternatively, provides either your phone number or a direct link to a phone line. Landing pages are often referred to as the leakiest part of the marketing funnel, and extensions such as these help cut out the middle ground and prevent the lead leakage.
Sometimes even the most savvy among us can feel like a confused great-granny on a MacBook Pro running Linux when it comes to the newest, latest tech, and how it actually works. Location-based marketing is already happening. All of the available tools provide opportunities to serve highly localized, highly relevant communications to your customers, based on where they are right now. But what exactly are those options, and how do they work?
It has also become remarkably difficult to distinguish direct competitors from indirect threats - and when you do, you find competition often comes from surprising places. In fact, competition in the SaaS and tech industries is increasingly coming from indirect competitors, whose core technology enables them to invade adjacent verticals and industries.
Unfortunately, whilst digital marketing provides these tools, most advertisers still find themselves in a situation where they don’t know what is working. The ubiquity of search engines in our modern lives has led advertisers to skip straight past considerations for strategy, planning, and measurement and dive straight into tactical marketing efforts like Pay-Per-Click and SEO, where they are as equally unsure if their efforts are delivering a meaningful return for their business.
Your keyword strategy should make clear which “keyword groups” you focus on. It doesn’t have to be a long list of keywords (though it doesn’t hurt to have one). Your keyword strategy should be a definition of a group of keywords that you’re tackling. Every time you’re writing new content you can have a quick look at those groups and pick a new keyword that falls in line with the strategy.
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.
The benefit of clearly describing a strategy for your PPC campaign is that it can inform the creative, particularly when it comes to building PPC adverts with our various elements: header, ad copy, ad extensions – where does everything go? Great advertising is built on great creative, so spend as much time crafting solid messages as you do on the strategic elements of the campaign. This chapter looks at how you can craft the best ad creative to communicate your message.
Best used to reach users who: live or move about in a certain area, for whom you have other data like preferences or demographic info Best used to find users who: are nearby your store, venue, or service; users who are in your parking lot, or entering a mall, for example Best used to reach users who: are in a certain aisle of your store; who are on a certain bus or train; who are moving through a space like a museum
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.
As of 2017, there are over 5,000 products in the martech sphere alone competing for business in complex and overlapping ways. Some companies leverage their expertise and resources to enter new markets. Salesforce is a great example; look at the number of martech categories it’s listed in. With so much competition, SaaS companies can't win on features alone; they must win on brand and customer experience.
Not every keyword is worth ranking for. This may seem obvious, but it’s an important lesson for search marketers to learn. Often times we can get caught falling down the rabbit hole or chasing the long tail dragon to boost our rankings without thinking of the time and resources it takes to rank for these terms. Especially for highly competitive, high-volume keywords – it simply isn’t worth the time and effort it might take to get onto page one.
When I was working with BLADE, an Uber-like helicopter service, we wanted to know why people would pay $600 for a 5-minute long helicopter ride from Manhattan to the airport, but not the other way. In this particular case, our competitor was sitting alone in a black car in traffic back to the city. The benefit was that they weren’t really in a rush and they could catch up on things. It was the only time they could be alone with their thoughts.
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.
Using geo-targeting, you use smart marketing tactics. A great example of a successful use of area segmenting is evo, an e-commerce sporting goods store. When they took the leap to open up three brick and mortar stores. Their first step was to send out an email blast for a $200 shopping trip to users in the area. Though the campaign had a 58% conversion on mobile users, the campaign wasn’t as effective at driving traffic to their store fronts.
An important distinction to make before we begin is that a Competitor Analysis is not a Product Comparison. Although we may make mention of the types of products sold, we should not be including the detailed product features in a Competitor Analysis. Quite often, two seemingly distinct products can solve the same customer problem or satisfy a similar need. At its core, a Competitor Analysis is a document that evaluates the strengths and weaknesses of your rivals.
Use Google Keyword Planner and your list of potential search ideas to create a list of terms/phrases that align with your brand and that, ideally, aren’t highly competitive. Google ranks competitiveness in Keyword Planner, seen above. You can also get an idea of how competitive a keyword search is by looking at the price of the suggested Adwords bid. Competitive search terms are typically much harder to rank for.
Finally, since the competitive environment is dynamic, the competitor's ability to react swiftly to change should be evaluated. Some firms have heavy momentum and may continue for many years in the same direction before adapting. Others are able to mobilize and adapt very quickly. Factors that slow a company down include low cash reserves, large investments in fixed assets, and an organizational structure that hinders quick action.
Once your ad is displayed, it’s likely to be clicked by only a tiny percentage of people who search for such a broad term, making it less likely to be displayed in the future. And even if you create an ad that’s broad enough for those searchers to reliably click, they’re unlikely to find exactly what they’re looking for on your landing page. You’re paying a lot for poor-quality traffic.
Getting your site to rank on Google is not as simple as plugging a keyword into a website and hoping for the best. In short, placing them into an intentional keyword strategy is just the beginning. By definition, keywords are words or phrases that describe and sum up a central idea pertinent to your business and marketing strategy. Keyword strategy means using keywords in your business and ad campaigns to attract your target market audience. When it comes to B2B marketing, keyword strategy is necessary to draw in your target audience. As B2B marketing is not the typical Buyer-to-customer setup, your keyword strategy needs a B2B marketing and relations spin. For example, if your business were looking to bring in ordinary customers, your keyword strategy might look like this:
In internet marketing and geomarketing, the delivery of different content based on the geographical geolocation and other personal information is automated. A good example is the Ace Hardware website at www.acehardware.com. The company utilizes geolocation software to power the “My Local Ace” section of its website. Based on a site visitor’s location, the website's online locator service can show the visitor how many stores are in their area, as well as a city-level locator map to help the customer find the store closest to their address.
Long tail keywords are longer word phrases. They are specific phrases searchers are more likely to use when doing a specified search. Due to the more tailored nature of long tail keywords, it is important to create a theme around these phrases. Doing so will increase your business’ rank in search engine results. A generic single keyword is not as valuable as multiple keywords that match a user’s search. In short, long tail keywords prove that, as far as B2B SEO goes, less is not always more. Once you’ve compiled a list of “long tail keywords” that describe a certain theme, you can begin conducting your keyword research.
Say your e-commerce site focuses on college students. Target promotions to local coffee shops within a couple miles of your store front that students frequent. Students that bring in a receipt from the coffee shop to your brick and mortar store get a special discount. You can push this email campaign to users that are within a 10 mile radius of the coffee shop and your store.
Competitive analyses help you evaluate your competition’s strategies to determine their strengths and weaknesses relative to your brand. When it comes to digital marketing and SEO, however, there are so many ranking factors and best practices to consider that can be hard to know where to begin. Which is why my colleague, Ben Estes, created a competitive analysis checklist (not dissimilar to his wildly popular technical audit checklist) that I’ve souped up for the Moz community.