SaaS Seat Utilization License Waste Analysis Builder

Analyze SaaS license usage, inactive seats, role mismatches, department patterns, and renewal risks to reduce software spend without disrupting critical users.

Prompt Template

You are a SaaS spend analyst helping finance, IT, and department owners reduce license waste. Analyze seat utilization for:

Tool/vendor: [software name]
License model: [per seat, tiered, role-based, usage-based add-ons, annual contract]
Dataset available: [user list, last login, feature usage, department, role, license tier, manager, cost]
Time window: [30, 60, 90, 180 days]
Renewal date and contract terms: [date, true-up rules, minimum seats, notice period]
Business context: [growth, layoffs, department changes, migration, vendor consolidation]
Exclusions: [executives, service accounts, compliance users, admins, contractors, shared inboxes]
Risk constraints: [customer-facing teams, regulated access, audit needs, data retention]
Decision needed: [reclaim seats, downgrade tiers, renegotiate, change provisioning, build approval workflow]

Provide:
1. Data quality checks before analysis
2. Utilization segments: active, low use, inactive, never logged in, wrong tier, duplicate accounts
3. Cost impact estimate by segment and department
4. Risk-aware reclaim and downgrade recommendations
5. Renewal negotiation talking points using the usage data
6. Provisioning/deprovisioning workflow improvements
7. Dashboard metrics to track monthly
8. Stakeholder review template for managers before seat changes
9. Executive summary with savings, risks, and next decisions

Do not recommend removing access without owner review for regulated, admin, or customer-critical users.

Example Output

# Seat Utilization Analysis: DesignCollab Pro

Data Quality Checks

Remove service accounts, confirm contractor end dates, deduplicate users with two emails, and verify last-login timestamps are in the same timezone.

Findings

| Segment | Seats | Monthly Cost | Recommendation |

|---|---:|---:|---|

| Never logged in | 18 | $1,080 | Manager review, reclaim if no exception |

| Inactive 90+ days | 42 | $2,520 | Reclaim before renewal notice date |

| Viewer behavior on Pro tier | 31 | $1,240 | Downgrade to Viewer or Standard |

| Active power users | 96 | $5,760 | Protect access |

Renewal Point

Current contract has 250 seats, but only 154 show meaningful monthly usage. Ask vendor for a 175-seat floor with quarterly true-up and role-based tier mix.

Tips for Best Results

  • 💡Include contract dates and true-up rules; the timing often determines whether savings are real.
  • 💡Separate inactive users from protected service or admin accounts before estimating waste.
  • 💡Ask for manager review language so reclaiming licenses does not surprise teams doing critical work.