Source to Target ETL/ELT Template for YouTube Reporting

ahoy

APR 2, 2021

Content

The YouTube Reporting Kit joins together the Analytics and Dimensions report (at the user level) to return a table with weekly user and video insights.

This kit includes

Data ingestion rivers for the Analytics Report, which brings in data concerning video insights, and the Dimensions report at the video level that brings in data concerning video/user properties.

Minimum RPU Consumption: 3

Configuring this kit for use

Variables

This Kit has 2 variables that are used to make for dynamic use of target configuration. 1 variable for the target database schema. {yt_database_id} is used in all Target configurations and queries as the target database id.{yt_schema_id} for the target schema that you want to load into.Go to the Variables menu on the left side navigation bar and create variables called yt_database_id and yt_schema_id. Then fill in the values for the Snowflake database and schema where you want the data to land.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:Swap out blank connections with existing connectionsAdd credentials to the blank connections that come with the imported Kit