Average Family Expected Revenue report

What the report shows

Average Family Expected Revenue Over Time estimates how much revenue you expect from each family in a season, then tracks how that average changes over time and across seasons.

Use this report when you want to:

• Compare how much families are expected to spend from one season to the next.

• Spot seasons where family spend is trending up or down.

• Drill into which families drive a season's expected revenue.

How expected revenue is calculated

Expected revenue in this report uses the same definition shown in the Campium UI.

For each season:

• Campium adds up the prices of all products on a family's account.

• Campium subtracts any discounts and credits applied to those products.

• The result is the family's expected revenue for that season.

Average Family Expected Revenue for a season is:

• Total expected revenue for that season ÷ number of families with a balance in that season.

This matches the avg_balance value in the underlying report data, where:

• total_balance = sum of expected revenue for all families in the season.

• family_count = number of families included in that season's calculation.

• avg_balance = total_balance / family_count.

Permissions and access

You need the finance module permission to view this report.

The report lives at the internal URL /report/average-family-spend.php and appears in your Reports area as Average Family Expected Revenue Over Time.

Run the report

Use these steps to open and run the report from Campium.

Filters

The Average Family Expected Revenue report has a single primary filter.

Season filter

The Season filter controls which seasons appear in the charts and season breakdown.

• The filter is a multi-select list of seasons.

• All seasons are selected by default when you load the page.

• Clearing or deselecting all seasons results in an empty chart and table.

When you change the Season filter and run the report, Campium sends the selected seasons (along with your agency) to the server to recalculate the averages.

URL context and pgcryid

You may sometimes see a pgcryid value in the URL when you open the report from another area, such as a dashboard widget or shortcut.

• pgcryid tells the report which context or saved view you came from.

• The report still honors any seasons you set in the Season multi-select.

• You can safely ignore pgcryid unless you are debugging a custom link or integration.

What you see on the page

After you run the report with at least one season selected, the page shows a combination of charts, summary cards, and a detailed table.

Average Family Expected Revenue Trend Over Time (line chart)

The line chart at the top is labeled Average Family Expected Revenue Trend Over Time.

This chart shows:

• The average expected revenue per family on the vertical axis.

• Seasons or time points on the horizontal axis.

• A line that connects each season's average expected revenue.

You can use this view to:

• See whether average spend per family is going up or down across seasons.

• Spot sharp increases or drops that might align with pricing changes, new programs, or discount policies.

The points on the line chart are clickable and correspond to individual seasons.

Average Family Expected Revenue by Season (bar chart)

The bar chart is labeled Average Family Expected Revenue by Season.

This chart displays:

• One bar per season included in your Season filter.

• The height of each bar representing the average expected revenue per family for that season.

Use the bar chart to:

• Compare seasons side by side at a glance.

• Identify outlier seasons with much higher or lower average expected revenue.

• Confirm the pattern from the line chart in a more categorical view.

Each bar is clickable and leads to the same season breakdown as clicking a season in the table.

Summary cards

Above or near the charts, you see summary cards that highlight key metrics:

• Current Average: The average family expected revenue for the most recent season in your selection.

• Highest Average: The season with the highest average expected revenue per family.

• Lowest Average: The season with the lowest average expected revenue per family.

• Trend: The change in the most recent season compared to the prior season (for example, up or down as a percentage or amount).

Use these cards as a quick readout before digging into the detailed table:

• If the Trend card shows a negative change, look for reasons families might be spending less (pricing, fewer sessions, more discounts).

• If the Highest Average is a past season, compare what was different about that season's offerings or pricing.

Season breakdown table

Below the charts, the season breakdown table lists each season with its key metrics.

The table includes these columns:

• Season
  The name of the season. The Season cell is clickable and opens the family-level drill-down for that season.

• Average Expected Revenue
  The average expected revenue per family for that season. The cell also shows a percentage change vs the prior season so you can quickly see whether family spend increased or decreased.

• Number of Families
  How many families are included in the average for that season. This count is the denominator in the average calculation.

• Total Balance
  The total expected revenue for that season across all included families. This is the sum of each family's expected revenue (product prices minus discounts and credits).

For a given season, you can interpret the numbers as:

• Total Balance ÷ Number of Families = Average Expected Revenue.

• The percentage change compares this season's average against the previous season's average.

Drill down to families

Clicking into a season opens a modal that shows which families contribute to that season's expected revenue.

Open the families modal

Interpreting and using the data

Average Family Expected Revenue helps you answer planning and pricing questions:

• Pricing impact: If average expected revenue per family jumps after a pricing change, confirm that the increase aligns with your goals and enrollment levels.

• Discount strategy: A drop in average expected revenue might reflect more aggressive discounts or scholarships. Compare changes in Total Balance and Number of Families to see whether the drop is due to pricing or enrollment.

• Enrollment mix: If the Number of Families grows but the Average Expected Revenue stays flat, you may be adding families with lower spend (shorter sessions, fewer add-ons).

Remember that this report looks at expected revenue, not actual payments collected. Use it alongside payment-focused reports when making financial decisions.

Troubleshooting empty or missing data

If the charts or table are empty, or you see less data than expected, check these common causes.