Skip to content

Box Count Breakdown Over Time Documentation

Menu Location: Reports > Subscriptions > Box Count Breakdown Over Time

Access Level: Manager and above

Last Updated: 2026-03-01

Overview

The Box Count Breakdown Over Time report visualizes subscription trends by box type across specified time periods. This helps you understand which box types are growing or declining, identify seasonal patterns, and make data-driven decisions about product offerings.

Primary Functions:

  • Track subscription counts by box type over time
  • Identify growing and declining box types
  • Analyze seasonal subscription patterns
  • Compare box type performance
  • Forecast subscription trends
  • Inform marketing and product strategy

Page Layout

Header Section

  • Report Title: "Box Count Breakdown Over Time"
  • Date Range Selector: Choose analysis period
  • Granularity: Daily, weekly, or monthly view
  • Export Button: Download data

Summary Stats

  • Total Current Subscriptions: Active subscriber count
  • Net Change: Subscriber growth/decline in period
  • Growth Rate: Percentage change
  • Most Popular Box: Highest subscription count

Box Type Trend Chart

  • Line Graph: Each box type as separate line
  • X-Axis: Time (dates)
  • Y-Axis: Subscription count
  • Legend: Color-coded box types
  • Hover Details: Exact counts on specific dates

Breakdown Table

Date Small Box Medium Box Large Box Family Box Total Subscriptions
Jan 1 45 82 63 28 218
Jan 8 47 85 65 30 227
Jan 15 48 88 66 32 234

Trend Indicators

  • ↑ Green: Growing subscription count
  • ↓ Red: Declining subscription count
  • → Gray: Stable (within 3% variance)
  • %: Percentage change from previous period

Configuring the Report

Date Range Selection

Preset Ranges:

  • Last 30 Days: Recent trends
  • Last 90 Days: Quarterly view
  • Last 6 Months: Seasonal patterns
  • Last Year: Annual trends
  • Year to Date: Current year performance
  • Custom: Specify exact date range

Granularity Options

Daily View:

  • Shows day-by-day counts
  • Best for: Short periods (7-30 days)
  • Use case: Track recent campaign impact

Weekly View:

  • Shows week-by-week counts
  • Best for: 1-6 month periods
  • Use case: Standard trend analysis

Monthly View:

  • Shows month-by-month counts
  • Best for: 6+ month periods
  • Use case: Long-term strategic planning

Filter Options

Box Type Filter:

  • All Box Types (default): Show all on one chart
  • Select Specific: Choose which boxes to display
  • Compare Two: Side-by-side comparison
  • Category: Group by box category

Subscription Status:

  • Active Only (default): Current subscribers
  • All Statuses: Include paused, cancelled
  • Active + Paused: Exclude only cancelled

Understanding the Data

Subscription Count Calculation

What's Counted:

  • Active subscriptions on each date
  • Snapshot at end of day/week/month
  • One count per subscriber (even if multiple boxes)

What's Not Counted:

  • One-time purchases
  • Gift subscriptions (unless configured to include)
  • Cancelled subscriptions (unless filter changed)
  • Test/internal accounts

Trend Analysis Metrics

Growth Rate:

  • Percentage change from start to end of period
  • Formula: ((End Count - Start Count) ÷ Start Count) × 100
  • Example: (250 - 200) ÷ 200 = 25% growth

Net Change:

  • Absolute number change
  • Example: 250 current - 200 at start = +50 net subscribers

Average Subscribers:

  • Mean count across all data points
  • Useful for capacity planning

Peak Subscriptions:

  • Highest count in period
  • Identifies capacity needs

Common Use Cases

Use Case 1: Identify Growing vs. Declining Box Types

Goal: Understand which boxes to promote or discontinue

Steps:

  1. Set Date Range: Last 6 Months
  2. Select Granularity: Monthly
  3. Include all box types
  4. Review trend lines in chart
  5. Identify boxes with upward trends (promote more)
  6. Identify boxes with downward trends (investigate why)
  7. Export data for further analysis
  8. Make strategic decisions based on trends

Example Insights:

  • "Medium Box growing 30%, promote heavily"
  • "Small Box declining 15%, consider discontinuation"
  • "Family Box stable, maintain current approach"

Result: Data-driven box type strategy

Use Case 2: Seasonal Pattern Analysis

Goal: Understand how subscriptions change seasonally

Steps:

  1. Set Date Range: Last Year
  2. Granularity: Monthly
  3. Review each box type's seasonal curve
  4. Note peak months (e.g., Jan for resolutions, Dec for gifts)
  5. Note low months (e.g., summer vacation months)
  6. Document patterns for future planning
  7. Adjust marketing budget by season
  8. Plan inventory accordingly

Example Patterns:

  • January spike (New Year resolutions)
  • Summer dip (vacation season)
  • November spike (holiday gifting)
  • Post-holiday decline (January cancellations)

Result: Seasonal marketing and inventory planning

Use Case 3: Measure Campaign Impact

Goal: Evaluate subscription campaign success

Steps:

  1. Note campaign launch date
  2. Set Date Range: 2 weeks before to 4 weeks after campaign
  3. Granularity: Daily or Weekly
  4. Filter to box type promoted in campaign
  5. Look for spike after campaign launch
  6. Calculate net new subscribers from campaign
  7. Compare to campaign cost
  8. Calculate customer acquisition cost
  9. Determine if campaign was profitable

Example:

  • Campaign: "50% off first Large Box"
  • Launch: Feb 1
  • Pre-campaign: 65 Large Box subs
  • Post-campaign: 95 Large Box subs
  • Net new: 30 subscribers
  • Campaign cost: $500
  • CAC: $16.67 per subscriber

