Entrepreneur and marketing guru Peter Yang is the co-founder of ResumeGo, a firm offering resume and CV writing services to people aspiring to advance in their professional careers. As the head of the company’s marketing operations and a content marketing manager for IBM in the past, he wants to share his experience with other marketers looking to make it big.
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.

For example, say you run your own B2B marketing agency. If you’re advertising high-level digital marketing services, you want to make sure that the traffic you get from PPC campaigns only includes quality leads. Using negative keywords like “free” and “cheap” will help you avoid people who are not looking to pay for marketing services. If you only work with clients in the United States, you could also use location-based negative keywords. For example, to avoid keywords like “B2B marketing services in Russia” you could add “Russia” as a negative keyword.


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.

If you have a poor billing system or are constantly losing invoices and important documents, soon your clients will move on to greener pastures (and more organised businesses). If you implement a strategy to become more organised, you will find your customer service improving. This will lead not only to return clients but to new business, as word-of-mouth travels about your professionalism and efficiency.


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.
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.
Zee came to Distilled after several web development and digital communications positions in the nonprofit space, including the Ad Council, Power Poetry, VolunteerMatch, DonorsChoose and Planned Parenthood. With her background, Zee learned how to make the most impact with shoestring budgets. A graduate of Smith College, Zee studied French Studies and Psychology and studied psychoanalysis at Paris IV – Denis Diderot University. Aside from analyzing languages and humans, she found a home in the tech space, where solutions are complex and (sometimes) easier to come by. Ask her about: user experience, web development, analytics, technical SEO questions, and rescue dogs like hers.
You can also find articles written about companies in local newspapers or on a Nexis file. Online databases are available from soures such as the U.S. Securities and Exchange Commission and Standard & Poor’s and news sources such as PR Newswire, and as we'll explain in this article, you can use search engines to find information on individual companies.
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.
By sharing this information, you can align all stakeholders that are involved with any kind of messaging (i.e., print, TV, PR, SEO, PPC, email, blog posts, etc.) and get everyone consistently using your targeted keywords. As your audience observes messages from each of these channels, they will see that consistency. This can highly influence which keywords they then use when they use a search engine to find you or your products. These are, of course, keywords you already rank well for, which will help to increase visibility and branding even more for your entire organization.
In reality, even profitability focused campaigns will have limits when it comes to budget, so our focus is often maximizing profitability within the budget we have allotted. This can mean bringing in fewer conversions at a lower cost per acquisition (CPA) and eliminating elements of campaigns that are under performing compared to your acceptable conversion goal. Mining search query reports, establishing negative keywords, bidding down on keywords with high CPA’s or no conversions are all techniques we employ in order to maximize our profitability within the parameters given.
if this is the best schema type, and if you've correctly implemented it, Google may choose to ignore your schema regardless. however, there may be other reasons your site just won't appear for rich search results–have you checked to see if the keywords you want to appear in rich results for actual have that as a search result function (you can check this in SEMRush)? is another domain that is "better" than your site ranking for that featured result instead (you can find out whether they're 'better' through this competitive analysis)?
Generic keywords: These are generic words that describe your business as well as other businesses in your niche. They do not necessarily set your business apart from the million other businesses out there and ranking for these keywords is difficult given the immense competition for both paid and organic results. Nevertheless, these terms are likely to be used by your audience in the first stage of searching.

This can mean simply using pictures from the surrounding area or structuring the landing page around a theme that is relevant. A great example of this is Grubhub. If you access their site from Boston, you get completely different suggestions and images than you do if you access it from San Francisco. Not only does this engage the user on a personal level, it also draws them in to the page, keeping them clicking for longer.
Furthermore, 70% of consumers are willing to share their location information if they believe they are getting something of value in return like coupons or loyalty points, according to LSA’s Local Mobile Search Study.  This dynamically moving consumer base is only going to be more receptive to search results and ads that are specific to their location.
Use these consumer characteristics to time and target your marketing. For example, airports on weekdays are a great source of business travelers looking for high-end restaurants, while weekends and Spring Break bring more leisure visitors and families looking for more casual dining options. Likewise, dance clubs and bars can benefit by promoting 18 and over events targeted at universities whose student bodies are largely between the ages of 18-21. These are just a few examples of how venues define audiences that can be effectively targeted.
As you consider new ideas for your next project or business, give extra credence to the things you believe to be true that others doubt. The most exciting products are created by people with tons of conviction for something that strikes most others as odd. I’ve heard from Joe Gebbia, co-founder of Airbnb, that when he and his co-founder Brian Chesky pitched the idea of having strangers sleeping in your home when you weren’t there, many investors shifted uncomfortably in their seats.

When an ad mentions the target customer’s region or city, such as Chicago, this approach has proven to deliver a much better response rate than running a national campaign that doesn’t include a location. “It goes back to the messaging aspect,” Fritz explains. “Your geolocation ad targeting is much more effective. That’s because it connects more deeply with prospective customers than a generic advertisement. You are running a social advertisement that is very specific to someone in a particular place. This could be Cleveland, New York City, Miami, Dallas, Los Angeles, or whatever area you have targeted.”
You can also find articles written about companies in local newspapers or on a Nexis file. Online databases are available from soures such as the U.S. Securities and Exchange Commission and Standard & Poor’s and news sources such as PR Newswire, and as we'll explain in this article, you can use search engines to find information on individual companies.

Once you have a short list of keywords, create separate pieces of valuable, high-quality content, each optimized for an individual term on the list. Through the process outlined above, you aligned keywords with searcher intent. You ostensibly know what searchers commonly put into search engines to find content related to your business goals. Now, your content should actually meet those searchers’ needs. In fact, it should be your goal to create the best, most actionable content to answer a specific question a target user might have as possible.
Geofencing hinges on the use of a “fence”—a designated area that a marketer sets. Where geo-targeting allows you to get more granular and include or exclude certain users in the target area (based on demographic, for instance), geofencing is a bit more of a blunt object in that you’ll capture all users who move into a certain area. The purpose of creating a geofence is to target communications in a given zone, in a given context—just like geo-targeting, but with greater accuracy. Retail operators who want to catch the attention of shoppers as they pass by a store, for example, might use geofencing.

Monitoring also allows you to notice trends. If there’s a high bounce rate (people leaving your landing page before making a purchase) but a high click-through rate as well (lots of people are clicking on your ad), it’s a sign that the issue isn’t with your ad but with your landing page. Instead of throwing the baby out with the bathwater, you can focus exclusively on improving your landing page.


What is the main messaging of their marketing materials? What common customer problems or goals do they often refer to? Let’s say you’re a pet sitter going through a rival business’ brochure. There is a huge difference between a brochure emphasizing frequent real-time online updates, and another brochure emphasizing pet pampering and grooming. The group of clients who are attracted by frequent real-time online updates are often focused on the safety and welfare of their pets, while those looking for more pampering and grooming services are focused on comfort and appearance.
Example 1: Say your business focuses on skin care. Your keywords might center around the idea: “how proper skin care can improve your health.” You would then begin looking for a keyword theme that sums up the idea of skin care relating to health. The takeaway message is that your business has a goal, and the right keywords will relay this goal to site visitors in a clear, concise way.
You will likely run into some difficulties along the way, and you may need to develop a hybrid strategy to achieve your goals. For example, I have often broken out campaigns between profitability focused keywords and brand focused keywords in order to satisfy clients. This is especially useful when someone demands visibility for certain keywords but does not give enough budget to achieve that visibility. The same goes for balancing visibility and profit.
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.

Your costs can be lower when you stay away from national campaigns that take a more shotgun approach to your social media advertising efforts. Instead, geotargeting will enable you to conduct regional-, state- and city-level campaigns that will improve your results. That’s because this approach helps to tighten your campaign’s boundaries around your company’s physical location.
Of course, many small businesses don’t have the time or expertise to run tests on the successes and failures of their PPC campaigns. This is why simplified tools that use complex machine learning to do the testing for you are so helpful to manage PPC for small businesses. If you’re a small business owner and want to take it on yourself though, follow the winning strategies above to get started on the right track!
It is dependent on the pre-analysis of the entire IP address space. There are more than 4 billion possible IP addresses, and detailed analysis of each of them is a Herculean task, especially in light of the fact that IP addresses are constantly being assigned, allocated, reallocated, moved and changed due to routers being moved,[6] enterprises being assigned IP addresses or moving, and networks being built or changed. In order to keep up with these changes, complex algorithms, bandwidth measurement and mapping technology, and finely tuned delivery mechanisms are necessary.[7] Once all of the IP space is analyzed, each address must be periodically updated to reflect changes in the IP address information, without invading a user's privacy. This process is similar in scale to the task of Web spidering.

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.
a) Look for any gaps ("0's") on you score sheet and try to fix them. Yes, to an extent–an "ideal" score would be all "4s" down your brand's column. However, that's not always possible and highly unlikely. That said, it might not be the most pertinent thing to address technical SEO issues if you can see that your area of greatest weakness is, for instance, building an audience. Look for the greatest difference in performance between your brand and your competitors, which will illuminate what their main legs-up are.
Attribution. Use attribution data to prove the influence of PPC on conversions either cross-channel or within the channel. For instance, you might learn that certain campaigns don’t convert well, and the instinct is to turn them off. However, if they lead to conversions in other campaigns, you’ll want to allocate budget to keep the conversion path open.
Knowing your business’ target audience and matching it up with where they live or work helps you find those who might be most interested in your product or service.  For example, a ticket broker might want to advertise NCAA basketball tickets in the state of Kentucky and might think of using Kentucky basketball in its messaging.  However, Louisville basketball would be preferable for any advertising within 50 miles of the city on the Kentucky side of the border and 70 miles into Indiana due to the strength of Louisville’s fan base in those areas.
Increase Clicks: If you have a niche site that has high quality scores and impression shares, but not enough volume to spend your budget, you will want to increase the traffic sent to your site while maintaining control over click costs. This can be done by increasing bids, expanding your keyword list, improving click through rates and refining ad copy. All of these items can be adjusted/improved upon to help reach your budgeted spend.
SEO competitive analysis is critical because it gives data about which tactics are working in the industry we are in and what we will need to do to start improving our keyword rankings. The insights gained from this analysis help us understand which tasks we should prioritize and it shapes the way we build out our campaigns. By seeing where our competitors are strongest and weakest, we can determine how difficult it will be to outperform them and the amount of resources that it will take to do so.
×