Pet Insurance MGA Portfolio Review: How to Analyze and Optimize Your Book of Business

Your book of business is a living organism it changes every day as policies are written, renewed, and cancelled. Without regular portfolio reviews, you're flying blind. You don't know which segments are profitable, where risk is concentrating, or what's driving loss ratio changes. A structured portfolio review gives you the data to make strategic decisions instead of guessing.

Talk to Our Specialists

What Is the Right Framework for a Pet Insurance Portfolio Review?

The right framework analyzes your book across six dimensions demographics (breed, age, species), geography (state concentration), product (plan tier distribution), vintage (policy year cohorts), channel (acquisition source), and financial (loss ratio by segment) — on a structured calendar of monthly KPI dashboards, quarterly segment analyses, and annual comprehensive reviews with your carrier partner.

1. Review Dimensions

Dimension	What to Analyze	Key Questions
Demographics	Breed, age, species distribution	Is the book shifting toward higher-risk segments?
Geography	State and regional concentration	Is risk geographically diversified?
Product	Plan tier, coverage level distribution	Are all products profitable?
Vintage	Policy year cohorts	Are newer vintages performing differently?
Channel	Acquisition source	Which channels produce the best risks?
Financial	Premium, claims, loss ratio by segment	Where is money being made and lost?

2. Review Calendar

Review Type	Frequency	Scope	Audience
KPI dashboard	Monthly	High-level metrics	Operations + leadership
Segment analysis	Quarterly	By state, product, breed, age	Leadership + actuarial
Comprehensive review	Annual	Full book analysis + strategy	Leadership + carrier + board
Event-driven review	As needed	Specific concern area	Relevant stakeholders

How Should You Analyze Your Book's Composition?

Book composition analysis examines three layers: demographic profile (species split, age distribution, breed concentration, policy tenure, and household composition), geographic distribution (state concentration, urban vs rural split, and state-level profitability), and product mix (plan tier distribution, average premium, coverage levels, add-on uptake, and product-level loss ratios).

1. Demographic Profile

Metric	What to Track	Why
Species split	% dogs vs cats	Cats have lower loss ratios
Age distribution	Average age, % by age band	Older pets = higher claims
Breed distribution	Top 20 breeds, % of book	Breed predispositions
Policy age	Average tenure, distribution	Seasoned book is more stable
Household composition	Single vs multi-pet	Multi-pet has better retention

2. Geographic Distribution

Metric	What to Track	Why
State concentration	Premium by state, top 5 states	Concentration risk
Urban vs rural	Vet cost differences	Pricing adequacy
State profitability	Loss ratio by state	Identify problem states
Growth by state	New policies by state	Where growth is coming from
Regulatory exposure	States with strict regulation	Compliance risk

3. Product Mix

Metric	What to Track	Why
Plan distribution	% by plan tier	Revenue and risk profile
Average premium	By product, trending	Revenue per policy
Coverage level	Average limits, deductibles	Exposure management
Add-on uptake	Wellness, dental, etc.	Revenue opportunity
Product profitability	Loss ratio by product	Sustainable product design

For KPI metrics and tracking, see our comprehensive metrics guide.

How Do You Assess Profitability by Segment?

Profitability assessment requires calculating loss ratios by segment (breed, age, species, geography, product, channel), identifying the drivers behind each segment's performance, and tracking 12-month trends. Young dogs (0–3) and multi-pet households are typically the most profitable segments (~50–56% loss ratio), while senior dogs (8+) often run unprofitable at 80%+ loss ratios.

1. Loss Ratio by Segment

Segment	Premium	Incurred Claims	Loss Ratio	Verdict
Young dogs (0–3)	$2.4M	$1.3M	54%	Profitable
Adult dogs (4–7)	$3.6M	$2.3M	64%	Acceptable
Senior dogs (8+)	$1.8M	$1.5M	83%	Unprofitable
Young cats (0–5)	$0.8M	$0.4M	50%	Profitable
Adult cats (6+)	$0.6M	$0.4M	67%	Watch
Multi-pet households	$1.8M	$1.0M	56%	Most profitable

2. Profitability Drivers

Driver	How It Affects Profitability
Age of pet	Older = higher claims frequency and severity
Breed	Certain breeds prone to expensive conditions
Plan tier	Higher coverage = higher loss ratio
State	Vet costs vary significantly by state
Tenure	Longer tenure = more predictable (better)
Acquisition channel	Some channels attract better risks

3. Trend Analysis

Metric	12-Month Trend	Concerning If
Average age of book	Track direction	Increasing steadily
Breed concentration	Top 10 breeds	Single breed >15% of book
Average premium	Track vs inflation	Declining or flat
New business LR	First-year loss ratio	>70% consistently
Renewal LR	Renewal-year loss ratio	Increasing
Mix shift	Product tier changes	Moving toward unprofitable tiers

