Thanks Ramon! You can easily add more tabs to input more backlink data for additional competitors and then adjust the query formula to use the new tabs. I often increase this to 10, 15 or even 20 competitors for larger clients. The beauty of Google Sheets templates is the ease in which you can make these adjustments. Let me know if you need any help with that.
To determine your company's market share on a percentage basis, thefollowing formula should be used: Current Market Share = Company sales Industry salesYou should then compute each of your competitors' market shares. It will give you a clear idea of how your sales volume compares to your competition's. If you don't have total industry sales figures you won't be able to figure out your market share, but you can still get a good idea of your competitive position by comparing the sales volume figures. For example, say last year Company A sold $3 million dollars worth of copiers, Company B sold $5 million, and you sold $4 million. It's obvious that Company B has the largest share of your market and is your greatest competitor. Competitive Objectives and Strategies For each competitor in your analysis, you should try to identify what their market objectives are and determine what types of strategies they are using to achieve them. Are your competitors trying:
Now the ad servers don’t create this table themselves, they license it from another company like MaxMind or DigitalEnvoy, whose primary business is geolocation data. This is no enviable task; IP addresses themselves don’t necessarily have an obvious pattern in the way they are assigned like a telephone area code would. It’s a bit like solving a mystery, and the geolocation companies use a variety of methods to approach the problem. /injects>