Airtable: analyze your product/market fit

Here's how to easily calculate your product/market fit score based on the product/market fit engine framework popularized by Rahul Vohra’s from Superhuman.

The process

Try It for Yourself

What do I get out of it?

Understand if you have product/market fit.

How does it work?

  1. You import your survey responses from Airtable in Actiondesk.
  2. You create a dashboard to get your product/market fit score, week by week.
  3. That's it! You get your PMF. The data is always up-to-date with live data.

Detailed tutorial & 5min how-to video

First, let's get the data we'll work with in this example:

  1. Download this product-market fit template.
  2. Go to the "Survey Responses" table.
  3. At the right of the table, add a column. Rename the field and call it "Date".
  4. Click on the column header and pick "Customize field type" in the dropdown.
  5. Choose "Created time" as your field type.
  6. It will automatically fill all the rows of your new column with the time at which each survey was filled.


Now, let's calculate your product/market fit score by weekly cohort of users:

  1. Create an Actiondesk sheet called "Airtable PMF Survey Responses".
  2. Import the Airable table "Survey Responses" in Actiondesk. See how here.
  3. Add a calculated column to return the week of each survey response with the format "YYYY_WW". To do this, just create a column called "Survey Week" and use the formula =YEAR(#Date)&"_"&WEEKNUM(#Date)
  4. Create a new sheet called "PMF Score".
  5. In "PMF Score", in B3 to B6, write the following 4 possible responses to the question "How would you feel if you could no longer use the product?": Very disappointed ; Somewhat disappointed ; N/A - No longer use ; Not disappointed. The percentage of your users responding "Very disappointed" is your product/market fit score!
  6. In C2, D2 and E2, write the weeks you want to get the data for with the format "YYYY_WW": 2020_25 ; 2020_26 ; 2020_27
  7. In C3, write the following formula: =COUNTIFS(Airtable PMF Survey Responses!#How would you feel if you could no longer use the product?,$B3,Airtable PMF Survey Responses!#Survey Week,C$2)
  8. Then, copy and paste this formula to the right and down.
  9. Add a row in B7 called "Product/Market Fit Score".
  10. In C7, write the formula =C3/SUM(C4:C6)
  11. Then, copy and paste this formula to the right.
  12. You can apply the percentage format on C7, D7 and E7.

If you want to go further and look at the score only for high priority users, you'd just have to add conditions to your COUNTIFS.

What do I get out of it?

Understand if you have product/market fit.

How does it work?

  1. You import your survey responses from Airtable in Actiondesk.
  2. You create a dashboard to get your product/market fit score, week by week.
  3. That's it! You get your PMF. The data is always up-to-date with live data.

Detailed tutorial & 5min how-to video

First, let's get the data we'll work with in this example:

  1. Download this product-market fit template.
  2. Go to the "Survey Responses" table.
  3. At the right of the table, add a column. Rename the field and call it "Date".
  4. Click on the column header and pick "Customize field type" in the dropdown.
  5. Choose "Created time" as your field type.
  6. It will automatically fill all the rows of your new column with the time at which each survey was filled.


Now, let's calculate your product/market fit score by weekly cohort of users:

  1. Create an Actiondesk sheet called "Airtable PMF Survey Responses".
  2. Import the Airable table "Survey Responses" in Actiondesk. See how here.
  3. Add a calculated column to return the week of each survey response with the format "YYYY_WW". To do this, just create a column called "Survey Week" and use the formula =YEAR(#Date)&"_"&WEEKNUM(#Date)
  4. Create a new sheet called "PMF Score".
  5. In "PMF Score", in B3 to B6, write the following 4 possible responses to the question "How would you feel if you could no longer use the product?": Very disappointed ; Somewhat disappointed ; N/A - No longer use ; Not disappointed. The percentage of your users responding "Very disappointed" is your product/market fit score!
  6. In C2, D2 and E2, write the weeks you want to get the data for with the format "YYYY_WW": 2020_25 ; 2020_26 ; 2020_27
  7. In C3, write the following formula: =COUNTIFS(Airtable PMF Survey Responses!#How would you feel if you could no longer use the product?,$B3,Airtable PMF Survey Responses!#Survey Week,C$2)
  8. Then, copy and paste this formula to the right and down.
  9. Add a row in B7 called "Product/Market Fit Score".
  10. In C7, write the formula =C3/SUM(C4:C6)
  11. Then, copy and paste this formula to the right.
  12. You can apply the percentage format on C7, D7 and E7.

If you want to go further and look at the score only for high priority users, you'd just have to add conditions to your COUNTIFS.

Read more
Create My First Report
see all Airtable use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your Airtable data. Analyze it alongside data from other sources, and build custom Airtable dashboards and reports.

View and organize your Airtable data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your Airtable data. Analyze it alongside data from other sources, and build custom Airtable dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within Airtable are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.