Creating a Data Studio Report
Follow these steps to create a Data Studio report using your YouTube Analytics data:
- After adding YouTube Analytics as a data source, go to Reports > Data Studio in your PMA hub
- Select YouTube Analytics under Create Data Studio Report (this will open the official Data Studio application in a new window)
- Google Data Studio Configuration:
- Step 1:
- Name your data source (e.g., "YouTube Analytics - Your Organization Name")
- Choose your Power My Analytics hub from the dropdown menu
- Optional: Leave "Use report template for new reports" checked to use the PMA demo template
- Click Next
- Step 2:
- User Account: Select your YouTube Analytics account (for real data) or "Sample Account" (for sample data)
- Click Next
- Step 3:
- Choose "Channel" for your reports
- Optional: Allow "Channel" modification in reports
- Click Connect in the top right to complete the data source configuration
- Step 4:
- Click Create Report in the top right corner
Understanding How YouTube Channels Are Billed
All channels managed by the connected Gmail/Google account will appear on the connector configuration screen:
- You will only be billed for channels for which a report is created.
- Each channel for which a report has been created will be billed as an account.
Key Reports and Fields
YouTube Analytics data in Power My Analytics offers a wide range of metrics and dimensions. Some popular metrics include:
- Key Performance Metrics: Current Subscribers, Views (last 28 days), Watch time (hours) (last 28 days), Views, Comments, Likes, Dislikes
- Channel Overview Metrics: Views, Watch Time, Subscribers Gained, Average View Duration
- Content Metrics: Views, Watch Time, Average View Duration
- Traffic Source Metrics: Views, Watch Time
- Geography Metrics: Views, Watch Time, Average View Duration
- Viewer Age Metrics: Viewer Percentage by Age Group, Views % by Viewer Age
- Viewer Gender Metrics: Viewer Percentage by Gender
- Date Metrics: Views, Watch Time, Average View Duration
- Subscription Status Metrics: Views, Watch Time, Average View Duration
- Playback Location Metrics: Views, Watch Time
- Device Type Metrics: Views, Watch Time
- Operating System Metrics: Views, Watch Time
- Sharing Service Metrics: Shares
- Videos by Privacy Status: Public, Unlisted, and Private Videos
- Breakdowns by Creator Content Type: Views, Watch Time, and Average View Duration by Creator Content Type
For a complete list of available YouTube Analytics fields in Power My Analytics, refer to the
Schema Explorer.
Limitations and Important Considerations
- Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
- Backfilling: YouTube's terms of service require that we store data for only 30 days.
- Data delay: There is a 48-hour data delay imposed by Google's YouTube Analytics API to ensure quality data.
- Impressions: Ad Impressions and Card Impressions are available, but other impression metrics are unavailable.
- Time-based reports: These cannot be broken down by another dimension. As a workaround, create separate reports for time dimensions and other dimensions.
Subscriber Reporting
Due to YouTube’s terms of service, only the last 30 days of subscriber data can be reported in PMA. This is a limitation of YouTube’s API.
- Reporting of subscriber data only begins from the day that you connect your YouTube account to PMA as a data source, and subscriber data from before you connected your account is not available.
- For example, on the third day after you connect your account, 3 days of subscriber data will be available in PMA reports. After a week, 7 days of data will be available.
- Once you have stored 30 days of subscriber data in PMA's data warehouse from your connected YouTube account, on the 31st day, the oldest day of data will no longer be warehoused by PMA in order to comply with YouTube’s terms of service. This will continue daily, with a sliding window limited to 30 days.
Although PMA is unable to warehouse your YouTube subscriber data for longer than 30 days, PMA users have the option to store unlimited YouTube data in their own data export destinations. To store your subscriber data for longer than 30 days, use PMA’s
Data Exports Addon to save your data in BigQuery or other destinations.
Unavailable Data
- Realtime data
- Custom fields
Show Thumbnails as Images
To show thumbnail images in your Data Studio report:
- Click on the small URL icon next to the Thumbnail field.
- Under Type, select URL, then Image.
