YouTube Analytics
YouTube Analytics Bulk Reports contain a comprehensive set of YouTube Analytics data for a channel or content owner. YouTube Data API allows you to get information about YouTube resources like videos, channels, etc.
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 |
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 reporting
YouTube does not start to generate a report until you create a reporting job for that report. After you click Save & Test in the Fivetran connector setup form, Fivetran creates a reporting job for your report. If a reporting job already exists for your report, Fivetran uses the existing job instead of creating a new one. The report will be available within 48 hours of creating the reporting job and will be for the day that the job was scheduled. For example, if you schedule a job on March 1, 2019, then the report for March 1, 2019 will be ready on March 3, 2019.
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.
YouTube Metadata
We support channels, videos, and playlists metadata. During every sync, we request and update all data which the user has access to.
We also support captions and comments metadata. We request this data and update it for the videos that were uploaded since one month before the last sync.
For example, the last sync was on May, 15. In this case, we request and update captions and comments metadata starting April, 15 and till the current sync date.
NOTE: For content owners, we can only sync video metadata from public playlists of the channels.
YouTube Analytics Targeted Queries
We support audience retention report from Targeted Queries. For all your videos uploaded within the last month, we provide the report of your audience retention from three days ago.
For example, today is September, 4 and within the 30 days you've uploaded 10 videos. Your retention report will include the audience retention data from three days ago, which is September, 1.
Schema information
Content Owner
If you are the owner of the YouTube channel, then you can only request 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 are an owner of.
YouTube Reporting
We support two sets of reports:
Channel reports bring in data for specific YouTube channels. Content owner reports bring in data for all channels that you are an owner of. You can disable or enable the report on the Schema tab. For either report type, we deliver a single destination table with two standard fields, date and _fivetran_id.
YouTube Metadata
We support the following metadata:
For YouTube Metadata, we have predefined tables in the schema tab that you can enable or disable.
To zoom, open ERD in new window
YouTube Analytics Targeted Queries
We support audience retention report from Targeted Queries. It includes following fields:
audienceWatchRatiodateelapsedVideoTimeRatiorelativeRetentionPerformancevideoId
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.