# View: anr_soundcloud

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

## Overview

- **File Size:** 6152 bytes
- **Lines of Code:** 228
- **Dimensions:** 31
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `soundloud_followers` | number |
| `soundcloud_followers_change` | number |
| `soundcloud_c_followers_change` | number |
| `soundcloud_followers_daily_change` | number |
| `soundcloud_followers_growth` | number |
| `soundcloud_followers_acceleration` | number |
| `soundloud_tracks` | number |
| `soundcloud_tracks_change` | number |
| `soundcloud_plays` | number |
| `soundcloud_plays_change` | number |
| `soundcloud_c_plays_change` | number |
| `soundcloud_plays_daily_change` | number |
| `soundcloud_plays_growth` | number |
| `soundcloud_plays_acceleration` | number |
| `soundcloud_likes` | number |
| `soundcloud_likes_change` | number |
| `soundcloud_c_likes_change` | number |
| `soundcloud_likes_daily_change` | number |
| `soundcloud_likes_growth` | number |
| `soundcloud_likes_acceleration` | number |
| `soundcloud_reposts` | number |
| `soundcloud_reposts_change` | number |
| `soundcloud_reposts_growth` | number |
| `soundloud_engagement` | number |
| `soundloud_release` | date |
| `soundloud_processing_date` | date |
| `artist` | string |
| `soundcloud_weekly_change_in_plays` | number |
| `soundcloud_last_weekly_change_in_plays` | number |
| `soundcloud_percentage_change_in_plays` | number |

## Derived Table

```sql
sql: SELECT
          SC.ARTIST,
    SC.CURRENT_FOLLOWERS_COUNT AS "SC Followers",
          SC.WEEKLY_CHANGE_IN_FOLLOWERS_COUNT AS "SC Weekly Followers",
          SC.CURRENT_WEEKLY_CHANGE_IN_FOLLOWERS_COUNT AS "SC C. Weekly Followers",
          SC.DAILY_CHANGE_IN_FOLLOWERS_COUNT AS "SC Daily Followers",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_FOLLOWERS_COUNT, 2) AS "% SC Followers Growth",
          ROUND(100 * SC.ACCELERATION_FOLLOWERS_COUNT, 2) AS "% SC F. Acceleration",
    SC.CURRENT_TRACKS_COUNT AS "SC Tracks",
          SC.WEEKLY_CHANGE_IN_TRACKS_COUNT AS "SC Weekly Tracks",
    SC.CURRENT_PLAYS_COUNT AS "SC Plays",
    SC.WEEKLY_CHANGE_IN_PLAYS_COUNT AS "SC Weekly Plays",
    SC.CURRENT_WEEKLY_CHANGE_IN_PLAYS_COUNT AS "SC C. Weekly Plays",
    SC.DAILY_CHANGE_IN_PLAYS_COUNT AS "SC Daily Plays",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_PLAYS_COUNT, 2) AS "% SC Plays Growth",
          ROUND(100 * SC.ACCELERATION_PLAYS_COUNT, 2) AS "% SC P. Acceleration",
    SC.CURRENT_LIKES_COUNT AS "SC Likes",
    SC.WEEKLY_CHANGE_IN_LIKES_COUNT AS "SC Weekly Likes",
    SC.CURRENT_WEEKLY_CHANGE_IN_LIKES_COUNT AS "SC C. Weekly Likes",
    SC.DAILY_CHANGE_IN_LIKES_COUNT AS "SC Daily Likes",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_LIKES_COUNT, 2) AS "% SC Likes Growth",
          ROUND(100 * SC.ACCELERATION_LIKES_COUNT, 2) AS "% SC L. Acceleration",
   SC.CURRENT_REPOSTS_COUNT AS "SC Reposts",
   SC.WEEKLY_CHANGE_IN_REPOSTS_COUNT AS "SC Weekly Reposts",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_REPOSTS_COUNT, 2) AS "% SC Reposts Growth",
    (100 * SC.PLAYS_ENGAGEMENT) AS "SC Engagement",
    SC.THE_LATEST_RELEASE AS "SC Release",
    SC.LAST_PROCESSING_DATE AS "SC Last Processing Date"
      FROM TABLE({% parameter stats_table_name %
```