Market Analysis Template For Microsoft Excel

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.

market analysis template excel

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.

marketing action plan template excel

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.

market analysis excel

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.

digital marketing plan template excel

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.

Related Template:  Cash Flow Projection For 12 Months Templates

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.

marketing campaign calendar template

EXAMPLES

The example below is digital marketing plan template excel.

Strengths

ABC Agency

XYZ Corp

What are your business advantages?
  • Cheaper price
  • Costumized Campaign
  • Brand Recognizition
  • Good Networking
What are your core competencies?
  • Using Internet
  • Customer Relationship
Where are you making the most money?
  • Start-up Company Campaign
  • Event for big company

Weaknesses

ABC Agency

XYZ Corp

What areas are you avoiding?
  • Long term campaign
  • Small companies campaing
Where do you lack resources?
  • Small team
  • Team diversity
What are you doing poorly?
  • keeping up with project
  • Lack of customer satisfaction

Opportunities

ABC Agency

XYZ Corp

Any beneficial trends?
  • Many Startup company on Fashion industry
  • Big Company who use social media campaign
New needs of customers?
  • Needs of tutorial video
  • Needs to have or try tester product

Threats

ABC Agency

XYZ Corp

Aggressive competitors?
  • XYZ Corp
  • ABC Agency
Negative economic conditions?
  • Inflation
  • Inflation
Vulnerabilities?
  • Lack of growth
  • Unaware of new trends

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:

Originally posted 2017-06-04 11:19:16.

Related templates

  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1821 ayVxdYHEW5w9qPp02TI8FHcB05i4IiR2_Ik45QGcj4ex-qVHGqqj3xpThne997u5 29183c16599703371f548b593c1513d73e586ac3&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme