MENU
    Using insights in Airtable
    • 08 Oct 2024
    • 3 Minutes to read
    • Dark
    • PDF

    Using insights in Airtable

    • Dark
    • PDF

    Article summary

    This article details how to use Airtable insights to understand base and interface activity, identify ways to optimize bases and interfaces, and help with base maintenance.

    Plan availability

    Business and Enterprise Scale plans

    Permissions

    Owners and Creators  

    Platform(s)

    Web/Browser, Mac app, and Windows app

    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

    Accessing insights in Airtable

    To access insights:

    1. Open your Airtable homepage.

    2. Create or open your preferred base.

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

    4. Select Insights from the “Tools” menu.

    Airtable base suggestions

    To access base suggestions:

    1. Open your Airtable homepage.

    2. Create or open your preferred base.

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

    4. Select Insights from the “Tools” menu.

      1. If you have any base suggestions, they will appear at the top of the “Insights”  window.

    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).

    Insights CSVs

    To download insights CSVs:

    1. Open your Airtable homepage.

    2. Create or open your preferred base.

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

    4. Select Insights from the “Tools” menu.

      1. Insights are available for: Daily active users, Record activity surface, Top users, and Top places.

    5. Click the ˅ icon next to your preferred insight.  

    6. Click Download CSV.

    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?