# View: anr_youtube

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

## Overview

- **File Size:** 6303 bytes
- **Lines of Code:** 241
- **Dimensions:** 33
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `youtube_subscribers` | number |
| `youtube_subscribers_change` | number |
| `youtube_c_subscribers_change` | number |
| `youtube_subscribers_daily_change` | number |
| `youtube_subscribers_growth` | number |
| `youtube_subscribers_acceleration` | number |
| `youtube_likes_change` | number |
| `youtube_c_likes_change` | number |
| `youtube_likes_daily_change` | number |
| `youtube_likes_growth` | number |
| `youtube_likes_acceleration` | number |
| `youtube_views_change` | number |
| `youtube_c_views_change` | number |
| `youtube_views_daily_change` | number |
| `youtube_last_week_views` | number |
| `youtube_views_growth` | number |
| `youtube_views_acceleration` | number |
| `youtube_comments_change` | number |
| `youtube_comments_growth` | number |
| `youtube_engagement` | number |
| `youtube_release` | date |
| `last_processing_date` | date |
| `artist` | string |
| `youtube_weekly_change_in_views` | number |
| `youtube_last_weekly_change_in_views` | number |
| `youtube_percentage_change_in_views` | number |
| `youtube_weekly_change_in_likes` | number |
| `youtube_last_weekly_change_in_likes` | number |
| `youtube_percentage_change_in_likes` | number |
| `youtube_weekly_change_in_subscribers` | number |
| `youtube_last_weekly_change_in_subscribers` | number |
| `youtube_percentage_change_in_subscribers` | number |

## Derived Table

```sql
sql:SELECT
          Y.ARTIST,
    Y.CURRENT_SUBSCRIBERS_COUNT AS "YT Subs",
          Y.WEEKLY_CHANGE_IN_SUBSCRIBERS AS "YT Weekly Subs",
          Y.CURRENT_WEEKLY_CHANGE_IN_SUBSCRIBERS AS "YT C. Weekly Subs",
          Y.DAILY_CHANGE_IN_SUBSCRIBERS AS "YT Daily Subs",
          ROUND(100 * Y.PERCENTAGE_CHANGE_IN_SUBSCRIBERS, 2) AS "% YT Subs Growth",
          ROUND(100 * Y.ACCELERATION_SUBSCRIBERS, 2) AS "% YT Subs Acceleration",
    Y.CURRENT_LIKES_COUNT AS "YT Likes",
          Y.WEEKLY_CHANGE_IN_LIKES AS "YT Weekly Likes",
          Y.CURRENT_WEEKLY_CHANGE_IN_LIKES AS "YT C. Weekly Likes",
          Y.DAILY_CHANGE_IN_LIKES AS "YT Daily Likes",
          ROUND(100 * Y.PERCENTAGE_CHANGE_IN_LIKES, 2) AS "% YT Likes Growth",
          ROUND(100 * Y.ACCELERATION_LIKES, 2) AS "% YT Likes Acceleration",
    Y.WEEKLY_CHANGE_IN_VIEWS AS "YT Weekly Views",
    Y.CURRENT_WEEKLY_CHANGE_IN_VIEWS AS "YT C. Weekly Views",
    Y.DAILY_CHANGE_IN_VIEWS AS "YT Daily Views",
    Y.LAST_WEEK_VIEWS_COUNT AS "YT Last Week Views",
          ROUND(100 * Y.PERCENTAGE_CHANGE_IN_VIEWS, 2) AS "% YT Views Growth",
          ROUND(100 * Y.ACCELERATION_VIEWS, 2) AS "% YT Views Acceleration",
    Y.WEEKLY_CHANGE_IN_COMMENTS AS "YT Weekly Comments",
          ROUND(100 * Y.PERCENTAGE_CHANGE_IN_COMMENTS, 2) AS "% YT Comments Growth",
    Y.LIKES_ENGAGEMENT + Y.COMMENTS_ENGAGEMENT AS "YT Engagement",
    Y.THE_LATEST_RELEASE AS "YT Release",
    Y.LAST_PROCESSING_DATE
      FROM
        TABLE({% parameter stats_table_name %
```