What Are the Key Risk Concentration Thresholds?

Risk concentration becomes a concern when any single state exceeds 30% of premium (action at 40%), any single breed exceeds 10% of policies (action at 15%), any single age band exceeds 25% of policies (action at 30%), or any single channel exceeds 40% of new business (action at 50%). Diversification strategies should be implemented proactively when warning levels are approached.

1. Concentration Limits

Concentration Type	Warning Level	Action Level
Single state	>30% of premium	>40% of premium
Single breed	>10% of policies	>15% of policies
Single age band	>25% of policies	>30% of policies
Single product	>50% of premium	>60% of premium
Single channel	>40% of new business	>50% of new business

2. Diversification Strategies

Concentration	Strategy
Geographic	Expand to new states, market in underrepresented states
Breed	Adjust marketing, breed-specific pricing
Age	Attract younger pets, adjust senior pricing
Product	Promote underrepresented tiers
Channel	Diversify distribution

For loss ratio management, see our remediation playbook.

How Do Portfolio Review Findings Translate to Action?

Every portfolio review finding should be mapped to a specific action type, assigned an owner, and given a deadline. Unprofitable segments (loss ratio over 80%) need rate increases or underwriting restrictions within 30–90 days. Geographic concentration requires 6–12 month diversification plans. Declining retention in profitable segments triggers targeted retention programs within 30–60 days.

1. From Finding to Action

Finding	Action Type	Timeline
Segment loss ratio >80%	Rate increase or UW restriction	30–90 days
Geographic concentration >40%	Diversification plan	6–12 months
Channel producing poor risks	Channel terms adjustment	30–60 days
Product tier unprofitable	Product redesign or rate correction	60–180 days
Retention declining in profitable segment	Targeted retention program	30–60 days
Adverse selection pattern	Underwriting guideline update	30–60 days

2. Presenting to Carrier

Section	Content
Book overview	Size, growth, composition
Performance summary	Overall loss ratio, trends
Segment analysis	Profitable vs unprofitable segments
Risk concentration	Any concentration concerns
Action plan	What you're doing about findings
Projections	Expected performance trajectory

How Do You Build and Maintain Portfolio Review Capability?

Build your portfolio review capability over three months: month 1 focuses on data infrastructure (warehouse, KPI dashboard, segment definitions), month 2 conducts the first quarterly review and identifies top findings, and month 3 presents to the carrier and implements priority actions. Then maintain ongoing monthly KPI monitoring, quarterly segment reviews, and annual comprehensive analysis.

1. Implementation Timeline

Month 1

• Build portfolio data warehouse (or views in PAS)
• Create KPI dashboard with core metrics
• Define segment categories and reporting dimensions

Month 2

• Build segment-level analysis reports
• Conduct first quarterly portfolio review
• Identify top 3 findings and action items

Month 3

• Present findings to carrier
• Implement priority actions
• Create ongoing monitoring cadence

2. Ongoing

• Monthly KPI monitoring
• Quarterly segment review
• Annual comprehensive analysis
• Continuous portfolio optimization

Talk to Our Specialists

Frequently Asked Questions

1. What is a portfolio review?

Comprehensive analysis of your book: demographics, geography, product mix, profitability by segment, risk concentration, and trends.

2. What should you look for?

Loss ratio by segment, concentration risk, declining retention in profitable segments, growth in unprofitable segments, and adverse selection.

3. How often?

Monthly KPI dashboard. Quarterly segment analysis. Annual comprehensive review with carrier.

4. How do findings become action?

Rate adjustments, UW guideline changes, targeted retention, product modifications, geographic strategy, and marketing reallocation. Every finding needs an owner and deadline.

5. What are the key concentration risk thresholds?

Warning levels: single state over 30% of premium, single breed over 10% of policies, single age band over 25%, single channel over 40% of new business.

6. How do you present findings to your carrier?

Six sections: book overview, performance summary, segment analysis, risk concentration, action plan, and projections. Carriers value proactive, data-driven communication.

7. What data infrastructure is needed?

At minimum: a data warehouse or PAS views, KPI dashboard, defined segment categories, and segment-level analysis reports. Build in months 1–3 of operation.

8. Which segments are typically most profitable?

Young dogs (0–3 years), young cats (0–5 years), and multi-pet households tend to have the best loss ratios. Senior dogs (8+) are typically the least profitable segment.

External Sources

• https://naphia.org/
• https://content.naic.org/

Internal Links

• Explore Services → https://insurnest.com/services/
• Explore Solutions → https://insurnest.com/solutions/