YouTube Performance Report
The video metrics that matter per campaign: view rate, CPV, quartile retention (25/50/75/100%) and conversions — showing exactly where each creative loses its audience.
by Dmytro Tonkikh·chiliad.io
Overview
YouTube Performance Report builds a per-campaign video scorecard: impressions, views and view rate, cost per view, audience retention through the quartiles, and conversions. The quartile pattern is the diagnostic: weak 25% means the first seconds fail (new hook needed); a 25-to-50 cliff means the middle sags (tighten the edit); strong completion with no conversions means the audience is wrong, not the creative. Campaigns below your view-rate floor are flagged.
Setup
- 1Open your Google Ads account and go to Tools → Bulk Actions → Scripts.
- 2Click the + button to create a new script and paste the code below.
- 3Adjust VIEW_RATE_FLOOR_PCT to your format mix (skippable in-stream typically runs 15-35%).
- 4Set EMAIL_ADDRESS to receive the report; leave blank for logs only.
- 5Preview once to verify, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
DATE_RANGE | LAST_30_DAYS |
VIEW_RATE_FLOOR_PCT | 15 |
MIN_IMPRESSIONS | 1000 |
EMAIL_ADDRESS | (empty) |
Expected Output
=== YouTube Performance Report (LAST_30_DAYS) === Video campaigns with volume: 3 Video — Product Launch cost: 1840.20 views: 42100 (28.4% view rate) CPV: 0.044 retention 25/50/75/100: 61/44/31/24% conversions: 18.0 Video — Remarketing cost: 620.15 views: 9800 (31.2% view rate) CPV: 0.063 retention 25/50/75/100: 72/58/49/41% conversions: 12.0 Video — Prospecting cost: 410.80 views: 4100 (9.8% view rate) CPV: 0.100 retention 25/50/75/100: 38/22/14/9% conversions: 0.0 --- Below view-rate floor: 1 --- Video — Prospecting - view rate 9.8% (floor: 15%) Email sent to you@example.com
Notes
View rate definitions differ by format (skippable counts 30s or full watch; bumpers have no views), so compare campaigns within the same format. Quartile rates are relative to impressions. Conversions on video are heavily view-through influenced — read them with the attribution settings in mind.