# Abacus Looker Documentation

Generated on: 2026-01-09 05:57:13

## Project Overview

This repository contains 28 Looker models and 82 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 |
|-------|-------|------------|----------|------------|
| [OrchardGo_Adoption_Updated](models/OrchardGo_Adoption_Updated.model.md) | Data Squad - OrchardGo Adoption Models | datasquad-looker | 3 | 3 |
| [anr_de_artists_test](models/anr_de_artists_test.model.md) | DE Artists | datasquad-looker | 1 | 1 |
| [anr_followers_statistics_ds](models/anr_followers_statistics_ds.model.md) | Data Squad - A&R Followers Statistics | datasquad-looker | 1 | 1 |
| [anr_likes_statistics_ds](models/anr_likes_statistics_ds.model.md) | Data Squad - A&R Likes Statistics | datasquad-looker | 1 | 1 |
| [anr_missing_days](models/anr_missing_days.model.md) | Data Squad - A&R Missing Days | datasquad-looker | 2 | 1 |
| [anr_nav](models/anr_nav.model.md) | Data Squad - A&R Dashboards Navigator | datasquad-looker | 1 | 1 |
| [anr_sc_artists_test](models/anr_sc_artists_test.model.md) | SC Artists | datasquad-looker | 1 | 1 |
| [anr_shazam_ds](models/anr_shazam_ds.model.md) | Data Squad - A&R Likes Statistics | datasquad-looker | 3 | 2 |
| [anr_shazam_total_ds](models/anr_shazam_total_ds.model.md) | Data Squad - A&R Shazam Top Statistics | datasquad-looker | 4 | 1 |
| [anr_spotify_monthly_listeners_ds](models/anr_spotify_monthly_listeners_ds.model.md) | Data Squad - A&R Spotify Monthly Listeners | datasquad-looker | 1 | 1 |
| [anr_statistics_ds](models/anr_statistics_ds.model.md) | Data Squad - A&R Statistics Overviews | datasquad-looker | 7 | 5 |
| [anr_tiktok_ds](models/anr_tiktok_ds.model.md) | Data Squad - A&R TikTok Statistics | datasquad-looker | 4 | 1 |
| [anr_top_staistics_ds](models/anr_top_staistics_ds.model.md) | Data Squad - A&R Top Metrics | datasquad-looker | 8 | 7 |
| [anr_uk_artists_test](models/anr_uk_artists_test.model.md) | UK Artists | datasquad-looker | 1 | 1 |
| [chartmetric_charts_ds](models/chartmetric_charts_ds.model.md) | Data Squad - Chartmetric Ingestions | datasquad-looker | 1 | 1 |
| [chartmetric_socials_backfill_ds](models/chartmetric_socials_backfill_ds.model.md) | Data Squad - Chartmetric Ingestions | datasquad-looker | 1 | 1 |
| [chartmetric_socials_ds](models/chartmetric_socials_ds.model.md) | Data Squad - Chartmetric Ingestions | datasquad-looker | 1 | 1 |
| [dt_awa_units_by_day_ds](models/dt_awa_units_by_day_ds.model.md) | Data Squad - AWA internal Availability | datasquad-looker | 1 | 1 |
| [dt_charts_monitoring](models/dt_charts_monitoring.model.md) | Data Squad - Charts Monitoring | datasquad-looker | 2 | 2 |
| [dt_insights](models/dt_insights.model.md) | Data Squad - Insights | datasquad-looker | 1 | 1 |
| [dt_soundcloud_units_by_day_ds](models/dt_soundcloud_units_by_day_ds.model.md) | Data Squad - SoundCloud Units by Day | datasquad-looker | 1 | 1 |
| [facts_prod_apple_podcast_analytics](models/facts_prod_apple_podcast_analytics.model.md) | Apple Podcasts Analytics | datasquad-looker | 8 | 8 |
| [market_share_temp_ds](models/market_share_temp_ds.model.md) | Data Squad - Core Models | datasquad-looker | 4 | 13 |
| [master_calendar_ds](models/master_calendar_ds.model.md) | Data Squad - Master Calendar Models | datasquad-looker | 3 | 5 |
| [master_calendar_sme_ds](models/master_calendar_sme_ds.model.md) | Data Squad - Master Calendar Models | datasquad-looker | 1 | 3 |
| [shazam_ds](models/shazam_ds.model.md) | Data Squad - Shazam Analytics | datasquad-looker | 2 | 8 |
| [store_availability_ds](models/store_availability_ds.model.md) | Data Squad - Store Availability | datasquad-looker | 7 | 11 |
| [youtube_analytics_by_day_ds](models/youtube_analytics_by_day_ds.model.md) | Data Squad - YouTube Analytics by Day | datasquad-looker | 9 | 9 |


