Market Analysis Template consist of SWOT analysis template, which purpose is for finding the Strength, Weakness, Opportunity, and Threat of company(s). The finding analysis can be used for company strategy (marketing, sales, etc) or evaluation. The Market Analysis Template can be used for startup, small to big company, in every industry. You can see the included market analysis excel sample for group study too.
Contents
THE MENUS
Market analysis template excel has only 2 menus:
1. SWOT Comparison
Menu for entering the SWOT analysis question and result, as well comparing with other companies.
The analysis question displayed in each rows, while the competitor placed on columns.
2. Competitor Information
Menu for entering the information of analyzed companies. The information merely contact details to company condition overview. You can see the information fields on picture below.
HOW TO USE
To use the marketing action plan template excel, you only need to simply answer the provided question based on SWOT quadrant. You can see the example below.
You can add your own question by inserting the row between the question. However, you must define your own question and decide which quadrant it belongs to.
Like all SWOT analysis, there are 4 quadrants:
1. Strength: Strengths or plus point from internal (company) perspective, and from the point of view of customers and people in company market or industry.
E.g. low price, good service
2. Weakness: Weakness or negative point from internal (company) perspective, and from the point of view of customers and people in company market or industry. This is what the company should improve or changed, or can be exploited by competitors.
E.g. bad product, bad management
3. Opportunity: Opportunity is the external point, that could be grasped or left alone by the company. The Opportunity factor can help the company to grow and prosper.
E.g. new market, customer needs
4. Threat: Threat is external factors which can put the business or company at risk. Threat is the factor that beyond your control. You have no control over these, but you maybe can make contingency plan to overcome the risk if should they occur.
E.g. competitors, political issues.
After you fill the table on SWOT Comparison menu, go to Competitor Information menu. Enter the information based on the information question. You can add new column for new information question. You can resize the row and column widths.
EXAMPLES
The example below is digital marketing plan template excel.
Strengths |
ABC Agency |
XYZ Corp |
| What are your business advantages? |
|
|
| What are your core competencies? |
|
|
| Where are you making the most money? |
|
|
Weaknesses |
ABC Agency |
XYZ Corp |
| What areas are you avoiding? |
|
|
| Where do you lack resources? |
|
|
| What are you doing poorly? |
|
|
Opportunities |
ABC Agency |
XYZ Corp |
| Any beneficial trends? |
|
|
| New needs of customers? |
|
|
Threats |
ABC Agency |
XYZ Corp |
| Aggressive competitors? |
|
|
| Negative economic conditions? |
|
|
| Vulnerabilities? |
|
|
CONCLUSION
The Market Analysis Template in A4 paper with Landscape format, you can use it for manually writing and pinned it. You can redesign the interface into more interactive and aesthetic.
You can integrate the template or use the analysis to create and fill the marketing campaign calendar template.
The Market Analysis Template can be use for various SWOT analysis, such as nonprofit organization SWOT template, self SWOT template, or product SWOT template.
Further modifying, you can turn the SWOT tables into TOWS table by reversing the table tows. You can download Market Analysis Template after you hit one of these buttons: