# Usage Analysis Report

Generated on: 2026-01-09 19:42:39

## Project Statistics

### Models Overview
- **Total Models:** 16
- **Models with Labels:** 15
- **Unique Connections:** 1
- **Total Explores:** 23

### Views Overview  
- **Total Views:** 29
- **Views with SQL Tables:** 29
- **Views with Derived Tables:** 5
- **Total Dimensions:** 281
- **Total Measures:** 119

### Code Statistics
- **Total Lines of Code:** 4395
- **Average Model Size:** 22.6 lines
- **Average View Size:** 139.1 lines

## Top Models by Explores

- **territory_kpis:** 5 explores
- **deal_risk_analysis:** 4 explores
- **youtube_video_reports:** 2 explores
- **sme_latam_weekly_unified_chart:** 1 explores
- **Spotify_DM_Chartmetric_Stats:** 1 explores
- **Spotify_DM_Agg:** 1 explores
- **Spotify_DM_Lifted_Agg:** 1 explores
- **Spotify_DM_Lifted:** 1 explores
- **youtube:** 1 explores
- **RM_Dashboard_Label_Store_Split:** 1 explores

## Top Views by Fields

- **int_dbt_prod_struggling_deal_analysis:** 49 fields
- **int_dbt_prod_new_deal_revenue_summary:** 25 fields
- **int_dbt_prod_sme_latam_charting_filtered:** 21 fields
- **int_dbt_prod_label_lookback:** 20 fields
- **int_dbt_prod_video_combined_intermediate:** 20 fields
- **int_dbt_prod_spotify_dm_agg_streams:** 19 fields
- **deal_analysis_metrics_overview:** 18 fields
- **int_dbt_prod_rm_db_accounting_base_periods:** 16 fields
- **int_dbt_prod_video_demographics_intermediate:** 16 fields
- **int_dbt_prod_spotify_dm_raw_streams:** 15 fields

## Connection Usage

- **orchard-strategy:** 16 models