Summary Queries Configuration

Name Target Table Query Type Group By Tags Status Actions
coll_agency_by_aging
Analysis of agency performance by aging bucket
- category_collections multi_dimensional Active
coll_agency_performance
Performance metrics by agency
- category_collections agency_analysis Active
coll_agent_performance
Performance metrics by collection agent
- category_collections agent_performance Active
coll_agent_weekly_trend
Weekly trend analysis by agent
- category_collections trend_analysis agent +1 Active
coll_aging_summary
Summary of collections by aging bucket
- category_collections aging_analysis Active
coll_channel_analysis
Collections performance by channel
- category_collections channel_analysis Active
coll_channel_by_priority
Analysis of collections by channel and priority le...
- category_collections multi_dimensional Active
coll_channel_day_of_week
Analysis of channel performance by day of week
- category_collections trend_analysis channel +1 Active
coll_channel_summary
Summary of collections by channel type
- category_collections channel_analysis Active
coll_commission_readiness
Analysis of data readiness for commission calculat...
- category_collections commission_readiness data_quality Active
coll_daily_trend
Daily trend analysis of collections
- category_collections trend_analysis daily Active
coll_daily_trends
Daily trends in collections performance
- category_collections daily_trends Active
coll_day_of_week_trend
Analysis of collections by day of week
- category_collections trend_analysis day_of_week Active
coll_monthly_trend
Monthly trend analysis of collections
- category_collections trend_analysis monthly Active
coll_monthly_trends
Monthly trends in collections performance
- category_collections monthly_trends Active
coll_multidimensional_analysis
Multi-dimensional analysis combining agency, produ...
- category_collections multidimensional_analysis Active
coll_performance_summary
Summary of collection performance categories
- category_collections performance_analysis Active
coll_priority_summary
Summary of collections by priority level
- category_collections priority_analysis Active
coll_product_analysis
Collections performance by product group
- category_collections product_analysis Active
coll_product_summary
Summary of collections by product group
- category_collections product_analysis Active
coll_region_by_product
Analysis of collections by region and product
- category_collections multi_dimensional Active
coll_region_summary
Summary of collections by region
- category_collections regional_analysis Active
coll_region_weekly_trend
Weekly trend analysis by region
- category_collections trend_analysis regional +1 Active
coll_settlement_analysis
Detailed analysis of settlement cases
- category_collections settlement_analysis Active
coll_settlement_summary
Summary of settlement cases
- category_collections settlement_analysis Active
coll_special_case_analysis
Analysis of special cases (settlements, deaths)
- category_collections special_cases Active
coll_special_case_summary
Summary of special collection cases
- category_collections special_case_analysis Active
coll_strategy_summary
Summary of collections by recommended strategy
- category_collections strategy_analysis Active
coll_template_eligibility_analysis
Analysis of template eligibility across different ...
- category_collections template_eligibility legacy_metrics Active
coll_weekly_trend
Weekly trend analysis of collections
- category_collections trend_analysis weekly Active
coll_weekly_trends
Weekly trends in collections performance
- category_collections weekly_trends Active