# View: int_dbt_prod_black17_tiktok

**View Name:** int_dbt_prod_black17_tiktok
**Table Source:** `intelligence.dbt_prod.black17_tiktok`
**File Path:** `views/Black17/int_dbt_prod_black17_tiktok.view.lkml`

## Overview

- **File Size:** 2326 bytes
- **Lines of Code:** 139
- **Dimensions:** 14
- **Measures:** 7
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- dimension: processed_daytime {
- hidden: yes
- sql: ${TABLE}.processed_daytime ;;

## Dimensions

| Name | Type |
|------|------|
| `pkey` | number |
| `platform_name` | string |
| `tiktok_track_id` | number |
| `isrc` | string |
| `product_code` | number |
| `song_title` | string |
| `artist_name` | string |
| `album` | string |
| `label_id` | number |
| `imprint` | string |
| `label_provided_genre` | string |
| `platform_classified_genre` | string |
| `territory` | string |
| `content_type` | string |

## Measures

| Name | Type |
|------|------|
| `creations` | sum |
| `video_views` | sum |
| `comments` | sum |
| `likes` | sum |
| `shares` | sum |
| `favorites` | sum |
| `avg_watchtime` | average |

## Dimension Groups

| Name | Type |
|------|------|
| `download_date` | time |