Using Airtable for Growth Marketing

Why use Airtable for growth marketing?

Using Airtable for growth marketing is a great starting point for new or small growth teams, they have a number of pre-built templates, or you can create our own, and it is a simple low-cost solution.

Once you get to even a small number of experiments on a regular basis, things can quickly become overwhelming. A solo growth marketer could easily run 5 or more experiments every week, for example:

  1. Test a new ad creative in Google Ads
  2. Try a new email subject line in HubSpot
  3. Experiment with a new landing page variation using Google Optimise
  4. Publish 2 new SEO optimised articles

This equates to 20 experiments a month or 260 a year, and this doesn’t take into account any additional idea generation and prioritisation, which is typically the bulk of any growth marketing system.

How to use Airtable for growth marketing

Track your growth experiments in Airtable by creating separate tables or views depending on the complexity you require, we suggest:

  1. Objectives
  2. Experiments
  3. Playboks
  4. Documentation
  5. Team
  6. System

We’ll expand on each of these more below.

Objectives

The objectives tab includes growth objectives in the OKR format as shown below:

  • Objective
  • KR1, KR2, KR3
  • Type (Growth Process, Traffic, Engagement etc)
  • Funnel Stage (Acquisition, Activate, Retention etc)

Experiments

The Experiment table is where ideas and experiments are stored, for ease of use we setup separate views for:

  1. Submit New Opportunity
  2. Awaiting Prioritisation
  3. Prioritised
  4. In Design
  5. Analysing
  6. In Progress
  7. Analysing
  8. Complete
  9. Playbooks

These are controlled via a ‘Stage’ field which is a single select drop-down.

The ‘Stage’ field is used to customise each view, for example, the ‘Experiments In Progress’ view shows content where the ‘Stage’ = ‘Experiment In Progress’.

1. Submit New Opportunity

Use Airtable to create a simple form to gather new ideas and opportunities, this should include the following fields:

  1. Idea Name
  2. Idea Description & Hypothesis
  3. Submitter Name
  4. Attachments (optional)

2. Opportunities Awaiting Prioritisation

The ‘Awaiting Prioritisation’ is where users can quantitatively score ideas, based on the prioritisation framework in use. For example:

  • Impact (High, Medium, Low)
  • Precedence (Worked For Us, Worked For Others, No Precedent)
  • Resource (1 Hour, 1/2 Day, 1 Day, 1 Week, 1 Month)

3. Opportunities Prioritised

The ‘Opportunities Prioritised’ view uses an Airtable formula (below) to create a score based on:

  1. Impact
  2. Precedence
  3. Resource
{Confidence Score}+{Impact Score}+{Resource Score}

Opportunities are displayed with highest-scoring first. With 5 options available for Resource, and 3 for Impact and Precedence, there is a slight weighting towards faster experiments. We find this to be beneficial in keeping a good experiment cadence.

4. Experiments In Design

The ‘In Design’ view displays a couple of additional fields, namely:

  • Test Plan & Methodology
  • Changelog
  • Primary Success Metric
  • Baseline

5. Experiments In Progress

Experiments In Progress have the ‘Date Test Started’ field populated. Typically this triggers an email alert to the team (more on Email Notifications below)

6. Analysing Results

When selecting the Analysing Results view two additional fields are displayed, these are ‘Experiment Results & Conclusion’ and ‘Experiment Rating’:

  • Experiment Results & Conclusion
  • Experiment Rating
    • Winner
    • Loser
    • Inconclusive

7. Experiments Complete

Completed experiments are grouped together based on the final experiment rating and category. Winning experiments are shown first.

8. Playbooks

Repeatable playbooks are created from, and optionally linked back to, winning experiments. We use Google Docs for this currently.

Email Notifications

Integromat can be used to integrate Airtable and your preferred email provider (ESP) to create email notifications to your team for key actions. We recommend sending email notifications for:

  1. Idea Submitted
  2. Experiment Started
  3. Experiment Complete
  4. Weekly Status Report

https://www.integromat.com/en/integrations/airtable

Integromat Configuration for Experiment Started
Team Email Notification for Experiment Started

Additional Airtable Growth Marketing Resources

Darius Contractor (currently head of Growth at Facebook) has published his own Airtable growth marketing template which is available here bit.ly/evelyn-airtable and here https://airtable.com/shrInOxl0SL1Xmauk.

Airtable also have their own growth experiments template that you can start with and customise as needed, see the video below for additional information.


P.S. Get monthly growth insights

Get links to the best growth marketing experiments run by our in-house team on the Growth Method platform.