# Model: Analytics_Spotify_Rollup

**Label:** Analytics Models - Store Level
**Connection:** snowflake_via_lookerappadmin
**File Path:** `Analytics_Spotify_Rollup.model.lkml`

## Overview

- **File Size:** 21012 bytes
- **Lines of Code:** 647
- **Number of Explores:** 3
- **Number of Includes:** 23

## Description

This explore provides daily Spotify Store data with 18 months of history.

## Comments & Notes

- sql_on: ${int_dbt_prod_agg_spotify_model_18months.labelid} = ${facts_prod_dim_label.label_id} ;;
- sql_on: ${int_dbt_prod_agg_spotify_model_18months.labelid}= ${int_dbt_prod_awal_tier_groups.label_id};;
- sql_on: ${int_dbt_prod_agg_spotify_model_18months.labelid} = ${orch_app_ar_vendor.vendor_id} ;;

## Explores

### int_dbt_prod_agg_spotify_model_18months
- **Label:** Spotify Store Model Daily
- **View:** `int_dbt_prod_agg_spotify_model_18months`

### int_dbt_prod_agg_weekly_rollup_spotify_model
- **Label:** Spotify Store Model Weekly Data
- **View:** `int_dbt_prod_agg_weekly_rollup_spotify_model`

### int_dbt_prod_agg_monthly_spotify_model
- **Label:** Spotify Store Model Monthly Data
- **View:** `int_dbt_prod_agg_monthly_spotify_model`

## Included Views

- `int_dbt_prod_agg_spotify_model_18months.view.lkml`
- `int_dbt_prod_agg_weekly_rollup_spotify_model.view.lkml`
- `int_dbt_prod_agg_monthly_spotify_model.view.lkml`
- `int_dbt_prod_stg_dim_playlist_spotify.view.lkml`
- `facts_prod_dim_label.view.lkml`
- `facts_prod_dim_country.view.lkml`
- `facts_prod_dim_release.view.lkml`
- `facts_prod_dim_track.view.lkml`
- `facts_prod_dim_artist.view.lkml`
- `orch_app_ar_releases.view.lkml`
- `orch_app_ar_country.view.lkml`
- `orch_app_ar_genre.view.lkml`
- `int_dbt_prod_awal_tier_groups.view.lkml`
- `orch_app_ar_vendor.view.lkml`
- `orch_app_ar_owner.view.lkml`
- `orch_app_prod_ddex_ingester_upc_remap.view.lkml`
- `orch_app_ar_orchadmin_users.view.lkml`
- `orch_app_ar_subaccount.view.lkml`
- `int_dbt_prod_spotify_track_audio_features.view.lkml`
- `int_dbt_prod_playlist_return_rate_last_6_month_avg.view.lkml`
- `int_dbt_prod_spotify_playlist_downstream_impact_6_month_avg.view.lkml`
- `int_dbt_prod_spotify_playlist_post_discovery_streaming_6_month_avg.view.lkml`
- `/views/playlist_metrics/spotify_playlist_lean_fwd_lean_back_categorization.view.lkml`

## Configuration

- **Fiscal Month Offset:** -9