## Views Summary

Total views: 82

| View | Table Source | Dimensions | Measures |
|------|-------------|------------|----------|
| [anr_de_artists_test](views/anr_de_artists_test.md) | Derived from: Prod.Artist_To_Track_De | 1 | 0 |
| [anr_soundcloud](views/anr_soundcloud.md) | Derived Table (Custom SQL) | 31 | 0 |
| [anr_spotify_monthly_listeners](views/anr_spotify_monthly_listeners.md) | Derived Table (Custom SQL) | 2 | 0 |
| [anr_tiktok](views/anr_tiktok.md) | Derived Table (Custom SQL) | 23 | 0 |
| [anr_youtube_latest_release](views/anr_youtube_latest_release.md) | Derived Table (Custom SQL) | 2 | 0 |
| [awa_internal_availability](views/awa_internal_availability.md) | Derived from: Prod.Dim_Day, Prod.Fact_Analytics | 2 | 0 |
| [dt_charts_monitoring_last_four_days](views/dt_charts_monitoring_last_four_days.md) | Derived from: Charts_Raw_Data, Prod.Dim_Chart, Pro... | 6 | 0 |
| [dt_orchgo_new_users](views/dt_orchgo_new_users.md) | Derived from: Art_Relations_Prod_Art_Relations.Cou... | 9 | 1 |
| [dt_rolling_date_windows_market_share](views/dt_rolling_date_windows_market_share.md) | Derived Table (Custom SQL) | 2 | 0 |
| [dt_store_availability_analytics_sme](views/dt_store_availability_analytics_sme.md) | Derived from: Prod.Data_Availability_By_Store_Dail... | 7 | 0 |
| [dt_store_availability_shazam](views/dt_store_availability_shazam.md) | Derived from: All_Available, Prod.Dim_Day, Prod.Di... | 5 | 0 |
| [dt_store_availability_tiktok_reduced](views/dt_store_availability_tiktok_reduced.md) | Derived from: All_Available, Prod.Dim_Day, Prod.St... | 7 | 0 |
| [dt_tiktok_song_tickets_by_week](views/dt_tiktok_song_tickets_by_week.md) | Derived from: Dt_Tiktok_Top_Song_By_Day, Prod.Dim_... | 1 | 1 |
| [dt_youtube_analytics_by_day](views/dt_youtube_analytics_by_day.md) | Derived Table (Custom SQL) | 1 | 1 |
| [facts_prod_apple_music_shazam_daily_events](views/facts_prod_apple_music_shazam_daily_events.md) | facts.prod.apple_music_shazam_daily_events | 7 | 1 |
| [facts_prod_chartmetric_socials](views/facts_prod_chartmetric_socials.md) | facts.prod.chartmetric_socials_log | 6 | 1 |
| [facts_prod_cm_url_backfill](views/facts_prod_cm_url_backfill.md) | facts.prod.cm_url_backfill | 6 | 1 |
| [int_prod_territory_grouping](views/int_prod_territory_grouping.md) | territory_grouping_v2 | 3 | 0 |
| [orch_app_ar_orchadmin_users](views/orch_app_ar_orchadmin_users.md) | orchard_app_reporting_v2.art_relations_prod_art_re... | 3 | 0 |
| [orch_app_ar_owner](views/orch_app_ar_owner.md) | orchard_app_reporting_v2.art_relations_prod_art_re... | 8 | 1 |

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