Once you know how to build a report, the next step is shaping it — filtering to the right contracts, grouping them so patterns stand out, and adding custom properties that capture exactly the data you care about.
This guide covers the techniques that make reports accurate and easy to work with at scale. If you're new to reports, start with Building AI Reports in Aline first.
Overview
In this article you'll:
Learn why columns must be added before you filter
Filter documents by label and metadata
Collapse multiple exclusions into a single "is none of" filter
Create custom properties with the right output type
Group by contract type to see your portfolio in segments
Save filter views and export to CSV or Excel
Add Your Data Columns Before You Filter
The single most important habit: add every data column (property) you need before you apply filters. If you filter first and add columns later, the AI may not run across the full set of documents, and you can end up with missing or blank values.
💡 Best Practice: Build the report in this order — add your columns, let the AI extract across the whole document set, then filter and sort. This guarantees every contract in view has complete data.
Step 1: Filter Your Documents
Use labels and metadata filters to narrow your report to the contracts you actually want to analyze — for example, a single contract type, a status (Signed, Expired), or a date range.
Filtering by label is the fastest and most reliable way to isolate a group, which is why consistent labeling pays off (see Organizing Documents with Labels & Bulk Labeling).
Step 2: Combine and Simplify Filters
When you're excluding several contract types at once, you don't need a separate filter for each. Collapse them into a single "is none of" filter listing everything you want to leave out. This keeps complex reports readable and easier to adjust later.
Step 3: Create Custom Properties
Beyond the built-in prompts, you can create custom properties to extract or store exactly the field you need. Each property has an output type — text, Boolean (yes/no), date, or multi-select — so the data comes back in a usable, sortable format.
Common examples from real portfolios:
An Execution Date property for teams that don't run every contract through a workflow and need a reliable signed date to filter on
A numeric Contract Amount property, so you can sort and prioritize by value (for example, surfacing every agreement over $25K)
Expiration Date and Auto-Renewal Provision columns to drive renewal tracking and reminders
⚠️ Give date and amount fields the correct output type (date, number) rather than leaving them as text — it's what lets you sort, filter by range, and feed the value into reminders.
Step 4: Group by Contract Type
Grouping arranges your report by a shared value — most often contract type — so you can see your portfolio broken out into meaningful segments and spot outliers quickly.
Combine grouping with filters to answer questions like "show me all vendor agreements expiring next year, grouped by renewal type."
Step 5: Save Your Filter Views
Once a report is filtered and grouped the way you like, save the view so you (and your team) can return to it without rebuilding the filters each time. Saved views are the backbone of recurring processes like quarterly renewal reviews.
Step 6: Export
When you need the data outside Aline, export to CSV or Excel. This is also handy as an intermediate step — for example, exporting a report to build a Playbook from its outputs.
💡 Best Practices
Columns before filters, always. It's the difference between a complete report and one with blanks.
Filter by label rather than by hand — it's faster and it rewards consistent labeling.
Use "is none of" instead of stacking exclusion filters.
Set output types deliberately — a date stored as text can't be sorted or used in a reminder.
Save the view as soon as a report is right, so quarterly reviews take minutes instead of a rebuild.
📚 Related Articles
Organizing Documents with Labels & Bulk Labeling
Setting Up AI Reminders for Contract Expirations & Renewals
❓ Need Help?
Building a report that has to answer a very specific question? Click the Support button in Aline — we can help you structure the columns, filters, and property types before you run it at scale.