- 23 Aug 2023
- 2 Minutes to read
- Print
- DarkLight
Using insights
- Updated on 23 Aug 2023
- 2 Minutes to read
- Print
- DarkLight
Airtable’s 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.
Introduction
Plan availability | Business and Enterprise Scale plans only |
Permissions | "Owner" or "Creator" permissions are needed to use or access insights as described in the article below |
Platform(s) | Web/Browser, Mac app, and Windows app |
Accessing insights
To access insights:
- From your Airtable homepage, open a base.
- Click Tools in the top right, next to Extensions.
- From the Tools menu, select Insights.
Fullscreen insights are accessible inside the insights panel by clicking the expand button.
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 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.
Insights: activity & daily active users
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
Airtable offers the option to download insights CSVs for:
- Daily active users
- Record activity surface
- Top users
- Top places
Top places bar chart & top places detail view
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.