Freeform tables are a flexible, spreadsheet-like way to explore and report on your data.

Benefits include: 

• In‐depth exploration: Go beyond standard reports by pivoting, grouping and filtering multiple metrics in a single view
• No more external spreadsheets: Easily manipulate data in one place - save time, reduce complexity, and ensure data consistency
• Tailored reporting: Create tables that match exact stakeholder needs, from high‐level summaries to granular breakdowns

Freeform tables can be used to answer questions such as:

• Which acquisition channels are actually driving conversion?
• How are my top KPIs trending week over week, broken down by country?
• Which features are your most valuable user segments actually using?

Quick start

Add columns 

Navigate to Analyze > Freeform table and click the Add an event or user behavior button to add your first metric. 

The Add column panel will open on the right and you can select your first metric and event. You can either name the column or let it be auto-generated based on the metric. 

Click Create or Create & add another to keep the panel open and continue making columns. 

You can also add another column later by clicking the + to the right of your table. 

Columns can be duplicated by clicking the column header's ... menu and selecting Duplicate. 

Groupings (Group by)

Add a Group by by clicking the … next to Group by. Group by device type, marketing channel, job title, or any property you want to use. 

Add Group bys to create rows and watch as your results update instantly.

To add another Group by, click the plus sign next to it. Click the x next to a Group by's name to remove it from your table.

Key features

Filtering

Like other Heap charts, you can apply time period filters and property filters at the table level to narrow your data. 

Event-level filters are available within your table for more granular control.

Transpose

Flip your table layout by moving a grouping from rows to columns for easier side-by-side comparisons — perfect for presenting data or comparing performance across segments at a glance.

Add your metrics in the Column metrics view and toggle to Row metrics (read only) when you are ready to solidify your columns

Note: You can transpose one grouping at a time, with a maximum of 2 groupings supported.

Aggregation control

Choose how your metrics are aggregated — switch between sum and average directly in the table, giving you more flexibility without needing to export to Excel.

Sum: total of all metric values

Average: mean value per user or session

Heap automatically selects the right calculation method for each metric to keep your data accurate. For example, event counts default to Sum, while per-user averages default to Average. 

You can change the aggregation via the column header by clicking the …menu. The current aggregation is always visible in the table.

Sorting, renaming, and reordering

Click on the ... menu in a column's header and select Edit to change the name or underlying metrics of the column. 

The arrows next to the menu will reorder the column results to either be ascending or descending. 

Save, share, and export

Like other Heap charts, Freeform tables can be shared once they are saved. Use the top right menu to save and share your Freeform table. 

Click Export and chose between exporting it as a CSV or Google Sheet. Exports reflect the transposed layout (row metrics). 

Limitations

• A maximum of ten Group by columns are allowed, and 12 columns for metrics
• The transpose feature is only available with a Group by
• Available aggregation types are sum and average. Other types (median, unique count, relative %) are not currently supported
• Freeform tables can't be added to Dashboards
• Email subscriptions are not available for Freeform tables