How to Read Your Sales Trend Chart
A trend chart only helps you if you know what to look for. Most owners glance at a line going up and say "we're good." Glance at a line going down and panic. Both are mistakes.
In this guide:
- What the chart actually shows
- The 3 patterns that matter
- When a slow month is just a slow month
- How to click into a specific month for detail
- How to compare this year to last year
Time to read: 6 minutes Best for: Owners and office managers.
What does a healthy trend look like?
Four signals add up to a healthy trend:
| Signal | What's healthy | What to worry about |
|---|---|---|
| Monthly premium | Steady or growing | Flat 3+ months in a row |
| Product mix | Consistent | 10+ point shift in 6 months |
| Producer balance | No one over 40% of total | One producer over 50% |
| Renewal retention | 88%+ | Below 85% |
If any one of these moves the wrong way for 2 months in a row, it's time to investigate.
The trap most owners fall into. Looking only at the top-line total. Last month $320K, this month $325K — looks flat. But if your product mix shifted 15 points from home to auto, something's changing underneath.
What does the trend chart show?
The chart on the dashboard has two tabs:
- Policies Written — how many policies per month
- Written Premium — how many dollars per month
Each bar is one month. Colors inside the bar break down the products (Auto is blue, Fire is orange, Life is green, Health is purple).
What are the 3 patterns to watch for?
Pattern 1 — Slow-rolling decline
A producer's number dips small for 3 months. Each dip is small enough to miss on its own.
Example. 5% down in March, 4% down in April, 6% down in May. Add them up and you're down 15% for the quarter. The conversation needed to happen in April, not August.
Spreadsheets miss this because you're looking at the current month. AgencyIQ shows the 3-month slope.
Pattern 2 — Product mix shift
Your book swings 10 or more points toward one product (usually auto) over 6 months.
Why that matters:
- Auto-only households shop every 6 months (worse retention)
- Carrier bonus checks often need minimum product mix (you could lose the bonus)
- If auto rates go up and customers shop, a lot of your book walks
Pattern 3 — More policies, same dollars
Your policy count is growing but premium is flat. That usually means more single-product sales and fewer bundles.
Not always bad — it depends on your strategy. But worth a look. Bundled customers retain far better than single-product customers.
What does it mean when new business dips but renewals stay flat?
Your retention is fine but your pipeline is slowing.
Renewals are a trailing signal — they take a year to show up. New business is a leading signal. When new business drops for 2 months while renewals hold, your agency is about to hit a soft patch 6–12 months out.
The 3 usual reasons
- Lead flow dried up — check your lead sources
- Close rate is down — coaching issue, probably
- Carrier changed their appetite — a slice of your pipeline got cut off
AgencyIQ flags this when the new-business slope and renewal slope split apart. You'll see it at month 2 instead of month 8.
When is a dip just a slow month?
Cheat sheet:
| What you see | Is it a problem? |
|---|---|
| One producer, one month off pace | Probably not — it's noise |
| One producer, 3 months in a row off pace | Yes — time for a conversation |
| One producer, one month 40%+ below pace | Yes — find out what happened |
| Agency Q1 dip, lots of Q1 renewals | Normal — expected seasonality |
Rule of thumb. Month-to-month swings on a single producer are usually noise. A producer who averages $60K a month can write $48K one month and $72K the next and nothing is actually wrong.
How do I click into a specific month's detail?
Click any bar on the chart. You drop into a detail view showing every policy that made up that bar — producer, carrier, product, premium, date.
You can sort, filter, and export to a CSV. This is the view that ends the "why was last quarter down?" meeting where three people argue about three spreadsheets. Everyone sees the same detail.
Can I compare this year to last year on the same chart?
Yes. Click the Compare toggle in the top-right of the chart. Last year's same-period numbers show up as a dotted line.
Year-over-year is the only honest way to read trend in a seasonal business. Month-over-month in January always looks bad because December had renewals.
Frequently Asked Questions
How much history do I need before the chart is useful?
Three months to see direction. Six months to see a pattern. Twelve months to see year-over-year. Upload as much history as you have on day one.
Why did one month spike way above the others?
Usually one of three things: a historical catch-up upload dumped a lot of sales into one month, a carrier posted a correction, or you actually landed a big commercial policy. Click the bar to see which.
Can I save the chart as an image?
Yes. Right-click the chart and pick "Save as PNG." For whole dashboards, use the PDF export button instead.
My commercial lines trend looks jagged. Is that normal?
Yes. Commercial premiums are lumpier than personal lines — one big policy can swing a month 20%. Commercial agencies usually look at 3-month or 6-month rolling averages instead of single months.
What's the difference between written and earned premium?
Written premium is what was sold that month. Earned premium is what actually hits your books as revenue over time. The trend chart uses written premium, which is almost always the right number for agency decisions.
Stop guessing whether a dip is a problem
AgencyIQ is free during beta for Founding Members. Get trend views that separate real problems from monthly noise — so you know when to act and when to wait.
Founding Members get grandfathered pricing when we launch paid tiers later this year.
Last updated: 2026-04-18