Using insights in Airtable
  • 31 Jul 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Using insights in Airtable

  • Dark
    Light
  • PDF

Article summary

Plan availability

Business and Enterprise Scale plans

Permissions

Owner or Creator permissions are required to use or access insights

Platform(s)

Web/Browser, Mac app, and Windows app

Accessing insights

To access insights:

NOTE

Insights are designed to help creators understand the activity connected to their bases and interfaces, identify ways to optimize their bases and interfaces, and aid in performing base maintenance via suggestions.

  1. Open your Airtable homepage.

  2. Create or open your preferred base.

  3. Click Tools in the top right, next to “Extensions”.

  4. From the “Tools” menu, select Insights.

Airtable insights glossary & metric definitions 

Insights glossary & metric definitions 

Term

Definition

View

A table view within a base

Page

An interface page

User

Both authenticated and unauthenticated users (unauthenticated users will be noted as anonymous users)

Metric

Definition

Daily active user

A unique user who has opened Airtable and/or made record edits in the last 24 hours

Weekly active user

A unique user who has opened Airtable and/or made record edits in the last 7 days

Overall activity

Count of unique users who have taken at least one action (view or page open/record edits) in any part of Airtable

Base activity

Count of unique users who have taken at least one action (view open/record edits) in the base

Interface activity

Count of unique users who have taken at least one action (page open/record edits) in interfaces

Days active

Count of days in a row the same user has taken at least one action (view or page open/record edits)

Opens

Navigating to, or refreshing, a view or interface page

Record edits

Count of all edits a user made to records in either views or interface pages

Record activity by base or interface

The total number of times there have been record edits in either the base or interfaces

Top users

The total count of activity across all metrics on the top users table, ranking users from highest total to lowest

Top places (bar chart)

The top 10 interface pages and views based on opens, ranked from highest to lowest

Top places (details table)

The top interface pages and views based on the total count of opens plus activity, ranked from highest to lowest

Base suggestions

Base suggestions overview

Base suggestions is a powerful tool that helps creators troubleshoot existing base issues through targeted suggestions. For example, Airtable will suggest ways to fix broken automations, address disabled table option syncing, and remove unused views.

Activity & daily active users

Activity and daily active users overview

The Activity section provides helpful insights into how your base or interface is being used by collaborators. With these insights, you have access to base or interface visits over time, collaborator activity, and record activity in views vs interface pages.

Directly above the Daily Active Users section provides high-level information detailing your total number of app, base, and interface visits.

The Daily Active Users section offers:

  • The overall number of daily active users + a breakdown of daily active users (interface vs base).

  • Record activity by surface area.

  • The top base and interface users.

  • The top base or interface places (most visited views/interface pages).

  • The ability to filter daily active user data by users, tables, and interfaces.  

  • The ability to filter by time frame (last week, last month, and last quarter).

Filtering insights

You can filter insights by:

  • Users, tables, and interfaces

  • Weeks, months, and quarters

Insights CSVs 

Owners and Creators can download insights CSVs for:

  • Daily active users

  • Record activity surface

  • Top users

  • Top places

Top places bar chart & top places detail view

Top places overview

The top places bar chart gives insight into your top 10 interface pages and views based on opens, ranked from highest to lowest.

Included below the top places bar chart is the top places detail table. The detail table allows you to select individual places (interface pages and views), opening a detailed view into that place's usage and more.



Was this article helpful?