%
Overview
The State and County Trends report includes two tables that include a massive spread of detailed market and demographic metrics. All of the metrics are described below, but here are the basics:
- Patient counts based on patient residency at the state and county level
- Counts for Medicare FFS and Medicare Advantage
- Patient counts by ethnicity
- Patient counts by gender and age
- Patient counts and aggregate costs of care specific to home health
- Annual trends for the last eight years (most recent year is year-to-date.)
- Quarterly trends for the last eight quarters
Buckle up. This is a feast!
Location
Use these steps to open the State & County Trends tab to see the reports.
| Click on the "Reports" button in the left navigation to open the Reports page. |  |
- Then, click on the State & County Trend tab.
There are two reports under the State & County Trends tab.
In this article
Quick Value
The two tables include detailed metrics at the state and county level. Evaluating these metrics will help you to understand geographic patient trends that shape market demand. Use the metrics to understand where patients are in the selected region and how care is being delivered to those patients. Understanding trends from the two tables enables better strategic planning, market assessment, and informs operational decision making.
Tables show where home health patients live
Reveals county-level patient distribution to help teams prioritize the highest-need and highest-potential markets.
Metrics highlight demographics by county
Provides visibility into how patient needs differ across counties, supporting targeted outreach and care program alignment.
Tables reveal utilization & competitive shifts
Tracks market changes, and penetration trends — equipping leaders with actionable intelligence for growth planning.
Analytics inform strategic territory design
Helps organizations align reps, resources, and expansion strategies with true market demand to strengthen coverage and performance.
 |
Filters and features
A few settings are needed before you can examine the metrics in the tables. There are also a couple helpful features to keep in mind. These are listed below.
State and County Selection
| There are two filters selectors at the top left of the page. These allow you to select the state and county for the metrics you want to view on the page. |  |
The selections will open
The State Trends table will display metrics for the state you choose
|
 |
|
Once you have chosen a state in the State filter selector, you have the option of choosing a county in the selected state. This can work one of two ways.
|
 |
|
After you choose a state, wait a moment before clicking the county filter button. It takes a moment for the counties to update. | |
Pages of metrics
If you are brave and ambitious and choose to view all counties in your selected state, you will be faced with a LOT of rows of metrics. The navigation tools at the bottom of the table will help you to navigate through the pages.
The table, for one location, has more than 40 metrics. The default for the "items per page" dropdown is 25 rows. This means that you will not see all available metrics for a single location when you scroll down.
Set the dropdown to 50 items per page so that all metrics for a single location are displayed on the page. You will still need to scroll down to see those metrics since the window can only show a dozen rows at a time.
The Big Blue "i" Button
|
The "i" button in the circle at the top left of the page is a dropdown that displays definitions for all of the metrics in both tables.
|
 |
