# View: anr_instagram

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

## Overview

- **File Size:** 4442 bytes
- **Lines of Code:** 163
- **Dimensions:** 23
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `verified` | string |
| `instagram_followers` | number |
| `instagram_followers_daily_change` | number |
| `instagram_followers_change` | number |
| `instagram_c_followers_change` | number |
| `instagram_followers_growth` | number |
| `instagram_followers_acceleration` | number |
| `instagram_posts` | number |
| `instagram_posts_change` | number |
| `instagram_likes_daily_change` | number |
| `instagram_likes_change` | number |
| `instagram_c_likes_change` | number |
| `instagram_likes_growth` | number |
| `instagram_likes_acceleration` | number |
| `instagram_comments` | number |
| `instagram_comments_daily_change` | number |
| `instagram_comments_change` | number |
| `instagram_c_comments_change` | number |
| `instagram_comments_growth` | number |
| `instagram_engagement` | number |
| `instagram_engagement_growth` | string |
| `last_processing_date` | date |

## Derived Table

```sql
sql: SELECT
          I.ARTIST,
          I.IS_VERIFIED AS "Verified",
          I.CURRENT_FOLLOWERS_COUNT AS "Insta Followers",
          I.DAILY_CHANGE_IN_FOLLOWERS AS "Insta Daily Followers",
          I.WEEKLY_CHANGE_IN_FOLLOWERS AS "Insta Weekly Followers",
          I.CURRENT_WEEKLY_CHANGE_IN_FOLLOWERS AS "Insta C. Weekly Followers",
          ROUND(100 * I.PERCENTAGE_CHANGE_IN_FOLLOWERS, 2) AS "Insta % Followers Growth",
          ROUND(100 * I.ACCELERATION_FOLLOWERS, 2) AS "F. Acceleration",
          I.CURRENT_POSTS_COUNT AS "Insta Posts",
          I.WEEKLY_CHANGE_IN_POSTS AS "Insta Weekly Posts",
          I.DAILY_CHANGE_IN_LIKES AS "Insta Daily Likes",
          I.WEEKLY_CHANGE_IN_LIKES AS "Insta Weekly Likes",
          I.CURRENT_WEEKLY_CHANGE_IN_LIKES AS "Insta C. Weekly Likes",
          ROUND(100 * I.PERCENTAGE_CHANGE_IN_LIKES, 2) AS "Insta % Likes Growth",
          ROUND(100 * I.ACCELERATION_LIKES, 2) AS "L. Acceleration",
          I.COMMENTS_COUNT AS "Insta Comments",
          I.DAILY_CHANGE_IN_COMMENTS AS "Insta Daily Comments",
          I.WEEKLY_CHANGE_IN_COMMENTS AS "Insta Weekly Comments",
          I.CURRENT_WEEKLY_CHANGE_IN_COMMENTS AS "Insta C. Weekly Comments",
          ROUND(100 * I.PERCENTAGE_CHANGE_IN_COMMENTS, 2) AS "Insta Comments Growth",
          ROUND(100 * I.ENGAGEMENT, 2) AS "Insta Engagement",
          CONCAT(TO_VARCHAR(ROUND(100 * I.WEEKLY_CHANGE_IN_ENGAGEMENT, 2)), '%') AS "Insta % Engagement Growth",
          I.LAST_PROCESSING_DATE
          FROM TABLE({% parameter stats_table_name %
```