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.
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.
The errors in technical SEO are often not obvious, and therefore one of the most popular. Mistakes in robots.txt and 404 pages, pagination and canonical URLs, hreflang tags and 301 redirects, http vs https and www vs non www versions: each of them can seriously spoil all efforts to promote the site. One quality SEO website analysis is enough to solve all the main problems in this part forever.