Building a Competitor Comparison Matrix

1. What is a Competitor Comparison Matrix?

At its core, a competitive matrix is a chart or table that organizes your research to compare your client's business against its competitors on a set of key criteria. It transforms lists of data points into a visual snapshot of the competitive landscape.

Let's start by looking at a couple of common examples.

As you can see, these matrices make it easy to spot strengths and weaknesses at a glance. But why is this so valuable? The following video from LYFE Marketing explains the strategic importance of competitor analysis.

The competitor matrix is the primary tool for achieving these goals. It's the deliverable that presents your findings in a way that helps business owners make strategic decisions.

2. Types of Matrices and Choosing Your Factors

There isn't one single way to build a matrix. The format and the factors you choose to compare will depend on your client's specific goals. The Pipedrive blog offers a great guide to the different formats you might encounter.

The factors you choose to include are the most important part of the process. These should directly relate to the data you have collected in our previous lessons:

• Price: Data gathered via IMPORTXML or manual research.
• Product Features: Information from competitor websites.
• Customer Service: Insights from analyzing customer reviews.
• Social Media Engagement: Follower counts and post frequency.
• Shipping Speed / Return Policy: Details from their sales process.

For today's practical exercise, we will build a Competitive Comparison Chart, as it's the most flexible and commonly used format for freelance projects.

3. Hands-On: Building Your Comparison Matrix in Google Sheets

Let's create a matrix that synthesizes data about product features. This is a classic deliverable that a client could use to inform product development or marketing messaging. We will build a simple, color-coded table, inspired by the "feature comparison" example in an article by Crayon.

Now, let's build it.

Step 1: Set Up Your Spreadsheet

1. Open a new Google Sheet.
2. In cell A1, type "Feature".
3. Starting in cell B1, C1, and D1, enter the names of three competitors. You can use hypothetical companies or real ones from a product category you're familiar with.
4. In cell E1, enter "Your Client's Company".
5. Starting in cell A2 and going down, list 5-7 key features relevant to the product category. For example, if you're analyzing smartphones, features might include "Screen Size," "Camera Quality," "Battery Life," "5G Connectivity," etc.

Your sheet should look something like this:

Step 2: Populate and Score the Data

Fill in the matrix based on your (hypothetical) research. For simplicity, we'll use a basic scoring system:

• 2 for "Strong" (feature is a key strength)
• 1 for "Weak" (feature exists but is not competitive)
• 0 for "Absent" (feature is not offered)

Step 3: Add Conditional Formatting

To make the matrix easy to read, apply conditional formatting (which you learned in Module 1).

1. Select the entire data range (e.g., B2:E8).
2. Go to Format > Conditional formatting.
3. Create three rules for the range:
   • If Cell value is equal to 2, make the cell background green.
   • If Cell value is equal to 1, make the cell background yellow.
   • If Cell value is equal to 0, make the cell background red.

Your matrix now provides a powerful visual summary.

Step 4: Add a Summary Score

To quickly determine an overall winner, we can add a total score for each competitor. This is a great way to add value for your client. The following video demonstrates a clever way to count up scores in Excel, and the same principle applies directly to Google Sheets.

In your Google Sheet, create a new row called "Total Score". In the cell for Competitor A's score, enter the formula =SUM(B2:B8), assuming your features are in rows 2 through 8. Drag this formula across for the other competitors and your client's company. You now have a simple, quantitative ranking that instantly shows who is leading on features.

Conclusion

You have successfully built a competitor comparison matrix, a cornerstone deliverable for market research. This process takes disparate data points and synthesizes them into a strategic tool that is clear, insightful, and actionable for a client. This is a skill that directly translates to paid freelance work.

Here are the key takeaways from today's lesson:

• Synthesis is Key: A matrix turns raw research into a coherent story about the competitive landscape.
• Form Follows Function: The type of matrix you build (e.g., table, scatter plot) should match your client's goals. A feature comparison chart is a versatile and valuable format.
• Google Sheets is Your Tool: You can build professional-looking and effective matrices using basic spreadsheet functions, conditional formatting, and simple formulas like SUM.
• From Data to Decisions: The ultimate goal of a matrix is to help businesses identify gaps, spot opportunities, and make informed strategic decisions.

In our previous lessons, we focused on collecting and organizing data. With the creation of this matrix, you've taken the first major step into analysis and reporting. In our next module, "Data Analysis and Reporting," we will dive deeper into quantitative analysis, starting with how to use pivot tables to summarize large datasets.