# View: anr_spotify

**View Name:** anr_spotify
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `anr_spotify.view.lkml`

## Overview

- **File Size:** 5637 bytes
- **Lines of Code:** 179
- **Dimensions:** 25
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `spotify_followers` | number |
| `spotify_followers_change` | number |
| `spotify_c_followers_change` | number |
| `spotify_followers_daily_change` | number |
| `spotify_monthly_listeners` | number |
| `spotify_monthly_listeners_change` | number |
| `spotify_c_monthly_listeners_change` | number |
| `spotify_monthly_listeners_daily_change` | number |
| `last_week_spotify_monthly_listeners` | number |
| `spotify_monthly_listeners_growth` | number |
| `spotify_monthly_listeners_acceleration` | number |
| `spotify_followers_growth` | number |
| `spotify_followers_acceleration` | number |
| `spotify_popularity` | number |
| `editorial_playlists_nulls_last` | number |
| `spotify_editorial_playlists` | number |
| `editorial_playlists_change_nulls_last` | number |
| `spotify_editorial_playlists_change` | number |
| `notable_playlists_nulls_last` | number |
| `spotify_notable_playlists` | number |
| `notable_playlists_change_nulls_last` | number |
| `spotify_notable_playlists_change` | number |
| `spotify_release` | date |
| `last_processing_date` | date |

## Derived Table

```sql
sql: SELECT
          SP.ARTIST,
          SP.CURRENT_FOLLOWERS_COUNT AS "Spoti Followers",
          SP.WEEKLY_CHANGE_IN_FOLLOWERS AS "Spoti Followers Change",
          SP.CURRENT_WEEKLY_CHANGE_IN_FOLLOWERS AS "Spoti C. Followers Change",
          SP.DAILY_CHANGE_IN_FOLLOWERS AS "Spoti Followers Daily Change",
          TRY_TO_NUMBER(SP.MONTHLY_LISTENERS) AS "Spoti Monthly Listeners",
          TRY_TO_NUMBER(SP.WEEKLY_CHANGE_IN_MONTHLY_LISTENERS) AS "Spoti Monthly Listeners Change",
          TRY_TO_NUMBER(SP.CURRENT_WEEKLY_CHANGE_IN_MONTHLY_LISTENERS) AS "Spoti C. Monthly Listeners Change",
          TRY_TO_NUMBER(SP.DAILY_CHANGE_IN_MONTHLY_LISTENERS) AS "Spoti Monthly Listeners Daily Change",
          ROUND(100 * SP.PERCENTAGE_CHANGE_IN_MONTHLY_LISTENERS, 2) AS "% Spoti Monthly Listeners Growth",
          ROUND(100 * SP.ACCELERATION_MONTHLY_LISTENERS, 2) AS "% Spoti ML Acceleration",
          ROUND(100 * SP.PERCENTAGE_CHANGE_IN_FOLLOWERS, 2) AS "% Spoti Followers Growth",
          ROUND(100 * SP.ACCELERATION_FOLLOWERS, 2) AS "% Spoti F. Acceleration",
          SP.SPOTIFY_POPULARITY AS "Popularity",
          SP.EDITORIAL_PLAYLISTS_ADDS_COUNT AS "Editorial Playlists",
          SP.EDITORIAL_PLAYLISTS_ADDS_COUNT - SP.LAST_WEEK_EDITORIAL_PLAYLISTS_ADDS_COUNT AS "Editorial Playlists Change",
          SP.NOTABLE_PLAYLISTS_ADDS_COUNT AS "Notable Playlists",
          SP.NOTABLE_PLAYLISTS_ADDS_COUNT - SP.LAST_WEEK_NOTABLE_PLAYLISTS_ADDS_COUNT AS "Notable Playlists Change",
          SP.THE_LATEST_RELEASE AS "Latest Release",
          TRY_TO_NUMBER(SP.MONTHLY_LISTENERS) - TRY_TO_NUMBER(SP.CURRENT_WEEKLY_CHANGE_IN_MONTHLY_LISTENERS) AS "Last Week ML",
          SP.LAST_PROCESSING_DATE
          FROM TABLE({% parameter stats_table_name %
```