Remembering Excel
Finally, and especially if you are looking at all of the counties in your chosen state, if you click on the 
button at the top right of the table, you can download the metrics in the table to an Excel spreadsheet. That way, you can organize and view the metrics the way you want.
|
How to use this page
When you first look at this page, at either of the tables, the splash of metrics might be overwhelming. Use the following tips and suggestions to breakdown the table into greater usefulness.
Table Summary
There are four categories of metrics (rows) that are presented as trends over eight years and eight quarters (columns). Keep these larger categories in mind.
- General Medicare Advantage and Medicare FFS patient enrollee counts
- Patient counts by age and gender
- Patient counts by Ethnicity
- Metrics specific to home health care
A color coded version of these categories can be found under the section for each table.
To keep in mind
- Four categories of metrics
- Trended metrics over two different periods - eight years and eight quarters
- Metrics pertain to residents who resided in the chosen region
Suggestions
Metrics tell a story about what happened. They also answer questions. The goal is to ask the right questions and the right types of questions. Some of these questions will be broad in order to provide the backdrop to understanding the big picture. Other questions need to be precise and targeted. Targeted questions tend to seek to draw a connection between the metrics are what you are trying to accomplish.
- Look for the big trends
- Are enrollee counts going up or going down? Is one row of metrics going up while another is going down? Hmm... why? Is there a sharp increase or decrease? What could be the reason? Are there seasonal trends?
- The demographic and home health specific metrics could also show trends over time.
-
Demographic questions
- Which demographic is dominating the selected territory? What is the mix of age or ethnicity in the selected territory? Is your organization properly aligned to serve those patient populations? Is there evidence of a demographic shift that your organization will need to respond to?
- Anomalies? Are there metrics that stand out as too high, or too low? What else do we need to know to understand metrics that stand out in this way? For the most part, when a metric stands out in this way, finding the reason provides the greatest insights into what is going on with patients in a specific territory
When you find anything in Trella Health's metrics that seem odd or askew, get in touch with your CSM. It is a goal to dig in on mysteries and make sense of them.
-
Opportunities!
- Look for metrics or trends that align with your organization's strengths and ongoing initiatives. Are there specific sectors in a patient population that is growing but is underserved?
- Look for metrics that connect patient needs to your strengths.
- Compare counties for patterns and trends that suggest strategic changes, or that suggest a change in allocation of resources.
Comparing different counties would be easiest by exporting the table to Excel. This is especially true if your territory serves adjacent counties in different states. You might need to combine multiple Excel exports into a single file.
-
Home health specific metrics
- The State & County Trends tab includes a score of metrics specific to patients who received home health care in the selected territory.
- All of the questions and types of questions suggested above can be reconsidered with specific focus on the home health patient population.
- These metrics allow you to closely align trends to your agency.
Connections
The metrics under the State & County Trends tab are very general. The picture painted from these metrics is the background against which you can view every other insight provided in Marketscape Insights for Home Health. Once you have set the scene under the State & County Trends tab, there are many tools that can complete the picture.
- On the Reports page, the Market Share tab can show the home health agencies that serve in your selected territory.
- On the Explore page, you can set the filters to the same territory and then evaluate and compare providers that serve the patients in the bigger picture.
- For significant provider of interest, open the Analyze page to do a detailed assessment
- If you use Marketscape CRM, which is a great idea, you can peruse your most active accounts and contacts in the same territory to make immediate tactical decisions based on the detailed context from the State & County Trends tab. Or dig in to your EHR for a similar assessment.
This only scratches the surface. If you want more ideas, make contact with you customer success manager, or send a question to Support@TrellaHealth.com
|
County Trends table
The image below shows a sample of the metrics for a single county, York, PA. (Identified in the first column in the box.)
Click on the image to expand it.
Categories
There are some general categories of content in the table that are identified in the image above.
Color Coding |
Description |
| Red | Rows - counts of Medicare Advantage and Medicare FFS enrollee |
| Orange | Rows - home health specific metrics - visit and patient counts, patient days, and averages |
| Green | Rows - patient gender and age demographics |
| Cyan | Rows - patient ethnicity breakdown |
| Yellow | Columns - annual metrics for the last eight years |
| Dark Blue | Columns - quarterly metrics for the most recent 8 quarters |
Understanding the Metrics
Each row includes metrics that are calculated for the period identified in the column header.
Metric name |
Description |
| Total Medicare Enrollees | The count of distinct beneficiaries enrolled in either Medicare FFS or Medicare Advantage during the period listed in the column header. |
| Medicare FFS Enrollees | Count of distinct beneficiaries enrolled in a Fee-for-Service plan for at least one month during the period listed in the column header. |
| Medicare Advantage Enrollees | Count of distinct beneficiaries enrolled in a Medicare Advantage plan for at least one month during the period listed in the column header. |
| Dual-Eligible Enrollees | Count of distinct Medicare enrollees who were eligible for Medicaid coverage during the period listed in the column header. |
| % Medicare Advantage Enrollees | the percentage of "Total Medicare Enrollees" who were enrolled in Medicare Advantage |
| HHA Patients Per 1,000 |
(FFS only) A "per thousand" metric provides a way to compare performance in the same row by leveling population metrics that could be very different.
|
| HHA Patients | Distinct count of patients enrolled in home health at any point during the year. |
| HHA Visits Per Patient | The average number of home health visits per patient during the period listed in the column header. |
| HHA Visits | The sum of home health visits for patients in the county during the period listed in the column header. |
| HHA Patient Days | The sum of patient days enrolled in home health at any time during the period listed in the column header. |
| HHA Average Patient Days | The average number of days spent in home health for patients who were enrolled during the period listed in the column header. |
| HHA Median Patient Days | The median number of days spent in home health for patients who were enrolled during the period listed in the column header. |
| HHA Admissions | The count of distinct home health admissions during the period listed in the column header. |
| HHA Discharges | The count of distinct home health discharges during the period listed in the column header. |
| HHA ALOS | The average number of days spent in home health for patients who were discharged during the period listed in the column header. |
| HHA MLOS | The median length of stay for all patients discharged from a home health stay during the period listed in the column header. |
| HHA ADC | The home health average daily census for the period listed in the column header. (Patient Days/Calendar Days). |
| Medicare FFS HHA Payments | The sum of Medicare FFS reimbursement for home health patients in the county during the period listed in the column header. |
| Medicare FFS HHA Payments Per Patient | The average Medicare FFS reimbursement per home health patient during the period listed in the column header. |
| Gender and Age | The counts of enrollees broken out by the listed gender or age for Medicare FFS and Medicare Advantage patients during the period listed in the column header. |
| Ethnicity | The counts of enrollees broken out by the listed ethnicity for Medicare FFS and Medicare Advantage patients during the period listed in the column header. |
Calculation: Divide the partial metric by the whole then multiply by 1000. Use two metrics in the table - "HHA Patients" / "Medicare FFS Enrollees" * 1000 |
State Trends table
The image below shows a sample of the metrics for a single state, PA.
Click on the image to expand it.
Categories
There are some general categories of content in the table that are identified in the image above.
Color Coding |
Description |
| Red | Rows - counts of Medicare Advantage and Medicare FFS enrollees |
| Orange | Rows - home health specific metrics - visit and patient counts, patient days, and averages |
| Green | Rows - patient gender demographics |
| Cyan | Rows - patient age metrics |
| Yellow | Columns - annual metrics for the last eight years |
| Dark Blue | Columns - quarterly metrics for the most recent 8 quarters |
Understanding the Metrics
Metric name |
Description |
| Total Medicare Enrollees | The count of distinct beneficiaries enrolled in either Medicare FFS or Medicare Advantage during the period listed in the column header. |
| Medicare FFS Enrollees | Count of distinct beneficiaries enrolled in a Fee-for-Service plan for at least one month during the period listed in the column header. |
| Medicare Advantage Enrollees | Count of distinct beneficiaries enrolled in a Medicare Advantage plan for at least one month during the period listed in the column header. |
| Dual-Eligible Enrollees | Count of distinct Medicare enrollees who were eligible for Medicaid coverage during the period listed in the column header. |
| % Medicare Advantage Enrollees | the percentage of "Total Medicare Enrollees" who were enrolled in Medicare Advantage |
| HHA Patients | |
| HHA Visits Per Patient | The average number of home health visits per patient during the period listed in the column header. |
| HHA Visits | The sum of home health visits for patients in the county during the period listed in the column header. |
| HHA Patient Days | The sum of patient days enrolled in home health at any time during the period listed in the column header. |
| HHA Average Patient Days | The average number of days spent in home health for patients who were enrolled during the period listed in the column header. |
| HHA Median Patient Days | The median number of days spent in home health for patients who were enrolled during the period listed in the column header. |
| HHA Admissions | The count of distinct home health admissions during the period listed in the column header. |
| HHA Discharges | The count of distinct home health discharges during the period listed in the column header. |
| HHA ALOS | The average number of days spent in home health for patients who were discharged during the period listed in the column header. |
| HHA Median LOS | The median length of stay for all patients discharged from a home health stay during the period listed in the column header. |
| HHA ADC | The home health average daily census for the period listed in the column header. (Patient Days/Calendar Days). |
| Medicare FFS HHA Payments | The sum of Medicare FFS reimbursement for home health patients in the county during the period listed in the column header. |
| Medicare FFS HHA Payments Per Patient | The average Medicare FFS reimbursement per home health patient during the period listed in the column header. |
| Gender and Age | Counts of enrollees broken out by the listed gender for Medicare FFS and Medicare Advantage patients |
| Ethnicity | The counts of enrollees broken out by the listed ethnicity for Medicare FFS and Medicare Advantage patients during the period listed in the column header. |
|
