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.
Gather Competitive Information Secondary sources of information are recommended as an excellent starting point for developing a competitive and industry analysis. Secondary sources include information developed for a specific purpose but subsequently made available for public access and thus alternative uses. For example, books are secondary sources of information as are articles published in journals. Marketing reports offered for sale to the general public also are considered secondary sources. Although, they have been created for a purpose other than your current need, they are still excellent sources of information and data. With the ever increasing speed of document identification and retrieval through electronic means, secondary sources are not only an inexpensive source of information but are readily available soon after publication. Sources of information include:

Between 2016 and 2017, Amazon was mentioned almost 3 times more frequently by senior executives on earning calls than any other company. It’s no wonder executives at public companies are obsessed with the retail giant. Even the threat of an Amazon entrance could result in a seismic shift in the market and put them out of business overnight. In other words, the SaaS world moves fast β€”β€Š and the only way to keep up is to be one step ahead.


It is crucial to separate business and personal finances – and to be very prudent in the first few years of running your business, especially when you start making profit. Keep tight record, develop regular forecasts, avoid overdrafts, watch interest rates, keep track of expenses, bank all income, self-fund if possible and check bank statement regularly. Re-invest your profits into the growth and development of the business, the reward will be well worth the investment.

In this article, I will introduce the subject of competitive analysis, which is basically a method to determine how well your competitors are performing. My aim is to introduce the subject to those of you who are new to the concept. It should be useful if you are new to product design, UX, interaction or digital design, or if you have experience in these fields but have not performed a competitive analysis before.
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.
×