Campaign Input Form
Example Data Table
| Campaign | Impressions | Starts | 25% | 50% | 75% | Completed | Spend |
|---|---|---|---|---|---|---|---|
| Spring Product Launch | 120,000 | 18,000 | 16,800 | 15,200 | 14,100 | 13,200 | $4,800 |
| Remarketing Burst | 64,000 | 12,500 | 11,900 | 10,400 | 9,100 | 8,600 | $2,250 |
| Awareness Flight | 210,000 | 25,700 | 21,000 | 17,500 | 13,800 | 11,200 | $7,200 |
Formula Used
Video Completion Rate (VCR) = (Completed Views ÷ Video Starts) × 100
Start Rate = (Video Starts ÷ Impressions) × 100
Completion From Impressions = (Completed Views ÷ Impressions) × 100
Quartile Rate = (Quartile Viewers ÷ Video Starts) × 100
Cost Per Completed View = Ad Spend ÷ Completed Views
Target Gap = Actual VCR − Target VCR
These formulas show how efficiently viewers reach the end of your video and how much budget is required to generate each completed view.
How to Use This Calculator
- Enter the campaign name for easier exported reporting.
- Fill in impressions, video starts, quartile viewers, completed views, clicks, spend, video length, and target VCR.
- Keep quartile counts in descending order from 25% through completion.
- Click the calculate button to display results above the form.
- Review the status label, target gap, drop-off stages, and efficiency metrics.
- Use the CSV or PDF buttons to save the result summary.
Why Marketers Use Video Completion Rate
Video completion rate helps marketers understand whether viewers stay engaged until the final frame. A high rate usually signals stronger message fit, better audience targeting, and more effective creative pacing.
When paired with impressions, clicks, and cost metrics, completion data becomes more actionable. Teams can spot weak intros, compare placements, and decide where creative edits or budget changes will produce stronger returns.
Frequently Asked Questions
1. What is a good video completion rate?
A good rate depends on platform, audience, and video length. Shorter ads often achieve higher completion percentages than longer awareness videos.
2. Why does completion rate matter in marketing?
It shows how many viewers stayed until the end. This helps measure message retention, content quality, and audience relevance.
3. Should completed views ever exceed starts?
No. Completed views are a subset of starts. If they exceed starts, the source data likely contains errors.
4. Why are quartile metrics useful?
Quartiles reveal where viewers drop off. They help you identify whether losses happen early, mid-video, or near the ending.
5. Can this calculator support benchmarking?
Yes. Use the target VCR field to compare actual results against goals and estimate how many additional completions are needed.
6. What does cost per completed view show?
It measures how much ad spend was required for each full video view. Lower values usually indicate better efficiency.
7. Can I save the results for reporting?
Yes. After calculation, use the CSV button for spreadsheet analysis or the PDF button for printable reporting.