YouTube Analytics
YouTube Analytics helps channel and content owners better understand their video content's performance.
We sync YouTube Analytics data by using the following APIs:
- YouTube Reporting API, which provides a comprehensive set of YouTube Analytics data for a channel or content owner.
- YouTube Data API, which allows you to get information about YouTube resources such as videos and channels.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step YouTube Analytics setup guide to connect YouTube Analytics with your destination using Fivetran connectors.
Sync overview
YouTube Analytics doesn’t generate a report until you create a reporting job for that report. After you click Save & Test in the connection setup form, Fivetran creates the reporting job.
If a reporting job already exists for that report, Fivetran reuses it instead of creating a new one. Reports are available within 48 hours of job creation and cover the day the job was created. For example, if you create the job on March 1, 2025, the report for March 1, 2025 is available by March 3, 2025.
Historical data
When you schedule a new job, YouTube generates historical reports covering the 30-day period prior to when you created the job. Fivetran syncs all available historical data at the moment of each sync.
Schema information
Table names don't always match the version of the report type. For example, we sync the channel_basic_a3 report to the CHANNEL_BASIC_A2 table. Refer to our changelog to learn more.
Report schema information
We support two types of reports:
- Channel reports - These reports sync data for specific YouTube channels.
- Content owner reports - Content owner reports sync data for all channels that you own. You can disable or enable content owner reports on the Schema tab.
For either report type, we deliver a single destination table with two standard fields, date and _fivetran_id.
Audience retention reports
Audience retention reports are a sub-type of channel reports. We support audience retention reports with targeted queries. The report includes the following fields:
audienceWatchRatiodateelapsedVideoTimeRatiorelativeRetentionPerformancevideoId
For the videos you've uploaded in the last three months, we provide audience retention data starting from three days ago.
For example, if today is January 4 and you uploaded 10 videos in the past three months, the audience retention report includes data from January 1 and goes back to sync 3-months worth of data.
YouTube metadata
For YouTube metadata, we have predefined tables in the Schema tab that you can enable or disable.
We support the following metadata:
During every sync, we request and update all metadata which the user has access to.
We request and update metadata for the videos that you've uploaded starting one month before the last sync date.
For example, if the last sync was on May 15, then we request and update metadata for videos uploaded since April 15, up to the current sync date.
Channel owner vs. content owner
If you are a YouTube channel owner, then you can only sync data for your channel. If you are an organization that hosts multiple YouTube channels, then you are a content owner, and you can request any data for all channels that you own.
For content owners, we can only sync video metadata from public playlists of the channels.
UTC conversion
We don't convert source timestamps to Universal Time Coordinated (UTC) but use Pacific Standard Time (PST) to store the data in your destination.