YouTube Reporting - BigQuery
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
You can find the full contents, data model documentation, and source fields used here.
Configuring this Kit for use
Variables
In this Kit, there are two variables that are used to make for dynamic use of target configuration.
- {Dataset_YouTube} is used in all Target configurations and queries as the target dataset ID.
- {YouTube_Alert_Group} is used as the alert email address(es) for when a river fails.
Go to the Variables menu on the left side navigation bar and create variables for Dataset_YouTube and YouTube_Alert_Group. Then fill in the values as the Google BigQuery dataset where you would like the data to land and the email address(es) to which you would like the failure emails sent.
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 connections
- Add credentials to the blank connections that come with the imported Kit
