Dbt Youtube Analytics

Abstract

1. Introduction

This dbt package transforms data from Fivetran's Youtube Analytics connector into analytics-ready tables.

This package enables you to transform core object tables into analytics-ready models and explore video demographics. It creates enriched models with metrics focused on video performance and demographic insights.

2. Objective

Data models for Fivetran's YouTube connector built using dbt.

This project demonstrates how modern tools can be applied to a real-world Digital Marketing & SEO problem.

4. Technology Stack

• package: fivetran/fivetran_utils
• package: dbt-labs/dbt_utils
• package: dbt-labs/spark_utils

5. System Requirements

General requirements for this technology stack — check the README for exact versions.

• See the project README for exact requirements
• Git (to clone the repository)

6. Installation & Setup

git clone https://github.com/fivetran/dbt_youtube_analytics.git
cd dbt_youtube_analytics

1. package: fivetran/youtube_analytics

# packages.yml
packages:
  - package: fivetran/youtube_analytics
    version: [">=1.2.0", "<1.3.0"] # we recommend using ranges to capture non-breaking changes automatically

Full setup instructions are in the project README.

7. Future Enhancements

Suggested extensions you can add to make this your own project.

• Export reports to Google Sheets or PDF
• Schedule weekly automated reports
• Add competitor comparison

8. Viva / Review Questions

Common questions examiners ask for projects in this domain.

1. Which marketing or SEO problem does this tool solve?
2. Which data sources or APIs does it use (Search Console, Analytics, social platforms)?
3. Which metrics or KPIs does it report and how are they calculated?
4. How could the output help a business make decisions?
5. How would you schedule it to run automatically?

9. Source Code & License

This project is developed by fivetran and published on GitHub under the Apache License 2.0. Please follow the license terms and credit the original author when you use or modify this code.