Result: ROI analysis for marketing campaigns

Use Case 4: Capacity Planning

Goal: Determine if growth is sustainable with current resources

Steps:

  1. Set Date Range: Last 3 Months
  2. Review total subscription trend
  3. Calculate growth rate (e.g., 10% per month)
  4. Project 6 months ahead using growth rate
  5. Determine capacity limit (max orders you can fulfill)
  6. Calculate when you'll hit capacity
  7. Plan capacity expansion (staff, equipment, space)
  8. Implement before hitting limit

Example:

  • Current: 250 subscriptions
  • Growth: 10% per month
  • Capacity: 400 subscriptions
  • Months to capacity: (400-250) ÷ 25 per month = 6 months
  • Action: Plan capacity expansion by month 5

Result: Proactive capacity management

Use Case 5: Compare Box Type Performance

Goal: Determine which box types to invest in

Steps:

  1. Set Date Range: Last Year
  2. Granularity: Monthly
  3. Export data to Excel
  4. Create comparison table:
    • Growth rate by box
    • Average subscribers by box
    • Revenue per box type (if available)
    • Profit margin by box (if available)
  5. Score each box on multiple factors
  6. Identify star performers (high growth, high margin)
  7. Identify underperformers (declining, low margin)
  8. Allocate marketing budget to star performers

Result: Optimized product portfolio

Export and Reporting

Export Options

CSV Export:

  • All data points in spreadsheet format
  • Date, box type, count columns
  • Easy to analyze in Excel
  • Can create custom charts

PDF Report:

  • Formatted report with chart
  • Summary statistics
  • Trend highlights
  • Shareable with stakeholders

Scheduled Reports:

  • Automated weekly or monthly email
  • Consistent tracking over time
  • Delivered to management team

Troubleshooting

Chart Looks Flat or Shows No Variation

Check:

  1. Is date range too wide? (zoomed out too far)
  2. Is granularity appropriate for date range?
  3. Very stable subscription base (not necessarily bad)

Solutions:

  1. Shorten date range to see detail
  2. Use daily for 30 days, weekly for 3 months, monthly for 1 year
  3. Add trend line to see subtle changes

Data Seems Incorrect

Check:

  1. Are cancelled subscriptions included in count?
  2. Correct box type classification?
  3. Time zone affecting date boundaries?

Solutions:

  1. Verify filter settings (active only vs. all)
  2. Check product categorization
  3. Confirm report timezone matches business hours

Can't See All Box Types

Check:

  1. Too many box types making chart crowded?
  2. Some box types filtered out?
  3. New box types not yet tracked?

Solutions:

  1. Select specific box types to compare (not all at once)
  2. Review filter settings
  3. Wait for data to accumulate for new boxes
  • Subscriptions Schedule Totals - Current subscription breakdown
  • Future Demand - Projected subscription impact
  • Customers - Filter by subscription type
  • Create New Box - Add new box types
  • Customer Longevity Report - Subscription retention

Best Practices

Regular Monitoring

  1. Monthly review - track trends consistently
  2. Compare year-over-year - same month last year
  3. Document insights - note what you learn
  4. Share with team - inform marketing and operations

Strategic Analysis

  1. Identify inflection points - when did trend change?
  2. Correlate with events - campaigns, price changes, competitors
  3. Project forward - use trends for forecasting
  4. Test hypotheses - try interventions, measure impact

Actionable Insights

  1. Growing boxes → Increase marketing, ensure inventory
  2. Declining boxes → Investigate causes, consider refresh
  3. Seasonal patterns → Plan ahead for peaks/troughs
  4. Stable boxes → Maintain current strategy

Quick Reference Card

Task Action/Location
View annual trends Date Range: Last Year, Granularity: Monthly
Check recent growth Date Range: Last 30 Days, Granularity: Daily
Compare box types Include all boxes in chart
Measure campaign impact Date range around campaign, Daily view
Export for analysis Export button > CSV
See current counts Check Summary Stats at top
Identify seasonal patterns Last Year, Monthly view
Calculate growth rate (End Count - Start Count) ÷ Start Count × 100

FAQs

How often should I check this report?

Monthly minimum for strategic planning. Weekly during growth campaigns or new box launches. Daily during major promotions.

What's a healthy subscription growth rate?

5-15% per month is strong growth for established subscriptions. 20%+ is excellent but ensure you can sustain with capacity. 0-5% is stable maintenance.

Why do subscriptions dip in summer?

Common pattern due to vacation season. Customers pause for travel. Plan for this with summer-specific promotions or pause-friendly policies.

How do I calculate year-over-year growth?

Compare same month this year to last year: (This January - Last January) ÷ Last January × 100 = YoY Growth%

Can I see individual customer changes?

This is aggregate data. For individual subscriber changes, use Customer Activity Log or Subscription Change Report.

Should I discontinue declining box types?

Not necessarily. Check: 1) Profitability (low volume but high margin?), 2) Strategic value (entry-level box?), 3) Customer preference (loyal segment?). Declining doesn't always mean discontinue.

How do I predict future subscription counts?

Use recent growth rate trend, apply to current count. Example: 3-month avg growth = 8% per month, current = 250, next month projection = 250 × 1.08 = 270.

What if a box type has irregular patterns?

Could be: promotional cycles, seasonal product availability, or small sample size volatility. Extend date range to smooth out noise.

Can I track by customer demographics?

This report shows box types only. For demographic analysis, use Customer Segmentation Report or filter Customers page and export.

Why is there a spike on one specific date?

Check: promotional campaign launch, partnership announcement, media coverage, or competitor exit. Document cause for future reference.

Change Log

2026-03-01

  • Initial documentation created
  • All sections completed following template structure

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.