Remember that martech landscape map with over 5,000 companies? Almost every product category is made up of over a dozen different players. You can’t reasonably expect to analyze all of them. You don’t need to either. An ideal competitor analysis includes three to five companies that represent the biggest threat to your business. (Go with five if you’re operating in a crowded market.)
City advertising[19] by advertising on web sites with extensive content related to particular cities. Such web sites can connect large city audiences with products/services for sale in those cities. Surfers searching for information about particular cities find adverts at such web sites as a result of city name related searches rather than product/service keyword searches. In this way businesses, e.g. shops, restaurants, can advertise and reach out to consumers located in the real-world localities of their product/service offerings.
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.

It’s important to classify your keywords. You should distinguish your most important high level keywords, the ones that have sufficient traffic for your business and connect the best to your business. These are usually more “head” than “tail”. You should only have a few of these keywords for your business. The rest of it are bound to be more down the tail. If you don’t know what I’m talking about, go read up on long tail keywords.


That would work but I would prefer to keep the data consistent and use Majestic or Ahrefs instead in that case. The template formulas can be adjusted to work with either tool. Sometimes, I will combine the data from all 3 tools to increase the amount of backlinks in the analysis but that takes a little bit more work and formatting to get it to work properly.
This broken-link checker makes it easy for a publisher or editor to make corrections before a page is live. Think about a site like Wikipedia, for example. The Wikipedia page for the term "marketing" contains a whopping 711 links. Not only was Check My Links able to detect this number in a matter of seconds, but it also found (and highlighted) seven broken links.
×