Skip to main content

YouTube Analytics

This connector syncs data from YouTube into your destination using Google OAuth. It supports multiple YouTube APIs to extract different kinds of data:

  • YouTube Data API (v3) for metadata (for example, channels, videos, playlists).
  • YouTube Reporting API for bulk downloadable reports (job-based).
  • YouTube Analytics API (Query API) for analytics reports (metrics/dimensions over a date range).
info

API Documentation:

Source Setup Guide​

Step 1​

Click banner in the Edit Source form.

Step 2​

Follow the authentication flow (OAuth) on Google/YouTube to grant Extract the required permissions.

Step 3​

Confirm you can see your email and profile picture, and that the source is Connected.

note

The API Client uses YouTube API Services.

By authorizing this connector, you agree to:

You can revoke access on the Google Security Settings page.

Step 4 (optional): Content Owner ID (for Content Owner reports)​

If you are a YouTube Content Owner (MCN / CMS account), add your Content Owner ID. This enables syncing content owner reports from the Reporting API.

To retrieve all content owner IDs associated with your admin account:

  1. Visit the Content Owner endpoint docs:
    https://developers.google.com/youtube/partner/reference/rest/v1/contentOwners/list?apix_params=%7B%22fetchMine%22%3Atrue%7D
  2. In the API Explorer, set fetchMine to true and click Execute.
  3. Sign in with the relevant Google admin account and accept prompts.
  4. The response includes content owner names and their corresponding IDs.

Connection Setup Guide​

Once you connect YouTube to a destination, configure:

  • Connection Pull Schedule: how frequently data is extracted.
  • Backfill (Days): how much historical data is retrieved on each run.
  • Destination-specific settings: e.g., dataset name / schema / warehouse options.
  • Schema Migration Policy: how schema changes are handled.

Authentication​

This connector uses Google OAuth 2.0. You authenticate by signing in to Google and granting access.

If you use Content Owner features, you may also provide:

  • Content Owner ID (on_behalf_of_content_owner)

Configuration fields​

Source-level fields commonly used by this connector:

FieldRequiredDescription
client_idYesGoogle OAuth client ID.
client_secretYesGoogle OAuth client secret.
tokenYesOAuth refresh token (created during the OAuth flow).
on_behalf_of_content_ownerNoContent Owner ID used for Content Owner Reporting API reports.

Some streams also define stream-specific configuration in connector_specific (for example, Analytics Query API reports). These are managed by the connector and typically don’t need manual editing unless instructed.

Schema ERD​

Explore the interactive entity relationship diagram for Youtube.

Open page

Data Streams​

The connector can expose multiple stream types (metadata, reporting, analytics). Stream availability depends on your YouTube account permissions and whether you provided a Content Owner ID.

Analytics (Query API) streams​

These streams are powered by the YouTube Analytics Query API and are typically date-ranged (respecting your connection backfill window).

  • channel_demographics
  • channel_device_os_daily
  • channel_geography_country
  • channel_geography_province
  • channel_playback_location_daily
  • channel_time_daily
  • channel_traffic_source_daily
  • playlist_device_os
  • playlist_geography_country
  • playlist_playback_location
  • playlist_time_daily
  • playlist_traffic_source
  • video_geography_country
  • video_time_daily
  • video_traffic_source

Notes on Analytics Query API behavior​

  • Analytics queries are executed over a start date / end date derived from your connection schedule and backfill.
  • Some analytics reports may be scoped to:
    • the authenticated user’s channel (ids=channel==MINE), and/or
    • specific channels (when applicable), and/or
    • filtered entities (for example, videos or playlists) depending on the report design.
  • The YouTube Analytics API enforces quotas and per-request limits; the connector may paginate and/or batch requests to stay within API constraints.

Reporting API streams (job-based)​

If enabled for your account, the connector can also sync Reporting API reports (bulk downloadable reports). These are created and fetched via jobs and may require Content Owner access for content owner reports.

Metadata (YouTube Data API v3) streams​

The connector can also sync metadata via the YouTube Data API (v3), such as channel/video/playlist metadata, depending on the configured catalog.

Connector Information​

  • Connector name: YouTube
  • APIs used: YouTube Data API (v3), YouTube Analytics API, YouTube Reporting API
  • Auth: OAuth 2.0 (Google)