# Abacus Looker Documentation

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

## Project Overview

This repository contains 16 Looker models and 29 views for the Abacus system.

## Quick Navigation

- [Models Documentation](models/model-inventory.md) - Complete list of all Looker models
- [Views Documentation](views/view-inventory.md) - Complete list of all Looker views  
- [Explores Catalog](explores/explore-catalog.md) - All available explores
- [Data Lineage](data-lineage/dependency-map.md) - View and model dependencies
- [Usage Reports](reports/usage-analysis.md) - Analysis and statistics

## Models Summary

| Model | Label | Connection | Explores | Views Used |
|-------|-------|------------|----------|------------|
| [RM_Dashboard](models/RM_Dashboard.model.md) | RM Dashboard | orchard-strategy | 1 | 2 |
| [RM_Dashboard_Catalog_Split](models/RM_Dashboard_Catalog_Split.model.md) | RM Dashboard Label Catalog Split | orchard-strategy | 1 | 2 |
| [RM_Dashboard_Country_Store_Split](models/RM_Dashboard_Country_Store_Split.model.md) | RM Dashboard Label Store Split | orchard-strategy | 1 | 2 |
| [RM_Dashboard_Label_Store_Split](models/RM_Dashboard_Label_Store_Split.model.md) | RM Dashboard Label Store Split | orchard-strategy | 1 | 2 |
| [RM_Dashboard_Revenue_over_Time](models/RM_Dashboard_Revenue_over_Time.model.md) | RM Dashboard Revenue over Time | orchard-strategy | 1 | 2 |
| [RM_Dashboard_Services](models/RM_Dashboard_Services.model.md) | RM Dashboard Services Revenue | orchard-strategy | 1 | 2 |
| [Spotify_DM_Agg](models/Spotify_DM_Agg.model.md) | Spotify DM | orchard-strategy | 1 | 1 |
| [Spotify_DM_Chartmetric_Stats](models/Spotify_DM_Chartmetric_Stats.model.md) | Spotify DM Chartmetric | orchard-strategy | 1 | 1 |
| [Spotify_DM_Lifted](models/Spotify_DM_Lifted.model.md) | Spotify DM | orchard-strategy | 1 | 1 |
| [Spotify_DM_Lifted_Agg](models/Spotify_DM_Lifted_Agg.model.md) | Spotify DM | orchard-strategy | 1 | 1 |
| [deal_risk_analysis](models/deal_risk_analysis.model.md) | Deal Risk Analysis | orchard-strategy | 4 | 1 |
| [orchard-strategy](models/orchard-strategy.model.md) | None | orchard-strategy | 0 | 0 |
| [sme_latam_weekly_unified_chart](models/sme_latam_weekly_unified_chart.model.md) | SME LATAM Weekly Unified Chart | orchard-strategy | 1 | 1 |
| [territory_kpis](models/territory_kpis.model.md) | Territory KPIs | orchard-strategy | 5 | 1 |
| [youtube](models/youtube.model.md) | YouTube | orchard-strategy | 1 | 1 |
| [youtube_video_reports](models/youtube_video_reports.model.md) | YouTube | orchard-strategy | 2 | 3 |


## Views Summary

Total views: 29

| View | Table Source | Dimensions | Measures |
|------|-------------|------------|----------|
| [deal_analysis_metrics_overview](views/deal_analysis_metrics_overview.md) | deal_analysis_metrics_overview | 16 | 2 |
| [dim_youtube_channel_names](views/dim_youtube_channel_names.md) | facts.prod.dim_youtube_channel_names | 4 | 0 |
| [int_dbt_prod_label_country_report](views/int_dbt_prod_label_country_report.md) | Derived from: Dbt_Prod_Strategy.Ifpi_Label_Country... | 6 | 4 |
| [int_dbt_prod_label_lookback](views/int_dbt_prod_label_lookback.md) | label_lookback | 8 | 12 |
| [int_dbt_prod_monthly_territory_kpis](views/int_dbt_prod_monthly_territory_kpis.md) | Derived Table (Custom SQL) | 1 | 12 |
| [int_dbt_prod_new_deal_revenue_activity](views/int_dbt_prod_new_deal_revenue_activity.md) | salesforce_new_deal_revenue_by_activity_date | 13 | 1 |
| [int_dbt_prod_new_deal_revenue_summary](views/int_dbt_prod_new_deal_revenue_summary.md) | salesforce_new_deal_revenue_summary | 19 | 6 |
| [int_dbt_prod_rm_db_accounting_base_periods](views/int_dbt_prod_rm_db_accounting_base_periods.md) | rm_db_accounting_base_periods | 12 | 4 |
| [int_dbt_prod_rm_db_accounting_label_catalog_split](views/int_dbt_prod_rm_db_accounting_label_catalog_split.md) | rm_db_accounting_label_catalog_split | 8 | 3 |
| [int_dbt_prod_rm_db_accounting_label_country_split](views/int_dbt_prod_rm_db_accounting_label_country_split.md) | rm_db_accounting_label_country_split | 9 | 3 |
| [int_dbt_prod_rm_db_accounting_label_store_split](views/int_dbt_prod_rm_db_accounting_label_store_split.md) | rm_db_accounting_label_store_split | 9 | 3 |
| [int_dbt_prod_rm_db_accounting_revenue_over_time](views/int_dbt_prod_rm_db_accounting_revenue_over_time.md) | rm_db_accounting_revenue_over_time | 8 | 1 |
| [int_dbt_prod_rm_db_accounting_services_revenue_coalesce](views/int_dbt_prod_rm_db_accounting_services_revenue_coalesce.md) | rm_db_accounting_services_revenue_coalesce | 9 | 3 |
| [int_dbt_prod_rm_db_label_rm_mapping](views/int_dbt_prod_rm_db_label_rm_mapping.md) | rm_db_label_rm_mapping | 6 | 0 |
| [int_dbt_prod_struggling_deal_analysis](views/int_dbt_prod_struggling_deal_analysis.md) | struggling_deal_analysis | 29 | 20 |
| [int_dbt_prod_summary_territory_kpis](views/int_dbt_prod_summary_territory_kpis.md) | Derived from: Cy25_Targets, Dbt_Prod_Strategy.Ifpi... | 5 | 5 |
| [int_dbt_prod_transaction_country_report](views/int_dbt_prod_transaction_country_report.md) | Derived from: Dbt_Prod_Strategy.Ifpi_Transaction_C... | 8 | 2 |
| [int_dbt_prod_transaction_country_report_filterable](views/int_dbt_prod_transaction_country_report_filterable.md) | stg_ifpi_transaction_country_report_filterable | 5 | 2 |
| [orch_app_ar_currencies](views/orch_app_ar_currencies.md) | orchard_app_reporting_v2.art_relations_prod_art_re... | 6 | 0 |
| [youtube_avod_fill_rate](views/youtube_avod_fill_rate.md) | youtube_avod_fill_rate | 4 | 2 |

*Showing first 20 views. See [complete views inventory](views/view-inventory.md) for all 29 views.*