Understanding which devices your audience uses to watch your YouTube content is essential for optimizing video formatting and technical specifications. YouTube Studio’s native analytics provide limited device data export options and make trend analysis difficult.
Coefficient solves this by creating a direct connection between your YouTube device viewership data and Excel, enabling comprehensive device usage analysis and visualization.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store in Excel
-
Step 2:
Connect your YouTube Analytics account
-
Step 3:
Select and import Device report data
-
Step 4:
Set up auto-refresh to keep device data current
-
Step 5:
Create device usage analysis dashboards in Excel
Step-by-Step Guide to Importing YouTube Device Data
Step 1: Install and Connect Coefficient
Begin by adding Coefficient to your Excel environment:
- Open Excel on your computer
- Navigate to the Insert tab in the ribbon
- Click Get Add-ins
- Search for “Coefficient” and click Add
- Once installed, click the Coefficient icon to open the sidebar
- Select “Import Data” to start connecting your data sources

Step 2: Import Device Data from YouTube Analytics
Now, connect to YouTube Analytics and select the device data to import:
- In the Coefficient sidebar, click “Import from”
- Select “Marketing” from the categories
- Choose “YouTube Analytics” from the marketing connectors list
- Log in to your YouTube account when prompted
- Under “Reports,” select “Device”
- Choose the time period and specific metrics you want to analyze
- Select where in your spreadsheet to import the data
- Click “Import” to bring the device data into Excel

Step 3: Set Up Auto-Refresh (Optional)
Keep your device usage data current with automatic refreshes:
- In the Coefficient sidebar, find your imported device data
- Click the “…” menu and select “Configure refresh”
- Choose your preferred refresh frequency (hourly, daily, or weekly)
- Set specific times for the data to update
- Click “Save” to activate automatic refreshes

Maximizing Device Analysis in Excel
With your YouTube device data in Excel, you can perform powerful analysis:
- Create visualizations of viewership breakdown by device type (mobile, desktop, TV, etc.)
- Track shifts in device usage patterns over time
- Compare engagement metrics across different device types
- Identify optimal video specifications based on primary viewing devices
- Develop device-targeted content strategies to maximize engagement
Available YouTube Analytics Reports in Coefficient
Reports
- Channel Metrics
- Top Videos Performance
- Channel Overview
- Traffic Source
- Geographies
- Demographies
- Device
- Social
- Playlist
- Playback Location
Frequently Asked Questions
Trusted By Over 50,000 Companies